
A supplier statement reconciliation template should explain the difference between the supplier's statement and your ledger at an agreed cutoff date. It also needs to show which items remain unresolved. A matching closing balance alone cannot demonstrate that the individual invoices, credits and payments are correct.
Use three worksheets: scope, source lines and exceptions. The structure below is a practical starting point for a finance team. Adapt signs and account treatment with the person responsible for your ledger.
Worksheet 1: fix the comparison scope
Record the supplier account, your legal entity, currency, statement cutoff date, ledger extraction time and opening balances. Link to both original files. Mark whether the statement includes outstanding items only or a complete movement history.
A current ledger and an older statement can differ because a payment falls between the two dates. Identify that timing difference before asking someone to change an entry. Never combine separate legal entities because a supplier uses the same trading name.
Worksheet 2: preserve the source lines
Use these columns: source side; source row ID; original reference; comparison reference; document date; transaction type; currency; signed amount; candidate match ID; matching rule; review result.
Keep the original reference intact. If your comparison reference removes spaces or punctuation, document that rule. Two different references can collapse to the same value after normalization. Such a collision needs review rather than an automatic match.
Treat a partial payment as an allocation to an invoice, not a replacement invoice amount. Record separate allocation rows when one payment covers several invoices. This preserves the movement history and the amount left open.
Worksheet 3: give each exception an owner
Copy these headers: exception ID; statement row; ledger row; category; amount effect; supporting evidence; owner; next action; review date; status; resolution reference.
Useful categories include statement-only invoice, ledger-only invoice, unmatched credit, payment allocation, timing difference, amount difference and ambiguous reference. Set the category after checking the evidence. A statement-only invoice may be missing from the ledger, but it may also use a different reference or fall outside the agreed scope.
A worked example with fictional numbers
Assume both sources describe amounts payable as positive. The supplier shows a closing balance of 12,000 and your ledger shows 10,800 in the same currency. The difference is 1,200.
You identify an invoice for 1,000 present only on the statement, and a credit of 200 present only in your ledger. Starting from the ledger, adding the invoice gives 11,800. Removing the ledger-only credit from the comparison adds back 200, producing the supplier's 12,000.
This is an explanation to verify, not a posting instruction. Ask for the invoice copy and confirmation of the credit's treatment. Do not enter an unexplained adjustment of 1,200 to make the totals agree.
Controls before closing the worksheet
Check that every source row is represented once, every allocation has a stable ID and each remaining difference appears in the exception register. Preserve unresolved items even if other differences offset them.
Protect formulas and retain a dated copy of the reviewed result. If two people work on the same account, make ownership and updates visible. A manually overwritten match can otherwise remove the evidence behind the balance.
For the broader process, see how to resolve supplier statement exceptions. Start with your accounting software's exports and reconciliation features. If PDF extraction and handoffs still create repeated work, discuss a bounded workflow with Kaliits.

