Salary Income Tax Calculator Fy 2021-22 Excel Free Download
Pirkko Wassell
Gross Total Income (GTI, in short), is the aggregate taxable income under the different heads of income such as income from salary, income from house property, income from profits or gains of business, capital gains, and income from other sources. i.e., the total income computed in accordance with the provisions of the IT Act before making any deductions under Sec 80 C to 80 U.
Payments of salary, wages, commissions, bonuses or allowances made after the death of an employee are not subject to withholding. Even if the income was earned before the death of the payee, you are not required to withhold an amount.
As you can see with the above income tax calculation, salary components and salary structure plays a very important role in how much income tax you pay. We have come up with some optimised salary structure using which you pay NO income tax even with CTC of more than Rs 20 Lakhs.
You should do the calculation using our income tax calculator and check yourself. In most cases if you do tax saving investments and get salary components tax deduction, you should follow the old tax slab.
Ans. You have the option of choosing between Old Slab Rates and New Slab Rates in order to calculate your Income Tax in FY 2021-22. You can choose based on your income and investments you make to accordingly calculate income tax in FY 2021-22
Ans. No, you cannot claim any deductions for your investments you make using New Income Tax Slab Rates for FY 2021-22. So your gross income becomes your Net Taxable Income to calculate your Income Tax.
Please download the income tax calculator from the links provided below on the basis of the required financial year/assessment year. Any person who has some basic knowledge of Microsoft Excel can use this tool easily.
Hi Sir,
Thanks for helping us by providing the excels. It is very useful for me to plan my activities.
I heard there is a tax applied for PF amount where it cross 2.5lakhs. Pls explain how its computed. Is employee, employer and VPF contributions are consider for 2.5lakhs. Is this calculation is considered in your tax calculator excel.
This free to download Excel tax calculator has been updated for the 2021-22 and later years 2022-23, 2022-24 and 2024-25 and includes the March 2022 Budget increase of $420 to the Lower and Middle Income Tax Offset for the 2021-22 year.
This is a simple spreadsheet calculator which enables the calculation of income tax plus Medicare Levy and LITO/LMITO for taxable income on an annual basis. (For periodic income payments, there is a calculator for tax instalment PAYG purposes here.)
From year 2018-19, standard deduction has been introduced, With arrears of salary, can i deduct standard deduction and then calculate tax?the calculator is not taking standard deduction into consideration, which is correct? with or without standard deduction
Sir I have received arrear of salary from 1995-96 where I fill this salary amount as per ur ay 18-19 form 10e please give a solution or send excel if available regarding this case
chetan...@gmail.com
Sir
In financial year 2017-2018 and Assessment Year 2018-2019 got arrears 11years and 05 months i.e. from 2006 to 2017, so I need updated Abacus Excel 10E salary arrear calculator.
Kindly sent its link to at my id.
thanks in anticipation
In financial year 2014-2015 and Assessment Year 2015-2016 got arrears 16years and 05 months i.e. from 1996 to 2012, and department deducted 84500/- as a TDS. Department alos not provide form 10E .so I need updated Abacus Excel 10E salary arrear calculator.
Kindly sent its link to at my id.
thanks in anticipation
This financial year 2017-18 /Assessment year 2018-19, I got 3 years arrears i.e. 2015-16 (2 month), 2016-17 and 2017-18. So I need updated Abacus excel form 10-E salary arrears relief calculator for the assessment year 2017-18
This financial year 2017-18 /Assessment year 2018-19, I got 10 years arrear from FY 1995-96 to FY 2003-04. So I need updated Abacus excel form 10-E salary arrears relief calculator for the assessment year 2018-19
i have downloaded excel 10e calculator software from your website, but even after filling the required details and followed the instructions, in Table-A columns 5,6 & 7 it is showing #VALUE!, so please send me the Updated version of 10e excel utility. to my mail id
Salary is taxed at normal rate and STCG is taxed at 15% so to claim relief for salary arrears should I consider only income heads which are taxed at normal rate that is income from salary and other sourses please explain about total income to be written in annexure 1
I got pension arrears of earlier years in ay 17-18 that is fy 16-17. I have one query about total income in to be entered in column 2 of table 1 my total income consists of salary and short term capital gain from shares so while writting total income of previous years should I include or exclude the short term capital gain amount
If the taxpayer has earned Rs 1,700 savings account interest and Rs 42,000 interest on deposits from XYZ bank during the financial year, Form 26AS will only display Rs 42,000 deposit interest details on which TDS is deducted. At the same time, the annual information statement will show both the transaction details. In addition, the taxpayer can also see the bank account details from where the income was received, for example, bank name, bank account number, account type, etc. Similarly, it will display all other financial information of the previous year, such as rent received, salary, dividends, etc.
Our income analysis tools and job aids are designed to help you evaluate qualifying income quickly and easily. Use our PDF worksheets to total numbers by hand or let our Excel calculators do the work for you.
I am having income from salary and filing ITR-2 to carry forward current year losses on house property. My income chargeable under the head salaries is 38L and the loss from house property is 5.5L. However in Tab AMT Tax Payable under section 115JC is coming zero and therefore Tax Payable on Total Income is Coming (Part B -TTI) is also coming zero. Please help
I am an NRI and work for an international organization. My salary income is tax-exempt both in the country where I am located and in India. My only income in India accrues from my bank account interest in India (both NRE and NRO accounts). Till last year (AY 2019-20) I submitted online ITR-1 and that was accepted without an issue. Now I understand that as an NRI I cannot use ITR-1. Please confirm if ITR-2 is the right form for me. Thank you.
I was an NRI during AY 2020-21 working abroad. Do I have to mention my NR salary income in ITR 2? I am confused about whether my NR salary income is to be mentioned in Schedule EI Exempt income under DTAA. Kindly advise.
Hi, I am an NRI. I have to file ITR 2. My resident status is of Bahrain, where has Nil Income Tax. I have to provide salary earned in Bahrain under exempt income and foreign income. But as per my understanding, NRI will not cover under DTAA. Is it correct? Then where should we show a foreign salary in ITR 2
Sir, I am a salaried person and used to file my IT returns under ITR 1. During FY 2017-18, I sold my flat. There was a long term capital loss and I have filed my IT returns in ITR 2. Kindly clarify, whether I have to file ITR 1 or ITR 2 for FY 2018-19. I have only salary income for the year.
Wingubox Online Payroll will automatically generate your iTax P10 data, NSSF Excel file and NHIF Byproduct for you with its in-built statutory formats. It will also give you a broad array of Human Resource Management tools not available on paye calculators in excel sheets.
f448fe82f3