Vendor Statement Reconciliation: Process and Steps

Vendor statement reconciliation is the monthly check that confirms what a supplier says you owe matches what your own books say. It is one of the most reliable ways to catch missing invoices, duplicate bills, unapplied credits, and pricing errors before they turn into overpayments or strained vendor relationships. The work itself is mostly comparison, but most of the clock goes to retyping invoice and statement data into a usable format first. If that is your bottleneck, drop your PDF or image invoices into the converter at the top of this page to get clean Excel or CSV rows in seconds, then reconcile against them. This guide covers what the process is, the exact steps, who owns it, how often to run it, the discrepancies to watch for, and how to do it in Excel.

What is vendor statement reconciliation?

Vendor statement reconciliation is the process of comparing a vendor's statement of account against your own accounts payable ledger to confirm that every invoice, payment, and credit lines up and that the closing balance matches. The goal is to find and resolve discrepancies, such as invoices you never received or bills already paid, before they affect payments or reporting.

The vendor statement is the supplier's running record of everything they have billed you and everything you have paid over a period, ending in the balance they believe is outstanding. Your AP sub-ledger is your own version of the same history. When the two disagree, one side has an error: a bill that never reached you, a payment posted to the wrong account, a credit memo nobody applied, or a price that does not match the purchase order. Reconciliation is how you find which side is wrong and fix it.

How do you reconcile a vendor statement?

To reconcile a vendor statement, request the current statement, line it up against your AP ledger for the same vendor and period, match the opening balances, then compare every invoice, payment, and credit line by line. Flag anything that appears on one record but not the other, investigate each difference, post the corrections, and confirm the closing balances agree.

The discipline that makes it fast is doing it the same way every month. Pull the statement, sort both records by invoice date or invoice number, and work top to bottom. Most lines will match on sight. The handful that do not are the entire point of the exercise, so park them in a discrepancy list with a note on what is missing and who needs to chase it.

What are the steps in vendor reconciliation?

Vendor reconciliation runs across six steps: obtain the vendor statement, match opening balances, verify each line item, identify discrepancies, resolve and adjust, then finalize and archive. Each step feeds the next, so a clean opening balance makes the line-by-line comparison faster and a documented resolution leaves an audit trail.

1. Obtain the statement. Get the current statement of account from the vendor, plus your own AP ledger extract, open invoices, purchase orders, goods receipt notes, and proof of payment for the period.
2. Match opening balances. Confirm the statement's opening balance equals your closing balance from last month. If those do not agree, a prior-period item was never resolved, so fix that before going further.
3. Verify line items. Compare invoices, payments, and credits one by one. Tick off every line that appears on both records with the same amount and date.
4. Identify discrepancies. List anything on the statement but not your ledger (a missing invoice), anything on your ledger but not the statement (a payment they have not posted), and any amount that differs.
5. Resolve and adjust. Chase missing invoices, apply unapplied credits, correct miskeyed amounts, and dispute genuine vendor errors in writing. Post the agreed adjustments to your ledger.
6. Finalize and archive. Confirm the closing balances now agree, save a short reconciliation report showing opening balance, adjustments, and closing balance, and file it with a clear name for the next audit.

What is the difference between vendor reconciliation and account reconciliation?

Vendor reconciliation compares your AP ledger against an individual supplier's statement to confirm what you owe that one vendor. Account reconciliation is the broader month-end task of confirming a general ledger account balance, such as total accounts payable or a bank account, against supporting records. Vendor reconciliation is one of the supporting checks that makes the wider AP account reconciliation trustworthy.

Put simply, vendor reconciliation is bottom-up and vendor-by-vendor, while account reconciliation rolls up to a single ledger figure. If you reconcile your major vendors cleanly, the accounts payable control account in your general ledger is far more likely to tie out at close.

How often should you reconcile vendor statements?

Match frequency to vendor volume and spend. Reconcile high-volume or high-value vendors monthly so discrepancies are caught inside a single billing cycle, and review low-activity vendors quarterly. Monthly is the sensible baseline for most suppliers because it lines up with the standard accounting close and stops small errors from aging.

A few very large vendors with hundreds of invoices a month may warrant a weekly check, especially if you take early-payment discounts that depend on clean balances. The practical rule: reconcile often enough that no discrepancy survives past the period it appeared in.

Who is responsible for vendor reconciliation?

The accounts payable team owns vendor reconciliation, usually an AP clerk or specialist who runs the comparison and an AP manager or controller who approves any adjustments. When a discrepancy traces back to a purchase order or a receiving issue, procurement or the department that raised the order helps investigate. Clear policy should name who requests statements, who matches, and who signs off changes.

Separating those three roles matters for control. The person matching the numbers should not be the same person approving the write-offs, because that separation is what prevents a bad adjustment from quietly clearing a real problem.

What are common vendor statement discrepancies?

The most common discrepancies are missing invoices, duplicate invoices, unapplied payments, unclaimed credits or rebates, pricing errors against the purchase order, sales tax differences, payment-term disputes, and incorrect vendor master data. Timing differences also appear often, where a payment is in transit on one record but not yet posted on the other.

Many of these are worth money to you, not just the vendor. Unclaimed credits, missed rebates, and previous overpayments are recoverable when reconciliation surfaces them. Duplicates are the dangerous ones, because a duplicate invoice that slips through becomes a duplicate payment. Catching repeated invoice numbers and identical amounts is exactly the kind of check that gets easier once your data sits in clean rows, which is also the foundation for duplicate invoice detection.

How do you reconcile vendor statements in Excel?

To reconcile in Excel, put your AP ledger and the vendor statement on two sheets with matching columns (invoice number, date, amount), then use XLOOKUP or VLOOKUP on invoice number to pull each statement line into your ledger and flag any that return no match. A COUNTIF on invoice number catches duplicates, and a simple total comparison confirms the closing balances agree.

The catch is getting both sides into clean columns in the first place. Statements and invoices arrive as PDFs and scans, so the data has to be typed out or extracted before any formula works. Pull the invoice side into a spreadsheet automatically with an invoice PDF to Excel converter, and capture every charge accurately with invoice line item extraction so the amounts you match on are the real ones. When you are reconciling invoices to the payments that cleared the bank, converting the bank side with a bank statement to Excel converter puts both halves in the same format. If your books live in QuickBooks, skip the spreadsheet step and convert the bank side straight to a QBO file with a bank statement to QuickBooks converter so the cleared payments import directly.

Can vendor statement reconciliation be automated?

Yes. The comparison logic automates well: software matches statement lines to ledger lines by invoice number and amount, flags exceptions, and leaves only the genuine discrepancies for a human to resolve. Automation reportedly cuts AP data-entry error rates from the 10 to 15 percent range down below 1 percent and scales without adding headcount, which is why high-volume teams move to it first.

Full reconciliation platforms sit inside a broader AP system, but you do not need one to remove the slowest part of the job. The retyping is what eats the hours, not the matching. Extracting invoice data straight to a spreadsheet with an invoice data extraction tool hands you clean rows to reconcile against, which is the practical first step toward automating accounts payable data entry and toward reducing invoice processing costs. Reconciliation is also closely tied to three-way matching and the wider invoice reconciliation process, since all three depend on the same clean, structured data.

Vendor statement reconciliation does not have to be the dreaded month-end task. Run it on a fixed cadence, work the same six steps every time, and keep a tidy discrepancy log, and most months become a quick tick-through with a short list of real issues. The single biggest speed-up is getting your invoice data into clean spreadsheet rows before you start. Upload your invoices at the top of this page and start the next reconciliation with the data already done.