income tax calculator excel free download

Form 16 Part B, Tax Calculation as per New Regime, Bulk TDS Calculator for multiple employees will also be provided on request.Our tax calculator calculates your personal tax free allowance. Helpful to employers to match Gross Salary / Amount Paid to be shown in Quarterly 24Q, while filing eTDS return.ġ4. So you don’t need to re enter all the data when the new version is released for Particular Financial Year Module.ġ3.

Data Import facility is provided to import from the previous release of this Tax Calculator ie. Number Format, changed to Indian Number format, instead of Thousands, except for Negative Numbers.ġ2. Print Preview by clicking a Button for commonly required statements.ġ1. The Tables are structured in such a way that it will be easier to fill information in the Income Tax Return.ġ0. of employees to Calculate Monthly TDS for each Employee.ĩ. This File may be useful to the Employers having limited no. Deductions under Chapter VI A (Sec 80 C, 80 CCC, 80 CCD, 80 D, 80 U, 80 TTA, TTB etc.)Ĩ. Exempted Income u/s 10 & Standard deduction u/s 16ĭ. Senior Citizen, Very Senior Citizen, Physically Handicapped, etc.ħ. Tax Provisions are considered where ever required w.r.t. Age is calculated (as per IT Act) automatically based on DOB.Ħ. Provision for Automatic calculation of deduction u/s 80 GG towards Rent Payment when HRA is not received.ĥ. Calculate Taxable Income, Tax, etc for Old Regime.Ĥ. Separate sheet for each Source of Incomeģ. You can input Capital Gain on Shares, Dividend Income, TDS deducted by others etcĢ. Interest from Savings Bank Account, FD Interest etc., NSC Accrued Interest)Ĭ. Mainly useful for the salaried Employees having income includes:ī. I have considered the Budget 2021 in this Tax Filing Softwarewhich is a Excel Tool for Tax Calculation.ġ.

I am a CA Inter Completed, Experience in Private Sector as a Head of Finance.

This will help the Individual to plan their Investments in advance and submit necessary documents to their Employer in time. Tax Planning in the beginning of the Financial Year is always better instead of doing that at the end of the year in hurry.

Simple Income Tax Calculator for the Financial Year 2021-22 in Excel for Salaried Individuals.

Income tax calculator excel free download