Income Tax Calculator for the Financial Year 2019-20 for Salaried Individuals in India in Excel.
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 Interim Budget 2019 Proposals in this Excel Tool for Tax Calculation.
Features :
1. Mainly useful for the salaried Employees having income includes:
a . Income from Salary
b. Income from House Property (Self Occupied and Rented out)
c. Income from Capital Gain on (eligible) Sale of Shares and Equity oriented Mutual Funds where STT is paid.
d. Income from Interest (Other Sources). (Bifurcation w.r.t. Interest from Savings Bank Account, FD Interest etc.)
2. Separate sheet for each Source of Income
3. Calculate Taxable Income, Tax, Surcharge and Cess.
4. Salary Particulars can be given on monthly basis. Flexible Allowance and user defined heads of allowance are incorporated.
5. Calculation of Accrued Interest on NSC in neat tabular form.
6. Provision for Automatic calculation of deduction u/s 80 GG towards Rent Payment when HRA is not received.
7. Age is calculated (as per IT Act) automatically based on DOB.
8. Tax Provisions are considered where ever required w.r.t. Senior Citizen, Very Senior Citizen, Physically Handicapped, etc.
9. Section wise Tax Rules for Reference Purpose are provided;
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.)
10. This File may be useful to the Employers having limited no. of employees to Calculate Monthly TDS for each Employee, Gross Salary / Amount Paid to be shown in Quarterly 24Q eTDS Purpose etc.
11. The Tables are structured in such a way that it will be easier to fill information in the Income Tax Return.
12. Print Preview by clicking a Button for commonly required statements.
13. Number Format, changed to Indian Number format, instead of Thousands, except for Negative Numbers.
14. Data Import facility is provided to import from the previous release of this Tax Calculator ie. from v 19.01 and 19.02. So you don’t need to re enter all the data when the new version is released for Particular Financial Year Module.
15. Included Notes and FAQ for better understanding. Like Gift to Minor Child and Spouse, Topics on Capital Gain, etc
You may contact me for any clarification in this Excel Tax Calculator.
Don’t forget to check income tax calculator for ay 2020.
(Republished with amendments)
Author Bio
Hi, can you please send me income tax calculation sheet (wherein we put month on month figures) in excel format for FY 2019-20
Please send excel version of tax computation for FY 19-20 salaried person
Sir please send the Excel format for tax calculation for fy 19-20 thank you to sandeepsandy5196@gmail.com
Sir please send the Excel format for tax calculation for fy 19-20 thank you
Please send excel sheet
HI. Please share the excel forat of calculator to sravankumar.kumar2@gmail.com
Thank You
kindly send XL sheet for FY 2019-20
Please send me the calculator . Thanks.
pls send excel sheet
Please send excel version of tax computation for FY 19-20 salaried
Please send excel version of tax computation for FY 19-20 salaried
Kindly send me the sheet
Sir
Please mail me the excel utility.
project.jaci@gmail.com
Please send excel version of tax computation for FY 19-20 salaried person by email:
pappuranjeeta@gmail.com
Regards
Sir, Please send the Income tax calculation excel sheet for FY 2019-20
Pls share 19-20 tax calculation excel sheet for salaried to ajay.inr@gmail.com. Thanks.
Please send excel version of tax computation for 19-20 salaried person to ajay.inr@gmail.com
Thanks.
Please send excel version of tax computation for FY 19-20 salaried persons on my email.
Best regards
Require income tax calculator in excel format for FY 2019-20
Please send excel version of tax computation for 19-20 salaried person
Pl. mail me the Income tax calculation excel sheet for FY 2019-20
Sir, Please send the Income tax calculation excel sheet for FY 2019-20
Pl. mail me the Income tax calculation excel sheet for FY 2019-20
Dear Sir,
Please send excel version of tax computation for FY 19-20 salaried person
Regards
You can download the latest version from this link also.
https://drive.google.com/drive/folders/1T-BfIgxNudtALodp8Xc-UbFTj-2XMyZc?usp=sharing
Regards,
Govind
hello
please share the excel sheet for FY2019-20
thanks in advance
Sir
Pls mail me the Income Tax Calculator for the FY 2019 – 20 in my mail id debasish.behera4678@gmail.com
Is additional deduction of rs50000 allowed for an individual who are s not employed but having other sources of income like rent int on FD etc
2 pl send your excel sheet
Please send me the tax calculator Excel file
pls. send the salaries TDS calculator for A.Y. 20-21 on my email id Raviteja.konda@gmail.com
pls. send the income tax calculator on for a.y. 20-21 on mail id gaurav@verto.in
pls. send the income tax calculator on fy 2019-20 to marines@aol.in
Dear Sir,
Please send email of income tax calculator excel sheet
Pl. mail me the Income tax calculation excel sheet for 2019-20
My email id is venkatesh@candeoinfotech.in
Pl. mail me the Income tax calculation excel sheet for 2019-20
Pl. mail me the Income tax calculation excel sheet for 2019-20
kindly send me to excel sheet for filling itr-1 also TDS was deducted on lic single premium policy TDS deducted 1% purchased for rs one lac on May 2011 &
repurchased on Oct 2018 with TDS rs 1935 total credited in 26AS Rs.193507/- for the income from lic 2018 & TDS Rs.1935/- net credited to my a/c.which income is exempted i.e. premium paid at the time of purchase price rs one lac & which ITR I shall file
CAPITAL GAIN :: If equity share allotted by company against issue in 2000-01 and. No STT payable on company issued & allotment. And share sold through reco exchange in 2019-20 and paid STT. Can we avail Rs. 1 lac exemption of LTCG. We calculate purchase rate on 31.1.2018 and sold rate actual on sale date
Sir,can you please share the tax calculator FY 19-20 and Tax declaration FY 19-20 excel for salaried.
Please send excel version of tax computation for 19-20 salaried person on email caosmbi@gmail.com
Regards
Kindly send me the Income tax calculator on kulwant_46@yahoo.com. Thanks.
–Kulwant Singh-
Hello sir Send excel sheet
Dear Sir,
Please send excel version of tax computation for 19-20 salaried person.
with regards
Now the latest version v 19.02 is already uploded in this article.
You can download the same from this website itself.
Dear Sir,
Please send excel version of tax computation for 19-20 salaried person.
ssprabhu.engg@gmail.com
Regards
KINDLY SEND ME EXCEL SHEET FOR TDS CALCULATION
Please send me the income tax calculator for salaried person.my email id niteshkumar.patel@gmail.com
Dear Mr Govind,
Please send excel version of tax computation for 19-20 salaried person
Regards
New version of this Tax Calculator is available now.
Any one wants please mail me. I will send that Excel file to you.
Revision Changes:
No change in Tax Calculation. (Except for addition made for Transport allowance for Blind)
No change in Input Data Ranges.
Change in Font.
Number Format changed to Indian Number format, Instead of Thousands, except in Negative Numbers..
Minor changes in Sheet “Summary of IncomeFromSalary” . Added Two Rows
Few Notes Added in “Instruction” Sheet
Regards,
Govind
Could you please realign the columns H & I in “Summary of incomefromsalary” sheet & Column H in “Tax ” sheet? The width needs to be increased.