Accounts receivable reconciliation is the process of comparing the amounts recorded as owed to you in your AR sub-ledger against the amounts reflected in your general ledger, bank receipts, and customer records. It confirms that every invoice issued has been correctly tracked through to payment or write-off — and that nothing has fallen through the cracks.
Why accounts receivable reconciliation matters
AR is a balance sheet asset. If the AR balance is overstated — because payments were received but not applied, or because invoices were raised in error — the financial statements misrepresent the firm's position. For family offices with operating businesses or private equity portfolio companies, AR reconciliation is a core month-end control.
Beyond financial accuracy, unreconciled AR creates operational problems: collection teams chase payments that have already been received, customers receive duplicate statements, and cash flow forecasts are unreliable because the true collectible balance is unknown.
What AR reconciliation covers
| Reconciliation point | What is compared | Common break causes |
|---|---|---|
| AR sub-ledger to GL | Total AR per customer ledger vs. GL control account | Journal entries posted directly to GL, timing of batch postings |
| Invoices to payments | Open invoices vs. received payments | Unapplied cash, partial payments, payment on account |
| Customer statements | Internal AR balance vs. customer's AP records | Disputed invoices, credit notes not applied, timing |
| Bank receipts to AR | Cash received per bank vs. payments applied in AR | Unidentified receipts, bulk payments, remittance matching |
| Ageing accuracy | Invoice dates and payment terms vs. ageing buckets | Incorrect payment terms, backdated invoices |
The AR reconciliation process
- GL to sub-ledger agreement. Confirm the total AR balance in the general ledger matches the sum of all customer balances in the AR sub-ledger. Any difference indicates a posting that bypassed the sub-ledger.
- Cash application review. Verify that all payments received during the period have been correctly applied to the corresponding invoices. Identify any unapplied cash (payments received but not matched to an invoice).
- Credit note matching. Confirm that all credit notes have been applied to the correct invoices and that the net AR balance reflects them.
- Ageing validation. Review the AR ageing report to confirm that invoice dates, payment terms, and ageing buckets are accurate. Misclassified ageing distorts provisioning and collection priority.
- Customer confirmation. For material balances, confirm the outstanding amount with the customer (or review their statement). Discrepancies indicate disputed invoices or unrecorded payments.
- Write-off and provision review. Assess whether any long-outstanding balances should be provided against or written off. Confirm that existing provisions are still appropriate.
Common causes of AR breaks
| Cause | Description | Typical resolution |
|---|---|---|
| Unapplied cash | Payment received but not matched to an invoice | Match using remittance advice or customer reference |
| Partial payments | Customer pays less than invoice amount without explanation | Confirm with customer; apply to oldest invoice or raise query |
| Duplicate invoices | Same invoice raised twice, inflating AR | Void the duplicate; issue credit note if already sent |
| Unrecorded credit notes | Credit agreed with customer but not posted to AR | Post the credit note; adjust the customer balance |
| Intercompany netting | Related-party balances netted off without proper entries | Post formal netting entries in both entities |
| FX revaluation differences | Foreign currency invoices revalued at different rates | Apply consistent FX rate; book the revaluation gain/loss |
AR reconciliation for family offices
Family offices encounter AR reconciliation in several contexts: portfolio companies with trade receivables, real estate entities with tenant receivables, and the family office itself with management fee receivables from entities it administers. Each context has different data sources and break patterns, but the reconciliation discipline is the same.
The challenge is often fragmentation — receivables spread across multiple entities, ERP systems, and currencies, with no single view of the total position. Reconciliation must aggregate across these sources before it can identify breaks.
Where agents fit in AR reconciliation
The most time-consuming step in AR reconciliation is cash application — matching incoming payments to open invoices when the remittance information is incomplete, ambiguous, or missing entirely. An agent can examine payment amounts, dates, customer history, and partial reference data to propose the most likely invoice match, then present its reasoning for approval.
Agents also handle the investigation of aged items: contacting customer records, checking whether a credit note was agreed but not posted, or identifying that a payment was applied to the wrong customer account. Each action is documented with full reasoning.
For family offices managing AR across multiple portfolio companies, our family office reconciliation service handles AR reconciliation as part of the monthly close process.
Key terms
- AR sub-ledger
- The detailed record of all customer invoices, payments, and balances that feeds into the general ledger control account.
- Unapplied cash
- Payments received and deposited but not yet matched to a specific invoice.
- Cash application
- The process of matching incoming payments to open invoices in the AR system.
- Remittance advice
- A document from the payer indicating which invoices a payment is intended to cover.
- Ageing report
- A report that categorises outstanding AR by how long invoices have been unpaid (e.g., 0–30 days, 31–60 days, 61–90 days, 90+ days).