ABCAUS Excel for Chartered Accountants

Excel for Chartered Accountants

ABCAUS - Excel for Chartered Accountants
Abcaus menu Bar

Excel Auto Income Tax Interest Calculator - Section 234A 234B 234C

Section 234A, 234B and 234C delas with interest for delay in ITR Filing or Short/Non deposit of Advance tax. Interest is payable under section 234A for delay in furnishing of income tax return in time. Interest is also payable under section 234A and 234B for deferring or non payment of advance tax as required under section 208 of the Income Tax Act, 1961.

Due date for filing of Income Tax Return for assessee other than companies and non-audit case is 31st July and 30th September for companies or audit case. If the Income Tax Return is not furnished within the due date as above simple interest under section 234A is payable @ 1% p.m.


Advance tax is payable if the gross tax liability for a year is equal to or more than Rs. 10000/- .


If the assessee who is liable to pay advance tax has failed to pay or the advance tax paid is less than 90% of the tax payable then simple interest is payable under section 234B @ 1% p.m.


Advance tax is required to be paid in quarterly installments,. Three for non companies and four installments for companies.

If the advance tax installments are not paid as required simple interest is payable under section 234C @ 1% .

With this excel based income tax interest calculator interest payable under all the three sections can be calculated for companies or non companies for Assessment Year 2014-15, 2013-14 and Assessment Year 2012-13.

Apart from the quick and automatic calculation of interest under all the three sections, text of the relevant provisions have been given for quick reference under help section which opens in a popup box.

Users have to only fill the amount of income tax liability and the dates and amount of tax already deposited or tax deducted at source (TDS) and it immediately calculates accurate amount of interest payable under section 234A, 234B and 234C of Income Tax Act, 1961.


It is very simple and user friendly with inbuilt help section and text of the relevant sections have been provided in a pop up box for ready reference.

ABCAUS Excel Auto Interest Calculator 234ABC AY 2014-15

Download Help File

ABCAUS Excel Auto Interest Calculator 234ABC AY 13-14, 12-13

ABCAUS Excel 234ABC Interest Calculator
Donít Forget to like and share ABCAUS Face Book Page