Vendor Statement Reconciliation: How to Reconcile Statements to Your AP Ledger

Why reconcile vendor statements

Statements are the supplier’s view of what you owe, so reconciling them finds invoices you never received, credits you never applied and payments you made twice.

Complete liabilities. Invoices lost in the mail or sent to the wrong person show up on the statement before they become past-due notices.
Recover money. A credit balance on a statement often points to a duplicate payment or an unapplied credit note.
Protect the relationship. Catching misapplied payments early avoids late fees and credit holds.
Audit evidence. A reconciled statement for each key supplier supports the accounts payable balance at year-end.

Step-by-step: reconciling a vendor statement

Pull both sides at the same cut-off date, compare balances, match line by line, then classify and clear every difference.

1
Step 1
Request statements from your largest and most active suppliers as of the same cut-off date as your ledger, usually month-end.
2
Step 2
Run a vendor ledger or open-items report in your accounting system for the same supplier and date.
3
Step 3
Compare the two closing balances. If they agree, file the statement as evidence; if not, work through the differences.
4
Step 4
Match line by line: each invoice, credit note and payment on the statement against the ledger, by invoice number, date and amount.
5
Step 5
Classify every unmatched item as a timing difference, a missing entry on either side, a duplicate, or a disputed amount.
6
Step 6
Fix what is yours (enter missing invoices and credits, void duplicates) and send the supplier a list of what is theirs.
7
Step 7
Record the reconciliation, the reconciling items and who reviewed it, and follow up open items next month.

Worked example: a statement that does not agree

In this example, the supplier’s statement shows $18,640 owed while the AP ledger shows $14,030, and four items explain the difference.

Example: reconciling one supplier’s September 30 statement
Item	Adjustment to statement balance	Action
Balance per supplier statement	$18,640
Invoice 5531 on the statement, not yet entered in AP (received late)	−$2,150	Get a copy, enter and approve it, or accrue it
Payment of $4,300 sent Sep 29, not yet on the statement	−$4,300	Timing difference: no action, check it clears next month
Credit note CN-208 on the statement, not recorded in AP	+$640	Record the credit and apply it to an open invoice
Invoice 5487 entered in AP twice	+$1,200	Void the duplicate before the next payment run
Balance per AP ledger	$14,030	Difference fully explained

Illustrative numbers. Signs show how each item moves the statement balance to the ledger balance.

Two of the four items are AP's to fix: the missing invoice and the unrecorded credit note. The duplicate entry would have been paid twice in the next run if the statement had not been checked. The payment in transit needs no correction, only a check that it appears on next month's statement.

Common reconciling items and what to do

Almost every difference falls into one of five types, and each has a standard fix.

Difference	Typical cause	Fix
Invoice on statement, not in ledger	Invoice lost, sent to the wrong person, or still awaiting approval	Request a copy; enter it or accrue it
Invoice in ledger, not on statement	Duplicate entry, or invoice from a different supplier record	Investigate before paying; void if duplicate
Payment in ledger, not on statement	Payment in transit or misapplied by the supplier	Wait one cycle; then send remittance details
Credit on statement, not in ledger	Credit note never received or never entered	Request the credit note, record and apply it
Amount differs	Price dispute, short payment, or partial invoice	Agree the correct amount with the supplier and buyer

Controls and common mistakes

Reconcile at a fixed cut-off, keep the reconciliation separate from payment processing, and never pay straight from a statement.

Paying from statements. A statement is not an invoice. Paying statement lines without the underlying invoices is a common route to duplicate payments.
Mismatched cut-off dates. Comparing a September 30 statement with an October 15 ledger creates differences that are not real.
Only checking the total. Two errors can cancel out. Match line by line for key suppliers.
Ignoring credit balances. Ask for refunds; unclaimed credits are easy money to lose.
Segregation of duties. The person reconciling statements should not be the person who sets up vendors or releases payments. See segregation of duties.

How Aequo AP helps with statement reconciliation

Aequo AP does not import supplier statements; it gives you a clean, exportable record of every invoice captured for a supplier, with its status, so the AP side of the reconciliation is quick to pull and trustworthy.

Per-vendor export. Export a supplier's invoices for a date range as CSV, with status, to compare against the statement line by line.
Duplicate checks before entry. Each new invoice is compared with earlier invoices by vendor, amount, date and invoice number, so fewer duplicates reach the ledger in the first place.
Partial invoices tracked on the PO. Installment billing is matched against the open PO balance, which explains many amount differences on statements.
One ledger. Approved bills sync to QuickBooks Online, Xero, FreshBooks or Zoho Books, where you run the vendor balance you reconcile to.

Missing invoices found during reconciliation can be forwarded to your Aequo AP inbox and processed like any other invoice. See exception handling in Aequo AP.

Frequently asked questions

What is vendor statement reconciliation?

Vendor statement reconciliation compares the balance and open items on a supplier’s statement with the balance you owe that supplier in your accounts payable ledger, and explains every difference between the two.

How often should I reconcile vendor statements?

Monthly for your largest and most active suppliers, as part of the month-end close, and quarterly or on request for the rest. Reconcile any supplier immediately if they send a past-due notice for an invoice you have no record of.

Why doesn’t my vendor statement match my AP ledger?

Usually because of timing (a payment in transit or an invoice still in the mail), an invoice or credit note recorded on one side only, a duplicate entry, a payment applied to the wrong invoice by the supplier, or a disputed charge.

What if the supplier shows a credit balance?

A credit balance usually means you overpaid, paid an invoice twice, or have an unapplied credit note. Confirm it against your payment records, then ask for a refund or apply it to the next invoice.

What if a supplier will not send statements?

Send them your open-items list for their account and ask them to confirm it or point out differences. This is sometimes called a balance confirmation, and auditors use the same technique.

Can vendor statement reconciliation be automated?

Partly. Software can export a vendor’s open items, match statement lines to invoices by number and amount, and flag likely duplicates. A person still needs to resolve the differences with the supplier.

Automate matching, approvals and exception handling

Aequo AP captures invoices, matches them to purchase orders and receipts, routes approvals and flags duplicates and exceptions, then syncs with QuickBooks Online, Xero, FreshBooks or Zoho Books.

Start a free trial Book a demo