NSDL e-TDS Return Preparation Utility (RPU) for Salary Statements (Form 24Q)

This RPU is the property of NSDL. This has been made available on NSDL TIN website - www.tin-nsdl.com as a free download. The RPU can be best viewed under 1024 by 768 pixels (Minimum) resolution. (Click on desktop go to properties and then settings and adjust screen area/resolution to 1024 by 768 pixels.)

This RPU cannot be used for editing or processing intermediate files saved using older versions of the RPU.

Table of Contents

Purpose
Procedure for using the Return Preparation Utility (RPU)
Instructions for using the Return Preparation Utility (RPU)
Instructions for preparation of Annexure 1 -
Instructions relevant to 4th Quarter
Instructions for preparation of correction statement
Nil Statement
Saving of Intermediate File
Generation of .fvu file
Submission of Statement
Windows Short Cut Keys
Rupee font installation

1.Purpose

This utility can be used for preparation of salary statements, Form 24Q (regular and correction) for all quarters of F.Y. 2007-08 onwards.

2.Procedure for using the Return Preparation Utility (RPU)

• Select type of statement to be prepared, i.e. regular or correction.
• Preparation of Regular statement: Select 'Regular' thereafter click on 'Click to Continue'.

• Preparation of Correction statements: Select 'Correction' thereafter click on 'Import Consolidated TDS/TCS File'. Browse and select consolidated TDS/TCS file (.tds file).
• Thereafter carry out corrections in consolidated TDS/ TCS file.

3.Instructions for using the Return Preparation Utility (RPU)

• Fields marked by asterisks (*) are mandatory.
• Date: Date to be entered in DD/MM/YYYY format (e.g. 31/03/2008). Date can be selected from Year Box provided in respective cells. Double click in that particular cell to select date.
• Insert Rows: To insert rows click on "Insert Row" button. Enter number of rows to be inserted.
• Delete Rows: To delete rows click on "Delete Row" button. In Challan Sheet, only last row can be deleted.
• If drop down list has been provided for any column, then value should be picked from the given list only.
• Amount field should not be Left blank.Enter '0'(zero) if no amount is to be mentioned in any of the amount fields except column 320 (Total amount on which tax deducted) should always be greater than '0'(zero).
• PAN/TAN should be entered in Capital Letters only (e.g. MUMM07081E).

4. Instructions for preparation of Annexure 1

Challan serial no. should be selected from drop-down for all deductees.
Deductee serial no. (column 313) should be given challanwise.

Example
There are two challans and six deductee records wherein tax amount of three deductees is deposited through challan one and of other three deductees through challan two. User will enter values in respective cells as shown below:

                 &nbspCase 1:                                               Case 2:                                              Case 3: 

    (Correct)             (Wrong)                 (Correct)           (Wrong)                 (Correct)            (Wrong)

Challan Serial No	Sr. No. (313)	Challan Serial No	Sr. No. (313)
1	1	1	1
1	2	1	2
1	3	1	3
2	1	2	4
2	2	2	5
2	3	2	6

Challan Serial No	Sr. No. (313)	Challan Serial No	Sr. No. (313)
1	1	1	1
2	1	2	2
3	1	3	3
4	1	4	4
5	1	5	5
6	1	6	6

Challan Serial No	Sr. No. (313)	Challan Serial No	Sr. No. (313)
1	1	1	1
1	2	1	2
2	1	2	1
1	3	1	1
3	1	3	1
4	1	4	1

5. Instructions relevant to 4th Quarter

• Salary detail record (i.e. Annexure II) is mandatory for all statements.

6. Instructions for preparation of correction statement

6.1 Corrections in Deductor Details

6.1.1 Other than TAN

In Form sheet, field 'Update Deductor Details' select 'Other Deductor Details' from drop down menu and update deductor details.

6.1.2 Change in TAN

In Form sheet, field 'Update deductor details' select 'TAN' from drop down menu. Mention new TAN in 'Tax Deduction Account No.' field. If there is a change in TAN no other details in the statement can be updated

