Tax planning for FY 2026‑27 requires precision, clarity, and timely preparation. Therefore, professionals and salaried individuals must understand how to prepare a Tax Computed Sheet, calculate House Rent Allowance (HRA), apply Arrears Relief under Section 89(1), and generate Form 16(130). Consequently, this guide explains each component step‑by‑step, ensuring compliance with the Income Tax Act while maximising efficiency.
Importance of a Tax Computed Sheet
A Tax Computed Sheet acts as the foundation of income tax filing. Moreover, it consolidates salary income, allowances, deductions, and exemptions into a structured format. As a result, taxpayers can visualise their liability before filing returns.
· It simplifies complex calculations.
· It ensures accuracy in reporting.
· It helps avoid mismatches with Form 16(Now Form 130).
Additionally, employers rely on this sheet to cross‑verify payroll records, while employees use it to plan investments strategically.
Preparing the Tax Computed Sheet
To prepare the sheet, follow these steps:
1. Collect Salary Details – Include basic pay, DA, HRA, special allowances, and perquisites.
2. Add Other Income – Interest, rental income, or freelance earnings.
3. Apply Exemptions – For example, HRA exemption under Section 10(13A).
4. Deduct Investments – Under Sections 80C, 80D, and 80G.
5. Compute Taxable Income – Subtract deductions from gross total income.
6. Apply Tax Rates – Use FY 2026‑27 slab rates.
7. Add Surcharge and Cess – As applicable.
Thus, the sheet becomes a ready reference for filing ITR‑1 or ITR‑2.
HRA Calculation Explained
House Rent Allowance is a major tax‑saving component. However, exemption depends on specific conditions.
Formula for HRA Exemption
The least of the following is exempt:
· Actual HRA received.
· Fifty per cent of salary (metro cities) or forty per cent (non‑metro).
· Rent paid minus 10% of salary.
For instance, if an employee earns ₹6,00,000 annually, pays ₹1,80,000 rent, and receives ₹1,50,000 HRA, the exemption is calculated using the above formula. Consequently, only the balance becomes taxable.
Arrears Relief under Section 89(1)[Amended Section 157(1) as per Income Tax Act 2025 with New Amended Form 39 in place of 10E]
Salary arrears often distort tax liability. Therefore, Section 89(1) provides relief by spreading income across relevant years.
Steps for Relief Calculation
1. Compute tax on total income including arrears.
2. Compute tax on total income excluding arrears.
3. Find the difference.
4. Compute tax for previous years with arrears added.
5. Compute tax for previous years without arrears.
6. Find the difference.
7. Relief = Excess tax in current year – Excess tax in previous years.
Hence, employees avoid paying disproportionately high taxes due to arrears.
Form 16(Amended Form 130) as per Income Tax Act 2025 for FY 2026‑27
Form 16 remains the most crucial certificate for salaried taxpayers. Specifically, Form 16(130) for FY 2026‑27 includes:
· Part A – Employer details, PAN, TAN, employee details, and summary of tax deducted.
· Part B – Detailed breakup of salary, exemptions, deductions, and tax computation.
Since the Income Tax Department mandates electronic issuance, employees must download it from the TRACES portal. Consequently, this document ensures smooth filing of ITR.
Integration of All Components
When taxpayers prepare a Tax Computed Sheet, calculate HRA, apply arrears relief, and reconcile with Form 16, they achieve:
· Accuracy – No mismatch between employer records and self‑calculation.
· Compliance – Adherence to IT Act provisions.
· Efficiency – Faster filing process.
· Savings – Optimised tax liability.
Therefore, integration is not optional but essential.
Common Mistakes to Avoid
Even though the process seems straightforward, taxpayers often commit errors:
· Ignoring rent receipts for HRA claims.
· Misreporting arrears without Section 89(1) relief.
· Forgetting to reconcile Form 16 with personal records.
· Overlooking deductions under 80C or 80D.
Thus, careful documentation prevents notices from the Income Tax Department.
Practical Example
Suppose Mr Sharma earns ₹8,00,000 annually, receives ₹2,00,000 HRA, pays ₹2,40,000 rent, and gets ₹50,000 arrears.
· Tax Computation Sheet shows gross income of ₹8,50,000.
· HRA Exemption = Least of ₹2,00,000, ₹3,20,000 (40% of salary), or ₹1,60,000 (Rent – 10% salary). Hence, exemption = ₹1,60,000.
· Arrears Relief reduces excess tax burden.
· Form 16(130) reflects final liability after deductions.
Consequently, Mr Sharma files his return accurately.
Conclusion
Tax compliance for FY 2026‑27 demands structured preparation. By creating a Tax Computed Sheet, calculating HRA exemption, applying Arrears Relief under Section 89(1), and reconciling with Form 16(130), taxpayers achieve accuracy and savings. Moreover, this integrated approach reduces stress during filing season. Ultimately, proactive planning ensures financial discipline and legal compliance.
Feature of this Excel Utility
1. Inbuilt the Salary Structure for the Government and Non-Government Employees' Salary Pattern
2. Amended Income Tax Sections and forms are included in this Utility as per the Income Tax Act 2025
3. Automatically calculate your Income Tax liability as per Budget 2026
4. Automatically calculate your House Rent Exemptions
5. Automatically prepare your Income Tax Arrears Relief Calculation U/s 89(1)(Modified Section 157(1) with Form 10E (Now Modified Form 39)
6. Automatically prepare Income Tax Form 16(Now Modified Form 130)
