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
Plz send monthly tax culculator 2019-20 with form 16
Sir,
FY 19-20 Employee Salary Working Excel Required,
pls forward the nail Id. srkrish56@gmail.com
please send IT calculator for 19-20
Pl. mail me the Income tax calculation excel sheet for FY 2019-20
Dear Mr Govind,
Please send me the income tax calculator for salaried person 2019-2020
please provide me income tax calculator fy 2019-20
Kindly, send me the calculator for AY 2019-20.
Please email me the income tax calculation sheet along with Form 16 for F.Y. 2019-20.
PLEASE SEND THE IT CALCULATOR FOR F.Y 2019-20 RELEVENT TO ASST YEAR 2020-21AND WHICH OPTION IS BENEFICIAL TO ASSESSEES
Please send me Income tax calculator 2019-20 in Exel Sheet
Pl. mail me the Income tax calculation excel sheet for FY 2019-20
Dear Mr Govind,
Please send me the income tax calculator for salaried person 2019-2020
Plz provide me with the income tax calculator for financial year 2019-20 in excel for individual and bulk. My email id shahmushtaq26@gmail.com
Plz provide me income tax calculator for financial year 2019-20 in excel for individual and bulk
Dear sir ,
Please email the TDS calcutor for f.y 2019-20 ( multiple employees).
TDS calcutor for f.y 2020-21 ( multiple employees).
Thanks
Vikrant
Please send me TDS Calculator for FY 2019-20 in excel
Sir, Request you to please mail the Income Tax Calculation (in MS-Excel) for FY 2019-20. My email ID is rbeekol@yahoo.co.in
Plz e-mail me the income tax calculator for FY: 2019-20 AY: 2020-21
Pl. mail me the Income tax calculation excel sheet for FY 2019-20
Dear Mr Govind,
Please send excel version of tax computation for 19-20 salaried person
Regards
Can you give me income tax calculator AY 19-20.
Sir please send Income Tax caluculator for salaried employees
please send individual salaried exel file thanks
Please send me income tax calculations form for ft 2019-2020
Dear Sir,
Please Send income tax exel sheet for salaried person with salary sheet and Form no. 16
Dear Sir,
Please send excel version of tax computation for F.Y.2019-20 salaried person
My E Mail.Id. bharataipl@gmail.com
Thanks & Regards
Please send excel format the income tax calculator for salaried person F.Y. 2019-20 & excel format for IT Computation for FY 2019-2020
Hi sir,
Please mai me tax calculator sheet 20119-20 thanks.
Krishna.gopi135@gmail.com
Dear Sir,
Please send me the Income Tax calculation excel sheet for FY 2019-20
Dear Sir,
Please send me the Income Tax calculation excel sheet for FY 2019-20
Dear sir ,
Please email the TDS calcutor for f.y 2019-20 ( multiple employees).
Thanks
Amar
kashyap.amar272@gmail.com
sir please send me income tax calculator in excel sheet for FY 2019-20 as i am a government servant.
my email address is
subha210@gmail.com
sir please send me income tax calculator in excel sheet for FY 2019-20 as i am a government servant.
Pl. mail me the Income tax calculation excel sheet for 2019-20
sir
how to average tax calculation, for salary employees example. pl. sent my email
.krathinasapathy@gmail.com
Thanks
sir
how to average tax calculation, for salary employees example. pl. sent my email
Thanks
Please mail me Excel utility for TDS Calculation of bulk employees on my mail ID dktiwari1680@gmail.com
Pl. mail me the Income tax calculation excel sheet for 2019-20
pls share the Income tax calculation excel sheet for FY 2019-20 @ nazeersdr@gmail.com
Sir,
Please let us know the TDS calculation to pay for 2Q TDS of fy 2019-20.
Sarma
Sir,
Kindly send me TDS calculator for 2019-2020.
Thanks
Everybody is asking for xls file.
Please let us know how to get that?
Please mail me the Income tax calculation excel sheet for FY 2019-20 based on the post budget slab. Expecting the excel to have all the formulaes to calculate TDS for salaried person.
Dear sir
Please send me xls file
Thanks and regards
Jitendra Vichare
May You Please kindly share the Excel sheet for myself use?
Regards
Please forward the excel sheet
Please send the tax calculation excel sheet on kundannadkarni@gmail.com
Dear Sir ,
Kindly share the excel file to 1992uv@gmail.com
Sir, please mail me Income Tax calcultaion sheet for FY 2019-20 for office use