Does Dext Supplier Statement Reconciliation Catch Missing Bills?

Coding Liquids tutorial cover featuring Sagnik Bhattacharya for Does Dext Supplier Statement Reconciliation Catch Missing Bills?
Coding Liquids tutorial cover featuring Sagnik Bhattacharya for Does Dext Supplier Statement Reconciliation Catch Missing Bills?

Dext Supplier Statement Reconciliation catches missing bills: it reads each line of an uploaded statement, matches it to bills in Dext and in connected Xero or QuickBooks Online, and marks any line it cannot find as Missing. Duplicates are partly covered: Dext promises duplicate flags, but a second copy keyed into your ledger is clearest in the balance check.

The Complete Excel Course with AI Integration

From formulas and pivot tables to Power Query, DAX, VBA and AI with Copilot, ChatGPT and Claude — hands-on from the first lesson.

By Sagnik Bhattacharya and Virginia Thorn, Primetime Emmy Award winner

Buy now

That split matters for how you use it. Missing bills are the job the feature was built for, and its Missing status is documented and dependable once the supplier and dates are right. Duplicates need two extra checks this page walks through: Dext's own duplicate detection on incoming bills, and a comparison of the statement balance with your aged payables, where a duplicate shows up as an exact overstatement.

How does Dext supplier statement reconciliation work?

Dext supplier statement reconciliation extracts every line of a supplier's statement and matches each one to a bill or credit note by supplier and reference, then by total and date if the reference fails.

The sequence, as Dext's help centre describes it:

  1. Extraction. When a document lands in the Supplier statements workspace, Dext extracts it automatically: the supplier, the statement date (the end date), the outstanding balance and up to 2,000 lines. Lines past 2,000 are not extracted or reconciled. Extraction can be switched off for a particular supplier under Costs, then Suppliers.
  2. Matching on reference. Each line is matched on supplier name and document reference against invoices in Dext and, if connected, your accounting software.
  3. Fallback matching. If a line has no reference or the reference does not match, Dext compares total amount, invoice date and supplier name instead.
  4. Statuses. Every line gets a status (covered in the next section), and the statement as a whole gets one too.
  5. Your decision. You fix what is missing, then mark the statement as reconciled or archive it.

Dext's product page adds three points worth knowing. It says the feature is available on all Dext plans, that it also reads your Xero or QuickBooks Online ledger to flag bills that exist there but never reached Dext, and that it works without any accounting integration, checking against what is in Dext alone. It also claims extraction accuracy of over 99%; treat that as the vendor's figure and check your first few statements line by line anyway.

What do the Dext reconciliation statuses mean?

Dext reconciliation statuses tell you where each statement line was found: in your payables only, in Dext only, in both, in neither (Missing), or in payables but not on the statement.

Line statusWhat Dext foundWhat to do
In Payables & DextThe bill is in Dext and in Xero or QuickBooksNothing; this is the healthy state
In Payables onlyThe bill is in the accounting software but not in DextFine if keyed by hand; find and upload the document if you want it on file
Dext onlyThe bill is in Dext but not in your payables reportCheck whether it was published, or published as Awaiting approval
MissingOn the statement, but not in Dext or the accounting softwareGet the invoice or credit note and upload it to the Costs inbox
Not on statementIn your payables report but not on the statementCheck it is a genuine bill from this supplier and not a duplicate or a mis-coded supplier

Hovering over a status shows links to the matching document in each source where one exists, which is the quickest way to open the bill behind a line. A Not on statement line does not block reconciliation if everything else matches; a bill posted after the supplier ran its statement is a common, harmless reason for one.

The statement itself moves through four statuses in the inbox: Ready (extraction finished, ready to reconcile), To review (a reconciliation error or missing details), Reconciled (marked as reconciled) and Mistake reported (reported as an extraction mistake and excluded from paid items). Marking a statement reconciled moves it to the Archive with a Reconciled status; archiving without reconciling moves it there as Archived.

