Vendor Statement Reconciliation: How to Reconcile a Supplier Statement to Your AP Ledger

Vendor statement reconciliation is the process of comparing a supplier's statement of account to the accounts payable ledger for that supplier in your own books, and explaining every difference. Where the two disagree, one of four things has happened: an invoice is missing on your side, an invoice is missing on theirs, a payment is in transit, or a credit has not been applied.

What is a vendor statement, and why does it matter?

A vendor statement (or supplier statement) is a document the supplier issues, usually at month end, listing every transaction on your account for the period: invoices issued, credit notes, payments received, and a closing balance. Unlike an invoice, it creates no new obligation. Its value is that it is the supplier's independent record of the same relationship your AP ledger describes, which makes it the one external check on whether your payables are complete and correct.

For a small operating business, the statement is where three expensive problems surface first:

• Missing invoices. A delivery was made, an invoice was issued, and it never reached whoever enters bills. The statement shows it; your books do not. Left alone, it becomes an overdue balance, a stopped delivery, or a surprise at year end.
• Duplicate payments. You paid an invoice twice, or paid an invoice and also a statement. The statement shows a credit balance or an unapplied payment. Our guide on how to prevent duplicate invoice payments covers the controls; the statement is where you find the ones that got through.
• Lost credits. The supplier issued a credit for a short delivery or a return, it appears on their statement, and it was never applied to a payment on your side. You have overpaid by the credit amount.

For a restaurant with a dozen food and beverage suppliers (our restaurant invoice management guide covers the weekly routine around it), or a logistics business with carriers and fuel vendors, the statement reconciliation is the AP control that pays for itself fastest.

Before you start: get the two documents side by side

You need two things for one supplier and one date.

The supplier's statement. Most arrive by email at month end. Some vendors only publish them in a billing portal; our vendor portal guides give the menu path for common suppliers such as US Foods, Uline, and Grainger.

Your AP ledger for that vendor as of the same date. In QuickBooks Online, search Reports for "Vendor Balance Detail" and filter to the vendor, or open the vendor's profile under Expenses, then Vendors, and use the Transaction List (Intuit help, as of October 2026). In Xero, run the Aged Payables Detail report filtered to the contact, which lists open bills, credit notes, and overpayments; Xero's supplier activity view shows the payments.

The precondition that trips most small businesses is that the ledger is only as complete as your invoice capture. If a third of the supplier's invoices are sitting unread in an inbox, the reconciliation will produce a long list of "missing on our side" items that are not really missing. This is where automated capture earns its place: Inbox Ledger connects to Gmail, Outlook, or IMAP with read-only access, finds invoices and receipts, extracts the data with AI, matches them to bank statement transactions, and pushes bills to QuickBooks Online or Xero. With that in place, every invoice the supplier emailed is already captured, under one normalized vendor name and, once your bank statements are uploaded, linked to its payment before you open the supplier's statement. The reconciliation becomes a comparison rather than a search.

The procedure

Step 1: Agree the opening balance

Compare the statement's opening balance to your ledger balance for the vendor at the start of the period. If last month was reconciled, these agree. If they do not, resolve the opening difference first; otherwise every item this month inherits it.

Step 2: Tick off matching invoices

Go line by line through the statement's invoices and find each one in your ledger by invoice number. Where the number matches and the amount matches, tick both. Where the number matches but the amount differs, note the difference; this is usually a partial credit, a freight line, or a tax rounding.

Step 3: Tick off matching payments and credits

Do the same for payments the supplier has recorded and for credit notes. A payment on the statement should correspond to a payment in your ledger (and to a bank transaction). A credit note should correspond to a credit entry on your side.

Step 4: Classify every unticked item

Everything left falls into one of four types:

A fifth category hides inside the second and third: the same invoice appearing twice in your ledger under two vendor names, or two payments against one invoice. If an item will not classify cleanly, check for that before anything else.

Step 5: Agree the closing balance

After classifying, the statement's closing balance should equal your ledger balance plus or minus the explained differences. If it does, the reconciliation is done; document the differences and their resolutions. If a residual remains that you cannot explain, do not plug it. An unexplained residual is the symptom of a duplicate or a lost credit, and plugging it hides the money.

Step 6: Fix the causes, not just the items

A supplier whose invoices are regularly missing on your side has a delivery channel you are not watching. Fix the channel: add their sending address to the connected inbox, set up a forwarding address they can bill to, or add their portal to the monthly download list. A supplier whose statement regularly shows unapplied payments needs your remittance advice sent with every payment.

A worked example

The figures below are illustrative and do not describe a real customer. A cafe reconciles its main produce supplier for September.

