Shop from Amazon.in, Stay safe from this pendemic situation.

Sunday, May 24

Auto Income Tax Calculator with Salary Statement for F.Y. – 2020-21 (A.Y.-2021-22) in Excel

2 in 1 Auto Income Tax Calculator with Salary Statement
Govt. has introduced a New tax regime from F.Y.-2020-21 with a lower tax rate without any exemption/deduction. Also left an option for assesses to choose any one suitable regime. between Old(existing) and New income-tax regime. A circular issued by the CBDT that salaried employees to choose at the time employers are deducting TDS. OR at the time for filing of ITR.
For your help an Auto tax Calculator for F.Y. -2020-21 is already available for download at this website www.taxationseva.com. Which will help you to calculate and compare according to both regimes in very simple way with less time and fewer efforts and suggest you that which tax regime would be better option for financial year 2020-21 and plan accordingly. In continuation of my Auto tax Calculator version 15.0 for F.Y.-2020-21. another tool of Auto Income tax calculator 2 in 1 Income Tax Calculator with Salary statement. In auto Tax calculator You had to input data directly in Calculator on annual basis. But in this 2 in 1 calculator you can calculate on actual received & accrual basis also you can prepare the salary statement. You will be able to customise the salary statement according to your salary structure. You can select allowances etc from drop down.
Now It is up to you on the basis of your suitability & requirement. You can work on anyone calculator. 

I hope you will like and share this creation. If you find any inconsistency please write. I will try to amend/rectify.

Download 2 in 1 Auto Income Tax calculator with Salary Statement for F.Y.-2020-21(A.Y.2020-21) 


Monday, May 4

Latest Income Tax Calculator with Form-16 and salary Statement (3in 1) for A.Y-2020-21 in Excel format.


In the view of currently corona virus pandemic government has extended the due dates of various returns including TDS return up to 31 June 2020 So the date to issue Form-16 by the employer has also defer.      
Due to amendment made by Income tax department in format of Form-16 vide notification_36_2019 dated 12/05/2019. Every employer has to issue Form-16 Part B to his employee in new format. The depart has made many changes to give more information & input regarding income and deduction etc.
Keeping in this view I have prepare 3 in 1 Form-16 (New format) generator with Auto tax calculator and Salary statement in excel format to make form-16 easy.
In a less time and effort you can generate and print the 
  • Form-16 with annexure 1 of form-16 and form 12B
  • Salary statement
  • Computation sheet.

It is up to you whether use this tool to generate Form-16 or salary statement with computation sheet of calculated income tax.  
You can also clear the latest applicable rules and information with hyperlinked ready reckoner.
Download Form-16 Generator in 2 types. 1st is Blank for your use and 2nd is pre-filled for your reference

Download Auto Income Tax Calculator with Form-16 and salary Statement (3in 1) for A.Y-2020-21 
from  Calculator & Forms Page (Click here)

Wednesday, April 29

Download New Auto Income Tax Calculator for F.Y. – 2020-21 (A.Y.-2021-22) in Excel

A circular issued by the CBDT that salaried employees can chose between the Old and New income-tax regime at the time employers are deducting TDS. OR at the time for filing of ITR.

These regimes proposals have left many Question Mark? among the taxpayers. 
Which is suitable regime? 
Whether new regime or Old (existing) regime?
Should I continue with deductions of existing savings, Investments & expenses according to existing regime or not? etc                                                                                
Now It is very difficult to taxpayers to choose suitable regime without calculate the actual  tax according to both regimes provisions                                                                                       
Do not panic- this Auto Income tax calculator tool from Taxationseva will help you to calculate and compare according to both regimes in very simple way with less time and fewer efforts and suggest you that which tax regime would be better option for financial year 2020-21 and plan accordingly.
Significant features of Auto Income Tax calculator for F.Y.-2020-21
  v   A simple easy to use tax Calculator for resident individual, especially for salaried persons to calculate income tax in both regimes.
  v  Once enter the amount in blank cells other cells calculate data & tax automatically
  v  Tax calculation with both regimes simultaneously on same sheet based on your income.
  v  Calculation for difference of tax benefit between regimes.
  v  Suggestion to choose suitable regime.
  v  Calculation of - Income Tax, Income from house property, Exemption/Deduction of Allowances and relief of 87A, 80EE/80EEA, 80EEB etc.
  v  Calculation of taxable Income at normal rate, Net tax, rebates, Cess, Surcharge, Marginal relief (where applicable) and balance tax payable/refundable.
  v  Know every latest information and applicable rule of tax rates, deduction and exemption with a hipper linked ready reckoner.

