Excel for Chartered Accountants
This excel based auto Challan ITNS 281 should be used for deposit of Tax Deducted at Source (TDS) on any heads of income or for deposit of Tax Collected at Source (TCS) by both companies (company deductees) or by others deductees (non company deductee)
(a) TDS /TCS payable by Taxpayer
(b) TDS/TCS Regular Assessment Demand
A separate challan should be used for each type of payment by ticking the appropriate box in the challan.
Apart from the above the relevant code for the nature of payment is also required to be correctly filled.
You are required to fill the TAN, Assessment Year, Amount, Cheques details (other than cash) etc.
After the challan is paid to the bank, make sure that the counterfoil contains seven digit BSR Code of the bank branch, date of deposit and five digit challan serial number.
ABCAUS excel based auto TDS/ TCS Challan ITNS 281 is very simple and user friendly. The user is required to fill the data in a pop up form and challan form in excel is updated automatically.
The ABCAUS challan have an inbuilt database facility to add assessee records and save them so that users don't have to feed repetitive information for the second time for generating a second challan for the same assessee. Also while creating the database there is an inbuilt TAN Structure check to alert for a wrong TAN structure being saved in database.
List of various codes have also been made available in a popup box.
Users are not required to give blank spaces while filling the pop up Challan form. Dropdown list for various options and check boxes have been provided to save the time of the user.
Macro should be enabled to use this form. Users are advised to read help file first.
ABCAUS Excel Auto Income Tax Challan ITNS-281 Download
Download Help File