Supplier Statement Reconciliation Checklist for Month-End and Before the Payment Run

The two cards

Which suppliers need a check, and how often?

Checking every supplier every month won’t last. Spend the hours where a mistake costs real money.

If no statement turns up

If a supplier never sends one, ask for a statement of account as at a named date. A short email does it: “Please send a statement of our account as at 31 October, listing open invoices, credits and payments received, by 7 November.” While you wait, send them your balance and ask them to confirm it. If they still won’t, log it as a risk on the file.

Which month-end steps do people get wrong?

Five month-end items tend to go wrong. Start with the account itself.

Is it the right account?

Confirm this before you match anything. A supplier with two accounts, or a statement addressed to a sister company, shows a gap that is not an error.

• Account number matches the one in your supplier record.
• Tax ID (ABN or VAT number) matches the supplier on file.
• Billing address and entity name are yours, not a sister company’s.
• Branch or division is the one you buy from, if the supplier splits them.

Pass when all four match the supplier record.

Which kind of statement is it?

This decides which sum you run. A balance-forward statement opens with a balance and lists the period’s activity, so you can prove it adds up. An open-item statement lists only what’s unpaid, so you add up the lines and compare them with the printed total. A plain list of transactions with no balances proves nothing, so ask for a proper statement.

Run the statement’s own sum first

A balance-forward statement should add up: opening balance, plus invoices, less credits, less payments, equals closing balance. Check it before you open the ledger. If it fails its own sum, a page or a line is probably missing from your copy, so ask for a fresh one.

Then agree the opening balance to last month’s signed-off closing balance. A gap means the supplier restated something, or your ledger has moved.

Pass when the printed closing balance equals your own sum and the opening agrees to last month’s sign-off.

Match on the invoice number, then the amount

Tick each statement line off against the ledger by invoice number. Matching on amounts looks quicker, but one wrong figure can cancel out against another. Match payments on date and amount, then check which invoice the ledger payment settled. Bad or mistyped references have their own guide.

Cut-off, and which date to read

Compare the ledger as at the statement date, not today. An invoice dated 30 October that reaches you on 3 November is in the supplier’s October and not yet in your ledger. List it as timing.

Many statements print two dates on a line. Read the column headed Date or Invoice Date, not Due Date. With no headers, the due date is the one that runs later down the whole page.

Pass when the ledger report and the statement end on the same date.

Tie the suppliers to the control account

Statements cover only some suppliers. When the checks are done, add up the supplier balances in your ledger report and compare the total with the accounts payable control account at the same date. If they differ, the fault is in your own books.

Pass when the supplier balances and the control account agree to the penny.

Foreign currency, part payments and restated months

• Foreign-currency statement: your ledger holds the invoices at your own rates, so totals differ even when every invoice is right. Compare each invoice in the supplier’s currency first.
• Part payment: the statement shows one payment against several invoices, and your ledger allocated it differently. Match by date and amount, then re-allocate if the remittance says otherwise.
• Restated earlier month: the opening balance no longer agrees to last month’s sign-off. Ask what changed, leave the old file alone and record the change in this month’s file.

Tolerance is not a write-off

A tolerance decides which small differences you stop chasing this month, such as anything under 1.00 for rounding. They stay on the log. A write-off is a posted adjustment in the ledger and needs approval. These limits are illustrative, so set your own and write them on the working paper. Neither covers a missing invoice or credit note. Materiality is a third idea: the size of difference that would change what you pay or report, which decides what goes to the reviewer first.

Pass when every difference under the tolerance is still on the log and every write-off has an approver’s name.

What does each kind of difference usually mean?

Write a cause next to every difference. “Timing” is a fine cause. “Unknown” isn’t one yet. ACCA’s study material on supplier statements lists the usual reasons: payments in transit, invoices posted to the wrong supplier, credit and debit notes not yet processed, discounts and transposition errors. The flow below sorts one disagreeing line into one of them.

A quick test for wrong amounts: when two digits are swapped, the difference divides by 9. The 180.00 gap on WF-31227 below is 20 x 9. If a gap divides by 9, check for a transposition before hunting for a missing invoice.

The day before the payment run

Do it for every supplier in the run, using the newest statement. A day early leaves time for a phone call. The six open lines below come from the Wexcombe statement in the next section (made-up numbers).

Two invoices are safe to pay, WF-31227 and WF-31241, which come to 4,450.55 once the bill is corrected and the duplicate voided. The credit note takes 612.35 off the next payment once the supplier sends a copy. A credit that shows on the statement alone is only a claim, so chase missing credits before you pay.

Pass when every invoice in the run is on the pay list or on the hold list with a name beside it.

A worked statement, 31 October

Made-up numbers and a made-up supplier. Pryor & Lisle Joinery Ltd is checking the October statement from Wexcombe Fixings Ltd, in pounds. At 31 October the statement says 8,616.20 and the ledger says 7,723.10, so there is a gap of 893.10 to explain.

The statement’s own sum holds: opening 4,731.20, plus five invoices, less one payment and one credit note, gives 8,616.20. The opening agrees to September’s sign-off, so every difference is between the two ledgers.

The 893.10 isn’t any one invoice. It’s the net of six items: three push the statement higher (4,778.00) and three pull it lower (3,884.90).

Four of the six are yours to fix: the swapped bill, the duplicate, the missing invoice and the unposted credit note. Look at your own books before you ring Wexcombe.

Which Xero or QuickBooks Online report gives you your side?

Run a report for your side of the account with its date set to the statement date, not today. We found both report names in Xero’s and Intuit’s own demo companies on 31 October 2026. Labels can differ by region, so check them in yours. The steps are in the Xero walkthrough and the QuickBooks Online walkthrough.

Where Statement Zen fits

A swapped-digit bill like WF-31227 is easy to find on an eight-line statement and slower on a long one. Statement Zen reads a supplier statement PDF against your ledger in Xero, QuickBooks Online or Vista and puts the differences in your dashboard. You can try it on one of your own statements.

Download and print the checklist

The two cards print as they are. Use the Print button, and choose “Save as PDF” if you want a file. The Excel workbook lays a statement against your ledger line by line, and the template guide explains how to fill it in.

Questions people ask

Sources

• ACCA: Supplier statement reconciliations, read 30 Oct 2026
• Xero Central: Select contents and display order in a new report, read 30 Oct 2026
• Intuit: Print or save a vendor report as a PDF, read 30 Oct 2026
• Xero Product Ideas: supplier statement requests, read 30 Oct 2026
• OpenTuition: Supplier Statement Reconciliation (ACCA FA notes), read 30 Oct 2026
• OpenTuition: Supplier statement reconciliation, three kinds of difference, read 30 Oct 2026
• AccountingWEB: Supplier statements and Sage help needed (AAT forum), read 30 Oct 2026

What changed

• 30 Oct 2026: First published. Report names checked against Xero and Intuit help pages and staff replies on this date.
• 31 Oct 2026: Shortened the opening answer, cut repeated prose, trimmed the report section to the two named reports, and added foreign-currency, part-payment, restated-month and escalation guidance. Turned the harder-cases table into a short list and added four more causes to the differences table.
• 31 Oct 2026: Trimmed repeated prose, the duplicate action table, the restated-month paragraph and several table rows. Added an account check, a status vocabulary with a disputed status, a cadence by supplier risk, a tolerance versus write-off note, a statement request email and preparer and reviewer sign-off items. We found the report names in Xero’s and Intuit’s own demo companies on this date, and did not test report contents.