ITR-6 Excel Utility AY 2026-27: Company Return Data-Population and Validation File

By Ravi Sisodia · Reviewed by CA Divyanshu Sengar · Updated 5 October 2026

ITR-6 online filing opened on 18 August 2026 and offline utility on 20 August. Company-return quality depends on a controlled bridge from audited accounts and tax computation into schedules, not on clearing Excel validation alone.

Finin2min 2-Minute Summary

• Online ITR-6 filing for AY 2026-27 became available on 18 August 2026.
• Offline utility became available on 20 August 2026 and current downloads should be checked before filing.
• Audited financial statements, MAT/AMT where applicable, depreciation, losses, related-party data, TDS and tax payments need schedule-level reconciliation.
• Utility validation does not prove tax correctness.
• Final submission should preserve utility version, JSON/output, validation, acknowledgement and board/authorised-signatory evidence.

Create a return data dictionary

Map each ITR-6 schedule field to the audited financial statements, tax computation, fixed-asset register, tax-audit/other report or statutory register. Identify manual fields with named owners.

Where tax presentation differs from Ind AS/Companies Act presentation, keep a bridge rather than changing accounts to mimic tax schedules.

High-risk validation areas

Check depreciation blocks, brought-forward losses, MAT credit, related-party/holding information, TDS/TCS, foreign income/FTC where relevant and balance-sheet/P&L cross totals.

A validation pass can coexist with a wrong mapping if both schedules carry the same incorrect figure.

Change control after accounts sign-off

If audited accounts are revised or a tax adjustment changes after the return file is prepared, re-run every dependent schedule and tax liability. Lock the final return-data population after authorised review.

Keep the previous draft only as archive with clear status.

Company return case: deferred-tax entry after audit sign-off

A company may post a late audit adjustment that changes deferred tax, depreciation or provision balances after the ITR-6 data file was prepared. Even if taxable income is unchanged, balance-sheet/P&L schedules can stop reconciling. The return workflow should therefore detect any post-lock journal and identify every ITR schedule affected.

Use a checksum or trial-balance version number in the tax pack. The final ITR-6 should state which audited trial balance version it was populated from so subsequent corrections can be traced.

• Version the final trial balance.
• Re-run dependent schedules after post-lock journals.
• Record return-to-accounts control totals.

Company-return analytics before sign-off

Run year-on-year analytics on revenue, margins, depreciation, related-party balances, tax expense, deferred tax, losses and major deductions before finalising ITR-6. A large movement may be correct, but the tax file should explain it. Analytical review often finds mapping errors that a formula-based utility validation cannot detect.

Where financial statements are consolidated as well as standalone, ensure the return uses the correct legal-entity standalone figures rather than data copied from the group pack.

• Use variance analytics in the final review.
• Confirm standalone entity data, not consolidated figures.

ITR-6 checklist

• Current Excel/offline utility.
• Audited accounts locked.
• Tax computation mapped.
• Depreciation/loss/MAT reconciled.
• TDS/tax payments matched.
• Validation clean.
• Authorised filing/e-verification evidence.

Questions readers commonly ask

When did ITR-6 online filing open?

18 August 2026.

Does a clean Excel validation mean the return is correct?

No.

What should be the source of truth?

Audited accounts plus tax computation and statutory/tax workpapers.

Should utility version be recorded?

Yes.

Official / primary sources

• Income Tax latest news - ITR-6 online/offline availability
• Income Tax downloads - Current AY 2026-27 ITR-6 files

Disclaimer

Important: General educational and professional-reference material. Verify the current operative law, commencement notification, portal version and exact facts before acting. Educational and professional reference only; confirm the current law, rates and the facts of your case before relying on this page.