1. Problem Statement

The verification of Sundry Debtors and Sundry Creditors is a recurring, evidence-intensive step in every statutory audit. In current practice, the auditor assembles evidence from multiple disconnected sources — the client's accounting software (Tally), GST return data, balance confirmations received over email, ledger statements in varied formats (Excel, PDF, scanned images), and MSME registration status — and performs reconciliation manually in spreadsheets, exercising judgment at each step.

This fragmentation across tools causes duplication of effort, transcription errors, inconsistent documentation, and difficulty in tracing each balance to its supporting evidence. The objective of this module is to consolidate every source of verification evidence into a single audit workspace and to perform the reconciliation of debtors and creditors in an optimised, well-documented and auditor-controlled manner.

2. Objective and Scope

To provide a structured audit programme for the verification of Sundry Debtors and Sundry Creditors, covering:

1. A. Reconciliation of GST returns with the books of account
2. B. Receipt and processing of external (counterparty) balance confirmations
3. C. Verification of subsequent realisations where confirmations are not received
4. D. Determination of vendors' MSME registration status
5. E. Preparation of Schedule III–compliant disclosure for Trade Receivables and Trade Payables

Throughout, artificial intelligence is applied only where transcription and judgment assistance add value, while every conclusion remains subject to arithmetical verification and the auditor's review and sign-off.

3. Audit Programme and Functional Coverage

A. Reconciliation of GST Returns with the Ledgers

The module reconciles the client's GST filings against the books, party-wise:

1. Receivables (Sales): the sales ledger is matched against GSTR-1, invoice-wise (covering B2B, B2C and Credit/Debit Notes), to confirm that no transaction is missing or misstated between the return and the books.
2. Payables (Purchases): the purchase ledger is matched against GSTR-2B, supplier invoice-wise, to confirm completeness of inward supplies and to quantify any Input Tax Credit exposure.

Each party carries a live reconciliation status, and the auditor can filter directly to the parties for whom GST reconciliation is pending — surfacing GST-side gaps and balance-confirmation gaps in the same view, as such gaps frequently explain ledger variances.

Reconciliation of the Counterparty Ledger — Two Types of Items

After comparing the counterparty's ledger with the books, unreconciled items are classified into two types, each with a defined next action:

1. Items correct in our books but absent in the counterparty's statement — the statement of such entries is sent from the system to the counterparty for their confirmation.
2. Items correct in the counterparty's books but absent in ours — these can be imported into the books of account through a single action, as accounting entries for posting to Tally.

B. Process of Obtaining the External Confirmation

Consistent with Standard on Auditing (SA) 505 — External Confirmations, confirmations are obtained through two routes:

1. Counterparty self-upload: the counterparty receives a secure link to submit their ledger / balance confirmation directly. Vendors additionally declare their MSME status and may attach their Udyam certificate. The system tracks the request lifecycle and issues periodic reminders.
2. Auditor upload: where the confirmation is received directly, the auditor uploads the counterparty's ledger — in Excel, PDF, or scanned-image form — and the system reads it into a review grid for reconciliation. Where entries are found that are missing in our books, the resulting variance is presented for verification and for posting the corresponding accounting entry into Tally.

C. Verification of Subsequent Realisations

Where a balance confirmation is not received, the module verifies the closing balance by tracing subsequent realisations — receipts recorded after the period-end — against the outstanding balance, providing an alternative audit procedure under SA 505. Each party's settlement status and the supporting post-period receipts are presented as audit evidence.

D. MSME Status of Vendors

The module obtains the MSME (Udyam) registration status of vendors through an API, supporting reporting under Section 43B(h) of the Income-tax Act, 1961, under which amounts payable to Micro and Small Enterprises beyond the prescribed period are not allowable as a deduction. This status also feeds the Trade Payables disclosure.

E. Schedule III Reporting

Finally, the module prepares the disclosure formatting required under Schedule III to the Companies Act, 2013, for Trade Receivables and Trade Payables — including the ageing schedule and the prescribed classifications (undisputed / disputed, good / doubtful, and the MSME / Others split on the payables side) — drawing directly on the confirmation, subsequent-realisation and MSME status determined in the preceding steps.

4. Role of Artificial Intelligence

AI is applied in a controlled, supervised manner:

1. Document reading: scanned or photographed ledgers are converted to structured data using vision-based extraction.
2. Reconciliation assistance: where mechanical matching cannot pair entries (for instance, because voucher numbers differ between the two parties' books), AI proposes high-confidence pairings on the basis of amount, date and description.

In every case, AI proposes; the system verifies arithmetically; and the auditor reviews and signs off. No conclusion is recorded without the auditor's confirmation, and a complete audit trail is maintained.

5. Outcome

The module replaces a multi-tool, manual process with a single, connected audit workspace. It improves completeness and consistency of evidence, reduces manual effort and transcription error, maintains full traceability and documentation, and produces a Schedule III–ready working paper for the auditor's sign-off — while keeping professional judgment and control firmly with the Chartered Accountant.