IndiaAuditLens
Reconcile bank statements and TDS credits with the books
The Bank and TDS reconciliation workspaces compare independent external evidence with the imported books. Complete the source setup and mapping first, work every residual exception, and preserve the export or raised…
By IndiaAuditLens product team · Updated 2026-10-15
Before you begin
Open the correct client and engagement and confirm the period under examination. Make sure the latest books, mappings, materiality, and relevant source evidence are available. Confirm who will prepare the work and who will review it. Do not conclude from a dashboard count alone; inspect the underlying records and evidence.
Reconcile a bank account
Audit › Assets › Cash and bank is one page: the area's questions, Bank and cash, evidence and findings, and the conclusion. Bank and cash opens on the Year view; its Bank reconciliation group holds the workbench that was Data › Bank reconciliation (an old link opens it). Its other groups are Cash, Confirmations and deposits and Risks.
Open Bank and cash › Year view. Each row is a ledger that holds money (a bank account, an overdraft or cash credit, a deposit, cash in hand), found by its type in the books and its Schedule III line, never by its name. It shows the books' balance at the year end, the bank statement's, the difference, where the statement ends, and the account's state. A client bank account no ledger is linked to is listed too, Blocked · No ledger linked: the books may be missing an account. Open it to link its ledger. A bank ledger with no bank account linked says Set up (see below). Read Money at stake:…
Link the ledger and upload the statement
From the Year view, Set up on a bank ledger does the first two steps in one dialog: it adds the client's bank account (the bank and the account type are filled from the ledger name for you to check; type the account number and IFSC yourself), links it to that ledger for this engagement, then offers Upload statement now or Later. If the client's record already holds an account with the same number, the dialog offers to link that one instead of adding a second copy. If the link cannot be saved, the added account is kept and the dialog says so; link it again there or in Accounts.
Check TDS and TCS deposits month by month
Audit › Taxes › TDS, TCS and statutory dues is one page: the area's questions, TDS and TCS, evidence and findings, and the conclusion. TDS and TCS opens on the Year view.
Open TDS and TCS › Year view. Each row compares the year: TDS deducted against deposited, TCS collected against deposited, TDS on the client's income in Form 26AS against the books, TCS paid on purchases, and the defaults TRACES shows in 26AS Part X. Read Money at stake: tax unpaid at the year end, the part unpaid for more than six months (CARO 2020 clause 3(vii)(a)), interest (an estimate, as TRACES counts it) and TRACES defaults. Open a line for its working. For an amount that needs a decision, click Raise finding. The amount is decided in Review › Findings; nothing is concluded on this…
The year's books end on the year end, so a deposit made after it is not seen: March TDS shows as due after the year end; check its challan.
Find TDS not deducted or short
Reconcile Form 26AS TDS with the books
This part (TDS and TCS › TDS on our income) is for tax deducted from the client and recorded as a receivable/credit in its own books. It is distinct from preparing the client's deductor TDS returns. It was Data › TDS reconciliation until 15 Oct 2026; old links open it here.
Load Form 26AS and link book accounts
Open TDS and TCS › TDS on our income › Upload 26AS. Click Upload 26AS PDF and select the correct financial-year PDF. Wait for parsing, then verify the displayed taxpayer identity, FY and TDS/TCS/default counts against the source. Never publish these identity values in a screenshot. A warning banner shows when the 26AS PAN is not the client's or its year is not the engagement's; the upload is kept, so upload the right statement. A new upload deletes nothing and clears no match: a changed statement waits for a manager in Books versions (the earlier 26AS stays read until then); on accept,…
Map deductors and analyse differences
Completion checklist
Correct external source, entity and period verified. Book ledgers and external counterparties mapped by evidence, not name alone. Auto-matches and AI suggestions reviewed rather than accepted blindly; each proposal or group accepted only after reading its lines. Bank charges, interest and TDS the books lack asked of the client to book. All residual differences explained, raised as findings or asked of the client. Payment flags that need a decision raised to Findings and decided there; no high-severity flag left not raised. BRS/export and source lineage retained in the audit file. Sensitive…
Expected result
The procedure is completed for the correct engagement and period, exceptions are supported by evidence, and the result is ready for review or captured in the audit file.