Does Dext catch duplicate bills as well as missing ones?

Dext catches duplicate bills in two different places: its duplicate detection stops repeated bills arriving in Dext, and statement reconciliation helps expose duplicates that already reached your ledger. Neither works alone.

Duplicates arriving in Dext

Dext's duplicate detection compares new cost items with ones already processed. For invoices, credit notes and refunds it matches on the same type, the same supplier record, the same total (not zero) and the same document reference, ignoring spaces; the date is used only when neither item has a reference. Receipts are matched on supplier, total, date and owner, with a ten-minute window when both show a time.

You choose what happens to a suspected duplicate under Business settings, then Extraction, then Duplicate items:

  • Automatic deletes it at once; it appears in Submission history as Confirmed duplicate and can be restored.
  • Review keeps it in the Costs inbox as To review with an amber dot, so a person compares the two side by side.
  • Off processes everything, which Dext advises against.

Each supplier can override the account setting from Costs, then Suppliers, using the "Duplicate costs items" drop-down. For a supplier that sends the same invoice by email and on paper with the delivery, Review is the safer choice: you see both copies before one disappears.

Know the gaps, all from Dext's own help pages. Supplier statements themselves are never checked for duplicates. Items already in an approval request or expense claim are skipped. Two copies uploaded seconds apart can both get through, because Dext only compares against items that have finished processing. A misread supplier name creates a second supplier record, and different records never match.

Duplicates already in Xero or QuickBooks

A bill entered by hand in Xero and also published from Dext is the classic duplicate, and Dext's incoming check never sees the hand-keyed copy. This is where the statement helps, but not through a special status: Dext's help pages do not describe how a second copy with the same reference is displayed on a reconciliation. The dependable signal is the balance. If your aged payables for the supplier exceed the statement balance by the exact amount of one bill, you have found the duplicate.

Accounting practices have a further tool. The Duplicate transactions check, part of the Data Health & Insights add-on on Practice Essentials and Advanced, scans Xero and QuickBooks Online for invoices matching on contact, date and value within a date window (plus or minus five days by default). It sits under Data Health, then Duplicate transactions, inside each client's account.

Worked statement test: a bookshop's wholesaler statement

The quickest way to trust the feature is to run one real statement through it while you already know the answers. Here is an illustrative independent bookshop doing exactly that with its main book wholesaler's October statement. The shop uses Dext Business connected to Xero.

The statement shows 33 lines (28 invoices and 5 credit notes for returned stock) and an outstanding balance of $6,418.75 at 31 October. Before uploading it, the owner noted five problems she already knew about:

Known problemAmountWhat Dext's documentation says should happen
Invoice A never reached Dext (emailed to an old address)$412.60Missing
Invoice B lost in the post room$188.40Missing
Credit note C for returns never processed$96.00 creditMissing
Invoice D published from Dext as Awaiting approval$305.25Kept off Xero's Aged Payables, so it should not count in payables (expect Dext only)
Invoice E keyed into Xero by hand and also published from Dext$259.90No documented status; check the balance

Then the balance check, which needs nothing more than Xero's aged payables report for the wholesaler at 31 October:

Statement balance                       6,418.75
Less invoices missing from the books     -412.60
                                         -188.40
Add credit note missing from the books    +96.00
Less bill not on Aged Payables           -305.25
Add duplicate bill in Xero               +259.90
Expected aged payables in Xero          5,868.40
Difference to explain                     550.35

The shop's aged payables showed $5,868.40, so the $550.35 difference was fully explained by the five known problems. That is the test passed: the three Missing lines told her what to chase, and the balance arithmetic exposed the two problems no status names directly.

The fixes took about 25 minutes:

  1. Request paperwork for invoices A and B and credit note C from the statement's Details page (wording below).
  2. Change invoice D in Xero from Awaiting approval to Awaiting payment, and change the default in Dext's integration settings so future bills do not repeat it.
  3. Void the hand-keyed copy of invoice E in Xero and tell staff to stop keying bills for suppliers that are in Dext.
  4. Upload the three documents to the Costs inbox when they arrive and publish them; the Missing lines clear once Dext finds them.
  5. Re-run the comparison: aged payables now equal $6,418.75, so mark the statement as reconciled.

