CORAA

Form 3CD Clause 40 Ratios Working Paper Format 2026 (Word) — GP, NP and Stock Ratios, AY 2026-27

Turnover, gross profit, net profit, stock-in-trade and material-consumed ratios for the previous year and the preceding year, computed from the amounts you enter, with the basis of each figure and a movement analysis.

Free · CORAA original — SA-aligned
Updated 1 Oct 2026
Applies to
Form 3CD clause 40 — AY 2026-27 (FY 2025-26)
Ratios
GP, NP, stock-in-trade to turnover; material to output
Basis
Value terms; net profit before tax
Comparison
Previous year v. preceding previous year
Share this template
Your firm — letterhead
Appears at the top of the document as the audit firm letterhead.
Used as the letterhead block.
Engagement details
The client and period this document is for.
What’s inside

An excerpt from the template.

FORM 3CD CLAUSE 40 — TURNOVER AND RATIOS WORKING PAPER

Assessee: ___ · PAN: ___ · Previous year ended: ___ · Assessment Year: ___

What the clause asks: details of turnover, gross profit and related ratios for the previous year and the preceding previous year — (1) total turnover of the assessee, (2) gross profit to turnover, (3) net profit to turnover, (4) stock-in-trade to turnover, and (5) material consumed to finished goods produced. The form notes that the details are for the principal items of goods traded or manufactured or services rendered.

1. Ratios for the clause

↑ Excerpt only — the full template is what you download as Word
About this template

What you’re downloading, and when to use it.

This template follows the format published by the Institute of Chartered Accountants of India (ICAI) in the AASB Audit Working Paper Templates (June 2023), the authoritative reference for Indian statutory-audit documentation. Fill in your firm’s letterhead and the engagement details on the form above, click Download Word file, and you’ll get a fully formatted .docx ready to use.

Everything is generated in your browser and on a stateless API endpoint — no account, nothing stored on our servers. We’ll ask for a work email once before your first download so we can send you the file and the occasional relevant update; after that, downloads on this device are instant. Edit freely in Word, Google Docs or Pages before sending to your client.

Common questions

FAQs.

Which ratios are reported in clause 40 of Form 3CD for AY 2026-27?
Five items: total turnover, gross profit to turnover, net profit to turnover, stock-in-trade to turnover, and material consumed to finished goods produced — each for the previous year and the preceding previous year. The ratios are worked out in value terms.
How is each clause 40 ratio calculated?
Gross profit is turnover less cost of goods sold (opening stock plus purchases and direct expenses less closing stock). Net profit is taken before tax. Stock-in-trade is the closing stock of finished or traded goods only, excluding raw material and work-in-progress. Material consumed is opening raw material plus purchases less closing raw material, and finished goods produced is the value of production for the year. The first three ratios are divided by turnover; the last is material consumed divided by finished goods produced.
Do service providers and traders have to report all the ratios?
No. The stock and production ratios are relevant to manufacturing and trading. A trader reports turnover, gross profit, net profit and stock-in-trade ratios but not material consumed to finished goods produced. A service provider with no stock reports turnover and net profit and marks the remaining rows as not applicable, with the reason.
What if the assessee was not audited in the preceding year?
The preceding-year figures are normally taken from the previous tax audit report. Where there was no tax audit in the preceding year, the preceding-year column need not be filled and the fact should be stated. If last year’s report used a different basis for a ratio, either follow that basis or restate last year’s ratio and disclose the change.
Does a fall in the gross profit ratio have to be explained in the report?
The clause asks only for the figures. The explanation belongs in the audit file: the auditor should understand significant movements — price, product mix, input cost, yield, stock valuation — before signing, because ratio variances are a common basis for selection and questions in assessment.
Is Form 3CD still used for tax year 2026-27 (FY 2026-27)?
No. Form 3CD, and this working paper, apply up to AY 2026-27 (FY 2025-26) under the Income-tax Act, 1961. For tax years beginning on or after 1 April 2026, the audit report and statement of particulars are furnished in Form No. 26 under section 63 of the Income-tax Act, 2025 read with Rule 47 of the Income-tax Rules, 2026, which replaces Forms 3CA, 3CB and 3CD. Re-map the clause numbers and section references before reusing this working paper for that year.
Related templates

You might also need.

Analytical Procedures Audit Working Paper
Free SA 520 analytical procedures audit working paper — expectation vs actual variance computed per line item,
Inventory Audit Working Paper (Ind AS 2 / AS 2) — ICAI Audit Working Paper
Free inventory audit working paper (ind as 2 / as 2) audit working paper template (ICAI, Chapter 3). Generate
Form 3CD Clause-wise Working Paper Index — Audit File Completeness Tracker
Free Form 3CD clause-wise working paper index — audit file completeness tracker mapping each clause to its sup
Form 3CD — Tax Audit Report under Section 44AB
Free Form 3CD + Form 3CB tax audit report template under Section 44AB of the Income-tax Act 1961. CBDT prescri