10 Common Supplier Statement Reconciliation Problems (and How to Fix Each One)

Why your supplier statement does not match your ledger: find the gap first

Supplier statement reconciliation is comparing the balance and open items on a supplier’s statement with your own ledger for that supplier, and naming the cause of every difference.

Start from your ledger balance, add or subtract every item you can explain, and you should land on the statement balance. ACCA teaches it this way. Whatever is left over is still unexplained.

First check that both sides are the same supplier account, the same currency and the same cut-off date. Two accounts for one supplier will give you a gap that does not exist.

One statement, four gaps

This is the October statement as Aldermoor printed it. It is a balance-forward statement: it opens with the 6,284.50 carried over from September and keeps a running balance down the page. The numbers on the page point to the four gaps, and to one reference that looks different but is not.

Four rows do not pair. Two are yours to fix, one is the supplier’s to fix, and one will fix itself. Adjust each side for what belongs to it and both balances meet.

4,341.55 is neither side’s starting balance, and you would not expect it to be. It is where the account ends up once the invoice is posted, the credit is applied, the duplicate is removed and the payment has landed.

The ten problems at a glance

1. Why does the opening balance not agree?

The statement opens at a figure that does not match your closing balance for last period. Until you know why, you are matching this month’s lines on top of a difference you cannot yet explain, so none of the pairings below it can be trusted.

The cause is usually an item from an earlier month that was never cleared, an entry that was backdated after you had reconciled, or a payment posted a day before or after the supplier’s cut-off. Because the difference started in an earlier period, looking through this month’s transactions will not find it. The usual approach is to go back to the last month in which both sides closed on the same figure, roll forward from there, and list each item carried over with its document reference.

The gap is 237.60 in August and it stays 237.60. A gap that stays the same usually comes from one item that first appeared in August. A gap that changes every month means new differences keep landing, and you have more than one problem. Restate from July and find the August document for 237.60, and the later months reconcile too.

One exception. If the supplier has reissued an old statement with changed figures, the closing balance you recorded may no longer match what they now print. Ask which version is current before you go looking for an error of your own.

2. Why is an invoice on the statement but not in my ledger?

E614118 is on the statement, dated 6 October for 2,745.00, and your ledger has nothing. Find out why before you post anything. It may have gone to the wrong inbox, been rejected as a duplicate, or be sitting in an approval queue. It may also not be yours.

Ask the supplier for a copy of E614118 and check it against the purchase order and the goods received note. If both back up the 2,745.00, post it; your ledger then moves from 2,237.85 to 4,982.85. If the delivery note is for less, or you can't find one, that's what you take back to the supplier, not the statement total.

A statement is what the supplier says you owe. It is not an approved liability, so do not pay from it alone.

3. What if a credit note is on the statement but not in my ledger?

The statement has a credit, CR-E90077 for 641.30, dated 9 October, and nothing in your ledger matches it. So your books say you owe 641.30 more than the supplier thinks you do. Ask for the credit note itself, post it, and allocate it against the invoice it relates to. On its own that takes the ledger from 2,237.85 down to 1,596.55.

Credits get lost because they often go to whoever placed the order, or to a mailbox nobody checks. Chasing credits, partial credits and the cash-or-credit choice are in missing credit notes and duplicate payments.

As of 30 October 2026 (Xero Central; Intuit US help; labels vary by region): in Xero, use Allocate Credit on a bill awaiting payment; in QuickBooks Online, the Pay bills screen shows Credit Applied.

4. Why is my payment not on the statement?

You paid 1,918.40 on 30 October against 614093. The supplier ran their statement on 31 October and E614093 is still showing as owed, because the money hadn't been applied yet. That's normal. Ringing them about an unpaid invoice just wastes a call; it'll clear on the next statement.

Look at when the money left your bank and when the supplier says they applied it. If that's after the statement date, you'll see it on next month's statement instead, so log it as timing and leave it there.

The test is the following month. If the same payment is missing from a second statement, it was never timing. It may have gone to the wrong account, bounced, or be sitting unallocated on the supplier’s side. Attach the remittance PDF and ask them to find it.

5. What if the supplier applied my payment to different invoices?

The balances can agree to the penny while the open items do not. You paid 4,372.90 on 16 October to clear three invoices. The supplier’s account shows that money against a different set, so the statement still lists invoices you believe are paid and shows as paid one you have not yet settled.

It usually starts with a lump sum and no remittance, or a payment on account. The fix is a remittance that names each invoice and amount, followed by a request to reallocate. Check your own payment detail too, because sometimes the supplier is right: your remittance never reached them, so they matched the money to whatever amounts fit. Look at E613566. 2,860.55 plus 1,512.35 equals your payment to the penny, so they probably matched on amount.

6. Why does the same invoice appear twice?

E614152 and E614152A are both for 873.65, raised on 13 and 14 October, and you've only booked the first. Don't assume the A is a typo. Until you've seen the paper it's a separate document. Check the delivery note, and if there was only one delivery then the supplier has billed you twice.

Check the dates, the order or delivery note number, and whether either copy has been paid. If you had booked both, void the second. If the supplier raised both, ask them to credit the second invoice, and do not pay it in the meantime. Pay it and you have paid twice and must recover the money. If you have already paid it, the guide linked under Problem 3 covers getting the money back.

The Washington State Auditor’s Office reports that, according to industry experts, organisations make duplicate payments on between 0.8 percent and 2 percent of their total payments (read 31 October 2026). Each one is small, but across a year of supplier payments they add up, which is why a repeat invoice is worth checking before it is paid.

7. Why does the amount differ when the reference matches?

