A vendor statement is a free second opinion on your accounts payable balance. Use it.
To reconcile a vendor statement, pull the vendor's open items from your AP subledger as of the statement date, match them to the statement by invoice number, and list every difference: checks and ACH payments in transit, credit memos not yet applied, invoices on the statement you haven't entered, pricing differences and duplicates. Adjust both balances until the difference is zero, then follow up each item.
Ask for a statement showing open items, not just a balance, as of a month-end date. See vendor statement requests for which vendors to ask and how often. Send the request from your usual AP address and check any statement that arrives with new remit-to or bank details: that is a common fraud route. See callback verification.
Run the vendor's open items from the AP subledger as of the same date: invoice number, date, amount, and any payments and credit memos. Include items still awaiting approval, because the vendor will show them as owed.
Clean invoice numbers on both sides first, so "INV-2291" and "2291" match:
=SUBSTITUTE(UPPER(SUBSTITUTE(SUBSTITUTE(TRIM(A2),"-","")," ","")),"INV","")
Then look each statement line up in your subledger and the reverse:
=XLOOKUP(D2,AP!D:D,AP!C:C,"Not in AP")
=IF(ISNUMBER(E2),ROUND(C2-E2,2),"")
The second formula shows any amount difference on matched invoices.
With all amounts shown as positive numbers:
Adjusted statement balance = Statement balance
- payments in transit
- credit memos in AP not on the statement
+ invoices in AP not on the statement
Adjusted AP balance = AP subledger balance
+ invoices on the statement not in AP
- credit memos on the statement not in AP
Difference = Adjusted statement balance - Adjusted AP balance (should be 0)
If the difference isn't zero, an item is missing or classified on the wrong side.
This guide uses US terms: vendor, AP subledger, credit memo, checks and ACH. UK teams say supplier, purchase ledger, credit note, cheques and BACS or Faster Payments, and the method is the same; see supplier statement reconciliation. Unclaimed or uncashed vendor checks may fall under state unclaimed property rules; check the current rules for your states.
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.
Monthly for your largest and most active vendors, and at least quarterly or at year end for the rest.
Not from the statement. Get a copy of the invoice, check it against the PO and receiving report, and route it for approval first.
A check or ACH payment you made before the statement date that the vendor had not recorded when the statement was produced.
Last updated 15 November 2026. General guidance for finance teams; check it against your own policies, systems and local rules.