Vendor Statement Reconciliation

In this article
    Share this article

    What is Vendor Statement Reconciliation?

    Vendor statement reconciliation is the process of comparing a supplier’s statement of account with the supplier’s balance in your accounts payable ledger. Also called supplier statement reconciliation, it matches invoices, payments, and credits line by line, then explains every difference as an item in transit, a missing document, an error, or a dispute.

    Why Vendor Statement Reconciliation Matters

    The vendor statement is the only evidence in accounts payable that comes from outside the company, which is why it finds what internal controls cannot: the invoice emailed to someone who left, the credit memo nobody applied, the payment posted to the wrong account, the duplicate that slipped through.

    AP owns the reconciliation; the controller decides which vendors are reconciled monthly. As an example, a supplier sending 80 invoices a month whose statement shows three the ledger has never seen is about to put the account on hold for invoices AP did not know existed and the first sign is usually a stopped delivery.

    How Vendor Statement Reconciliation Works

    Vendor statement reconciliation is a matching exercise between two records of the same relationship, and every difference falls into one of four categories.

    How Vendor Statement Reconciliation Works

    1. Obtain the statement at a cut-off date and confirm the opening balance agrees with the last reconciliation.
    2. Match each invoice on the statement to an open or paid item in the ledger by invoice number and amount; matched items drop out.
    3. Match payments and credit memos on the statement to payments made and credits applied in the ledger.
    4. Classify what remains: invoices on the statement but not in the ledger, payments in the ledger but not on the statement, credits missing on either side, and amounts that simply differ.
    5. Resolve each item: request the missing invoice, send the remittance, claim the credit, raise a dispute and record the action.
    6. Sign off with the adjusted balances agreeing, and carry open queries forward with a date.

    Vendor Statement Reconciliation vs Three-Way Matching

    Purpose

    Vendor statement reconciliation

    Three-way matching

    Unit of work A vendor’s whole account A single invoice
    Timing After the fact, monthly or rolling Before payment
    Evidence The supplier’s own record Purchase order and goods receipt
    Catches Missing invoices, unapplied payments and credits, duplicates paid Price and quantity errors on an invoice
    Owner AP, with the controller AP processor, system-driven

    Matching stops a bad invoice from being paid; statement reconciliation finds the invoices and credits that never entered the process at all. One does not replace the other.

    Example

    Assume a supplier’s statement at 31 July shows $48,600 outstanding, while the vendor’s account in the AP ledger shows $41,000.

    Item

    Statement

    Ledger

    Action

    Balance per record $48,600 $41,000 —
    INV-2207, dated 29 July, received by AP on 3 August Included Missing Invoice in transit — post it (+$5,400 to ledger)
    Payment sent 30 July Not yet applied Applied Payment in transit — none (−$2,100 from statement)
    Late-payment fee on INV-2180 $100 — Disputed — query with supplier
    Adjusted balances $46,500 $46,400 $100 open query, dated

    Two of the three differences in this example are timing and resolve within days; the third is a charge AP never agreed to, surfaced before it is quietly paid with the next run. A duplicate invoice paid twice shows up here too, as a credit balance the supplier is holding and nobody asked about.

    Common Mistakes

    • Reconciling only when a supplier complains. By then the account is on hold, and the missing invoices are overdue; a rolling schedule reconciles every significant vendor at least quarterly.
    • Accepting the statement balance as true. Statements contain supplier errors and unagreed charges; each unexplained item needs a reason, not a correcting entry.
    • Ignoring credit balances. A supplier holding your money, from a duplicate payment or an unapplied credit, rarely volunteers it.
    • Treating items in transit as closed. An invoice in transit for sixty days was never sent, or went to the wrong address; chase it.

    How Reconiva Handles Vendor Statement Reconciliation

    Reconiva keeps the ledger side of a vendor statement reconciliation clean. Every invoice and credit memo is captured on arrival and visible with its status; duplicates are caught before posting, and each document posts to the connected ERP against the right vendor with its reference and an audit trail of when it arrived and was approved. When the statement comes in, the differences that remain are timing and supplier-side items rather than documents lost inside the process. See compliance and audit trail in Reconiva.

    Subscribe to our newsletter

    Get new accounts payable guides and glossary terms in your inbox.