Customer statement reconciliation means comparing your accounts receivable ledger for a customer with the customer's own accounts payable records at the same date. You send the customer a statement or a balance confirmation request; if the balances differ, both sides compare their entries line by line to find unposted invoices, unapplied or misapplied payments, short payments, disputed items and missing credit notes.
Why it matters for cash collection
A customer who disagrees with your balance will not pay the disputed part. Finding the difference early turns a stalled collection into a short list of documents to resend or credit notes to issue. Reconciled balances also make your bad-debt provisions and credit limits reliable.
Typical differences on the customer side
| Item | In your AR ledger | In the customer's AP ledger | What to do |
|---|---|---|---|
| Invoice INV-2026-0412 | 12,600.00 | — | Resend the invoice; customer has not received or posted it |
| Payment 15 Oct | −30,000.00 (posted 17 Oct) | −30,000.00 (paid 15 Oct) | Timing only; no action |
| Payment 22 Oct | −8,000.00 on account | −8,000.00 against INV-0398 | Apply the cash to the right invoice |
| Short payment INV-0377 | 1,450.00 open | Paid in full minus deduction | Agree the deduction or issue a credit note |
| Credit note CN-0018 | −1,000.00 | — | Send the credit note to the customer |
Step by step
- Pick the date and export open and cleared items for the customer from your ERP.
- Send a statement or balance confirmation to the customer's accounts payable contact, not to sales.
- When the customer disagrees, ask for their supplier ledger (vendor statement) for the same period.
- Match invoices by number and amount, payments by amount and date, credit notes against invoices.
- Classify each unmatched item: timing, missing document, misapplied cash, deduction, dispute.
- Resend documents, correct cash application, issue or agree credit notes, and confirm the new balance.
Frequently asked questions
Who should reconcile customer accounts, finance or sales?
Finance (accounts receivable) owns the reconciliation; sales helps resolve commercial disputes such as price differences or returns.
How often should customer statements be sent?
Monthly for active customers and always at quarter and year end. Large or overdue accounts benefit from a monthly reconciliation, not just a statement.
What is the difference between a customer statement and a balance confirmation?
A statement lists open items and the balance; a balance confirmation asks the customer to confirm or dispute that balance in writing.
Start with one account. If the differences are not clearer than in your spreadsheet, you have lost nothing.
Start free trial →Last updated: November 14, 2026 · mutabakat.com