)
Supplier statement reconciliation is the periodic comparison of a supplier’s statement of account against the balance your purchase ledger holds for that same supplier.
By the end of this guide you’ll be able to take a supplier’s statement, agree it to the purchase ledger balance for that supplier, explain every difference, and post the corrections before trade creditors are signed off at month-end. It’s written for AP specialists and finance controllers at UK and European SMEs, and it includes a £ worked example you can copy into your own reconciliation template.
Key takeaways
Work from the statement to the ledger in one direction, and list every difference before you try to explain any of them.
Investigate the largest variance first; handle credits before cut-off items.
Separate timing items from errors, then identify whether each error is in your records or on the supplier’s statement.
Correct your own errors by journal; raise the supplier’s errors as queries and leave your ledger alone.
Reconcile high-spend and credit-heavy suppliers monthly, and put the rest on a rota rather than leaving them.
What supplier statement reconciliation is and why it matters
A supplier statement is the supplier’s version of your account with them. It shows what you owed at the start of the period and what the supplier thinks you owe now. Between those balances, it lists invoices and credit notes alongside payments. Reconciling it tests your purchase ledger against an external document. ACCA treats agreeing payables to supplier statements as a check on completeness, and its guidance on supplier statement reconciliations frames the exercise as a way to find errors early enough to raise them with the supplier.
In the month-end close, it comes before you finalise trade creditors and accruals. A reconciled supplier balance shows which invoices are missing and which credits haven’t been taken. It also shows whether a payment has gone astray before those numbers reach the balance sheet. It is also the accounts payable (AP) control auditors ask about. A monthly reconciliation, documented and reviewed by someone other than the preparer, helps evidence that your payables are complete and can surface duplicate payments.
What you need before you start
Gather these before you open the spreadsheet, because the reconciliation stalls the moment one of them is missing:
The supplier statement, dated to your period end (ask for a re-run if the cut-off is a week out)
The purchase ledger or AP sub-ledger for that supplier, including the closing balance and transaction list
Outstanding invoices, including any sitting in approval or an inbox
Credit notes received or expected, including any disputed items
Payment records, with payment dates and the invoices each payment settled
How to reconcile a supplier statement: step by step
The working sequence is to date-align, match, list, classify, and then correct. Keep that order: if you start adjusting the ledger while you’re still ticking items, you’ll lose track of which differences you’ve explained.
Obtain and date-align the statement
Match the statement cut-off to your period end before you tick anything. A statement dated the 5th of the following month will include invoices and payments that belong to next period, and every one of them will show up as a false difference. If the supplier can’t re-run the statement, note the extra items and exclude them from the comparison.
Match invoice by invoice and credit by credit
Tick off every item that agrees on both sides by document number and amount. Give invoices and credit notes separate passes, then check payments in their own pass. Where a payment on your ledger settled several invoices, check the supplier allocated it to the same ones. Matching by total alone hides offsetting errors.
List the unmatched items
Write down everything left unticked on either side, recording its date and document number alongside the amount. Investigate the largest variance first, since a single big item often explains most of the gap. Credits come next, because an unmatched credit note is cash you haven’t taken. Cut-off items come last; most of them resolve as timing once you check the dates.
Classify each difference
Each unmatched item falls into one of three categories, and the category decides who acts:
Timing differences clear on their own, such as a payment you sent that the supplier hadn’t received by the statement date.
Errors need action from whoever made them. Errors in your records include an invoice received but not posted or a credit note sitting unprocessed; a payment applied to the wrong supplier also belongs here. Errors on the supplier’s statement include an invoice listed twice or a payment the supplier failed to record.
Agree a reconciled balance and post or query corrections
Adjust the statement for timing items and the supplier’s errors, adjust the ledger for your own errors, and the two figures should meet. Post the missing document or a correcting entry, with the source document attached. Raise the supplier’s errors as written queries quoting invoice numbers and dates alongside the values. Hold the affected invoices rather than paying on the statement figure. Keep timing items on the list until next month’s statement shows them cleared.
Worked example: reconciling a supplier statement to the purchase ledger
A supplier’s statement shows a closing balance of £14,820 at 30 September. Your purchase ledger shows £8,460 for the same supplier. Four unmatched items explain the £6,360 gap:
Line | Supplier statement (£) | Purchase ledger (£) |
|---|---|---|
Closing balance per source | 14,820 | 8,460 |
Invoice 4471, received 30 September, not yet posted |
| +2,400 |
Credit note CN118, issued 24 September, not yet posted |
| −600 |
Payment sent 29 September, not yet received by supplier | −3,000 |
|
Invoice 4402 listed twice on statement | −1,560 |
|
Reconciled balance | 10,260 | 10,260 |
Two items are errors in your records, so they need entries. Post invoice 4471 as Dr Purchases £2,000, Dr Input VAT £400, Cr Purchase ledger control £2,400, and credit note CN118 as Dr Purchase ledger control £600, Cr Purchases £500, Cr Input VAT £100. After posting, the ledger shows £10,260.
The other two items get no ledger entry. The £3,000 payment is a timing difference and will appear on October’s statement. The duplicated invoice 4402 is the supplier’s error, so query it and keep the £1,560 on the reconciliation until the supplier confirms the correction.
Why the two balances differ: common causes
Most differences fall into these categories:
Timing differences: A payment is still in transit. Goods may have arrived but not been invoiced, or an invoice dated before period end may have arrived after it. These clear on their own and need an accrual at most.
Missing invoices: The supplier has invoiced, but the document is sitting in someone’s inbox or is stuck in approval. It may never have arrived. Chase the invoice, and accrue the cost if the goods or services were received in the period.
Duplicates: The same invoice has been posted twice on your ledger or listed twice on the statement. On your side, reverse the second posting and check whether it was paid.
Misapplied payments: A payment has gone to the wrong invoice or the wrong supplier. The balance may look right in total while individual invoices stay open and get chased, or paid again.
Unapplied credits: A credit note was issued but never posted or deducted. Net it against the next payment, or request a refund if you no longer trade with the supplier.
Where a supplier invoices in a foreign currency, reconcile in that currency first; your sterling or euro balance will differ because of exchange rates, so separate that movement before investigating other differences.
A statement line is not evidence for an input VAT claim. HMRC’s guidance on keeping VAT records says a statement cannot support a reclaim, so an unposted invoice or credit note found on a statement needs the document itself before it reaches the VAT return.
Statement reconciliation versus bank reconciliation and three-way matching
All three controls compare two or more records, but they work at different levels and catch different things:
Control | What it compares | What it catches | Level |
|---|---|---|---|
Supplier statement reconciliation | Statement vs purchase ledger | Unrecorded invoices and credits, duplicates, misapplied payments, cut-off errors | Account |
Bank statement vs cash book | Unpresented payments, uncleared receipts, bank charges, cash-book posting errors | Account | |
Invoice vs purchase order and goods received note | Wrong price or quantity, goods not received, maverick spend | Document |
Three-way matching runs when an invoice enters the system and stops a wrong invoice before it’s paid; ICAEW groups it with duplicate-invoice checks as a preventive control. Reconciliations run after the fact and are generally treated as detective controls, catching invoices that never reached the system and payments that have already gone.
Manual versus automated reconciliation
Manual reconciliation breaks on volume before it breaks on complexity. One supplier with a few hundred lines can take hours to tick off in a spreadsheet, so many teams can only reconcile their largest accounts each month and review the rest less often. Those less-reviewed accounts are where unclaimed credits can go unnoticed.
One workable approach weights suppliers by spend and credit-note volume, while also considering dispute history. It makes sense to reconcile monthly where any of those is high, since errors there cost the most and age fastest. Put the remaining suppliers on a quarterly rota, and as a minimum review every open item older than 45 to 60 days on any account.
Statements can arrive as PDFs, Excel exports, email bodies, or EDI messages, and each has to be re-keyed or parsed before matching can begin. Accounting systems such as Xero, Sage, NetSuite, and DATEV will produce the supplier account report or open-item list for your side, but line-by-line matching of an incoming statement usually stays in a spreadsheet or a third-party add-on.
It helps to cut the number of differences before they reach the reconciliation. Spendesk is an all-in-one spend management platform consolidating company cards, expense management, accounts payable, procurement, and budgeting. With accounts payable automation, AP teams can flag a likely duplicate invoice at capture and hold an invoice for review when two-way or three-way matching shows it disagrees with the purchase order or goods received note. Native accounting exports to systems including Xero, NetSuite, Sage 100, and DATEV can help keep the invoice in your ledger the same as the one AP approved; review the current integration catalogue to confirm which connector fits your stack.
Frequently asked questions
These answers explain what reconciliation checks and how to set a supplier rota. They also clarify how reconciliation types differ from three-way matching.
What is the purpose of supplier statement reconciliation?
It confirms that the purchase ledger balance for each supplier is complete and accurate before trade creditors reach the balance sheet. Along the way, it surfaces missing invoices and untaken credits. It also identifies duplicate payments while you can still query them with the supplier.
Which suppliers should you reconcile every month?
Reconcile your highest-spend and credit-heavy suppliers monthly; include suppliers with a history of disputes. Lower-activity suppliers can run on a quarterly rota.
What are the three types of reconciliation?
Some guides group bank and supplier reconciliations with customer reconciliation, though the lists vary and no standard classification exists. Bank reconciliation agrees the cash book to the bank statement; supplier statement reconciliation agrees the purchase ledger to the supplier’s account. Customer reconciliation agrees the sales ledger to the customer’s records. Three-way matching is a document-level control, not a fourth type.
With a template and a monthly rota, trade creditors can go to sign-off with every supplier difference explained. If you’d like fewer differences to explain in the first place, book a Spendesk demo to see how duplicate detection and matching could fit your month-end close alongside native accounting exports.
Curious how Spendesk works?
Try an interactive demo to see spend control and approvals end-to-end.
Get a free tour)
Maxime Reding
Originally from Luxembourg and educated at the Rotterdam School of Management, he brings a sharp analytical mindset and a background in strategic management to our finance team. Maxime joined Spendesk in 2021 and has grown steadily through the ranks since, becoming our resident finance engineer.
)
)
)
)
)