6.2 Corrections in Challan Details

6.2.1 Update challan details

If there are changes in challan, go to the 'Challan' sheet. In challan records where change is required, go to Column No. 2 'Update mode for challan', select 'Update' mode and thereafter make necessary changes in that particular challan.

6.2.2 Add a new challan

If a new challan is to be added it should be added after last challan detail record. For example, if there are 5 existing challans the last challan record no. will be 5 and new challan to be added will be challan record no. 6.
Before entering details of new challan go to Column No. 2 'Update mode for challan ' select 'Add' and thereafter enter details of the new challan. Do not insert a row between existing challan details to add a new challan.

6.3 Corrections in Deductee Details

To make changes in deductee details, go to 'Annexure-I' sheet.

6.3.1 Update deductee details

If there are changes in deductee details including update of deductee PAN, go to Column No. 2 'Updation mode for deductee (Add / Delete / Update / PAN Update)', select 'Update' mode and thereafter make necessary changes in that particular deductee record.

6.3.2 Update only PAN of deductee

If only PAN of deductee is to be updated go to Column No. 2 'Updation mode for deductee (Add / Delete / Update / PAN Update)' select 'PAN Update ' mode. In this mode only deductee PAN field can be updated.
Note: A valid PAN and invalid PAN cannot be updated with invalid PAN. If value in PAN Field is 'PANINVALID' 'PANNOTAVBL' or 'PANAPPLIED' it can be updated only with valid PAN.

6.3.3 Delete deductee

If deductee record is to be deleted, go to Column No. 2 'Updation mode for deductee (Add / Delete / Update / Pan Update)', select 'Delete' mode. This record will be marked for deletion and no changes can be made in that deductee.

6.3.4 Add deductee

If a new deductee record is to be added it should be added after last deductee record. For example, if there are 10 deductee records last deductee detail record no. will be 10, new deductee detail record to be added will be deductee record no. 11. Before entering details of new deductee go to Column No. 2 'Updation mode for deductee (Add / Delete / Update / PAN Update)' select 'Add' mode and thereafter 'enter details of the new deductee. Do not insert a row between existing deductee records to add a new deductee.

6.4 Corrections in Salary details

To make changes in Salary Details, go to 'Annexure-II' sheet.

6.4.1 Update only PAN of Salary Details

If only PAN in salary details is to be updated, go to Column No. 2 'Updation Mode', select 'PAN Update' mode. In this mode only the salary PAN Field can be updated.
Note: A valid PAN and invalid PAN cannot be updated with invalid PAN. If value in PAN Field is 'PANINVALID' 'PANNOTAVBL' or 'PANAPPLIED' it can be updated only with valid PAN.

6.4.2 Delete Salary Detail

If salary record is to be deleted, go to Column No. 2 'Updation Mode', select 'Delete' mode. This record will be marked for deletion and no changes can be made in that salary detail.

6.4.3 Add Salary Detail

If a new salary record is to be added it should be added after the last salary record. For example, if there are 10 salary records the last salary detail record no. will be 10, the new salary detail record to be added will be salary record no. 11. Before entering details of the new salary go to Column No. 2 'Updation Mode', select 'Add' mode and thereafter enter details of the new salary. Do not insert a row between existing salary records to add a new salary.

7. Nil Statement

RPU can be used to prepare a return without a challan and/or deductee. If there is no challan i.e. when no tax has been deposited, then challan sheet should be filled as below –

Field Value	Value
Serial No. (Column no. 301)	1
Section Code(Section Relevant to the Nature of Payment)	From DropDown Menu
Amount Fields i.e. TDS,Surcharge,Education Cess,Interest and Others(Column no 302 to 306)	0.00 (Zero)
Cheque / DD number	Blank
Date on which tax deposited (Column no. 311) e.g. for quarter 4	31/03/2008
Transfer voucher / Challan serial No. (Column no. 310)	Blank
Whether TDS Deposited by Book Entry ?(Yes)/(No) (Column no.308)	Blank
Interest `	0.00 (Zero)
Others `	0.00 (Zero)

