How to reconcile accounts payable to vendor statements

Reconciling accounts payable to vendor statements means comparing what your books say you owe each supplier against what the supplier says you owe, then resolving every difference so your payable balance is accurate. Do it monthly for your highest-volume vendors and quarterly for the rest, because an unreconciled payable balance distorts cash planning and can hide duplicate or missed bills.

Gather the Right Records First

Pull three items for each vendor: your accounts payable aging detail, the vendor's current statement, and the underlying invoices and proof of payment. The IRS notes that purchase documents should identify the payee, the amount paid, proof of payment, the date incurred, and a description of the item, and that a combination of supporting documents may be needed to substantiate all elements of a purchase (IRS, What Kind of Records Should I Keep?). Organize these by vendor and period before you start matching, so you are not stopping mid-reconciliation to hunt for a missing invoice.

Match Statement Line Items to Your Ledger

Start with the vendor's opening balance and confirm it agrees with your prior month's closing balance. Then tick each invoice on the vendor statement against the corresponding entry in your AP ledger, and do the same for each payment. Mark each line as matched, matched with a difference, or missing from one side. Work in invoice-date order so timing gaps become obvious.

Common mismatches and their usual causes:

• An invoice on the statement but not in your books: the bill never got entered, or it was posted to the wrong period.
• An invoice in your books but not on the statement: the vendor issued it after the statement cutoff date.
• Payment differences: payments in transit, payments applied to the wrong invoice, or unapplied credits.
• Amount differences: pricing or quantity disputes, freight or sales tax added by the vendor, or a partial payment recorded as full.

Resolve Each Difference and Document It

Every unmatched line needs a disposition: an adjusting entry in your books, a credit memo request to the vendor, or a documented timing difference that will clear next cycle. For adjusting entries, keep the vendor statement and the supporting invoice with the entry. The IRS emphasizes keeping supporting documents because they support the entries in your books and on your tax return, organized by year and type of income or expense (IRS, What Kind of Records Should I Keep?). Write a short reconciliation memo listing each difference, the cause, and the fix, and attach it to the month-end file.

Build the Reconciliation Into a Repeatable Workflow

Make the process routine rather than a fire drill:

1. Request statements from key vendors at the start of each month.
2. Reconcile the prior month before closing AP, so corrections land in the right period.
3. Review any vendor bill that looks unusual before posting it, since a bad bill that slips in will surface as a reconciliation difference later. Our guide on reviewing a vendor bill before it distorts job profit covers this in more depth.
4. Age the payables after reconciliation and investigate anything older than agreed terms.
5. Keep the reconciliation memo, statements, and supporting invoices together for the period.

The IRS allows any recordkeeping system suited to your business that clearly shows income and expenses, and you must keep records as long as needed to prove income and deductions on a tax return (IRS, Recordkeeping). A consistent monthly reconciliation file satisfies that practical need for payables.

Know When the Balance Is Right

The reconciliation is complete when the vendor statement balance equals your AP ledger balance for that vendor, or every remaining difference is a documented timing item with an expected clear date. If a vendor statement shows a balance you cannot trace at all, request a detailed transaction history from the vendor before booking any adjustment. Never plug an unexplained difference into an offsetting account; that hides the real problem and undermines the reliability of both your payables and your expense records. Note that recording a payable does not by itself determine the tax treatment of the underlying cost; deductibility depends on the nature and substantiation of each expense, which is why the underlying invoices and proof of payment matter.

If you would like help setting up a monthly AP reconciliation routine, contact KDM Accounting Services Inc. and we will walk through your current process.

Further reading

For related context, read What Your Overhead Costs — and What You Can Cut.

Sources

• IRS: Accounting periods and methods