2 types of calculator are available for download. 1st is Filled for your reference and 2nd is Blank for your use.
I hope you will like and share this creation. If you find any inconsistency please write. I will try to amend/rectify.
Download Auto Income Tax calculator 15.0 for F.Y. 2020-21

Friday, May 10

Download New Auto Income Tax Calculator for FY 2019-20 version 14.1 in Excel

Financial year 2019-20 has over and Tax calculation for filing of ITR  has begun.
Auto tax calculator version 14.1 for FY 2019-20 is available to help you calculation according to provision of Finance bill 2019. 
Tax rates are not changed and remain same as last FY.
There are only 2 major changes which will impact the tax liability of a person.
1.      Standard deduction to all salaried people ( including Pensioners) has risen to Rs. 50,000/- from Rs 40,000/-
2.      A rebate u/s 87A up to 12500/-has risen to tax payers, who have their total taxable Income (after Exemption and all Deduction) up to Rs. 5,00,000/-. 
If total Income Increases even by Rs 10/- One will not get the rebate and will be taxed on total Income.
Please give me your feedback about the contents you would like to add or delete. 

Download New Auto Tax Calculator for FY 2019-20

Download Latest Form-16 Generator with Auto tax Calculator and Salary Statement - 3 in 1 in Excel.


Due to latest amendment made by Income Tax department in format of Form-16.  w.e.f 12/05/2019 vide notification_36_2019 dated 12/04/2019.
Now from AY 2019-20 every employer has to give form-16 part B to his employee in a new format. The department has made many new changes to give some more information & input regarding income and deduction etc.

Keeping in view I have made a 3 in 1 - Form-16 Generator, Auto Tax Calculator and Salary statement available to you in excel format.
Now with a less time, you can easily generate and print the
  1. ·         Salary statement,
  2. ·          Computation sheet,
  3. ·          Form-16 with Annexure to form -16, form 12BA,
  4. ·         Calculation of Income from house property with 80EE rebate,
  5. ·          Exempted allowances and Income from other sources.

Also you will be able to know the applicable rule (also hipper link) in Information & Rules for exemption and deduction section.


Download Form-16 Generator (New Format) with Auto tax Calculator and Salary Statement in Excel
from Calculator and form page

Form-16 Generator without Annexure & Salary Statement

If you want to Generate only Form-16 Part B without salary statement and its Annexure A & Form 12BA. You can use only Form-16 Generator with Auto Tax calculator. You have to fill the amount and select the heads in Tax calculator only.and print the


  1. Form-16 only.
  2. Computation sheet.
  3. Detail of  calculation of House Property & Exempted Allowances.  

 Download Form-16 Generator(without Annexures) in excel                                                  from Calculator and Form Page     (click here)                     

Form-16 new format from FY-2018-19


The CBDT has notified a new format for form-16 vide notification_36_2019 dated 12/04/2019..
The Income Tax department has made  many new changes in format of  Form-16 - the salary TDS certificate.requiring a detailed break-up of salary,tax exempted allowances paid to the employee and also all break-up of deduction claimed by employee.  
Also concurrent changes have been made in the format of TDS return (24Q) filed by employer with the tax department and form-16. Which will allow the taxman to cross check the employee's ITR, Form-16 and employer TDS return.
Now from AY 2019-20 w.e.f 12/05/2019 every employer has to give form-16 part B to his employee in a new format. 

Saturday, April 7

Auto Income Tax Calculator for FY 2018-19 (AY 2019-20)


Auto Income Tax Calculator for Financial Year- 2018-19 / Assessment Year 2019-20 in Excel Format after considering the amendment in Tax Rates, Deductions and Rebates vide Finance act 2018-19.
Thanks a lot to motivate me to do something new & subscribe my original version calculator earlier.

