Download Automatic Income Tax Form 10E for FY 2025-26 in Excel

Download and Prepare at a Time 50 Employees Form 16 Part A & B in Excel for FY 2025-26

Salaried employees often receive salary arrears, which push them into higher tax slabs. Download the automatic Income Tax Form 10E Excel calculator for FY 2025-26 to claim relief under Section 89(1) instantly. This tool simplifies calculations and prepares Form 10E data accurately.​

What is Form 10E?

Form 10E furnishes particulars for tax relief on arrears or advance salary under Section 89(1). Taxpayers file it online before claiming relief in their ITR. First, it details income spread across relevant years; then, it computes tax differences. Therefore, the Income Tax Department verifies claims easily. Moreover, employees submit it to employers or assessing officers.

Why Need Arrears Relief?

Arrears increase the current year’s income sharply. Consequently, taxes rise due to higher slabs. However, Section 89(1) spreads arrears to original years for fair taxation. As a result, you pay only the due amount. Furthermore, without Form 10E, claims fail during scrutiny. Thus, this relief protects your wallet effectively.

Feature Benefit
Year-wise slabs Accurate historical taxes ​
Form 10E output Ready for e-filing ​
Auto-allocation Spreads arrears correctly
New/Old regime Flexible choices ​
Offline Excel No internet needed ​

Key Features

This automatic Excel utility excels in simplicity. Firstly, it auto-applies tax slabs from FY 2000-01 to 2025-26. Secondly, it generates Form 10E annexures instantly. Thirdly, users input salary and arrears; then, formulas compute relief. Additionally, it supports old and new regimes. Moreover, offline use ensures privacy. Meanwhile, error checks prevent mistakes. As a result, beginners handle complex math effortlessly.

How to Download

Search for trusted sites like ABCAUS or tax software portals. Click download links for FY 2025-26 versions. Enable macros upon opening. Next, save the file securely. Thereafter, verify updates match Budget 2025 slabs. Finally, test with sample data. Note: The official portal offers online Form 10E; Excel aids pre-calculation.

Step-by-Step Usage

Step 1: Open Excel; enter PAN, name, and current FY salary.
Step 2: List arrears by original FY in designated columns.
Step 3: Input deductions like 80C, standard deduction.
Step 4: Review auto-calculated tax with/without arrears.
Step 5: Copy relief to Form 10E annexures.
After that, e-file on incometax.gov.in. Consequently, your ITR processes smoothly.

For example, if FY 2024-25 arrears of ₹2 lakh join ₹10 lakh salary, tool spreads it back. It recalculates taxes; relief emerges as a difference. Thus, you avoid ₹20,000+ extra tax.​

Benefits for FY 2025-26

Budget 2025 updates slabs; this tool incorporates them. Government employees get pay commission arrears support. Private staff handle bonuses easily. Moreover, pensioners claim delayed pensions. In addition, it reduces consultant fees. Similarly, accuracy boosts refund chances. Notably, it covers multi-year arrears seamlessly. On the whole, users save time and money.

Common Mistakes to Avoid

Many skip Form 10E; claims are rejected. Others ignore the cess/surcharge in past years. Always use gross taxable income post-deductions. Double-check FYs; mismatches trigger notices. Furthermore, enabling macros or formulas fail. Consequently, verify totals manually.​

Who Should Download?

Salaried individuals with arrears download now. Government servants post-pay hikes use it first. Non-govt employees facing delays benefit next. Pensioners and retirees follow. In contrast, those without arrears skip it. Ultimately, anyone eyeing Section 89(1) relief grabs this.

Tax Slabs Overview (FY 2025-26)

Tool auto-handles these, but know the basics. Old regime: 0-3L nil, up to 30% over 15L. New: Simpler slabs post-Budget 2025. Relief applies regardless. Therefore, choose wisely via Excel preview.

The Arrears Relief Calculator Excel simplifies Section 89(1) tax relief for salary arrears in FY 2025-26. Follow these steps precisely for accurate results before filing Form 10E.

Preparation Steps

Download the utility from trusted sites like taxexcel.net or abcaus.in. Save as macro-enabled (.xlsm) format. Enable macros when opening—click “Enable Content” in the security bar. Verify FY 2025-26 slabs load correctly. Gather your Form 16s, arrears statements, and past ITRs.

Enter Personal Details

Locate the “Personal Info” or “Input Sheet 1” tab: input PAN, name, assessment year (2026-27), and residential status. Select old or new tax regime. Enter current FY 2025-26 gross salary excluding arrears. Add standard deduction and eligible Chapter VI-A deductions (e.g., 80C). Save changes.

Input Arrears Data

Switch to “Arrears Sheet” or “Year-wise Income.” List each arrears amount in a column for the original FY (e.g., FY 2024-25 arrears in row for that year). Specify if family pension or advance salary. Include tax already deducted on arrears (TDS). Use “Add Row” if multiple entries. Avoid overwriting formula cells (shaded yellow).

Auto-Calculate Relief

Press F9 or click the “Calculate” button to refresh. Review “Summary Sheet”: it shows tax without arrears, tax with arrears, and relief per year. Check Annexure I-VI for Form 10E figures—tax on total income minus tax on arrears spread. Verify totals match your inputs.

Generate Form 10E Output

Navigate to “Form 10E Sheet.” Formulas populate annexures automatically from prior sheets. Print or export as PDF—Cross-check Annexure II (arrears breakup) and V (relief computation). Note the relief amount for ITR Schedule 89.

Verify and Troubleshoot

Compare tool outputs with manual slab checks for one year. Common issues: Macros disabled (re-enable); wrong FY (correct dates); missing cess (tool includes). If errors, clear inputs and retry. Test with sample: ₹1L arrears from FY 2023-24 on ₹8L salary yields specific relief.

File ITR with Relief

Submit Form 10E online first via the e-filing portal (mandatory pre-ITR). Use Excel figures in ITR-1/2 Schedule 89. Claim relief reduces tax payable. E-verify within 30 days

 

Download Automatic Income Tax Form 10E for FY 2025-26 in Excel | Arrears Relief Calculator U/s 89(1) 

https://www.incometax.gov.in/iec/foportal/help/statutory-forms/popular-form/form10e-um

https://www.incometax.gov.in/iec/foportal/help/statutory-forms/popular-form/form10e-um

https://www.incometax.gov.in/iec/foportal/help/statutory-forms/popular-form/form10e-um

This utility transforms tax woes into wins. Download today; calculate confidently. File error-free; claim rightful relief. Your finances thank you

Related posts

Leave a Comment