Excel Automatic Income Tax TDS Challan ITNS-281 with database facility for AY 2019-20 Latest version 11.00

Excel Income Tax TDS Challan ITNS-281 with database facility 

Excel Income tax TDS Challan ITNS-281

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)

This challan should not be used for deposit of self assessment tax for which a separate excel ITNS 280 Utility has been provided.

Type of payments  covered by ITNS 281 Challan are as under:

(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.

See ABCAUS ITNS-281 Video Tutorial:

ABCAUS Excel Income Tax TDS Challan ITNS-281 Version 11.00 have an inbuilt database facility to add multiple assessee’s records and save them so that users don’t have to feed repetitive information for the next time for generating a subsequent 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. Howver extreme care should be taken to ensure that the TAN should not only be structurally valid but should be an existing one that actually belongs to the assessee concerned.

On the request of the users, an option to unprotect database sheet to fill the information directly in the cells have been provided in this version. However users should exercise extreme caution that only correct PAN is filled.

List of various codes have also been made available in a popup box. Also the challan has been updated to provide for option to specify payment of late fee under section 234E.

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. In case users are not aware of how to enable macros, they can download a help file

Excel Income Tax TDS Challan ITNS-281

Download ABCAUS Excel Challan ITNS-281

----------- Similar Posts: -----------


  1. Nitin Modi April 21, 2016
  2. SATHIA NARAYANAN July 6, 2016
  3. ashok verma November 23, 2016
  4. HARISH ALDAK April 19, 2017
    • administrator April 19, 2017
  5. yatin dattani May 12, 2017
  6. vivek April 11, 2018
  7. Balasundaram Athreya May 1, 2018
    • administrator May 1, 2018
  8. SRINIVAS August 16, 2018
    • administrator August 16, 2018

Leave a Reply