Download Advance Tax Calculator in MS Excel

Under Income tax act, advance tax is the mechanism by which Central Government collects taxes payable in the assessment year in previous year itself.

Under Income tax act, advance tax is required to be paid by all the assessees, if there is a tax liability in their hands, except -

• Advance tax is not required to be paid if total income tax estimated for the year is less than Rs 10,000/-

• Senior Citizens are required to pay advance tax only if their total income includes income under the head ‘Profit and Gain from Business or Profession’

So, senior citizens are not required to pay advance tax even though their tax liability is Rs 10,000 or more.

They are required to pay advance tax only if they are having income from business or profession, and tax liability is Rs 10,000/- or more.

Advance tax by the Corporate and non-corporate assessee is payable in four instalments, except assessee opting for section 44AD or 44ADA.

Advance tax computation -

Note: Under Income tax act, for computing advance tax, TDS and TCS can be deducted only if they are actually deducted or collected. They cannot be deducted on an estimated basis.

Net tax payable for the whole year is not to be paid at one shot, it must be paid in four instalments.

Instalments for payment of Advance Tax -

For corporate and non-corporate assessee, except those opting for section 44AD and 44ADA -

Estimated Net Tax Payable must be reassessed in every quarter, and TDS and TCS should be deducted if they are actually deducted or collected.

Tax paid after 15th March but before 31st March is also treated as advance tax under Income Tax Act.

If advance tax is not paid as per provisions, then interest will have to be paid under section 234B and 234C. So, it very pertinent to pay advance tax on time.

Download Advance tax calculator for Individuals/HUF FY 2018-19 (AY 2019-20)

Unlike prior years, individual too are now required to pay advance tax in four installments, except assessee opting for section 44AD and 44ADA. Assessee opting for 44AD and 44ADA are required to pay only last installment.

Download Advance tax calculator for FIRMS FY 2018-19 (AY 2019-20)

Unlike prior years, Firms too are now required to pay advance tax in four installments, except assessee opting for section 44AD and 44ADA. Assessee opting for 44AD and 44ADA are required to pay only last installment. Firm include LLP, and LLP cannot opt for section 44AD and 44ADA.

Download Advance tax calculator for Company FY 2018-19 (AY 2019-20)

For Companies there is no change in advance tax liability, Companies have to pay advance tax in four installments.

Download Advance Tax calculator in excel

How to use income tax advance tax calculator?

Download the above attached, advance tax calculator excel file.

After downloading, open the advance tax calculator file in excel.

You need to fill the tax liability in Expected Tax cell. You can calculate your tax liability using tax calculator for individuals.

Once you have filled expected tax liability, advance tax calculator will show you advance tax liability for each quarter.

You can fill details of already paid taxes in Already Paid column.

Calculator will calculate and show exact advance tax liability for each due date.