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
Just wanted to mention keep up the good job.
Kudos for the article.
Pl. mail me the Income tax calculation excel sheet for FY 2019-20
Pl. mail me the Income tax calculation excel sheet for FY 2019-20
jude@intellizecorp.com
Pl. mail me the Income tax calculation excel sheet for FY 2019-20
Please sent mail the Income tax calculation excel sheet for FY 2019-20 Thanks
Kindly send me Salaried Individual Tax Calculator (Excel) FY 2019-20. Thanks
pls email me
Plz share latest income tax calculator (2019-2020)
Kindly mail me Income tax calculation excel sheet for FY 2019-20
the last date of filling itr for fy 2019-20 is 30 november 20 but when i file itr it calculates interest in 234/235 section why?
PLEASE SEND ME AN INDIVIDUAL I.T. CALCULATOR FOR AY 2020-21
sir tds reverse calculation formula
kindly send Salaried Individual Tax Calculator (Excel) FY 2019-20
Please send me income tax calculation excel sheet financial year 2019_20 assessment year 2020-21
Harjeet singh sodhi user ID 91585
24.6.2020
Please mail me Income Tax calculator excel sheet for salaries employees for FY 2019-20 on h.zala28@gmail.com
HI
Can anyone send me the details for calculation Capital gain against sale of property long term occupies & sold
IT calculator please …capt.mahdi7@gmail.com
GOOD AFTERNOON SIR
PLS SEND ME THE INCOME TAX CALCULATION FY 2019-20
Dear Sir,
Pl. mail me the individual tax calculator for the year 20-21 AY 21-21.
ACCOUNTANT
SAROJ KUMAR
SREEM SERBA TURBINES PVT. LTD.
Sir, provide me income tax calculator excel for financial year 2019-2020 for Pensioners .
i.Tax calculation sheet
Sir.
Please provide me the income tax calculation and form 16 for the FY 19 20 in excel format
AT omkar.nat@gmail.com
Sir
Please provide me the income tax calculation sheet as well as form 16 in excel format.
At omkar.nat@gmail.com
May I request you to kindly provide the tax calculation Excel sheet for fy 2019-20. I am retired from Army
Please send excel sheet on Klsharma1971 @ gmail.com
Pl send excale sheet of IT culstiom rxsting & new
sir please send me income tax calculator in excel sheet for FY 2019-20 as i am a government servant.
my email address is amoldj15@gmail.com
Please send me excel sheet for Salary Tax Calculation for the FY 2019-20
please mail me for the salary person tax calculation sheet for F.Y 2019-2020
sir, I am the 14000/-per month salary based employee i need income tax returns for the year 2019-20 for house loan please send the software
Pl. mail me the Income tax calculation excel sheet for FY 2019-20
Plz mail me IT calculation sheets in Excel. I am retired and have income from House Rent, pension and interest from Bank deposits. TIA
Please send me the excel format of tax calculator 2019-2020
Thanks
SANOJ
Please mail me the Income tax calculation excel sheet for FY 2019-20
please send income tax calculation excel sheet for Fy-2019-20 and also send salary tds excel sheet
Pl. mail me the Income tax calculation excel sheet for 2019-20
Pl send IT calculation E cell Sheet
I m a salaried employee. I saved 1.5lac in ppf. Can I get additional tax benefit on the amount of 50000 under section 80ccd1(b) which was contributed in cpf from my side.
PLZ MAIL ME THE EXCEL FORMAT OF TAX COMPUTATION OF SALARIED PERSON FY19-20. MAIL ID : VARSHNE@GMAIL.COM
Please mail me Income Tax calculator excel sheet for salaries employees for FY 2019-20 on hardik.modi123@yahoo.com
Please send us Income Tax Calculator Excel sheet for FY-19-20
Pl. mail me the Income tax calculation excel sheet for FY 2019-20
Sir, Request you to please mail the Income Tax Calculation for Salaried (in MS-Excel) for FY 2019-20. My email ID is jagdip.shah@topland-india.com
Sir, Request you to please mail the Income Tax Calculation for Salaried (in MS-Excel) for FY 2019-20. My email ID is mind2money@gmail.com
Please email me the income tax calculation Excel sheet (for monthly salary details) along with Form 16 for F.Y. 2019-20.
mail ID: jigishaclient@gmail.com
Dear Sir,
Please be kind enough to mail me excel sheet for income tax recoverable for the FY 2019-20
Please mail me the Income tax calculation excel sheet for FY 2019-20
how to enter 10e relief
PLS MAIL ME THE EXCEL SHEET (FORM NO16) FOR CALCULATING TAX FOR THE YEAR 2019-20
FY 19-20 Employee Salary Working Excel
pls forward the email Id. lkovijay@gmail.com