Month-end close
How to Reconcile the AP Subledger to the General Ledger
A step-by-step AP reconciliation method covering scope, control totals, timing differences, foreign currency, reconciling items, and review evidence.
Key takeaways
- Align entity, period, currency, and posting status before comparing totals.
- Separate timing differences from true errors.
- Age every reconciling item and assign an owner.
- Retain the source reports, bridge, and reviewer sign-off together.
01
Define the reconciliation boundary
Begin by identifying the legal entity, ledger, control accounts, reporting date, and currencies in scope. Confirm whether the subledger report includes unposted, parked, or future-dated items. Confirm whether the general ledger includes manual journals or interfaces that never pass through the AP subledger.
Run both reports from a consistent cutoff whenever possible. Record report names, parameters, timestamps, row counts, and totals. A reconciliation prepared from two moving populations will create avoidable timing differences.
02
Build the control-total bridge
Use the general-ledger control balance as one side and the supplier-level AP total as the other. Group by entity, control account, and transaction currency before combining values. If the ledger is maintained in a functional currency, document the exchange-rate basis used by each report.
- 1
Capture opening evidence
Save unchanged copies of the subledger and GL reports with their parameters.
- 2
Validate totals
Confirm that row-level amounts reproduce the displayed report totals.
- 3
Calculate the difference
Show subledger, GL, and variance explicitly rather than embedding it in a formula chain.
- 4
Create the bridge
List each reconciling item so the adjusted balances agree without a plug.
03
Classify reconciling items
Classification speeds resolution and prevents the same issue from returning every month. Typical categories include posting timing, manual journals, interface failures, foreign-exchange remeasurement, account-mapping errors, and transactions posted directly to the control account.
- Document reference and posting date.
- Amount and currency.
- Root-cause category.
- Owner and expected clearance date.
- Corrective entry or evidence required.
- Prior-period status for recurring items.
04
Review cutoff and unusual balances
A zero difference does not prove the underlying AP population is sound. Review old debit balances, long-outstanding credits, unusual manual journals, negative supplier balances, post-close entries, and invoices dated far outside the period. These items may reconcile mathematically while still requiring action.
Compare current findings with prior months. A recurring reconciling item that is repeatedly rolled forward is a process issue, not a permanent explanation.
05
Create review-ready evidence
Package the source reports, control-total calculation, reconciling-item schedule, supporting entries, and reviewer approval together. Protect formulas and identify manual inputs. The reviewer should be able to reproduce the final variance and understand why every adjustment is valid.
A deterministic spreadsheet check can help surface missing references, invalid amounts, duplicates, and risky dates in the supporting AP register. It complements the reconciliation by testing the quality of the population behind the balance.
This article provides general operational guidance, not accounting, audit, tax, or legal advice. Apply your organization's policies and professional judgment.