How to Reconcile a Supplier Statement, With a Full Worked Example

What is a supplier statement?

Your ledger holds only what reached accounts payable. If the supplier raised an invoice that never got to you, or sent a credit note to an inbox nobody reads, the statement is the only place it appears. A payment they put against the wrong invoice looks like this from your side: a balance you believe you cleared, still open on their page.

The statement is the supplier’s version, and it can be wrong too. They may post your cash on the day it clears rather than the day you sent it, or print an invoice twice, or bill the wrong account. Look at each line before you decide the mistake is yours.

Two kinds of statement

The glossary has short entries on each: balance-forward statement and open-item statement.

Same document, different names

What to have in front of you

Get these together first, or you will stop halfway and start again.

• The statement, dated to your cut-off. If it was run on the 25th and your ledger runs to the 30th, ask for a re-run.
• Your ledger transactions for that supplier over the same dates, with the closing balance as a check.
• Bills sitting in an approval queue or a shared inbox. The supplier counts them and your ledger does not.
• Credit notes you have received and not yet posted.
• Remittance advice or the bank file, showing which invoices each payment cleared.

Run the ledger side as at the statement date, not today. Run it today and everything paid since has dropped off the open list, so you will chase items that are already settled.

How to reconcile a supplier statement in seven steps

Step 1 can stop the whole job. If the statement does not add up, ask the supplier for a reprint before you do anything else.

1. 1

   Prove the statement adds up

   Opening balance, plus invoices, less credits and payments, must equal the printed closing balance. Do the sum before you open your own books, and add up the ageing box too if there is one. If either sum fails, a page or a line is missing, so ask for a reprint and stop there. In the example it comes to $19,337.55 and it holds.

2. 2

   Agree the opening balance to last month

   The opening balance should equal the closing balance you agreed last month. When it does not, something from an earlier month is still unresolved, and matching September’s lines will not fix it. Go back to the last month the two sides agreed and work forward from there. An open-item statement has no opening balance, so skip this step.

3. 3

   Clean the references on both sides

   One invoice can be written CPS-70495, 070495 and cps 70495. Strip the prefix, the spaces and the leading zeros so all three read 70495. If you skip this, you will report an invoice as missing when it is in your ledger under another spelling, and you will miss the duplicate. When two documents share an amount and the reference is ambiguous, the matching guide shows how to decide.

4. 4

   Tick line by line, in three passes

   Do invoices first, then credit notes, then payments. Match on reference and amount together, because two real invoices can share a total. Check the allocation of a payment that clears several invoices, not only its total. In the example the 12 September payment of $9,386.40 clears two older invoices, and the statement names both.

5. 5

   List what is left on each side

   Whatever has no partner is a difference. Write the statement leftovers and the ledger leftovers as two lists and do not net them yet, because a duplicate can hide behind a missing invoice once they are netted.

6. 6

   Give each leftover a cause and an owner

   At this stage each line that is left should fall into one of three groups. It is either an item you booked wrongly or missed, an item the supplier got wrong, or a timing difference, such as a payment that left your bank on the 29th and will appear on their next statement. Your own errors can be corrected straight away, the supplier’s need a query sent to them, and the timing items should be noted so they can be checked on the next statement. A line that still has no explanation should stay open until it has one. Posting the remainder to a suspense account would make the totals agree, but it would only hide the problem until it is found at audit. If a line will not sort, the Academy decision tree takes you through the same questions in order.

7. 7

   Fix, query, diary, then sign

   Post your own corrections, send the queries and diary the timing items for next month’s statement. Then write the two-sided reconciliation. Both adjusted balances must agree to the cent before anyone signs.

A full worked example: Wenlock Pallet & Crate, September

