- Govindaraj K
- | Income Tax - Downloads
- 02 Mar 2020
- 846,762 Views
- 207 comments

**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)**

Tags: Income Tax Calculator

Kindly Refer to Privacy Policy & Complete Terms of Use and Disclaimer.

- Threshold Limit for Compliances Under Companies Act 2013
- SEBI clarifies on Trading limitation for research analyst & HOD of research entity
- Income Tax Department conducts search & seizure in Haryana
- SEBI: Empowering Investors through Investor Charters
- Capital Employed’ refers to Paid up capital of entity: IRDAI
- Budget 2022 – Increase Standard Deduction for Salaried Class
- Bogus ITC passing of Rs 47.99 Crore: HC grants bail to accused
- Bogus purchase additions confirmed by CIT(A) & ITAT: HC upheld Section 276C prosecution
- Motor Accident Claim – Fixing of 15K as Notional yearly Income for Non-Earning Member is Unreasonable: HC
- Section 194D TDS not deductible If Sum Paid Directly to Services Providers

- Join Self-Learning Courses on GST, Customs, Excel & Income Tax
- Delhi govt closes Private offices except those in Exempted Category
- Bank Branch Auditors’ Draft Panel of CAs/firms for 2021-22
- Income Tax Audit Due & ITR Due date for AY 2021-22 extended
- High Court directs CBDT to formulate a scheme to train its officers; Passes strictures against AO, JCIT & PCIT

- 56 Union Budget 2021-22 Provisions implemented by Government
- ICAI expresses concerns on returning of Approach Paper for revision of existing AS by NFRA
- Changes in CGST Act effective w.e.f 1st January 2022
- ITAT upheld addition of unexplained Rs. 12.81 crore deposited in Bank
- ITAT explains Basic modus of providing bogus LTCG- Upheld addition

Pl.send me income tax calculator sheet in Excel form for financial year 2020_ 2021 .I am a retired senior citizen .

Please mail me the Income-tax calculation excel sheet for FY 2019-20

Please mail me the Income tax calculation excel sheet for FY 2020-2021 SIR

Sir file is asking for password to unprotect sheet and enter the values. Please send the password or unprotected excel sheet at [email protected]

Please mail me the Income tax calculation excel sheet for FY 2019-20

Pls send me the excel sheet for income tax return calculator for fy 19-20

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

[email protected]

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 [email protected]

HI

Can anyone send me the details for calculation Capital gain against sale of property long term occupies & sold

IT calculator please …[email protected]

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 [email protected]

Sir

Please provide me the income tax calculation sheet as well as form 16 in excel format.

At [email protected]

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 [email protected]

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 : [email protected]

Please mail me Income Tax calculator excel sheet for salaries employees for FY 2019-20 on [email protected]

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 [email protected]

Sir, Request you to please mail the Income Tax Calculation for Salaried (in MS-Excel) for FY 2019-20. My email ID is [email protected]

Please email me the income tax calculation Excel sheet (for monthly salary details) along with Form 16 for F.Y. 2019-20.

mail ID: [email protected]

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. [email protected]

Plz send monthly tax culculator 2019-20 with form 16

Sir,

FY 19-20 Employee Salary Working Excel Required,

pls forward the nail Id. [email protected]

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 [email protected]

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 [email protected]

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. [email protected]

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.

[email protected]

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

[email protected]

sir please send me income tax calculator in excel sheet for FY 2019-20 as i am a government servant.

my email address is

[email protected]

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

[email protected]

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 [email protected]

Pl. mail me the Income tax calculation excel sheet for 2019-20

pls share the Income tax calculation excel sheet for FY 2019-20 @ [email protected]

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 [email protected]

Dear Sir ,

Kindly share the excel file to [email protected]

Sir, please mail me Income Tax calcultaion sheet for FY 2019-20 for office use

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 [email protected]

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 [email protected]

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.

[email protected]

Please send excel version of tax computation for FY 19-20 salaried person by email:

[email protected]

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 [email protected]. Thanks.

Please send excel version of tax computation for 19-20 salaried person to [email protected]

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 [email protected]

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 [email protected]

pls. send the income tax calculator on for a.y. 20-21 on mail id [email protected]

pls. send the income tax calculator on fy 2019-20 to [email protected]

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 [email protected]

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 [email protected]

Regards

Kindly send me the Income tax calculator on [email protected]. 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.

[email protected]

Regards

KINDLY SEND ME EXCEL SHEET FOR TDS CALCULATION

Please send me the income tax calculator for salaried person.my email id [email protected]

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.