Skip to main content
How-To · 5 min read

Debtors and Creditors Reconciliation: Ledger Matching Best Practices

Debtors and creditors reconciliation — matching your AR and AP ledgers against counterparty records — is the foundation of accurate financial reporting. In India, it is also a statutory audit requirement, a GST compliance check, and a TDS matching exercise simultaneously. This guide covers the process for both sides of the ledger.

Terra Insight
Terra Insight Reconciliation Infrastructure

Content authored by practitioners with experience at Amazon India, Intuit QuickBooks, and the Tata Group. Meet the team →

Published 18 March 2026
Domain expertise
TDS Reconciliation GST Input Credit Platform Settlements NACH Batch Matching Bank Reconciliation Form 26AS Matching ERP Integrations Enterprise Finance Ops

Accounts receivable in India carries a compliance dimension that is not present in most other markets. A debtor’s balance is not just an amount owed — it is also a record that must reconcile to Form 26AS (for TDS deducted by the customer), to GSTR-1 (for GST declared on the supply), and to the customer’s GSTR-2B (for ITC they have claimed). All three must agree.

Accounts Receivable Ledger Reconciliation

AR reconciliation has two components: the internal reconciliation (your AR ledger vs your bank receipts) and the external reconciliation (your AR ledger vs the customer’s records).

Internal AR Reconciliation

Internal reconciliation verifies that every payment received from a customer has been correctly allocated to the right invoice in the right amount.

Common internal AR errors in India:

  • Payment received net of TDS allocated to the gross invoice — leaving a balance equal to the TDS amount
  • Partial payment allocated to the oldest invoice in the ledger rather than the invoice the customer intended
  • Cash payment recorded in a different period than the bank receipt (timing difference)
  • Advance from customer posted to AR rather than customer advance liability

The TDS Dimension of AR Reconciliation

Every professional services or contractor payment received from a customer carries a TDS deduction. Reconciling AR in India requires matching:

Your recordCustomer’s recordGovernment record
Invoice amount (gross)Invoice received (gross)GST outward supply (gross)
Payment received (net of TDS)Payment made (net of TDS)
TDS receivableForm 26AS TDS credit

The TDS receivable must be matched to Form 26AS separately — it is not resolved by the payment receipt alone.

Accounts Payable Matching Process

AP reconciliation confirms that what you owe to suppliers matches what they say you owe them.

The standard AP reconciliation process:

  1. Download the AP ledger — all open items by supplier, invoice number, and due date
  2. Send balance confirmation requests to suppliers above the materiality threshold (₹5 lakh typically)
  3. Receive supplier statements and reconcile to the AP ledger — invoice by invoice
  4. Classify differences: timing (invoice received, not yet posted), disputed (invoice in dispute), genuine error
  5. Resolve timing differences within 5 working days; escalate disputes to commercial team

The GST dimension of AP reconciliation: every supplier invoice above ₹50,000 should appear in GSTR-2B. If it does not, the buyer cannot claim ITC — and the AP balance should be flagged until the supplier files.

Age-Wise Outstanding Analysis

Age-wise analysis classifies AR by days since invoice date:

Age bucketStandard treatmentIndia-specific action
0–30 daysNormalNo action
31–60 daysSend payment reminderVerify TDS deduction applied correctly
61–90 daysFormal follow-upVerify GSTR-2B credit appeared
91–180 daysLegal notice or escalationITC reversal approaching (180-day rule)
180+ daysProvision for doubtful debtITC reversal mandatory under Section 16(2)(b)

The 180-day rule under Section 16(2)(b) of the CGST Act is one of the most operationally important GST compliance requirements for AP teams: if the buyer has not paid the supplier within 180 days of the invoice date, the buyer must reverse ITC claimed on that invoice in the next GSTR-3B filing.

Disputed Invoice Resolution

Disputed invoices are a common source of AR reconciliation differences. Best practice:

  1. Record the dispute in the invoice header — “disputed: reason + date raised”
  2. Age disputed invoices separately from clean AR — do not provision against clean AR
  3. If the dispute results in partial payment: match the payment to the agreed portion, credit note the rest
  4. If a credit note is issued: reconcile to the original invoice, ensure the credit note appears in GSTR-1, and verify the customer reverses ITC in their GSTR-3B

Confirmation of Balance from Vendors

Vendor balance confirmation is a dual-control process: you send a statement of what you believe is owed; they confirm or dispute it. The differences identified in this process are often more significant than internal reconciliation finds — because the supplier and buyer have different invoice records, different accounting dates, or different GST treatment of the same transaction.

Reconciliation software India that manages intercompany and counterparty matching can automate the balance confirmation workflow — sending confirmation requests, recording responses, and flagging unconfirmed balances above threshold for auditor follow-up.

Bank reconciliation software that tracks payment receipts by UTR and links them to AR invoices prevents the most common internal AR error: payment allocated to the wrong invoice.

The Institute of Chartered Accountants of India publishes SA 505 (External Confirmations), the auditing standard that governs debtor confirmation procedures in statutory audits.

Primary reference: Institute of Chartered Accountants of India — where auditing standards for accounts receivable and payable confirmation are published.

Frequently Asked Questions

What is the difference between debtors reconciliation and bank reconciliation?
Bank reconciliation matches your cash book against the bank statement — confirming actual cash receipts. Debtors reconciliation matches your accounts receivable ledger against the customer's accounts payable ledger — confirming that both sides agree on what is owed. A customer may have paid, but if their payment is recorded against the wrong invoice in your books, the bank reconciliation will pass but the debtors reconciliation will show a mismatch.
How often should accounts receivable reconciliation be done in India?
AR reconciliation with counterparties should be done at minimum quarterly for amounts above ₹5 lakh. For high-value customers (above ₹25 lakh outstanding), monthly confirmation is best practice. Statutory auditors expect confirmation of balances from debtors representing more than 5% of total AR — if these are not reconciled regularly, the audit process becomes more time-consuming.
What is age-wise analysis and why does it matter for India GST?
Age-wise analysis classifies AR by the number of days since the invoice date — typically in buckets: 0–30, 31–60, 61–90, 90–180, and 180+ days. Under GST rules, if a buyer does not pay within 180 days of the invoice date, the ITC claimed on that purchase must be reversed (Section 16(2)(b) of the CGST Act). Age-wise analysis identifies invoices approaching the 180-day threshold and triggers ITC reversal before the compliance deadline.
How do disputed invoices affect debtors reconciliation?
A disputed invoice creates a difference between your AR ledger and the customer's AP ledger — you show an outstanding receivable; they show nothing (or a reduced amount pending dispute resolution). Disputed invoices must be separately classified in the AR ledger — not aged with normal receivables — and the dispute terms documented. If the dispute results in a credit note, the credit note must be reconciled to both the original invoice and the GST credit note in GSTR-1.
What is a balance confirmation letter and when is it required?
A balance confirmation letter is a written statement from the counterparty confirming the outstanding balance in their books as of a specific date. Statutory auditors under SA 505 (External Confirmations) require confirmation letters from debtors representing significant AR balances — typically above ₹10 lakh per debtor, or the top 10 debtors by balance. Confirmation letters must be sent by the auditor directly (not by the management) to be effective as audit evidence.

See how TransactIG handles reconciliation for your industry

Configuration takes 2–4 weeks. No code development required. ISO 27001:2022 certified.