A supplier statement can disagree with your AP ledger even when both sides are internally consistent. Differences often come from timing, unmatched payments, missing invoices, supplier credit notes or documents allocated to the wrong account. The goal of reconciliation is not to force the numbers to match: it is to explain every material variance with evidence.
Choose one supplier and one comparison date
Begin with the supplier statement and the AP ledger extract for the same supplier, entity, currency and statement cutoff. Check whether the supplier's opening balance includes amounts cleared earlier in your ledger. Where a business has multiple supplier accounts for the same legal party, document precisely which accounts are in scope.
Match the transactions correctly
Use a composite match key when possible: supplier identifier, document type, normalised invoice number, currency and signed amount. Keep the original invoice number as evidence, even when you use a normalised copy to identify differences in spaces, case or punctuation. A repeated reference can indicate a possible duplicate, but invoices with identical amounts are not automatically duplicates.
For each statement line, record whether there is an exact match, partial match, unmatched statement transaction or unmatched ledger transaction. Partial matches deserve a separate reason code rather than being silently treated as clear.
Investigate the highest-value differences first
Common investigation categories include:
- Invoice appears on the statement but has not been entered into AP.
- Payment appears in AP but the supplier has not allocated the remittance yet.
- Credit note is missing, reversed or posted against the wrong supplier.
- Document amount differs because of tax, pricing, freight or exchange-rate treatment.
- Invoice is posted to a different reporting period.
Build a transparent balance bridge
Start from the supplier closing balance, add or subtract supported reconciling items using consistent sign conventions, and arrive at the comparable AP balance. Never classify a difference as timing merely because it is small. Save document references and explanatory notes for each reconciling item.
Worked example: a $550 supplier difference
Fictional example, USD: supplier statement $12,400; AP ledger $11,850. Investigation finds an $800 statement invoice not yet posted in AP and a $250 credit already in AP but absent from the statement. Balance bridge: $11,850 + $800 − $250 = $12,400.
The bridge explains the variance but does not validate either transaction. Verify the invoice, receipt, credit authorisation and posting dates. Record the owner, evidence and follow-up date; never post an unsupported balancing adjustment just to force agreement.
Close with evidence and independent review
Give each unresolved item an owner and due date. Preserve the statement, AP export and remittance evidence. The reviewer should see both the mathematical reconciliation and a list of unresolved transactions. An item can be under investigation without making the whole report appear clean.
Free resource: The GetTheDocs Supplier Statement Reconciliation Guide contains a step-by-step investigation sequence.
Human verification is required before altering supplier records, making adjustments or authorising payments.
Put this into practice: Supplier ReconMatch Pro matches supplier statements to your AP ledger line by line and explains the balance difference. Macro-free Excel with a Worked Example and a Blank edition, one-time payment, instant download. Or start with the free Supplier Reconciliation Guide (printable PDF).