The pair is obvious. E614230 is on both sides, and the statement says 1,436.40 where the ledger says 1,168.00. Do not correct either figure yet. Split the difference into parts you can name until nothing is left unexplained.

Here the invoice was keyed from the goods line alone. Whoever entered it left off VAT and freight, and the statement already shows a settlement discount taken. Freight appears with no VAT to keep the split simple. On a real invoice, check how the delivery charge was taxed. The standard UK VAT rate is 20 percent (GOV.UK, checked 30 October 2026), and reduced and zero rates exist, so use the rate printed on the invoice. This is general information, not tax or legal advice.

Two more to check. A partial credit knocked off part of the invoice and the supplier shows the net. A transposition leaves a difference that divides by nine: 54.10 keyed as 51.40 is out by 2.70, which is 270 pence, and 270 divides by nine. That points to two digits swapped next to each other, so check the typing first.

8. Why won’t these references pair?

You can see the pair. The statement says E614093, your ledger says 614093, and a filter reports both as missing. It is formatting, not a real difference, and it clears with a formula. In Google Sheets, or any spreadsheet with REGEXREPLACE, put =REGEXREPLACE(LOWER(SUBSTITUTE(A2," ","")),"^[a-z]+-?0*","") in a helper column and pair on the result. It drops spaces, case, a leading supplier prefix and leading zeros, and it leaves a suffix such as -A alone. Test it on your own references first, and use it only for pairing; never rewrite either record.

Each of those rules helps in some cases and misleads in others. How supplier statement matching works goes through where each one stops.

The last three need a person. A truncated reference is a lead, not a match, until the amount and date agree.

9. Why do the dates look wrong?

A line looks late, or early, or in the wrong month. Usually it is one of three things. The page prints an invoice date and a due date, the day and month are the other way round from what you expect, or the supplier cuts the month on a different day.

The Aldermoor statement prints a due date 30 days after each invoice date. Read the wrong column and every invoice jumps past the 31 October cut-off.

Settle the invoice date column once for the whole page, rather than row by row. Start with the headers, since most statements label them. If they do not, check which column is later on nearly every row, because a due date should come after its invoice. Position is the weakest clue. The invoice date is usually on the left, but that is just how suppliers tend to lay things out. When a handful of rows break the pattern, put it down to the supplier’s keying and keep the column you chose.

For day and month order, look for any date on the page with a day above 12, such as 25/10/2026. That one date usually settles the order for the whole document. Until you find one, 03/10/2026 could be the third of October or the tenth of March.

For the supplier’s cut-off, use the date printed on the statement, not the calendar month end. If the supplier cuts the month on the 28th and you cut on the 31st, an invoice dated 29 October sits in your October and on their November statement.

10. Statements that never arrive, or findings that go nowhere

This is the one you will not see on any single page. You reconcile the five suppliers you worry about and never see a statement from the other forty. Or you found the 2,745.00 invoice in the example, wrote it down, and it was still unposted at quarter end.

Most of this is housekeeping. Get statements going to one shared inbox rather than whoever happened to be copied in, and ask each supplier in writing to send one every month. For every difference, write down who is dealing with it and by when. Then keep a single page per supplier per month with the statement, the ledger report and the list of differences, each with a cause and a status. When an auditor or someone new asks why a payment went out, you can hand them that page.

How often to run each supplier, and what to do before a payment run, is set out in the month-end and payment-run checklist.

Who is right when the two sides disagree?

Go to the paper. A statement is the supplier’s summary, and suppliers do bill twice and misapply payments. Your ledger is only as good as what was keyed into it, and ACCA lists an invoice posted to the wrong supplier among the causes of a difference.

In the example, E614152A is almost certainly the supplier’s error, pending the order number. In the opening balance account, you cannot say yet whose it is, because the August difference of 237.60 could be a missed posting or a mis-posted one. Open the invoice, the credit note, the remittance or the bank line. The record that disagrees with the paper is the one to correct. Correct your own books with a journal; for the supplier’s records, send a message and the document.

Getting your side out of the ledger

You need a list of one supplier’s bills and credits, with the payments, for the period, to set beside the statement. Each system has a report that lists one supplier’s activity, though neither compares it with the statement.

We searched Xero’s published help and found no supplier statement matching feature as of 30 October 2026, and Xero staff said in April 2024 that it was not planned. A search of QuickBooks Online’s help found none either, though we did not read it end to end. For the report-by-report steps, see reconciling supplier statements in Xero and the QuickBooks Online equivalent.

Stop some of these upstream

A few habits head off several of these: send statements to one inbox, record the supplier’s invoice number in the reference field every time (never your own order number), and post credit notes the day they arrive. None of it needs software.

What if you have too many suppliers to do this by hand?

With a long supplier list, doing this by hand every month stops being practical, however good your method is. Statement Zen reads a statement you forward as a PDF and lists each difference against your Xero, QuickBooks Online or Vista ledger on your dashboard. Whether to pay a disputed invoice is still your call. The free reconciliation takes one real statement, and the pricing page has the paid plans.

Questions people ask

Sources

• ACCA: Supplier statement reconciliations, read 30 Oct 2026
• GOV.UK: VAT rates, read 30 Oct 2026
• Xero Central: Apply a supplier’s credit to a bill, read 30 Oct 2026
• Xero Product Ideas: supplier statement reconciliation request, read 30 Oct 2026
• Intuit: Apply vendor credits to a bill (US help), read 30 Oct 2026
• Washington State Auditor: Paying vendors twice is a problem, read 31 Oct 2026

What changed

• 30 Oct 2026: First published.
• 31 Oct 2026: Reworded the short answer and the opening balance explanation, added a check of the example arithmetic to the introduction, and added the Washington State Auditor source on duplicate payments.