Excel Auto 234ABC Interest Calculator for AY 2024-25 download

Excel Auto 234ABC Interest Calculator for AY 2024-25 with accurate calculation as per revised provisions. Download for Corporate and Non-corporate Assessees

Section 234A, 234B and 234C of the Income tax Act, 1961 deals 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

Excel 234ABC Interest Calculator AY 2024-25

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.

CBDT has vide its circular no. 02/2015 dated 10-02-2015 has clarified that no interest under section 234A of the Act is chargeable on the amount of self-assessment tax paid by the assessee before the due date of filing of return of income.

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 2018-19

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.

Video Tutorial

Important  Notes:

1. Green field are for data Input. Select from drop down or fill the amount as the case may be.
2. Please note that format of the date cells should be set to English (United Kingdom) and Date as dd/mm/yyyy. You can change the format from Control Panel > Regional Settings
3. In case of senior citizen, select yes from the drop down option
4. In all the cells for Income Tax deposit for 15^th June, 15th Sep, 15^th Dec and 15^th Mar, cumulative amount of tax paid should be filled.
   For example
   Tax paid between 1^st April to 15^th June is 5000/-
   Tax paid between 1^st July to 15^th Sep is 2000/-
   Tax paid between 1^st Oct to 15^th Dec is 4000/-
   Tax paid between 1^st Jan to 15^th Mar is 6000/-
   Fill the amount as under:

Interest shall be calculated up to the date specified. Use Fill current date button for current date.

Download Excel 234ABC Interest Calculator Click here >>

• GST e-invoice-1 and e-invoice-2 Portals to be launched from 18.07.2024
• The Companies (Significant Beneficial Owners) Amendment Rules, 2024
• Clarification on GST rates & classification of goods as per GST Council 53rd meeting 
• Clarifications on applicability of GST on certain services as per 53rd GST Council meeting
• Merely increasing/ reducing agriculture expenses/ income not result in taxable income