Supplier statement, September 30: opening balance $4,180.00; closing balance $2,540.00.

Working the $1,110.00 difference:

• Ledger is missing Inv 55261 ($1,290.00). Adding it moves the ledger to $2,720.00.
• Ledger is missing Credit 9012 ($180.00). Applying it moves the ledger to $2,540.00. The balances now agree, but the line-by-line tick-off still does not.
• The two $1,240.00 payments on Sep 26: the ledger records one against Inv 55102 and the second against Inv 55188 by mistake (the bookkeeper matched it to the nearest open invoice), so the ledger shows only $75.00 still open on 55188. The supplier applied the first payment to 55102 and holds the second as an unapplied payment on account, so its statement shows 55188 fully open at $1,315.00 alongside a $1,240.00 credit. The totals match; the open items do not. Moving the second payment off 55188 to an unapplied vendor credit leaves the ledger balance at $2,540.00 and reveals that Inv 55102 was paid twice.
• Resolution: ask the supplier to refund the $1,240.00 or apply it to Inv 55188, which leaves $75.00 open on that invoice. Either way, both sides close at the same figure with the same open items.

Three findings from one statement: a missing invoice (a capture gap, the invoice was in the owner's personal inbox), a lost credit worth $180.00, and a duplicate payment worth $1,240.00 that would have sat as a credit on the supplier's books indefinitely. Note that the duplicate payment did not show up in the balance at all: once the invoice and the credit were entered, both sides agreed at $2,540.00. It only surfaced in the item-by-item tick-off of Steps 2 and 3, which is why agreeing the closing balance alone is not a reconciliation.

Tolerance and escalation rules

You do not need to chase every cent. Write down two rules and apply them every month.

Tolerance for timing and rounding. Differences under a small fixed amount (for example $5 to $10 per item) that are explained by tax rounding or freight allocation can be written off to a variance account. Differences explained by timing (a payment sent on the 29th, received on the 2nd) are noted and expected to clear next month. Our guide to what invoice reconciliation is covers how tolerance thresholds are set in matching generally.

Hard rule for persistence. Any item that appears in two consecutive reconciliations unresolved is escalated: the supplier is contacted in writing with the invoice or payment reference, and the item is flagged in the close memo. A balance that will not clear in two cycles is usually a duplicate payment or a lost credit, not a timing difference.

Materiality for which vendors to reconcile. Reconcile every supplier above a spend threshold monthly, and the rest quarterly. In many small businesses, the top ten vendors by annual spend account for the bulk of payables, which makes them a sensible monthly list.

Where this fits in the close

Vendor statement reconciliation is a Day 4 item in a five-day month-end close, after the bank accounts are reconciled and before the statements are produced. It depends on the bank reconciliation, because the payment side of the statement can only be confirmed against cleared transactions; see our bank reconciliation guide for that step. It feeds the AP aging review, because a reconciled vendor balance is the only aging figure worth reviewing.

Start for free and extract your first 10 invoices without a credit card.

Automating the comparison

The part of this procedure that automation handles well is the matching: invoice numbers and amounts on the statement against invoices and payments in your records, with vendor names normalized so "Sysco" and "SYSCO CORP" are the same supplier. The part that stays human is the classification and the chase.

Inbox Ledger approaches it from the invoice side. Once your bank statements are uploaded, each captured invoice is matched to its bank transaction with a confidence score and confirmed with one click, so it already carries its payment status when you open the supplier's statement. An invoice the supplier lists that you have never captured stands out as absent. An invoice with two confirmed transactions against it raises a Money Found alert that it looks paid more than once, before the supplier's statement would have shown the credit. The reconciliation feature page describes the matching flow, and for how the matching logic works in general, including tolerance and date windows, see our guide to invoice matching software.

The honest limit: the tool does not read the supplier's statement PDF and tick lines for you. It makes your side of the comparison complete and already linked to payments, which is the half of the work that otherwise takes the hour.

A short checklist

1. Pull the supplier's statement and your vendor ledger for the same date.
2. Agree the opening balance; resolve any inherited difference first.
3. Tick matching invoices, then matching payments and credits.
4. Classify every unticked item into one of the four types, checking for duplicates and name variants when an item will not classify.
5. Agree the closing balance; never plug a residual.
6. Apply the tolerance rule to small timing items and the two-cycle rule to anything persistent.
7. Fix the cause: add the supplier's channel to your capture, or send remittance advice with payments.
8. Record the findings in the close memo.

A vendor statement is the only document in your AP process that someone else wrote about your account. Reconciling it monthly is how you find out what your own books do not know.