Wenlock Pallet & Crate (the supplier) sent Oakhollow Joinery (the customer) a balance-forward statement dated 30 September 2026. Both businesses are made up, and all amounts are Australian dollars including GST, so if you work in another currency read the dollar signs as yours. The numbered lines are the ones to watch. Two defects will not show on the page at all: a double posting in Oakhollow’s ledger, and a line where Wenlock’s statement is higher than its own invoice. You only find those by comparing.

Step 1 in numbers

Start at 9,386.40. Add the six invoices (3,712.60, 1,958.25, 2,604.10, 4,271.35, 5,129.80 and 2,047.95, total 19,724.05). Take off the payment of 9,386.40 and the credit note of 386.50. The result is 19,337.55, the printed closing balance, so the statement holds.

The ledger against the statement

Oakhollow’s ledger shows $12,875.60 for Wenlock at 30 September, a gap of $6,461.95. Here is each document against its partner, with the references cleaned.

Why the gap of $6,461.95 misleads

Three items push the gap up: the payment in transit (3,712.60), the missing invoice (5,129.80) and the supplier’s overstated invoice (54.00), together 8,896.40. Two push it down: the unposted credit note (386.50) and the duplicate (2,047.95), together 2,434.45. Net, that is 6,461.95.

The five items move $11,330.85 in all, yet the net gap is $6,461.95. Chase the net figure and you would hunt for one missing invoice of about that size, when the duplicate has already cancelled part of the 5,129.80 invoice. No single 6,461.95 item exists.

The finished reconciliation

After the 29 September payment, Oakhollow owes Wenlock $15,570.95, provided CPS-70488 turns out to be a real invoice for that amount and Wenlock corrects CPS-70466. Do not pay CPS-70488 until you have the document. The sign-off block below holds the usual details, and the free spreadsheet template lays the same page out for you to fill in.

So for Friday: CPS-70412 is already paid. What is left to pay is CPS-70427, CPS-70439, CPS-70466 at its invoice amount of 4,217.35 and CPS-70495 once, plus CPS-70488 when you have seen it, less the credit note. The Academy has more statements to practise on, with answers.

The same account on an open-item statement

Had Wenlock sent an open-item statement, it would list only what is unpaid, with no opening balance to agree. CPS-70412 would still appear at 3,712.60, because Wenlock has not received the 29 September payment. Match each line against your open bills and that one becomes your timing item. The other lines are the same as the table above, and the total is 19,337.55.

Why does the supplier’s balance differ from your ledger, and who fixes each difference?

These are twelve differences you are likely to meet, and ACCA’s technical article on supplier statement reconciliations (listed under Sources) names the same main ones. The owner column says whether you post, query or wait. The Academy cheat sheet has a one-page version.

Ready-made emails for a missing credit note or a double payment are in the guide on missing credit notes and duplicate payments. The problems that come up across suppliers are in the problems guide.

When not to chase

Decide on a tolerance before you start, so that it is not made up line by line, and write it down where a colleague can find it. The tolerance applies only to differences you have already explained.

A statement line is not a tax invoice

Can Xero or QuickBooks Online produce a supplier statement?

Not in the shape a supplier sends. As of 30 October 2026 we found no supplier statement in Xero’s published help or on its Product Ideas board, and no vendor statement report in QuickBooks Online’s help. Both packages give you a transaction list for one supplier, which you tick against the statement. The reports are listed below.

Run the report to the statement date. Which report suits which kind of statement is covered in the Xero guide and in the QuickBooks Online guide, and in any other system the supplier’s transaction list can be exported to a spreadsheet.

What to say to the supplier

Say which invoice or credit note you mean, give the reference and the amount, then say what you need from them and by when. A short message with one clear question is usually answered first.

The wording for a missing credit note or a duplicate payment is in the guide on missing credit notes. The message below is for a statement whose lines do not add up to the printed closing balance.

How often should you reconcile supplier statements, and who signs off?

