Customer Reconciliation (also called Debtor Reconciliation) ensures that the balance you show as receivable what the customer shows as payable. It is essential for cashflow, dispute resolution, GST compliance, and audit accuracy.
Customer reconciliation validates:
- Your outstanding receivables
- Customer acknowledgments
- Correct application of payments
- Credit/debit note adjustments
- GST outward supply accuracy
Weak reconciliation leads to:
- Disputes delaying payment
- Incorrect ageing
- Bad debts
- GST mismatches (GSTR-1 vs customer’s GSTR-2A/2B)
- Loss of trust with customers
- Audit remarks
• Customer reconciliation ensures receivables accuracy.• Helps resolve disputes early instead of at year-end.• Ensures GSTR-1 correctness and reduces mismatches.• Essential for audit confirmations and financial statements.
To provide a practical, structured process for performing customer reconciliation and standard formats that SMEs can use immediately.
Customer reconciliation is the process of comparing:
vs
Reconciliation ensures:
- All invoices are recorded
- All payments are adjusted properly
- Credit notes/debit notes are matched
- Advances are accounted for
- No duplication exists
- Outstanding balance is accurate
This forms the basis for:
- Collection follow-ups
- GST reporting accuracy
- MIS reporting
- Bad debt provisioning
A simple, clear, and scalable method for SMEs and accounting teams.
Request the customer for:
- Ledger for the period
- Invoice acknowledgement/GRN details
- TDS deduction summary
- Credit/debit notes issued
- Payment details with UTR references
Large customers often have portal-based statements.
From your accounting system pull:
- Customer ledger
- Invoice register
- Receipt (payment) register
- Credit notes/Debit notes
- Advances
- TDS challan & 26AS details
Perform matching of:
Match invoice date, number, and amount.
Match bank receipts to specific invoices.
Match adjustments from both sides.
Customer ledger should reflect TDS deducted.Your books should record TDS receivable.
Ensure advances are adjusted against invoices.
Match with debit notes/credit notes.
Differences fall into clear categories:
In your books but not in customer’s → send invoice copies.In customer’s books but missing in your books → post entry.
Customer has paid but you haven’t adjusted → allocate correctly.
Customer deducted TDS but you didn’t record → adjust TDS receivable.
Often missed → adjust asap.
Either side may have duplication.
GST mismatches must be corrected.
A clean reconciliation statement includes:
- Opening balance
- Add invoices
- Less receipts
- Less credit notes
- Add debit notes
- TDS adjustments
- Closing balance as per both books
- List of differences with explanation
(A format is given below.)
Share reconciliation with customer:
- Resolve invoice-wise disputes
- Share supporting documents
- Obtain confirmation
- Update your ledger based on resolution
SMEs often face:
- Missing purchase order (PO) references
- Customer not accepting invoices without GRN
- Payment applied to wrong invoice
- TDS applied on incorrect amount
- Credit notes not updated in books
- Customer reducing invoice amount due to penalties
- GST mismatch due to wrong HSN/SAC
- Invoice rejected due to late filing in GSTR-1
These issues directly delay collections.
Customer Reconciliation Statement
Customer Name:
Period:
Opening Balance (as per Books) ₹______
Add: Invoices Raised ₹______
Less: Receipts ₹______
Less: Credit Notes ₹______
Add/Less: Debit Notes ₹______
Less: TDS Deducted ₹______
Closing Balance (as per Books) ₹______
Closing Balance (as per Customer) ₹______
Difference ₹______
Reasons for Difference:
1. _________________________________
2. _________________________________
3. _________________________________
Missing in customer record
To complete clean customer reconciliation, you need:
- Customer ledger
- Invoice copies
- Payment receipts (UTR number)
- Customer GRN or approval
- TDS certificates / 26AS report
- Credit/Debit notes
- GSTR-1 reconciliation
- Email communication with customer
Strong documentation = faster dispute resolution.
Manufacturing business supplying components ₹32 lakh stuck due to disputes over invoice amounts and payment adjustments.
• Performed detailed line-item reconciliation• Identified ₹8 lakh of unadjusted payments• Found ₹4 lakh CN not posted by customer• Mapped GSTR-1 with their GSTR-2A• Sent complete reconciliation packet with proofs
• Customer released ₹28 lakh immediately• Balance settled after CN dispute resolution• No further disputes in next 3 cycles
• Customer Reconciliation Template (Excel)• Monthly AR Reconciliation Checklist• TDS vs Receivables Matching Tool• Customer Ledger Clean-Up SOP• AR Ageing Analysis Template
(Available on request.)