The box, filled
The seven statutory figures on the opening screen, with commas, ready to re-key — plus the three-line Schedule-GST that Form 26 asks for from tax year 2026-27.
Clause 44 of Form 3CD · Tax audit
Clause 44 wants the whole year’s expenditure split by the GST status of each supplier — seven columns, every rupee placed. Tally has no such report, so it gets rebuilt in Excel each year. This one fills the box inside TallyPrime, from the vouchers you already posted.
or scroll down to see it work ↓
Inserted by the Income-tax (Eighth Amendment) Rules, 2018 and required in full since AY 2022-23: the break-up of total expenditure into payments to registered persons — exempt, composition and other — and to persons not registered under GST.
TallyPrime 3.0 and above · installs in 2 minutes · read-only · your data never leaves your computer
Why this clause eats a week
The registration status sits on the supplier’s ledger. The expenditure sits on the expense ledger. Clause 44 asks you to cross the two — for every voucher of the year — and Tally has no report that does it. So the job becomes an export, a pivot, and a fortnight of judgement calls that nobody records.
What the clause requires
Break up the total expenditure incurred during the year: the amount relating to entities registered under GST — split into exempt supplies, composition dealers and other registered entities — and the amount relating to entities not registered under GST. Capital expenditure is in. Salaries, depreciation and provisions are not a supply and stay out.
And it is not a formality any more. The figures are reconciled against your GST returns, so a break-up assembled by guesswork is an exposure — for the assessee and for the auditor who signed it.
See it at rest
The statutory line first — the seven figures you re-key into Form 3CD. One key opens the working behind them: every expense ledger, what it contributed to each column, and the vouchers underneath.
| Expenditure head | (2) Total | (3) Exempt | (4) Compo | (5) Other regd | (7) Not regd | Excluded |
|---|---|---|---|---|---|---|
| Purchase Accounts | ||||||
| Local Purchase | 59,04,940 | 59,04,940 | ||||
| Import Purchase | 68,91,773 | 68,91,773 | ||||
| Packing Material | 4,26,180 | 50,000 | 1,12,400 | 2,63,780 | ||
| Sub Total — in Clause 44 | 1,32,22,893 | 50,000 | 1,12,400 | 61,68,720 | 68,91,773 | |
| Excluded from Clause 44 — GST not applicable, or tagged | ||||||
| Customs Duty | 3,13,889 | 3,13,889 | ||||
| Sub Total — excluded | 3,13,889 | 3,13,889 | ||||
| Indirect Expenses | ||||||
| Commission Paid | 8,40,000 | 6,90,000 | 1,50,000 | |||
| Freight Outward | 2,74,180 | (–)50,000 | 3,24,180 | |||
| Salaries & Wages not a supply | 41,20,000 | 41,20,000 | ||||
Demo company — no real supplier, ledger or balance is shown. A credit note reduces its column (the freight row), and what is not a supply under GST is grouped out, in red, where you can see it and act on it.
What it does
The seven statutory figures on the opening screen, with commas, ready to re-key — plus the three-line Schedule-GST that Form 26 asks for from tax year 2026-27.
Every voucher of every expense ledger is placed in one column from its supplier’s GSTIN or registration type. Not ledger balances. Not a sample.
Salaries, depreciation, provisions and levies sit under their own red band with their own sub-total, inside each head — so you can see what is out and regroup it if you disagree.
Creditors banded by GSTIN and registration type. Open a band, see each supplier’s expenditure and the column it reports in, open a supplier, see its vouchers.
Force a ledger or a supplier into any column, or exclude it. The choice is written to the master, so next year’s audit opens already classified.
A books check on the face: what the report walked against the same ledgers’ own period balances. The difference must be zero — and it says so.
One key opens every rule the report applied, what it rests on, what to include or exclude, and links to the ICAI Guidance Note and the Income-tax site to verify it.
A report inside your own TallyPrime. It posts no voucher, changes nothing, uploads nothing. No licence key, no expiry.
How it works
Get it free
Tell us where to send it and we email you the file with install steps and the user manual. It’s free and it stays free — nothing to buy, nothing to activate, yours to keep and to share with the firm next door.
Three emails and nothing else: the file, one check-in the next day, and a version update if one ships. One-click unsubscribe on every one.
Straight answers
Free first consultation — tell us where you are and we'll tell you exactly what's possible. No commitment.
Book a free consultation