Form 3CD Tax Audit Checklist Excel – AY 2026-27
Clause-wise working checklist for the tax audit season – all 44 clauses of Form 3CD as amended from 1 April 2025, with assistant-to-partner workflow columns, auto-computing annexures (43B, PF/ESI, MSME clause 22, loan register, TDS recon, clause 40 ratios), a client documents-request list and the review traps that get caught in peer review.
⬇️ Download Excel – FreeNo signup. No email required. Direct download.
What you get
Amended-form ready
Built on Form 3CD as substituted by Notification 23/2025 – new clause 36B (buybacks), rewritten MSME clause 22, omitted clauses 28/29 greyed, clause 31 nature codes A to L.
Workflow columns
Applicable? / workpaper ref / prepared by / assistant remarks / reviewed by / status / risk – run the audit file from the checklist itself.
Auto dashboard
Client header, percent-complete, open high-risk count and sign-off block with a UDIN field – engagement status at a glance.
Working annexures
43B due-date verdicts, month-wise PF/ESI late-deposit flags, clause 22 MSME split, 269SS/269T register with mode codes, TDS reconciliation and auto clause 40 ratios.
Client PBC list
An 18-item documents-request list mapped to clauses – mail it to the client on day one.
Review traps
Ten misses that surface in peer review – ICDS disclosures, journal-entry loans, clause 44 test-check documentation and more.
Sheet-by-sheet overview
Workbook contents (7 sheets)
- Dashboard – engagement header, auto progress, high-risk counter, UDIN + sign-off
- Applicability – 44AB quick grid with auto verdicts + engagement-acceptance reminders (incl the 60-audit ceiling)
- Master Checklist – 61 rows covering clauses 1-44 with plain-English requirements, documents and workflow columns
- Annexures – 43B tracker, PF/ESI monthly, clause 31 loan register, MSME clause 22 block, TDS recon, clause 40 auto ratios
- PBC – Documents Request – client-ready request list mapped to clauses
- Review Traps – ten partner-review traps with the fix
- Law + Version Log – notification basis, change summary and version history
How to use
1. Fill the yellow cells on the Dashboard (client, PAN, partner). 2. Mark each clause Applicable Y/N on the Master Checklist – the documents column tells the article what to collect, and the PBC sheet is ready to send to the client. 3. Work the annexures as vouching progresses – verdict columns compute automatically. 4. The partner reviews by status and risk columns; the dashboard shows completion and open high-risk items. 5. Transcribe into the e-filing utility clause by clause – the checklist follows the utility order.
Sheets are protected so formulas cannot be broken; every yellow input cell is open. One workbook per client per year – save it into the audit file as your working paper.
Why this checklist is different
Most checklists floating around are pre-2025 files that still show the omitted clauses 28/29 and the old MSME clause – using them this season means missing the substituted clause 22 split and the new clause 36B buyback reporting. This workbook was drafted fresh on the amended form, in plain English (with the Guidance Note, Revised 2025, as the para-wise reference), and adds what the paid audit modules have that free files never did – workflow columns, auto-verdict annexures and a documents pipeline.
It pairs with two free CalcGuru tools: the Tax Audit Applicability Calculator (which limb of 44AB, which form, what due date) and the MSME Delayed Payment Interest Calculator. For the law behind the new clauses, see the clause 22 guide, the clause 36B guide and the Form 26 transition (produces the clause 22 figures and the section 23 interest number this checklist asks for).
Frequently asked questions
Is this updated for the Form 3CD changes effective 1 April 2025?
Yes – the checklist is built on Form 3CD as amended by Notification 23/2025: substituted clause 22 (MSME three-part disclosure), new clause 36B (share buyback receipts), omitted clauses 28/29 and the clause 31 nature-of-amount codes. This is the form that applies for AY 2026-27 audits.
Can my article assistants use it directly?
That is the design – each clause row has the requirement in plain English, the documents to verify, and prepared-by / remarks / reviewed-by columns so the file moves from assistant to partner inside one sheet.
Are the sheets locked?
Sheets are protected only to keep formulas and structure safe. Every input cell (yellow) is open – applicability answers, workflow columns, annexure figures. Nothing you need is locked.
Does it replace the ICAI Guidance Note?
No. It is a working checklist in our own words, meant to be used WITH the Guidance Note on Tax Audit (Revised 2025) – keep the GN as the authoritative reference for positions you sign.
Will it be updated if the law or utility changes?
Yes – when you download, an optional popup lets you leave your email; every new version of this checklist is mailed automatically to subscribers.
What about the tax audit due date for AY 2026-27?
Audit report by 30 September 2026 and ITR by 31 October 2026 (transfer-pricing cases 31 October / 30 November). Penalty for failure: 0.5% of turnover capped at Rs 1.5 lakh u/s 271B, with reasonable-cause relief u/s 273B.