Bookkeeping

Supplier statement reconciliation, step by step

Supplier statement reconciliation is the monthly routine of comparing what a supplier says you owe against what your own accounts payable ledger says you owe — and explaining every difference. Do it well and you catch missing invoices, unapplied payments and duplicated bills before they become disputes or late-payment queries.

Note the two directions: here the supplier sends you a statement and you match it to your AP ledger. The mirror task — generating a statement from your own books to send out — is covered in how to create a supplier statement.

The order of operations that actually works

Start with the closing balances. If supplier statement and ledger agree, you may be able to stop here — check for old items anyway.
Confirm the period boundaries. Their statement may start mid-month or include invoices you received after your close. Align the dates first; many "differences" are just cut-off artifacts.
Match by document, not by total. Walk each invoice number on their statement and find it in your ledger. Same for payments and credit notes. An amount-only comparison hides offsetting errors.
Tick the matches, then explain the residue. Whatever remains un-ticked falls into one of the six buckets below.
Write the reconciling items down. A reconciliation that isn't written up is a conversation, not a control. Note: item, value, whose books it's missing from, and the fix.

The six differences that cause almost all mismatches

1. Timing differences

A payment you sent is on your ledger but not yet on their statement (in transit, or not yet applied to the account). This is the most common and least alarming item — just note the clearing date.

2. Invoices not yet received

They billed you; the invoice is in their system and hasn't reached yours. Real risk: an unexpected liability. Flag it and request a copy.

3. Unapplied payments or credits

They received your payment but didn't apply it to an invoice — it sits on account. Your ledger says paid; theirs still shows the invoice open and a credit balance. Ask them to allocate it.

4. Duplicated or disputed invoices

Same invoice posted twice on either side, or a bill you dispute that they still show as live. These need action, not explanation.

5. Credit notes not processed

They issued a credit note but you haven't booked it — the reverse also happens, which is worse because you're owed money you're not tracking.

6. Errors on either side

Wrong amount, wrong currency, wrong supplier account, keyed twice. Every reconciliation should be able to prove:

your true balance = their statement balance + items they're missing − items you're missing

Proving the balance from your own side

When you need to produce the evidence — during a dispute, an audit, or month-end — you need your own supplier statement with a running balance that is provably arithmetic-correct. That's exactly what Statemint generates from your accounting export: sorted chronologically, computed in integer cents, closing balance guaranteed by an enforced identity. No upload, works offline, one-time purchase ($29 early bird, $39 regular).