Vendor Statement Reconciliation: Steps, Example and Template

Quick answer: Vendor statement reconciliation means comparing a supplier's statement of account with your accounts payable ledger for that supplier, listing every difference (missing invoices, payments in transit, unapplied credits, duplicates, price disputes) and adjusting each side until both show the same balance. Do it monthly for key suppliers and always before paying a disputed balance.

Every supplier keeps its own record of what you owe. When that record and yours disagree, you either overpay, underpay or end up on credit hold. Supplier statement reconciliation is the routine check that keeps both sides aligned. If you are the one sending statements to your own customers, see our guide to the statement of account; this article covers the buyer's side. And when you need to invoice your own clients, our free invoice generator does that part.

Below: why reconciliation matters, a seven-step process, a worked example where two different balances become one, a reconciliation template and the controls that stop the same problems recurring.

What is a vendor statement?

A vendor statement (supplier statement or statement of account) is a periodic summary a supplier sends you, usually monthly. It lists the opening balance, invoices issued, payments received, credit notes and the closing balance due, often with an aging breakdown of 0 to 30, 31 to 60 and 60+ days.

Your side of the comparison is the supplier's sub-ledger in your accounts payable system: every bill you have entered, every payment you have made and every credit you have recorded. The difference between accounts payable and accounts receivable matters here: the supplier's statement is drawn from their receivables, and your ledger is your payables. In a perfect world they mirror each other. In practice, timing and errors mean they rarely do without some work.

Why supplier statement reconciliation matters

• Finds missing invoices. Bills lost in email or never received show up on the statement, so your expenses and liabilities are complete at month-end.
• Prevents duplicate payments. A duplicated bill in your ledger shows as a difference against the statement before it gets paid. See our guide to detecting duplicate invoice payments.
• Confirms credits are applied. Credit notes for returns and pricing errors are easy to forget on one side.
• Protects the relationship. Resolving differences early keeps you off credit hold and preserves trade terms.
• Supports audits and year-end. Reconciled supplier balances are strong evidence that your payables figure is right.

How to reconcile a vendor statement in 7 steps

1. Get the statement and your ledger for the same date. Request a statement as of your month-end and run your supplier ledger report to the same date.
2. Compare opening balances. If last month was reconciled, the opening balances should agree or be explained by last month's open items. If they do not, fix that first.
3. Tick off matching invoices. Match each invoice on the statement to your ledger by invoice number, date and amount. Mark the matches on both sides.
4. Tick off payments and credits. Match payments by date and amount, and credit notes by reference. Use your bank reconciliation to confirm payment dates.
5. List the unmatched items. Anything not ticked on either side goes on a reconciliation schedule with a reason: timing, missing, duplicate, dispute or error.
6. Investigate and act. Enter genuinely missing invoices only after they pass your normal approval checks, reverse duplicates, and contact the supplier about disputes or credits they have not applied.
7. Agree the adjusted balances and sign off. Adjusted ledger balance must equal adjusted statement balance. Record who reconciled it and when, and carry open items forward to next month.

Worked example: reconciling a $3,580 difference

A café buys packaging from one supplier. At 30 September, the supplier's statement shows a balance due of $8,450. The café's payables ledger for the supplier shows $4,870. The difference is $3,580. After ticking off matches, five items remain unmatched:

Item	Explanation	Effect	Adjust which side
Invoice 4471, $1,950	Delivered 29 Sept, invoice on statement but never received by the café	Statement higher by $1,950	Ledger: add after checking delivery note
Payment, $2,000	Bank transfer sent 29 Sept, not yet applied by supplier	Statement higher by $2,000	Statement: payment in transit
Credit note CN-118, $320	Returned damaged cups; café recorded the credit, supplier has not issued it on its statement	Statement higher by $320	Statement: credit to be applied
Invoice 4402, $950	Entered twice in the café's ledger	Ledger higher by $950	Ledger: reverse duplicate
Invoice 4430, $260 overcharge	Billed $1,260; purchase order price was $1,000	Statement higher by $260	Statement: disputed, credit requested

Check that the items explain the whole gap: $1,950 + $2,000 + $320 + $260 minus $950 = $3,580. That matches the difference, so nothing is left unexplained.

The reconciliation schedule

Ledger side	Amount	Statement side	Amount
Balance per café ledger	$4,870	Balance per supplier statement	$8,450
Add: invoice 4471 not yet entered	+$1,950	Less: payment in transit	-$2,000
Less: duplicate invoice 4402 reversed	-$950	Less: credit note CN-118 not yet applied	-$320
		Less: disputed overcharge on 4430	-$260
Adjusted ledger balance	$5,870	Adjusted statement balance	$5,870

Ledger side: $4,870 + $1,950 minus $950 = $5,870. Statement side: $8,450 minus $2,000 minus $320 minus $260 = $5,870. Both sides agree, so the reconciliation is complete. The café now owes $5,870 on its own books, and it emails the supplier asking for the $260 credit on invoice 4430 and confirmation of the $320 credit note. If the supplier issues a credit note for the overcharge, the café records it next month. Our guide to credit notes explains how these documents work, including the case where you raise a debit note yourself.

Common reconciling items and how to fix them