For any supplier you pay every month, a monthly reconcile is the usual rhythm. If they send you credits regularly, or you have a dispute open, it is worth looking at the account again just before each payment run. Most people do the big suppliers and let the small ones slide, and that is where unclaimed credit notes tend to pile up, so give the small accounts a rule as well, even a light one. We put the tiers and what to do for each in a month-end and pre-payment-run checklist.

Who prepares it and who signs it

The accounts payable clerk usually prepares it. A second person, such as the accounts payable lead or the financial controller, reviews it and signs it off. We found no standard that mandates this for statement reconciliations, so treat it as good practice. A smaller business with one bookkeeper can swap the reviewer for a quarterly look by the owner. Auditors care about this check as well. An OpenTuition tutor answering an audit student in November 2023 named cut-off as the risk that ties most closely to timing differences, meaning items recorded on the wrong side of the period end.

Does three-way matching or a bank reconciliation replace supplier statement reconciliation?

Three-way matching does not cover this. It matches an invoice to a purchase order and a delivery note, which stops a wrong bill being approved. It cannot find an invoice you never received, because there is nothing to match. The comparison of statement reconciliation and invoice matching goes into why.

Doing it in a spreadsheet, and when to stop

A spreadsheet is fine while you have few statements and can copy from them. Once you are retyping PDFs, it stops being worth the time.

The workbook strips prefix letters, leading zeros and spaces before it matches, so INV-00123 and 123 count as the same invoice, and it will not mark the reconciliation as signable while any check is failing. It holds 300 lines a side, one supplier and one currency per copy. It cannot read a PDF or explain why a line differs, and a reference with a trailing part such as INV-4541-1 needs the override column on the Statement sheet. We tested it in LibreOffice, not Google Sheets.

Where Statement Zen fits

We make Statement Zen, so weigh this section accordingly. It takes over the retyping, which is what stops a spreadsheet working once you pass 300 lines a side or a pile of PDFs. Forward the supplier’s statement PDF and it is checked against your ledger in Xero, QuickBooks Online or Vista, with the differences grouped on your dashboard. To see it on one of your own statements, forward the statement and see the result.

Where to start on Monday

Take the supplier whose statement has sat in a folder since last month and do steps 1 and 2 only. If the statement adds up and the opening balance agrees, the rest is ticking. If either fails, you have probably found why this account has never agreed.

When the routine is steady, the best-practice guide covers how to keep it cheap.

Questions people ask

Sources

• ATO: Tax invoices, read 30 Oct 2026
• HMRC VAT Input Tax manual: acceptable evidence for claiming input tax, read 30 Oct 2026
• Xero Product Ideas: supplier statement report (Xero staff replies), read 30 Oct 2026
• Intuit: Vendor Balance Detail report, read 30 Oct 2026
• OpenTuition forum: supplier statement reconciliations (tutor reply on cut-off, November 2023), read 30 Oct 2026
• ACCA: Supplier statement reconciliations (cross-check on causes), read 30 Oct 2026

What changed

• 30 Oct 2026: First published. On this date we read the six pages listed under Sources. They are the ATO page on tax invoices and the HMRC VAT Input Tax manual page on acceptable evidence. They also include the Xero Product Ideas thread on supplier statements, the Intuit help article on Vendor Balance Detail, the OpenTuition forum thread and the ACCA article. We also recomputed every figure in the worked example.
• 31 Oct 2026: Shortened the Xero and QuickBooks Online, supplier wording and spreadsheet sections and four FAQ answers, with no change to any figure or source. Rewrote the opening definition, changed the answer box to match the first heading, and replaced the tolerance paragraph with a table. On this date we recomputed the worked example on both sides: the statement side (19,337.55 less 3,712.60 and 54.00) and the ledger side (12,875.60 plus 5,129.80, less 386.50 and 2,047.95) both come to 15,570.95.
• 31 Oct 2026: Takeaways now open with the definition and the example’s figures. Ran Supplier Bill Activity in Xero’s Demo Company (AU) and updated its report card.