NSDL e-TDS/TCS Return Preparation Utility (RPU)

By | February 21, 2013

Return Preparation Utility (RPU)

Return Preparation UtilitySince FY 2003-04, all corporate deductors should file Income tax returns for deduction of tax at source (TDS) only in electronic form. Further, from FY 2004-05, in addition to corporate deductors, filing of TDS returns in electronic form is mandatory for government deductors also.

Extending the scheme of filing of returns in electronic form to tax collected at source (TCS), the ITD mandated that with effect from FY 2004-05, all TCS returns filed by corporate and government collectors should be only in electronic form.

ITD has notified revised file formats for preparation of TDS and TCS returns in electronic form. Deductors/collectors can prepare the e-TDS/TCS returns as per these file formats using in-house software or any other third party software and submit the same to any of the TIN-FCs established by NSDL. Deductors/collectors can also directly upload the e-TDS/TCS returns through NSDL-TIN website.

NSDL has developed software called e-TDS/TCS Return Preparation Utility (RPU) to facilitate preparation of e-TDS/ TCS returns. This is a freely downloadable MS excel based utility. Separate utilities are available for preparation of each type of return.

RPU for Annual Returns: These utilities can be used to prepare e-TDS/TCS returns upto FY 2004-05. These utilities can be used for preparation of original or revised annual returns.

RPU for Annual Returns

These utilities can be used to prepare e-TDS/TCS returns upto FY 2004-05. These utilities can be used for preparation of original or revised annual returns.

RPU for Quarterly Returns

From FY 2005-06 onwards, TDS/TCS returns have to be filed every quarter (i.e. quarterly statements). The following utilities can be used to prepare regular quarterly statements:

Correction Statements

Corrections required in the regular quarterly statements can be furnished by submitting a correction statement in the prescribed format. The following utilities can be used to prepare correction quarterly statements:

Key features of NSDL Return Preparation Utility (RPU) version 3.2

Feature to highlight overbooked challans*: In case the challan is overbooked challan, then the update is allowed only for fields as below:

    • Section code(column no.3)
    • Interest amount (column no. 19 – As per NSDL RPU)
    • Others amount (column no. 20 – As per NSDL RPU)

*Overbooked challan: Challan, where the summation of the underlying deductee deposit amount is more than the challan deposit amount.

Feedback Form

Guidelines for usage of these RPUs are provided in the respective utilities. The users are advised to read these guidelines carefully before the utility is used to prepare the returns. Users may ensure that they download the latest version of the utility at the time of preparation of return.

Users must pass the e-TDS/ TCS return file generated using RPU through the File Validation Utility (FVU) to ensure format level accuracy of the file. This utility is also freely downloadable from NSDL TIN website. In case the e-TDS/TCS return contains any errors, user should rectify the same in the excel utility itself. After rectifying the errors, user should pass the rectified e-TDS/ TCS return through the FVU. This process should be continued till an error free e-TDS/ TCS return is generated.


These utilities have been developed by NSDL for small deductors/collectors and returns exceeding 20,000 deductee records should not be prepared using this utility. NSDL does not warrant any accuracy of the output file generated using any of these utilities. All users are advised to use latest FVU and check the format level correctness of the file before submitting the same to TIN-FC. In case FVU reports any error in the file, then the users are advised to rectify the same. Further, deductors/collectors are advised to ensure that the e-TDS/TCS returns are filed before the last date specified by Income Tax Department. Non-functioning or non availability of this utility may not be considered as a reason for inability to file the return before the last date.

Leave a Reply

Your email address will not be published. Required fields are marked *