Nil challans/transfer vouchers need to mandatorily have deductee records with flag  'A', 'B', 'Y', 'S', 'T' & 'Z' (as applicable) in the remarks for lower or non-deduction.

8. Saving of Intermediate File

To save intermediate file, click on "Save" button. It will ask for path and the name by which the file has to be saved. After saving the file, do not change its name and path. Note that hidden files with .ss3 extension are also saved at the same location where the original file is saved. To unhide these file go to "Tools -> View -> Hidden files and folders" and click on "Show hidden files and folder".

• For 1st, 2nd & 3rd Quarter, 2 hidden files are created
• For 4th Quarter, 3 hidden files are created

Example

Original file name	ETDS24Q4
Hidden file name	ETDS24Q41.ss3, ETDS24Q42.ss3, ETDS24Q43.ss3

In order to open saved file on some other computer system, these files (i.e. 1 original file and hidden files) are required to be copied to the computer where the file is to be opened.

9. Generation of .fvu file

FVU is inbuilt in this RPU. After preparation of statement (data is filled in all sheets) click on 'create file' and provide path as below.

1. Challan Input File (Optional)

• Specify the name (with the .csi extension) of the input file (including the path) i.e. the name of the challan file downloaded from Challan Status Inquiry for the verification of challan in TDS/TCS statement
• Length of input filename should not be more than 25 characters (including the .csi extension) and should not contain any special characters eg. : , \ / etc.,.For example Filename can be MUMM11111A040909.csi.

2. Output Files (Mandatory)
Select location with the browse button to save the output files. Following files will be created if

File is correct:

• .fvu file (fvu file should be copied on a CD/floppy)
• .txt file
• FVU -TDS statement statistics report (to be used in preparing Form 27A)
• TDS/TCS-PAN statistics (created if PAN of the deductee is PANNOTAVBL, PANAPPLIED, PANINVALID)
• e-TDS/TCS statement warning file, created if –
  1. Bank branch code not present in the list of authorized bank branches OR
  2. Same PAN in deductor and deductee PAN field OR
  3. Challan details of the statement do not match with the details uploaded by the bank (if .challan detail file is imported)

File is incorrect:

• .txt file
• Error file (both in .txt and html)

10. Submission of statement

If statement is being filed through a TIN-FC, then CD/floppy should be accompanied by 'Statement Statistics Report' generated by the FVU along with Form 27A in physical form. Form 27A should be prepared separately. Format of same is available at www.tin-nsdl.com. The control totals on Form 27A and Statement Statistics Report should match with the statement details.

User can directly upload the statement to NSDL through online upload facility.

11. Windows Short Cut Keys

Function	Keyboard Keys
Copy	Ctrl+C
Paste	Ctrl+V
Cut	Ctrl+X
Save	Alt+S
Open	Alt+O
Create File	Alt+C
Close	Alt+F4

12. Rupee font installation

• Click on start button and then click on control panel. On clicking the control panel a window will appear containing folders.
• Open the folder “Fonts” by double clicking the same.
• Select option “Install New Font” under file menu. On clicking the same pop up will be displayed.
• Browse to the folder where “RPU” folder is saved. On browsing the folder “Rupee Foradian (True Type)” will be displayed under list of fonts.
• Select the font “Rupee Foradian (True Type)” and uncheck the option “Copy fonts to Fonts folder”.
• Click on Ok button.
• In case you are unable to install, kindly contact TIN Call Centre at 020-27218080.

Caution

It may be noted this RPU has been provided with a view to help deductors in preparation of their TDS statements. While all necessary care has been taken by NSDL, deductors are advised to ensure the correctness of their statement in all respects, including but not limited to its conformity with the applicable rules before the submission of same. NSDL does not assume any responsibility in respect of performance or output of the RPU in any manner. It should be noted that RPU and FVU are subject to modifications by NSDL. Hence the latest available version on our website should be used.