Financial Year 2018-19 has started and all have to calculate that how much tax is payable in financial year 2018-19. This tool of Auto Income Tax Calculator for FY 2018-19 from Taxationseva will help you to calculate the income tax in very simple way with less time and fewer efforts. After calculate your tax liability you will be able to plan your tax saving accordingly.
There are no major changes in income tax for financial year 2018-19. Tax rates for Individual assesses are same as previous financial year 2017-18.


  •     The government has allowed a standard deduction of Rs. 40,000/- to all salaried tax payers but transport allowance of Rs. 19200/- and reimbursement of medical allowances Rs.15,000/- has been abolished.
  • ·   Education Cess has been replaced with Health & Education Cess and rate has been increased from 3% to 4%.
  • ·   Senior Citizens taxpayers are allowed  to avail
  1.      Deduction up to Rs 50,000/- per annum for medical insurance u/s 80D.
  2.      Deduction of interest income for Rs. 50,000 on deposits with banks and post offices. (The exemption has been increased from Rs. 10,000 to Rs. 50,000 with a new section of 80TTB).
  3.   3. Deduction u/s 80 DDB up to Rs.1 lakh (Limit u/s 80DDB, has been raised to Rs 1Lakh for amount paid for medical treatment of specified diseases).
Auto Income tax calculator is very simple and user friendly, also know all current applicable rules.  You can use calculator hyperlinks to clear and understand all related rules, Information with aspects. This version 13.0 of Auto Tax Calculator is designed for salaried people with a standard deduction of Rupees 40,000/- also calculating the surcharge and marginal relief for income over and above of Rs 50 lakh & 1 Crore.

Download Auto Income Tax Calculator for FY 2018-19 from Calculator & Form section

Saturday, February 4

Auto Income Tax Calculator Version 12 for FY 2017-18

 After budget 2017, there are many doubts in respect of Key changes in individual taxation which affects the individual tax liability. In news & social media they are writing that there is no tax on annual income of ₹3Lakh. People are taking that tax slab has change from ₹3L to 5l etc.
Actually there are only three new major changes for an individual in this Budget and new slabs are as follows.

1. Tax slab remain same but rate for tax slab of 2,50,000 to 5,00,000 has reduced from 10% to 5% and rest rates are same.
    Now new slabs are     
       For Individual Male/Female with age <60 Yrs         
                                           Up to ₹2,50,000 -   Nil
                               ₹ 2,50,000 to 5,00,000 -    5%
                              ₹ 5,00,000 to 10,00,000 -  20%
                                   ₹10,00,000 & above -   30%
    For senior. Citizen of above 60 Yrs & less than 80 Yrs
                                         ₹ Up to 3,00,000 -    Nil
                                  ₹3,00,000 to 5,00,00 -    5%
                                ₹5,00,000 to 10,00,000 - 20%
                                    ₹10,00,000 & above -   30%
2.  Rebate under section-87A - has been reduced from ₹ 5,000 to 2,500 and eligibility for rebate of Sec 87A has reduced for individual of total income of ₹3,50,000,( instead of ₹ 5,00,000)

3.  Surcharge @ 10% will be charge from income above ₹50 Lakh, up to ₹1 cr  & @ 15% for income above ₹1 Cr. 

You all have to how much tax is payable in financial year 2017-18. This tool of Auto Tax Calculator from Taxationseva will help you to calculate the income tax in very simple way with less time and fewer efforts. After calculate your tax liability you will be able to plan your tax saving accordingly.
As a ready reconer related informations are also hyper linked in simple calculator. So calculate your tax, TDS , Exemptions, Deductions etc and know the related rules.

Monday, April 18

Auto Income Tax Calculator 2016-17 version 11.0

Download  Auto Tax Calculator Version 11.0 for Financial Year 2016 – 17 and Assessment Year 2017-18.
Financial year 2016-17 has posed start and all have to know that how much tax is payable in this Financial Year. This Auto Tax calculator from Taxationseva will help you to calculate the Income tax, TDS in very simple way with less time & fewer efforts. After that you will be able to planning accordingly.  .  
A clubbed type of calculator "Software Calculator and Simple Excel Calculator" in same work book.                                            
Now you can use anyone or both as per your suitability. Simple calculator is hyperlinked with information and Rules to clear and understand all related aspects.
Download Auto Tax Calculator

From :- CALCULATOR AND FORMS page

Thursday, December 3

Tax calculator for Financial year 2015-16

Download Auto Tax Calculator with ready reckoner for Financial Yr 2015 -16 Assessment Year 2016 -17  
Dual type calculator "Software Calculator and Simple Excel Calculator" in same work book.
Now you can use anyone or both as per your suitability.                                                 Simple calculator is hyperlinked with information and Rules to clear and understand all related aspects.
Tax liability calculation for Financial year 2015-16 has started and everyone has to know that how much taxis payable & how much they can save. This calculator will help you with very simple way & less time.
You will be able to calculate tax & print calculation sheet. 

Download from " CALCULATOR AND FORM" page