This RPU is the property of Protean. This has
been made available on Protean 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
Rupee font installation
Remarks
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.
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 are deposited through challan one and of other three
deductees through challan two. User will enter values in respective
cells as shown below:
|
|
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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
TAN of statements cannot be changed.
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.
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 /
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 / 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
Deductee record cannot be deleted.
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.
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.
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.
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. In order to open saved
file on some other computer system, these files (i.e. saved file)
is required to be copied to the computer where the file is to be
opened.
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.
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:
If
statement is being filed through a TIN-FC, then CD/Pen drive
(containing soft copy of .fvu file) should be accompanied by Form
27A (generated through latest FVU) in physical form. Format of same
is available at www.tin-nsdl.com. The control totals on Form 27A
should match with the statement details present in .fvu.
User can directly upload the statement to Protean through
online upload facility.
|
Particulars |
Code |
Whether
PAN mandatory |
|
In case of lower
deduction/no deduction on account of certificate under section
197 |
A |
Yes |
|
In case of no
deduction on account of declaration under section 197A. Allowed
only for section 194, 194A, 194EE and 193 |
B |
Yes |
|
In case of
deduction of tax at higher rate due to non-availability of PAN |
C |
No |
|
In case of
Transporter transaction and valid PAN is provided |
T |
Yes |
|
Transaction where
tax not been deducted as amount paid/credited to the vendor/party
has not exceeded the threshold limit (as per the provisions of
income tax act). Applicable for sections 193,194, 194A, 194B,
194BB, 194C, 194D, 194EE, 194G, 194H, 194I, 194J, 194LA. |
Y |
Yes |
|
For software
acquired under section 194J (Notification 21/2012). Applicable
from FY 2012-13 onwards. |
S |
Yes |
|
In case of no
deduction on account of payment under section 197A (1F). |
Z |
Yes |
Caution
It
may be noted that, 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 Protean, 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. Protean 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 Protean. Hence the latest available version on our
website should be used.