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.
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)
3.Instructions for
using the Return Preparation Utility (RPU)
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:
 Case 1:
Case 2:
Case 3:
(Correct) (Wrong)
(Correct) (Wrong)
(Correct) (Wrong)
|
|
|
5. Instructions relevant to 4th Quarter
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
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)
2. Output Files (Mandatory)
>Select location with the browse button to save the output files. Following
files will be created if
File is correct:
File is incorrect:
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
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
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