Recovery playbooks · Prevention

A monthly supplier statement reconciliation routine

A monthly supplier statement reconciliation matches what a supplier says you owe against your vendor ledger, so duplicates, missing credits and unapplied cash get cleared while they're recent.

In short

  • Pick the suppliers that make up most of the spend, plus any with known issues.
  • Match each statement item to the vendor ledger and list differences.
  • Clear differences with the supplier the same month.
  • Track credits found on statements until they are applied or refunded.
  • Rotating smaller suppliers through the routine covers the rest over the year.

What the check does

The supplier's statement is their version of the account. Your vendor ledger is yours. The two almost never agree, and most of the time the gap is small and dull: an invoice in transit, a payment not yet banked, a credit posted late. The routine puts both records side by side every month for the suppliers that matter, while the paperwork is still on someone's desk and the clerk who keyed the invoice still remembers it.

What you're hunting is the smaller set of differences that cost money. A duplicate invoice the supplier issued twice and never credited. A credit note your team received and filed without applying. Cash you sent that the supplier is holding unapplied because the remittance never reached the right person. An invoice on the statement that never made it into your ledger at all. A discount you took that the supplier didn't allow.

A packaging supplier's statement arrives with an invoice your ledger shows as paid. That one line can mean several things. The payment is in transit and will clear shortly. The payment posted to the wrong vendor record. Or the supplier billed the same delivery twice, you paid once, and their statement is carrying a duplicate that becomes a second payment if nobody looks. Only a line-by-line match tells you which.

The reason to do it monthly is that recent differences are cheap. Someone can call the supplier and get a credit note issued the same week. Differences left for a year need research, argument and sometimes a write-off, and by then the paperwork has usually gone.

Setting it up

Start with the suppliers that make up most of the spend, plus any with known issues: the ones who keep sending credit notes nobody applies, or whose statements never quite match. Rotate the smaller suppliers through the routine over the year so they get a look without swamping the month. Ask the supplier to date the statement as of your cut-off, because a statement dated halfway through close fills the difference list with timing noise you then have to explain.

Match every statement item to the vendor ledger and build a difference list. For each line, record what the statement says, what the ledger says, what kind of difference it is, and who is clearing it. The categories that do most of the work are duplicate, missing credit, unapplied cash, invoice not recorded, payment not recorded and timing. Naming the type matters: a timing difference needs patience, while a duplicate needs a credit note before the next payment run.

Clear differences with the supplier in the same month. Send one written list per supplier, quote the statement date and the invoice numbers, and ask for a specific action: credit note, refund, or offset against the next invoice. Keep it to one contact where you can. A difference emailed to four people usually gets actioned by none.

Track every credit you find on a statement until it is applied or refunded. This is the step AP teams skip. The credit gets spotted, mentioned in a meeting, and then the next statement arrives without it and nobody notices it has gone. The same applies to a credit sitting with a supplier who has stopped invoicing you.

Where it falls short

Statements only cover the suppliers who send them, and the ones who send them late, partially or not at all are often the accounts with the most wrong with them. A statement is the supplier's claim, not proof of anything. It won't flag the duplicate you paid twice where the supplier recorded both copies and is happy to leave it alone. Silence from a supplier does not mean your records agree.

The routine is also only as good as the vendor ledger it's checked against. If cash gets posted in a lump and cleared later, or credits sit on account with no matching invoice, you're comparing two untidy records and the difference list fills with noise. Tighten the posting habits and the reconciliation gets shorter. Timing differences around cut-off are normal, and a team that chases every line will burn out and stop doing the routine at all.

Coverage is the other limit. Rotating smaller suppliers means some accounts wait months for a look, and suppliers who never issue a statement fall outside the routine entirely, so their unapplied credits sit there quietly. What you can recover, and how long you have to pursue it, depends on the contract and the jurisdiction. Take advice on anything aged or disputed.

Checking that it works

Watch a few measures month to month: how many differences the routine finds, how many are cleared before the next statement, and how old the open items are getting. A difference list that grows while the cleared column stays flat means people are finding problems and not fixing them. If the same supplier shows the same difference two statements running, the routine isn't working yet.

Then test whether the fixes actually landed. Pick something marked as cleared and trace it into the ledger. Did the credit note get posted against the right invoice, or was it noted and forgotten? Did the duplicate get blocked before the next payment run? Did the refund reach the bank? A routine that reports clean while the underlying record stays unchanged is worse than none, because it gives everyone false comfort.

Check coverage as well. Every supplier on the list should have produced a statement, and a missing one is a follow-up, not a gap to accept. Ask the person doing the matching whether they had enough time, because a rushed match skips the odd line and misses the duplicate on page two.

Keep an eye on credits you're owed. A credit held by a supplier is cash sitting with them instead of you. If it can be refunded rather than offset against a future invoice, compare what having that cash back is worth with your own cost of funds before you decide which to ask for.

Questions

What is supplier statement reconciliation?

It's the monthly job of matching the statement a supplier sends to your vendor ledger, line by line, and listing the differences. You're looking for duplicates, credits that were never applied, cash the supplier hasn't matched, and invoices missing from one side or the other. The point is to clear those differences while they're recent.

How often should we reconcile supplier statements?

Every month for the suppliers that make up most of the spend, plus any with known problems. Smaller suppliers can be rotated through over the year so they get a look without filling the difference list. If a statement only arrives once a quarter, reconcile it when it lands and note the gap.

What do we do if a supplier won't send a statement?

Ask in writing, name the cut-off date you need, and keep asking. In the meantime reconcile from remittance advices and your own ledger, and treat the account as a known issue so it stays on the list. Silence doesn't mean the records agree.

How do we handle a credit that shows on a supplier statement?

Log it the day you find it and don't close it until it's applied to an invoice or refunded. Ask the supplier for a specific action, offset or refund, quoting the credit reference. Then check the next statement to confirm it actually moved.

Updated Nov 15, 2026. Figures on this page are calculated by ERPSav from the definitions shown. The explanatory text is drafted with AI from those figures and checked automatically before it is published. General information only, not legal, tax or financial advice.