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

TDS/TCS statements are furnished on quarterly basis, Now, quarterly statements pertaining to Financial Year 2007-08 onwards are accepted as per the guidelines of Income Tax Department.

ITD has notified revised file formats for preparation of TDS (i.e. Tax Deducted at source) and TCS (i.e. Tax collected at source) statements . Deductors/collectors are required to prepare e-TDS/TCS statements as per these file formats using, NSDL e-Gov. Return Preparation Utility or in-house software or any other third party software and submit the same to any of the TIN-FCs established by NSDL e-Gov.

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

RPU for Quarterly Returns

From Financial Year 2005-06 onwards, TDS/TCS statements have to be filed on quarterly basis; however, as advised by Income Tax Department, acceptance of TDS/TCS statements prior to the FY 2007-08 has been discontinued at TIN. The following utility can be used to prepare quarterly regular as well as correction statements:

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 e-Gov 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 e-Gov for small deductors/collectors and returns exceeding 20,000 deductee records should not be prepared using this utility. NSDL e-Gov 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.