Run this test on your own busiest supplier before trusting the feature on all of them. If your balance arithmetic leaves a difference you cannot explain, that unexplained amount is the next thing to investigate, not the software.

How do you upload a supplier statement to Dext?

Dext takes supplier statements through the Supplier statements tab of the upload window: select Add documents, open the Supplier statements tab, then choose or drag in a PDF, JPEG, JPG or PNG file.

  1. In Dext, select + Add documents.
  2. Open the Supplier statements tab.
  3. Select the files or drag and drop them in. The help centre lists PDF, JPEG, JPG and PNG.
  4. Find the statement under Costs, then Supplier statements. Open it and confirm the supplier is right; if the wrong supplier is selected, the matching invoices will not appear.
  5. Check the statement date and outstanding balance on the Details page against the paper copy.

Two rules catch people out. First, email is not a route in: forwarding a statement to your Dext email address creates a regular Costs item, which you then open and move with Move to, then Supplier statements, and moving it incurs the statement extraction charge on top. Second, visibility: standard users only see their own supplier statements, so whoever reconciles needs the right role. The upload and management help article covers the details.

Ask suppliers for PDF statements where you can. A clean PDF gives the extraction less to guess than a photo of a printed page, and Dext's own duplicate guidance recommends uploading the supplier's original PDF over a photo for the same reason.

Why does a line show Missing when the bill is in Dext?

A line shows Missing when Dext cannot match it, and the usual causes are a wrong supplier on the statement, a bill dated after the statement date, or a supplier split into two records.

  • Wrong supplier selected. If the statement is assigned to the wrong supplier, no invoices match and nearly every line shows Missing. A statement where 30 of 33 lines are Missing almost always means this.
  • Dates after the statement date. Dext's help says invoices dated after the statement date appear as Missing. A bill whose date was misread, or entered as next month, looks missing even though it is in Dext.
  • Duplicate supplier records. "Harbour Books Ltd" and "Harbour Books Limited" are two suppliers to Dext. Merge near-identical supplier entries under Costs, then Suppliers.
  • Reference typed differently. If your bill shows "INV-55812" and the statement shows "55812", reference matching can fail; Dext then falls back to total, date and supplier, so a wrong total or date on the bill breaks the fallback too.
  • Approval tools. Invoices published through ApprovalMax may show as Dext only rather than matching your payables.

The opposite problem, a statement balance that will not agree even when every line matches, usually comes from publish status. Xero bills published from Dext default to Awaiting approval, and those do not appear on the Aged Payables report, so the statement balance does not update. Fix it per bill with the Publish as field, by approving the bills in Xero, or for good by changing "Publish costs items to purchases as" in the integration settings.

How do you chase the missing invoices from a statement?

Dext chases missing invoices with Request paperwork on the statement's Details page, which emails the supplier a list of missing invoices and credit notes or exports the list for you.

  1. Open the statement's Details page and select Request paperwork.
  2. Check the sender name, which is pre-filled but editable.
  3. Add one or more recipients by name and email, using + for extra contacts.
  4. Review the missing items. You can edit the date, reference, type or total, remove an item with the X, or select Add to enter one by hand.
  5. Select Send, or Export to download the request instead.

Limits: each line can be requested once per statement (use Add to request it again by hand), and you can send one request per statement every 12 hours. If you prefer your own email, the exported list drops into something like this:

Subject: Copies needed: invoices and credit note on your October statement

Hello [first name],

We're reconciling your statement dated 31 October and can't find
these documents in our records:

- Invoice 55790, 4 October, $412.60
- Invoice 55844, 19 October, $188.40
- Credit note CN-2231, 22 October, $96.00

