Excel Automatic Income Tax TDS Challan ITNS-281 with database facility AY 2020-21 Latest version 13.00

Excel Income Tax TDS Challan ITNS-281 with database facility 

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.

excel tds challan itns 281

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 13.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: -----------

16 Comments

  1. K S Anand Reddy April 29, 2019
    • administrator April 29, 2019
  2. Guruprasad Rao April 26, 2019
    • administrator April 26, 2019
  3. SRINIVAS August 16, 2018
    • administrator August 16, 2018
  4. Balasundaram Athreya May 1, 2018
    • administrator May 1, 2018
  5. vivek April 11, 2018
  6. yatin dattani May 12, 2017
  7. HARISH ALDAK April 19, 2017
    • administrator April 19, 2017
  8. ashok verma November 23, 2016
  9. SATHIA NARAYANAN July 6, 2016
  10. Nitin Modi April 21, 2016

Leave a Reply

Subscribe to ABCAUS Newsletter

Get reliable, authentic and latest updates on taxation/corporate and other laws in your mail box free.



After subscribing, please check your email (including spam or junk folder) and activate the subscription link by clicking it.