Simple Income Tax Calculator for the Financial Year 2021-22 in Excel for Salaried Individuals.
Tax Planning in the beginning of the Financial Year is always better instead of doing that at the end of the year in hurry. This will help the Individual to plan their Investments in advance and submit necessary documents to their Employer in time.
I am a CA Inter Completed, Experience in Private Sector as a Head of Finance.
I have considered the Budget 2021 in this Tax Filing Software which is a Excel Tool for Tax Calculation.
Features :
1. Mainly useful for the salaried Employees having income includes:
a . Income from Salary / Pension
b. Income from Interest (Other Sources). (Bifurcation w.r.t. Interest from Savings Bank Account, FD Interest etc., NSC Accrued Interest)
c. You can input Capital Gain on Shares, Dividend Income, TDS deducted by others etc
2. Separate sheet for each Source of Income
3. Calculate Taxable Income, Tax, etc for Old Regime.
4. Provision for Automatic calculation of deduction u/s 80 GG towards Rent Payment when HRA is not received.
5. Age is calculated (as per IT Act) automatically based on DOB.
6. Tax Provisions are considered where ever required w.r.t. Senior Citizen, Very Senior Citizen, Physically Handicapped, etc.
7. Detailed statements are provided for :
a. Income Tax Slab
b. Tab Rebate
c. Exempted Income u/s 10 & Standard deduction u/s 16
d. Deductions under Chapter VI A (Sec 80 C, 80 CCC, 80 CCD, 80 D, 80 U, 80 TTA , TTB etc.)
8. This File may be useful to the Employers having limited no. of employees to Calculate Monthly TDS for each Employee.
9. The Tables are structured in such a way that it will be easier to fill information in the Income Tax Return.
10. Print Preview by clicking a Button for commonly required statements.
11. Number Format, changed to Indian Number format, instead of Thousands, except for Negative Numbers.
12. Data Import facility is provided to import from the previous release of this Tax Calculator ie. So you don’t need to re enter all the data when the new version is released for Particular Financial Year Module.
13. Helpful to employers to match Gross Salary / Amount Paid to be shown in Quarterly 24Q, while filing eTDS return.
14. Form 16 Part B, Tax Calculation as per New Regime, Bulk TDS Calculator for multiple employees will also be provided on request.
You may contact me for any clarification in this Excel Tax Calculator at grajan_k@yahoo.com.
(Republished with Amendments)
Author Bio
please forward income tax calculator xls file for the income assessment for the year 2022-23. with income slab basic, hra, conveyance, epf, all perq, bonus, exgratia etc and with less exemption criteria fill-up and at last taxable income
Please suggest how to print after feeding all the data because I clicked on the PRINTALL button, which shows some error in VBA Projects. Kindly guide me and can u share the computation of Income for ITR-1, ITR-2, and ITR-3 format in Excel?
please do mail j9thathagar@gmail.com
You can call me.
Further the tax calculation in excel will suffice the requirements to fill ITR-1, ITR-2, and ITR-3. I do not provide excel tool in those ITR formats separately.
Dear Mr. Govindaraj,
Can I get excel sheet of Income tax calculation with formula
Please share income tax calculator in excel for the year 2021-22 to mail id o.rajeshindia@gmail.com
Sir,
Please share income tax calculator in excel for the year 2021-22 to mail id srinibhat2000@gmail.com
Thanks in advance
Password of the Excel File ??????
I am need excel sheet computation income statement
i need income tax calculator for the year 2021-22
Tax calculator fy 2020 21
Dear Sir,
One of our staff joined on middle of the year. How to calculate his Income Tax, Standard deductions, 80C Deduction and other deductions.
Thanking you,
sheet required password to open. can anybody help..?
wanted income tax calculator excel sheet
Dear Sir,
Please provide excel sheet password
Dear Sir
Please Provide Password For Use This File
please provide the password to open the worksheet
PLEASE SIR SEND ME OF FULL VERSION OF EXCEL SHEET OF SALARY F.Y-2021-22
Dear Govind Raj
Thank you very for uploading excel based TDS calculation software.
Can you please provide me password for opening in VBA editor & worksheet password, if any, ?
It is required for using vlookup to fetch data from salary & other employee particulars.
It is very helpful to me if you share password. Thank you once again
KK Unnikrishnan
unnikrishhnankk@gmail.com
PLEASE SIR SEND ME OF FULL VERSION OF EXCEL SHEET OF SALARY F.Y-2021-22
for working purpose
it is working except locked sheet income from house property
I downloaded the spreadsheet and it is not working as designed. I correctly entered the data in Input_Basic, Input_Salary, Input_Others, Deductions but the final Tax sheet is unable to calculate the correct Tax. It doesn’t calculate the Income Tax Payable/Refund and shows in Purple highlighted cell.
Additionally, ForWorking page, Print and Import Data are not working in this spreadsheet.
Micro’s are enabled and all the instructions were followed correctly.
sheet required password to open. can anybody help..?
for study
I have invested some amount in Sri gururaghavendra bank which is under sec 35a. The amount of interest on my deposit has been credited to my account after recovering 10pc tax. It is only book adjustment and nothing is withdrwn as per 35a. The interst credited has come in 26a. How can we avoid it on that income. Will you please help me
This is not working , i am not able to insert data on any cell/ sheet.
Please guide.
FY 2021-22 excel utility for tax calculation is not showing. Request to attach to my mail id ssp1758@gmail and Prabhakaran.Subramaniam@gmail.com
Pl. calculate IT taking into consideration above all facts i.e salary . HRA . Rent paid house provided , Car maintenance given . perks etc. so that easily can understand computaion. Thanks.
No Excel sheet. Nothing. Is it really authenticated website or not. Only error message is coming while log in. They should explain clearly where went wrong.
Dear Sir,
CAN YOU CLEAR THE DOUBT?
IN E-FILI 2 PORTAL
SCHEDULE ‘CFL’
XII) TOTAL LOSS CARRIED FORWARD TO FUTURE YEARS
CONTAINS 4 LOSS OPTIONS –
1. HOUSE PROPERTY LOSS
2. SHORT-TERM CAPITAL LOSS
3. LONG-TERM CAPITAL LOSS
4. LOSS FROM OWNING AND MAINTAINING RACE HORSES
BUT, NOT SALARY LOSS.
THEN, HOW TO CARRY FORWARD SALARY LOSS INCURRED IN AY 2021-22 TO AY 2022-23.???
How Did you get salary loss?
Salary income cannot be in loss.
Regards,
Govind
Attachment not found please
Excel File is very well available in taxguru.in website for download.
You need to register in taxguru.in to download.
Attachment not there
https://taxguru.in/r/?link=https://taxguru.in/wp-content/uploads/2021/08/Simple-Income-Tax-Calculator-for-the-Financial-Year-2021-22-in-Excel-for-Salaried-Individuals.zip&title=Income%20Tax%20Calculator%20for%20FY%202021-22%20in%20Excel%20for%20Salaried%20Individuals
Thanks for your efforts. No calculator available to check and give opinion. Kindly provide and oblige. Vasudevan Bengaluru
will you provide excell sheet after paying your fee? if so,how much fee for calculation sheet?will you provide your account no,so that by Phonepay we can send amount
Excel File is very well available in taxguru.in website for download.
You need to register in taxguru.in to download.
You have not given your correct email id.
What you have given is
abc@gmail.com
Is this your email id ?
Sir you forgot to attach the excel calculator
Exactly.. U forgot to attach the file
Excel File is very well available in taxguru.in website for download.
You need to register in taxguru.in to download.
Age not calculating..
You need to enable macro in Excel.
Please read the instruction sheet.