Could you send PDF copies to [accounts email]? Once they arrive
we'll process them and pay the balance in our usual run.

Thanks,
[your name]

Ask for PDFs and give the exact address. The most common reason an invoice goes missing is that it was sent to an address nobody reads; a request that repeats the old address fixes nothing.

What does Dext supplier statement reconciliation cost?

Dext supplier statement reconciliation comes with a monthly allowance on every plan; Dext Business includes 5 statements a month, then from $0.50 each or $20.50 for 50.

ItemPrice (USD, excluding tax)Note
Dext Business plan$302.50 a year (shown as $25.21 a month)250 documents a month, 5 users; annual billing is up to 20% cheaper
Supplier statements included5 a monthListed under free credits on the Business plan
Extra statements, pay-as-you-goFrom $0.50 eachCharged per statement processed
Extra statements, bundle$20.50 a month for 50 ($0.41 each)$246 billed annually; unused documents do not roll over
Moving a Costs item into Supplier statementsExtraction charge appliesOn Business the first upload also counts towards the 250 documents

A quick sum for the bookshop: nine suppliers send monthly statements, five are included, so four cost $0.50 each, or $2 a month. The bundle only beats pay-as-you-go above 41 extra statements a month ($20.50 divided by $0.50), which is a practice-sized volume, not a single shop's. You can see the allowance, overage pricing and add-on costs under Business settings (or Practice settings), then Subscription.

One cost trap: reporting a mistake does not re-extract a statement. To get a fresh extraction you report the mistake, delete the statement and upload it again as a new document, and Dext notes that deleting the statement alone does not remove its charge.

If reconciling the exported statement against your aged payables report in a spreadsheet is the slow part, try The Complete Excel Course with AI Integration on Coding Liquids.

How do accountants use supplier statement reconciliation for clients?

Accountants use Dext supplier statement reconciliation as a monthly check across client accounts, paid from practice credits and paired with the Duplicate transactions check for bills already sitting in Xero or QuickBooks.

Dext's practice price list shows supplier statement reconciliation on both Essentials and Advanced practice plans, with credits covering the heavier extraction jobs (bank statements, line items and supplier statement reconciliation) and top-ups for busy months. Practice admins can see each client's usage under Practice settings, then Subscription, then View client usage, and export it to CSV, which is the number to watch if you bill clients for extra work.

An illustrative bookkeeper with 20 clients might run this routine in the first week of each month:

  1. Clients forward statements from their top five suppliers; the bookkeeper uploads them through the Supplier statements tab, never by email forwarding.
  2. Sort the inbox by status and open the To review statements first.
  3. For each statement, check the supplier assignment, then work the Missing list and send Request paperwork.
  4. Compare each statement balance with the client's aged payables; any unexplained difference goes on the client query list.
  5. Run the Duplicate transactions check for clients on the Data Health & Insights add-on, dismissing false positives so they stay dismissed.
  6. Mark matched statements as reconciled and export any that the client's accountant wants on file; exports run one statement at a time.

A realistic first-month result: 100 statements, of which 70 reconcile cleanly, 20 have one or two Missing lines, and 10 are To review because the supplier was mis-assigned or a statement was a photo. That pattern tells the bookkeeper where to spend the second month: supplier clean-up and PDF statements, not more checking. For more on where automated bookkeeping still needs a person, see common problems with AI bookkeeping software and how to fix them.

A filled-in monthly statement log

Keep a short log so nobody reconciles the same statement twice and every open item has an owner. Here is the bookshop's November log after its October test:

SupplierStatement dateBalanceMissing linesBalance agrees?Action and ownerStatus
Book wholesaler30 Nov$5,904.101No, $72.00 outPaperwork requested; owner checks credit noteTo review
Stationery supplier30 Nov$611.380YesNoneReconciled
Café supplies30 Nov$248.902NoBoth invoices were in a staff member's bag; uploadedReady
Shop-fit maintenance30 Nov$0.000YesNoneReconciled
Second distributor28 Nov$1,377.450No, $129.99 overDuplicate bill in Xero voidedReconciled

