TDS/TCS Return Preparation Utility (RPU) version 2.5

NSDL Return Preparation Utility (RPU) version 2.5 for preparing quarterly regular and correction TDS/TCS statement (using only consolidated TDS/TCS file) released June 10, 2011

A. Procedure for preparation of return

Deductors’ Manual for quarterly returns

Dos and Don’ts for Deductors/Collectors

B. Forms

• Form 24Q
• Form 26Q
• Form 27Q
• Form 27EQ
• Form 27A

C. Data Structure

1. For statement pertaining to FY 2010-11 and onwards
   • File Format for Form 24Q (1st, 2nd & 3rd Quarters)
   • File Format for Form 24Q (4th Quarter)
   • File Format for Form 26Q Q1 to Q4
   • File Format for Form 27Q Q1 to Q4
   • File Format for Form 27EQ Q1 to Q4
2. For statement up to FY 2009-10 and onwards
   • File Format for Form 24Q (1st, 2nd & 3rd Quarters) version 4.0
   • File Format for Form 24Q (4th Quarter) version 4.0
   • File Format for Form 26Q version 4.0
   • File Format for Form 27Q version 4.0
   • File Format for Form 27EQ version 4.0

D. Sample files prepared as per the file format

1. For statement pertaining to FY 2010-11 and onwards
   • Sample file for Form 24Q (1st, 2nd & 3rd Quarter)
   • Sample file for Form 24Q (4th Quarter)
   • Sample file for Form 26Q
   • Sample file for Form 27Q
   • Sample file for Form 27EQ
2. For statement upto FY 2009-10
   • Sample file for Form 24Q (1st, 2nd & 3rd Quarter)
   • Sample file for Form 24Q (4th Quarter)
   • Sample file for Form 26Q
   • Sample file for Form 27Q
   • Sample file for Form 27EQ

E. NSDL e-TDS/ TCS Return Preparation Utility

• e-TDS/TCS RPU (ver 2.5) for statement from FY 2005-06 onwards

F. File Validation Utility (FVU)

e-TDS / e-TCS returns prepared for FY 2005-06 and onwards (i.e. Forms 24Q, 26Q, 27Q and 27EQ) can be validated using this utility.

The e-TDS/TCS FVU is a Java based utility. JRE (Java Run-time Environment) [versions: SUN JRE: 1.4.2_02 or 1.4.2_03 or 1.4.2_04 or IBM JRE: 1.4.1.0] should be installed on the computer where the e-TDS/TCS FVU is being installed. Java is freely downloadable from http://java.sun.com and http://www.ibm.com/developerworks/java/jdk or you can ask your vendor providing computer facilities (hardware) to install the same for you.

The e-TDS/TCS FVU setup file (e-TDS/TCS FVU.exe) comprises of three files namely:

1. TDS FVU Readme.rtf: This file contains instructions for setup of the e-TDS FVU.
2. e-TDS FVU Setup.exe: This is a setup program for installation of FVU.
3. TDS_FVU_STANDALONE.jar: This is the FVU program file.

These files are in an executable zip file. These files are required for installing the e-TDS/TCS FVU.

FVU for quarterly e-TDS/TCS statement pertaining to FY 2010-11

• e-TDS/TCS FVU.exe (Version 3.2) New features/Validation

FVU for quarterly e-TDS/TCS statement up to FY 2009-10

• e-TDS/TCS FVU.exe (Version 2.130) New features/Validation

Instructions for extracting the files are given in:

• e-TDS FVU Extract

Source : NSDL