Vendor statement reconciliation means comparing the statement your supplier sends with your accounts payable ledger for that supplier at the same date. You match every invoice, credit note and payment on both sides; the lines that appear on only one side, or with a different amount, date or sign, are the items that explain the balance difference and must be corrected or confirmed.
Why reconcile supplier statements?
A supplier statement is an independent record of what you owe. Comparing it with your ledger reveals invoices that were never posted, payments the supplier has not applied, duplicate postings and missing credit notes before they turn into late-payment disputes or audit findings.
Regular reconciliation also protects your cash: a payment made twice or an unapplied credit note is money you can recover only if you notice it.
Step by step
- Choose the reconciliation date and request a statement from the supplier as of that date (or download it from their portal).
- Export your vendor ledger for the same supplier and the same date range from your ERP, including open and cleared items.
- Check that both opening balances agree; if they do not, start from an earlier date where they did.
- Match invoices by invoice number and amount, payments by amount and date, and credit notes against the invoices they reduce.
- List the unmatched items on each side and classify them: timing difference, missing posting, wrong amount, duplicate or wrong account.
- Agree the corrections with the supplier, post your own adjustments and confirm the closing balance in writing.
Most common causes of differences
- Invoices in transit: issued by the supplier, not yet received or posted by you.
- Payments booked on different dates (value date vs. posting date) or applied to the wrong invoice.
- Credit notes, price differences or returns recorded on one side only.
- Invoice numbers written differently (prefixes, leading zeros, spaces).
- Foreign-currency invoices converted at different exchange rates.
- Postings made to the wrong vendor account.
Example: a difference sheet
| Item | Supplier statement | Your ledger | Category |
|---|---|---|---|
| Invoice 4471 | 8,400.00 | — | Invoice not received or not posted |
| Payment 18 Oct | — | −12,000.00 | Payment not yet applied by supplier |
| Credit note 0093 | −650.00 | — | Credit not taken in your ledger |
| Invoice 4402 | 5,200.00 | 5,200.00 paid twice | Duplicate payment, recover it |
Doing it faster
Matching in a spreadsheet works for a few dozen lines. For long statements, many suppliers or a year-end deadline, a reconciliation tool reads both exports, normalises invoice numbers, matches lines and lists only what needs your attention.
With mutabakat.com you upload both files, the lines are matched by a rule engine supported by trained AI, an expert checks the result and you can share the list of differences with your supplier through one link.
Frequently asked questions
How often should supplier statements be reconciled?
Key suppliers monthly, others at least quarterly and always at year end. Large or disputed accounts deserve monthly attention.
What if the supplier does not send a statement?
Send your own balance and open items and ask them to confirm or list the differences. A balance confirmation request with a reply link makes this easier.
Who should adjust: us or the supplier?
Whoever made the error. Timing differences need no adjustment; they clear when the document is posted on the other side.
What are the three types of reconciliation?
In accounts payable work people usually mean bank reconciliation, vendor (supplier) statement reconciliation and general ledger account reconciliation. Customer and intercompany reconciliation follow the same principle.
Can vendor reconciliation catch duplicate payments and fraud?
Yes. Duplicate payments appear as credits on the supplier's statement; invoices from a supplier that never sends statements, or bank details that changed recently, are warning signs worth checking.
Start with one account. If the differences are not clearer than in your spreadsheet, you have lost nothing.
Start free trial →Last updated: November 14, 2026 · mutabakat.com