The two "No" rows are the value of the whole exercise: one unprocessed credit note and one duplicate bill, worth $201.99 between them, found before the payment run rather than after.

Where the feature fits alongside other Dext checks

Statement reconciliation is a monthly safety net, not a replacement for getting bills in properly. Three other habits do most of the work. Capture documents promptly, which is where the comparison of Dext and Hubdoc for receipt capture helps if you are still choosing. Keep bank reconciliation tight, covered in automating bank reconciliation and checking the matches. And decide whether Xero's free capture is enough for your volume, which whether Xero Smart Document Capture is enough without Dext weighs up.

Dext's AI Assist add-on is a separate purchase that applies coding guidance to documents; if you are weighing it alongside statement checks, the breakdown of what Dext AI Assist costs and whether it is worth it covers that decision.

If you want help fitting statement reconciliation into how your month-end already runs, I offer one-to-one AI consultations for small businesses.

Mistakes that make the feature look worse than it is

  • Reconciling before the month's bills are in. Run statements after your last bill upload for the month, or the Missing list fills with bills sitting in someone's inbox.
  • Treating Not on statement as an error. Bills posted after the supplier ran the statement belong here. Only chase ones dated before the statement date.
  • Uploading photos of statements. Every misread reference pushes a line onto fallback matching. Ask for PDFs.
  • Reporting a mistake and expecting a refund of the charge. Reporting removes the statement from your processed count, but if you also need a fresh extraction you must delete and re-upload.
  • Leaving duplicate detection on Automatic for messy suppliers. Automatic deletes suspected duplicates straight away; Review lets you see them first.
  • Skipping the balance comparison. Statuses explain lines; only the balance shows a duplicate already in your ledger.

Dext supplier statements: common questions

Which Dext plans include supplier statement reconciliation?

All of them, according to Dext's product page. The Dext Business plan includes 5 supplier statement extractions a month, with extra statements from $0.50 each pay-as-you-go or $20.50 for a bundle of 50, and the practice price list shows the feature on both Essentials and Advanced practice plans.

Can I email supplier statements to Dext?

Not directly. Forwarding a statement to your Dext email address creates an ordinary Costs item; open it and choose Move to, then Supplier statements. Moving it incurs the statement extraction charge, and on Dext Business the first upload also counts towards the monthly document allowance, so upload statements through the Supplier statements tab instead.

Does Dext need Xero or QuickBooks to reconcile statements?

No. Dext says supplier statement reconciliation works without an accounting connection, matching statement lines against bills already in Dext. Connecting Xero or QuickBooks Online adds a second check, because Dext then also reads your payables and flags bills that are in the ledger but never reached Dext.

What happens to a statement longer than 2,000 lines?

Dext extracts up to 2,000 lines per statement, and anything beyond that is neither extracted nor reconciled. Few small-business statements come close, but a wholesaler's annual statement might; ask the supplier for monthly statements instead, so every line is checked and the Missing list stays short.

Why is my reconciled statement balance still different from Xero?

Usually because some bills were published to Xero as Awaiting approval, which keeps them off the Aged Payables report. Change the Publish as field, approve those bills in Xero, or change the default publish status in Dext's integration settings, then compare the statement balance with aged payables again.

Further reads

Sources: Dext Supplier Statement Reconciliation product page; Dext business pricing and extraction pricing pages; Dext practice pricing page; Dext help centre articles on uploading and managing supplier statements, reviewing and reconciling them, requesting paperwork and reporting mistakes, how Dext handles duplicate cost documents, how Dext decides two items are duplicates, why a duplicate was missed, and the Duplicate transactions check (all read 22 November 2026).

Have a specific process in mind?

Describe the job in your own words on a 1:1 call and I'll show you what AI you can use for it with the tools you already pay for.

Book a 1:1 call with me