Accounts receivable reconciliation example: invoices to closing balance

Cedar Lane Studio is a fictional business reconciling August 2026. Its opening AR is $12,000. During August it issues a $3,000 invoice, applies $6,500 of customer receipts, and issues a $500 credit memo. There are no write-offs, foreign-currency changes, or other adjustments in this simplified example.

Use the same August 31 cutoff for the customer subledger and ledger comparison. Keep the original invoice, receipt, credit memo, and bank references. Do not compare today's open-invoice export with a prior-month ledger and treat the difference as an error.

A $4,500 ACH includes remittance identifying two invoices for the same customer: INV-101 for $3,000 and INV-102 for $1,500. A second customer pays $2,000 toward INV-103, which had $7,500 outstanding. The approved $500 credit memo also belongs to INV-103. INV-104 is a new $3,000 invoice with no payment yet.

The table shows balances after the reviewed applications. An equal total alone would not justify assigning the ACH: verify payer identity, currency, remittance, and whether the receipt was already applied.

For these facts: opening AR + new invoices − applied receipts − credit memos = closing AR. Therefore $12,000 + $3,000 − $6,500 − $500 = $8,000. The remaining customer balances also total $8,000: $5,000 on INV-103 and $3,000 on INV-104.

The partial payment does not close INV-103. The credit reduces the balance separately from cash. If an unidentified receipt or overpayment were present, track it separately and follow the accounting system's treatment; do not force it onto an unrelated invoice just to reduce the outstanding total.

Suppose the AR control account shows $8,500 while the customer subledger shows $8,000. Inspection finds that the $500 credit memo is in the subledger but its accounting has not been transferred to the general ledger. The observed $500 difference is explained by that specific record, not by an assumed fee or a balancing adjustment.

The authorized accounting team completes the missing posting through its normal process, checks for duplicates, and reruns both reports. In this example both then show $8,000. Other differences may require different action. Oracle's reconciliation documentation describes comparing beginning balances, period activity, and ending balances and investigating detailed differences; its report behavior is specific to Oracle.

Save the report cutoffs, invoice applications, remittance references, credit memo ID, explanation of the $500 difference, and the final report comparison. Record who prepared and reviewed the reconciliation. A zero difference is useful only when the supporting applications and adjustments are also correct.

InvoiceReconcile can help prepare and review the invoice-to-payment matching step from CSV or XLSX exports. Credit memo posting, the AR control-account comparison, and final accounting treatment remain in your accounting workflow. The examples here illustrate a method, not a claim that the app performs the entire month-end close.