Accounts Payable Reconciliation Process: Step by Step

AP reconciliation means proving two things: that your AP aging agrees with the general ledger control account, and that what you think you owe each supplier agrees with what they think you owe.

Both comparisons are easier when completed on a consistent close schedule. Here is the process and the common causes of differences.

Part one: aging to general ledger

• Run the AP aging summary as at the close date
• Run the general ledger balance for the accounts payable control account, same date
• Compare the totals

After report date, basis, currency, and filters are aligned, the totals are expected to agree. Differences can come from direct control-account entries, cutoff, unapplied payments, mapping, or report configuration.

Common causes of a difference

• A journal entry posted straight to the AP control account, which bypasses the subsidiary ledger
• Payments recorded as expenses rather than applied against open bills, leaving payables open and double-counting the cost
• Bills entered in the wrong period
• Credit notes recorded but never applied
• Accruals posted into accounts payable instead of a separate accrual account

Review accruals separately so estimates outside the vendor subledger do not obscure the AP control reconciliation.

Part two: supplier statement reconciliation

• Obtain the statement from the supplier
• Compare each open item on the statement to your AP detail for that vendor
• Identify items on the statement not in your records: usually invoices never received or never entered
• Identify items in your records not on the statement: usually payments in transit or invoices the supplier has not issued
• Investigate anything that is neither

What supplier reconciliation catches

Missing invoices, which understate costs and liabilities and produce a nasty surprise later. Duplicate entries, which do the reverse. Credit notes you were owed and never applied. And payments applied to the wrong invoice, which makes both look wrong.

How often

General ledger reconciliation monthly, as part of close. It takes minutes when the process is sound and it is the check that catches structural errors.

Reconcile supplier statements on a risk-based schedule that considers spend, volume, disputes, credits, operational importance, and history. Document which vendors are selected and why.

Clearing old items

Payables that have sat unchanged for a long time need investigation. Possible causes include an unapplied payment, unprocessed credit, duplicate bill, dispute, or valid outstanding obligation. Clearing an old payable without understanding it can hide an error that may recur.

Define the three-way reconciliation

A complete accounts payable reconciliation compares the vendor subledger with the general-ledger control account and compares material vendor balances with vendor statements or other external support. Each comparison detects a different problem. Subledger-to-ledger proves the accounting structure. Vendor statements help identify missing invoices, credits, or misapplied payments.

Set one close date and basis for all reports. Preserve the reports used, not only the final total. A changing aging report can make an old reconciliation impossible to reproduce.

Step 1: freeze the close inputs

Complete the payment cutoff, post known bills and approved credits, and identify invoices received after the cutoff that relate to the period. Run the AP aging detail, AP aging summary, and general-ledger detail through the same date. Note report filters, currencies, entities, locations, and excluded vendors.

If the period is still open for posting, record the report time and rerun after any approved adjustment. Do not compare a morning aging with an afternoon general ledger after additional entries were posted.

Step 2: prove the roll-forward

Calculate opening AP plus bills and other valid increases, less payments, credits, and other valid decreases, to arrive at closing AP. Compare the calculated closing balance with both the aging and control account.

For an illustrative roll-forward, opening AP of $120,000 plus $85,000 of bills, less $70,000 of applied payments and $5,000 of credits, produces closing AP of $130,000. If the aging shows $130,000 but the general ledger shows $134,000, the $4,000 ledger difference requires transaction-level investigation.

Step 3: isolate ledger differences

Search the control account for direct journals, entries from unsupported sources, manual checks, transfers, beginning-balance changes, and transactions posted after the report cutoff. Search the subledger for unapplied payments, bills in the wrong entity or currency, credits not linked, and voids with inconsistent dates.

Group differences by cause rather than posting one net reconciliation entry. Correct the underlying document or application when possible. Use a journal only when it represents the approved accounting event and does not damage the subledger.

Step 4: reconcile vendor statements

Prioritize high-spend, high-volume, disputed, credit-balance, and operationally critical vendors. Match statement invoices, credits, payments, and opening balance to the vendor detail. Identify statement-only items, ledger-only items, timing differences, and application differences.

A missing invoice may require an accrual, a bill, or follow-up depending on the facts and period. A payment missing from the statement may be in transit or applied elsewhere. A supplier credit may exist outside the accounting file. Preserve correspondence and assign every unresolved item.

Step 5: review debit balances and old items

Debit vendor balances can represent overpayments, unapplied cash, credits, deposits, duplicate payments, or errors. Old credit balances may represent valid debt, disputes, unrecorded payments, duplicate bills, or stale items. Review legal and policy implications before writing off or reclassifying a balance.

Use age, amount, vendor status, and activity to prioritize. Contact the vendor when external confirmation is needed. Do not clear an item because it is inconvenient or because a new year began.

Step 6: verify cutoff and completeness

Review invoices received shortly after period-end, unmatched receipts or purchase orders where relevant, recurring charges, freight, subcontractor work, utilities, and other items that may relate to the closed period. Compare current spend with prior periods and operating activity to identify unexpected gaps.

Completeness work is not the same as forcing every later invoice into AP. Determine the period, amount, evidence, and approved accounting treatment. Document material estimates and reversals separately from ordinary vendor bills.

Step 7: retain review evidence

The reconciliation package should show the aging total, control-account total, difference, roll-forward, vendor-statement results, adjustments, unresolved items, preparer, reviewer, and dates. The reviewer should inspect report parameters, direct control-account entries, old and debit balances, large changes, and post-close adjustments.

Close only when differences are resolved or clearly documented under an approved materiality and escalation process. Carrying a reconciling item requires an owner and target date.

Prevent recurring differences

Restrict direct posting to the AP control account. Require bills and credits to use the vendor subledger. Apply payments to specific documents, control vendor-master changes, separate payment approval from release, and review exception reports after every payment run.

Track causes over time. If the same difference recurs, change the source workflow, mapping, access, or training rather than correcting it monthly.

Reconciliation checklist

• Aging and ledger use the same date and filters
• Roll-forward explains opening to closing AP
• Direct control-account entries are reviewed
• Payments and credits are properly applied
• Material vendor statements are reconciled
• Debit and old balances are investigated
• Cutoff and unrecorded liabilities receive review
• Differences have causes, owners, and dates
• Preparer and reviewer evidence is retained

Retain vendor correspondence and approval evidence with each material adjustment so the correction remains traceable in a later review.