A supplier statement reconciliation is only useful if it tells you exactly why the balances differ, item by item.
Supplier statement reconciliation software compares a supplier's statement with your accounts payable ledger and explains every difference: payments in transit, credit notes not yet on the statement, invoices missing from your ledger, price differences and duplicates. Look for tolerant invoice number matching, separate reconciling item types, a query log, a clear reconciliation statement and data that stays where you need it.
A supplier says you owe one amount; your ledger says another. The reconciliation explains the gap with specific items, each with a reason and an action. The manual method is in how to reconcile a supplier statement. Software is worth paying for when it does the matching and sorting faster and more reliably than you can by hand.
For a handful of key suppliers with clean invoice numbers, a controlled Excel workbook works well. Normalise invoice numbers on both sides before matching:
=SUBSTITUTE(UPPER(SUBSTITUTE(SUBSTITUTE(TRIM(A2),"-","")," ","")),"INV","")
This removes spaces, hyphens and an "INV" prefix and puts everything in capitals. Leading zeros remain a difference, so "00104" and "104" still won't match; check those by eye or strip zeros in a helper column. Then match with:
=XLOOKUP(D2,Ledger!D:D,Ledger!C:C,"Not in ledger")
As the number of suppliers grows, or statements arrive in inconsistent formats, the time spent cleaning data is usually where software pays for itself.
UK teams say "supplier statement" and "purchase ledger"; US teams say "vendor statement" and "accounts payable subledger". See the US vendor statement reconciliation guide for US terms.
AI software that reconciles a supplier statement to your AP ledger on your own computer: missing invoices, credit notes, price differences, duplicates and payments in transit. $2,997 once-off; see it on the built-in example first.
The Supplier Statement Reconciliation Template keeps payments in transit, credit notes not yet on the statement and statement items not yet in your ledger as three separate reconciling items, and logs genuine queries instead of netting them into one difference. Excel, no macros, one-time price.
It compares a supplier statement with your AP ledger, matches invoices, payments and credit notes, and lists every difference with its type so you can act on it.
For a few suppliers with clean invoice numbers, yes. As supplier numbers and messy statement formats grow, software usually saves time.
Payments in transit, credit notes not yet on the statement, invoices on the statement not yet in your ledger, price differences and duplicates.
Last updated 15 November 2026. General guidance for finance teams; check it against your own policies, systems and local rules.