Reconciling item	Timing or error?	Fix
Invoice on statement, not in ledger	Usually missing paperwork	Request a copy, check receipt, approve and enter
Payment in your ledger, not on statement	Timing	Confirm with bank record; should clear next statement
Credit note on one side only	Timing or omission	Request or record the credit note
Duplicate invoice in your ledger	Error	Reverse the duplicate, block payment
Price or quantity difference	Dispute	Compare with PO and delivery note, request credit
Invoice posted to the wrong supplier	Error	Reclassify between supplier accounts
Early payment discount taken but not accepted	Dispute	Check terms; agree with supplier

Discount disputes deserve a note. If you deducted a prompt payment discount, such as 2/10 net 30, the supplier may not apply it if your payment arrived late by their records. See how early payment discounts work before you argue the point.

Vendor statement reconciliation template

A simple spreadsheet template is enough for most small businesses. Use these columns for each supplier:

Supplier | Statement date | Balance per statement | Balance per ledger | Difference | Item reference | Item type (timing / missing / duplicate / dispute / error) | Amount | Side to adjust | Action | Owner | Status | Date resolved

Add a check cell that recalculates both adjusted balances and shows "Reconciled" only when they match. Keep each month's sheet; the history is useful when the same supplier creates the same problem repeatedly.

Controls that make reconciliation easier

Most reconciling items are symptoms of weak upstream controls. Fix those and each monthly reconciliation shrinks to a few minutes.

• Use purchase orders for regular suppliers and match invoices to them and to goods received before approval. This is the three-way match, and it stops most price and quantity disputes at entry.
• Centralize supplier invoices in one inbox so none are lost.
• Enter invoices on receipt, not on payment, so the ledger is complete at any date. A clear accounts payable process sets this rule.
• Check for duplicates by supplier, invoice number and amount before posting.
• Send remittance advice with every payment, listing the invoices paid, so the supplier applies cash correctly.
• Track your payables metrics. Rising reconciliation differences or a growing number of overdue items are early warnings that a process upstream is breaking.

Mistakes to avoid when reconciling suppliers

• Entering statement items without checking them. An invoice that appears on a statement still needs to pass your approval checks. Confirm the goods or services were received and the price matches before you enter it.
• Writing off small differences too quickly. A recurring $40 difference can hide a duplicate charge that repeats every month. Find the cause before adjusting.
• Reconciling only the closing balance. Two balances can match by coincidence while containing offsetting errors. Tick off individual items, not just totals.
• Leaving open items open. Every unresolved item should have an owner and a follow-up date, and should be checked on next month's reconciliation.
• Not keeping evidence. Save the supplier's email confirming a credit or a payment receipt with the reconciliation, so the next person does not have to ask again.

Vendor reconciliation vs other checks

Vendor statement reconciliation is one of several controls around payables. Each catches different problems, so they work best together.

Check	Compares	Catches	When
Three-way match	Purchase order, goods received, supplier invoice	Wrong prices, short deliveries, unordered goods	Before each invoice is approved
Vendor statement reconciliation	Supplier statement, your supplier ledger	Missing invoices, unapplied payments and credits, duplicates	Monthly or quarterly per supplier
Bank reconciliation	Bank statement, your cash records	Unrecorded payments, bank errors, fraud	Monthly
AP control account reconciliation	Total of all supplier ledgers, general ledger AP balance	Posting errors between sub-ledger and ledger	Monthly

The last row is easy to forget. Even if every supplier balance agrees with its statement, the sum of all supplier balances must also agree with the accounts payable control account in your general ledger. If it does not, a journal has been posted directly to the control account or a supplier ledger entry has gone astray.

How to read a supplier statement quickly

Before you start ticking, scan the statement for three things. First, the aging columns: any amount in the 60+ day column is either a genuine overdue bill or, more often, an old invoice you have disputed or already paid. Those are the items most likely to trigger a credit hold, so tackle them first. Second, unapplied cash: some suppliers show payments they could not match to an invoice as a separate credit line. That usually means your remittance advice was missing or unclear. Third, the statement date and cut-off: if the supplier's statement runs to the 25th and your ledger to the 30th, you will see timing differences that are not real problems.

Year-end supplier reconciliations

At year-end, reconcile every supplier with a material balance, not just the regular ones. Accountants and auditors often ask for supplier statements for the largest balances as evidence that your payables are complete. Unrecorded invoices for goods or services received before year-end are liabilities of that year, even if the invoice arrives in January; record them as accrued expenses if the bill is not yet in hand. Old credit balances, where a supplier owes you money, should be claimed as a refund or offset rather than left sitting on the ledger.

Record retention for supplier statements

Keep reconciled statements, the reconciliation schedule and supporting emails with your other accounting records. In the US, the IRS general rule is to keep records that support items on a tax return for at least three years, with longer periods in some situations (see the IRS guidance on how long to keep records). Other countries set their own periods, often longer, so check local rules.

When you are the supplier

The same logic applies in reverse. If you sell on credit, your customers will reconcile your statements, and clear invoices make that easy for them: a unique number from an invoice number generator, the customer's PO number, itemized lines and a running balance. When a customer pays part of an invoice, show the amount paid and balance due on a partial payment invoice so their ledger and your statement stay aligned. If you ship goods, a matching delivery note gives the customer proof of receipt for their own match, and a formal payment request can help when a balance is overdue.

Send invoices your customers can reconcile. Clear invoices make vendor statement reconciliation easy for your clients, just as clear supplier invoices make it easy for you. Create numbered, itemized invoices with PO references, amount paid and balance due using our free invoice generator, or start from the classic invoice template for a familiar, audit-friendly layout. Your finished invoice downloads as a PDF, free and with no sign-up.