Once Dext extracts a supplier statement, you can review its details and check how each invoice matches your records. This article covers how to review a statement, check its reconciliation status, and reconcile or archive it once you're done.
Reviewing supplier statements
Once a supplier statement is in the inbox, open it to review and edit the details on its Details page.
On the statement's Details page, Dext automatically extracts:
Supplier
Date: the statement end date
Outstanding balance: the total balance shown on the statement
The History tab shows the statement's activity within Dext.
Review invoice reconciliation
To review a statement's reconciliation, open it and check the status of each invoice listed.
Open the statement from the inbox.
In the Reconciliation section, review the status of each invoice listed on the statement.
Invoices can have the following statuses:
In Payables only: found only in Xero or QuickBooks.
Dext only: found only in Dext.
In Payables & Dext: found in both Dext and the connected accounting software.
Missing: extracted from the statement but not found in Dext or the accounting software.
Not on statement: found in the accounts payable report but not on the supplier statement.
Hover over a status to see links to the related document in each source, where available.
Reconcile or archive supplier statements
Once you've finished working with a statement, reconcile it or archive it to remove it from the Supplier statements inbox.
To archive a supplier statement:
Select the statement.
Select Archive.
The statement moves to Archive with an Archived status.
To reconcile a supplier statement:
Select the statement.
Select Mark as reconciled.
The statement moves to Archive with a Reconciled status.
Common questions about reviewing and reconciling supplier statements
Here are common questions about reviewing and reconciling supplier statements in Dext.
Can I export supplier statements in bulk?
Can I export supplier statements in bulk?
No. You can only export supplier statements one at a time. To export a statement, open it and select Export on the statement's details page.
Why does a supplier statement's balance not update after publishing my invoices to Xero?
Why does a supplier statement's balance not update after publishing my invoices to Xero?
When Dext publishes a document to Xero, it sends the item to Awaiting approval by default.
Items in this state don't appear on Xero's Aged Payables report, so the outstanding balance on the supplier statement isn't updated.
To resolve this, you can:
Use the Publish as field on the item details page.
Update the item's status in Xero after publishing.
Change the default publishing status in Integration settings (the "Publish cost items to purchase as" setting).
Why is Dext showing an entry as being in Xero or QuickBooks but not on the statement?
Why is Dext showing an entry as being in Xero or QuickBooks but not on the statement?
If an item shows as Not on statement, Dext found it in Xero or QuickBooks' Accounts Payable report, but it doesn't appear on the supplier statement itself.
Dext includes these items to show other unpaid bills for the same supplier. If all other items match correctly, you can still reconcile the supplier statement even when lines appear as Not on statement.
Why do invoices published to ApprovalMax show as "Dext only"?
Why do invoices published to ApprovalMax show as "Dext only"?
Dext matches invoices that are published directly to Xero and included in Xero's accounts payable report.
If an invoice is published via ApprovalMax, it may not match, and it can appear as Dext only in the Supplier statements table.