What Is Receivables Reconciliation?

Receivables reconciliation is the process of proving that customer-level invoices, credits, payments, refunds, write-offs, and other detail agree with the accounts receivable balance in the general ledger as of the same date. It also tests whether the remaining balances are valid, collectible, correctly aged, and assigned for follow-up.

A report that equals the ledger is only the first layer. The detail can still contain duplicate invoices, unapplied cash, old credits, disputed balances, or activity posted after the cutoff. A reliable reconciliation combines numerical agreement with review of the underlying customer balances.

What should agree?

The ending accounts receivable control account should agree with the total of the customer subsidiary ledger or aging report for the same entity, currency, date, and accounting basis. The opening balance plus credit sales, less cash applied, credits, write-offs, refunds, and other supported adjustments should also explain the ending balance.

If multiple receivable accounts exist, map each report to the correct control account. Trade receivables, employee advances, related-party balances, retainage, financing receivables, tax receivables, and other assets should not be combined merely because all are amounts due.

Documents and reports needed

• General-ledger detail and trial balance for the receivable account.
• Customer aging or subsidiary-ledger report as of period end.
• Prior-period reconciliation.
• Invoices, credit notes, cash receipts, refunds, and write-off approvals.
• Bank and payment-processor settlement information.
• Unapplied payment, negative-balance, and exception reports.
• Customer statements, dispute records, and collection notes.

Save reports with their run date, report date, filters, basis, entity, and currency. A current aging rerun later may change after backdated entries, so it is not a substitute for the period-end evidence.

Receivables reconciliation steps

1. Confirm the period cutoff and close date.
2. Run the customer aging and general ledger for the same date and basis.
3. Compare their totals by receivable control account.
4. Investigate any difference using transaction-level detail and audit history.
5. Reconcile cash receipts and processor settlements through period end.
6. Review unapplied payments, credits, refunds, and negative customer balances.
7. Test invoice dates, service or shipment support, and cutoff for material items.
8. Age open balances and assign collection or dispute owners.
9. Assess allowance, expected credit loss, and write-off needs under policy.
10. Save the reconciliation and obtain reviewer approval.

Why the aging and ledger differ

• A journal entry was posted directly to the control account.
• The aging and ledger use different dates or accounting bases.
• A payment or credit was recorded but not applied to the customer invoice.
• A transaction was posted to another receivable account.
• A customer record or currency filter was excluded.
• A backdated edit changed a closed period.
• Migration or opening balances did not load consistently.
• The report includes later transactions because its date was not fixed.

Do not force agreement with an unexplained journal entry. Identify the source record and correct the supported transaction using a method that preserves customer detail and the audit trail.

Unapplied cash and customer credits

Unapplied cash is money received but not connected to the correct invoice or customer obligation. It can overstate both open invoices and customer credits while the net ledger balance appears reasonable. Match by remittance information, invoice number, amount, date, customer communication, and bank or processor evidence.

Review old credit memos, overpayments, duplicate payments, and negative customer balances. Determine whether to apply, refund, reclassify, or retain the amount under contract and applicable law. Assign an owner and document customer contact.

Cutoff testing

Revenue and receivables should be recorded in the period supported by the applicable accounting policy and underlying performance. Test invoices immediately before and after month-end against contracts, delivery, service completion, acceptance, and other relevant evidence.

Also review cash received after period end. A later payment can support existence and collectibility, but it does not automatically prove the original invoice date or revenue recognition was correct.

Customer confirmations and statements

Sending customer statements can uncover missing invoices, unrecorded credits, misapplied payments, and disputes. For selected high-risk or material balances, an independent confirmation process may provide stronger evidence. Design and control confirmations with an accounting or audit professional when they serve a formal assurance purpose.

Allowance and write-offs

A mathematically reconciled balance may not be fully collectible. Review aging, disputes, payment history, customer condition, concentrations, subsequent receipts, security, and current economic facts under the company’s accounting framework and policy.

Write-offs require approval and should preserve the customer history. Tax treatment may not match book treatment, and rules vary by method, entity, and jurisdiction. Coordinate material or unusual items with a qualified tax professional.

Illustrative reconciliation

Suppose the ledger shows $184,200 while the aging totals $181,700, a $2,500 difference. The ledger detail reveals a direct debit to accounts receivable for a customer charge that was never entered through the invoicing module. Correcting it through the supported customer workflow brings the aging and control account together.

The aging then shows a $9,000 invoice and a separate $9,000 unapplied receipt for the same customer. Applying the payment does not change total receivables, but it corrects the customer’s open items and aging. Both the control-account difference and the detail-quality issue matter.

Month-end control package

• Final aging and general-ledger reports.
• Rollforward from opening to ending balance.
• Difference investigation and correction support.
• Unapplied cash, credit, refund, and negative-balance review.
• Aged-item owners and collection notes.
• Allowance and write-off analysis.
• Preparer and reviewer signoff.

Common mistakes

Common errors include running reports for different dates, ignoring direct control-account entries, netting customers without support, leaving old unapplied payments, changing closed invoices, writing off balances without approval, and treating ledger agreement as proof of collectibility.

Continue with accounts receivable reconciliation for a deeper workflow or review what a reconciled balance means. Businesses needing reliable customer ledgers can explore bookkeeping services.