Get documents about "Salary - TDS Software eTDS Software from Fast Facts
Document Sample
Tax Deduction Account Number
Permanent Account Number
Name of the Company
Branch/ Divison
Flat / Door / Block No
Name of Premises / Building
Road / Street / Lane
Area / Locality
Town / District / City
PIN Code
STD Code
Telephone No.
Email
Name of the Responsible Person
Flat / Door / Block No
Name of Premises / Building
Road / Street / Lane
Area / Locality
Town / District / City
PIN Code
STD Code
Telephone No.
Email
Designation
Remarks
TDS Circle
Employee Serial Serial Number in Employee Mode PAN Reference PAN of the Name of the Date of Amount Taxable Amount Book Entry TDS Surcharge Education Cess Total Tax Total Tax Date of Date of Deposit Reason for Non-
No Challan as per Reference Number Employee Employee payment / credit on which Tax (319) (320) (321) Deducted Deposited Deduction (dd/mm/yyyy) deduction /
(313) (301) provided by (315) (316) (317) Deducted (319+320+321) (323) (dd/mm/yyyy) (325) Lower
Employer (318) (322) (324) Deduction, if
(314)
any. (326)
Salary Details Permannent PAN Ref No. Name of the Category of Date from
Record No Account Employee Employee Which
(Serial Number [329] [330] Employeed
Number of (PAN) of the with the
Employee) Employee current
(327) [328] employer
(dd/mm/yyyy)
[331]
Date upto Total amount Entertainment P Tax Income Income
Which of Allowance 16(iii) chargeble (including loss
Employeed salary (See 16(ii) [333] under the from house
with the note 4 [333] head Salaries ( property)
current appearing at Column 332- under any
employer the end 333) head other
(dd/mm/yyyy) of the main [334] than income
[331] Form) under the
[332] head
"salaries"
offered for
TDS [section
192 (2B)]
[335]
Gross Total Aggregate Amount Gross Total of Total Taxable Income Tax on
Income amount of Deductible 'Amount Income Total Income
(Total of deductions under any deductible (Column 336 - [341]
Column 334 under other under 339)
+ 335) sections 80C, provision(s) of provisions of [340]
[336] 80CCC and Chapter VI A chapter VI-A'
80CCD (Total [338] under
to be limited associated '
to amount Salary Details -
specified in Chapter VIA
section Detail '
80CCE) [339]
[337]
Surcharge Education Income Tax Net Income Total amount Shortfall in tax
[342] Cess Relief u/s 89 Tax payable of tax deduction
[343] when salary (341+342+343+ deducted at (+)/Excess tax
etc is paid in 344) source for the deduction(-)
arrear or [345] whole year [345-346)
advance [346] [347]
[344]
Running Section-Code TDS Surcharge (303) Education Cess
Serial No. (302) (304)
(301)
Interest Others Total Tax Cheque No / DD BSR Code
(305) (306) Deposited No. (309)
(302+303+304+3 (308)
05+306)
(307)
Date on Which Tax Transfer Voucher/ Whether TDS Interest Allocated Other Amt
Deposited Challan Serial No. Deposited by Book Allocated
(dd/mm/yyyy) (311) Entry
(310) (312)
NIL Challan Remarks
Indicator
Instructions for Salary Sheet
Column Name Column Description M/ O Format
Salary Details Record No (Serial
Number of Employee)
A (327) M INTEGER
Permannent Account Number
(PAN) of the Employee
[328]
B M CHAR
PAN Ref No.
C O CHAR
Name of the Employee
D [329] M CHAR
Category of Employee
E [330] M CHAR
Date from Which Employeed with
the current employer (dd/mm/yyyy)
[331]
F M DATE
Date upto Which Employeed with
the current employer (dd/mm/yyyy)
[331]
G M DATE
Total amount of
salary (See note 4
appearing at the end
of the main Form) [332]
H M INTEGER
Entertainment Allowance 16(ii)
I [333] M INTEGER
P Tax 16 (iii) [333]
J M INTEGER
Income chargeble under the head
Salaries (Column 332-333)
K [334] M INTEGER
Income (including loss from house
property) under any head other
than income under the head
"salaries" offered for TDS [section
192 (2B)] [335]
L M INTEGER
Gross Total Income (Total of
Column 334 + 335)
M [336] M INTEGER
Aggregate amount of deductions
under sections 80C, 80CCC and
80CCD (Total to be limited to
amount specified in section 80CCE)
[337]
N M INTEGER
Amount Deductible under any other
provision(s) of Chapter VI A [338]
O M INTEGER
Gross Total of 'Amount deductible
under provisions of chapter VI-A'
under associated ' Salary Details -
Chapter VIA Detail '
P [339] M INTEGER
Total Taxable Income
(Column 336 - 339)
Q [340] M INTEGER
Income Tax on Total Income
R [341] M INTEGER
Surcharge
S [342] M INTEGER
Education Cess
T [343] M INTEGER
Income Tax Relief u/s 89 when
salary etc is paid in arrear or
advance [344]
U M INTEGER
Net Income Tax payable
(341+342+343+344)
V [345] M INTEGER
Total amount of tax deducted at
source for the whole year
W [346] M INTEGER
Shortfall in tax deduction (+) /
Excess tax deduction (-) [345-346)
X [347] M INTEGER
Instructions for Challan Sheet
Column Name Column Description M/ O Format
Running Serial No. INTEGER
A (301) M
Section-Code
B M CHAR
TDS
C (302) M INTEGER
Surcharge
D (303) M INTEGER
Education Cess
E (304) M INTEGER
Interest
F (305) M INTEGER
Others
G (306) M INTEGER
Total Tax Deposited
(302+303+304+305+306) (307)
H M INTEGER
Cheque No / DD No.
(308)
I O INTEGER
BSR Code
(309)
J O INTEGER
Date on Which Tax Deposited
(dd/mm/yyyy)
K (310) M DATE
Transfer Voucher/ Challan Serial No.
(311)
L O INTEGER
Whether TDS Deposited by Book Entry
(312)
M O CHAR
N Interest Allocated
O Other Amt Allocated
NIL Challan Indicator
P M CHAR
Q Remarks
Instructions for Deductee Sheet
Column Name Column Description M/ O Format
Employee Serial No
A (313) M INTEGER
Serial Number in Challan as Per
(313)
B M INTEGER
Employee Reference Number provided
by Employer
C (314) O INTEGER
D Mode O
PAN Reference
E O CHAR
PAN of the Employee
(315)
F M CHAR
Name of the Employee
G (316) M CHAR
Date of Amount payment / credit
H (317) M DATE
Taxable Amount on which Tax
Deducted
I (318) M DECIMAL
Book Entry
J M CHAR
TDS
K (319) M DECIMAL
Surhcharge
L (320) M DECIMAL
Education Cess
M (321) M DECIMAL
Total Tax Deducted (319+320+321)
N (322) M DECIMAL
Total Tax Deposited
O (323) M DECIMAL
Date of Deduction
P (324) M/O DATE
Date of Deposit
Q (325) M DATE
Reason for Non-deduction / Lower
Deduction, if any
R (326) O CHAR
Instructions for Salary Sheet
Remarks Max Len
Running serial no. to indicate detail record no. Should start with 1
9
PAN of the employee. ( The employer will however have to mention
„PANAPPLIED‟ in place Deductee has applied for PANf . If the deductee
is not sure of the PAN Format he will mention 'PANINVALID'. if the
deductee has not given any declaration, employer will have to mention
„PANNOTAVBL‟ in place of PAN.) 10
If Valid PAN is not available with the employer, then it may (optionally)
assign a unique reference number for each of such deductees. This
reference number will have to be unique across all types of returns across
all quarters for a given employer 10
Mention the Name of the employee
75
W' for woman, 'S' for senior citizen and 'G' for others
1
Date format should be dd/mm/yyyy. From date should be the date from
which employed with the current Employer.
8
Date format should be dd/mm/yyyy. To date should be the date upto
which employed with the current Employer.
8
Greater than or equal to Zero. The amount cannot be a negative amount.
( Note 4 appearing at the end of the paper form 24Q gives definition of
Salary)
15
Amount of Entertainment allowance, if any
9
Amount of professional tax, if any
15
Greater than or equal to Zero. The amount cannot be a negative amount.
15
This is the only field where amount may have negative value. Here total of
other income other than salaries is to be entered. Since, Income from
house property is mostly negative, the net amount may be negative.
15
Greater than or equal to Zero. The amount cannot be a negative amount.
15
The Total amount of Deduction here cannot exceed Rs. 100000/-
15
Total of other Deductions under chapter VI-A to be entered here.
15
Should be equal to sum of column 337 & 338
15
Cannot be a negative amount.
15
Greater than or equal to Zero. Value must be less than or equal to 'Total
Taxable Income (340) 15
Greater than or equal to Zero.
15
Greater than or equal to Zero.
15
Greater than or equal to Zero.
15
Greater than or equal to Zero.
15
Should be equal to total amount of tax deducted for the whole financial
year.
15
Value maybe negative
15
Instructions for Challan Sheet
Remarks Max Len
Each RECORD or ROW should have an UNIQUE Serial No. 9
Leave Blank. eTdsWizard will automatically imput the correct code depending
upon the status of the Employer. 3
TDS Amount Should be Rounded off to Nearest Rupee & should be NUMERIC
Please do not use any Special Character (/-) 15
TDS Surcharge Should be Rounded off to Nearest Rupee & should be NUMERIC
Please do not use any Special Character (/-) 15
TDS Cess Should be Rounded off to Nearest Rupee & should be NUMERIC
Please do not use any Special Character (/-) 15
Interest Amount Should be Rounded off to Nearest Rupee & should be NUMERIC
Please do not use any Special Character (/-) 15
Other Amount Should be Rounded off to Nearest Rupee & should be NUMERIC
Please do not use any Special Character (/-) 15
Total Tax Deposited Should be Sum of (C+D+E+F+G) 15
Specifies the Cheque /DD No. Value should be 0 where tax is deposited in cash.
Leave blank if value in Column "P" (NIL Challan Indicator) is Y. Leave blank if tax
is deposited by book entry. 15
BSR Code of the branch where challan is deposited. Applicable to both Govt. and
Non Govt. Leave blank In case of transfer vouchers. Leave blank for Nil
Statement. 7
Date should not be Greater than System Date. Date Format should be
dd/mm/yyyy. Value should be equal to last date of respective quarter if the value in
Column "P" (NIL Challan Indicator) is Y in case of Nil return 8
A. Challan Serial Number - Specify 5 Digit number given by bank in the challan.
Applicable to both Govt. and Non Govt., Leave blank in case of a NIL return.
B. Transfer Voucher Number - Applicable only in case of a Government Organization.
Leave blank in case of a NIL return. 9
For Government Deductors Enter Y for Other Enter N. Leave Blank in the case of Nil
return
1
INTEREST ALLOCATION
OTHER AMOUNT ALLOCATION
Enter Y in cases where no tax has been deposited in bank (Applicable in case of NIL
return) else enter N
Leave Blank
Instructions for Deductee Sheet
Remarks Max Len
Each RECORD or ROW should have an UNIQUE Serial No. 9
Each deduction entry should have link to respective serial number entered in
Challan Sheet, e.g 5 deduction entries are paid wide challan number 1, so in all
the above 5 deduction entries mention Serial number in challan as 1 9
This field is used for mapping between the Deductee Detail Sheet with the corresponding
Salary Detail Sheet The value in this field should be same as the value in field no. 327 in
Salary Detail Sheet 9
For Regular Returns, Leave Blank
The PAN Ref. No is a unique identifier to identify an Employee Assessee where PAN is
not available / Pan Invalid / Pan Applied. This is quoted by the deductor. 10
Should be Valid PAN Format. Employees who have applied for a PAN In such
cases, will have to mention „PANAPPLIED‟ in place of PAN. If the Employee is not
sure of the PAN format he will have to mention 'PANINVALID'. However if the
Employee has not given any declaration, deductor will have to mention
„PANNOTAVBL‟ in place of PAN 10
Name of Employee should NOT BE LEFT BLANK. 75
Date Should not be greater than System Date. Date Format should be
dd/mm/yyyy 8
Specifies the Amount paid to Employee on which tax deducted
15
Specifies whether it is paid by Book entry or otherwise ('Y' or 'N'). Mention "Y" for Book
entry and "N" otherwise. 1
TDS Amount can be entered Upto 2 decimal points, it should be NUMERIC. Please do not
use any Special Character ( / -) 15
Surcharge can be entered Upto 2 decimal points, it should be NUMERIC. Please do not
use any Special Character ( / -) 15
Cess can be entered Upto 2 decimal points, it should be NUMERIC. Please do not use
any Special Character ( / -) 15
Total of Column (K , L , M)
15
Specifies the Total Tax Deposited for the Deductee. Zero (0.00 ) for a Nil
Statement. 15
Date of tax deduction. Mandatory if TDS Amount is greater than Zero (0.00) . No value
needs to be specified if TDS Amount is Zero (0.00) . 8
Date of Deposit of Challan should be same Date, as of Bank Challan No / 'Transfer
Voucher No in Challan Sheet 8
Value should be "A" if 'lower deduction' and "B" if 'no deduction' is on account of certificate
under section 197
1
1
Do not rename the worksheet names viz. Deductor, Challan, Deductor, Salary.
Do not delete/ Add any column from the Template-Salary files . If you do so the program will not work
Do not use “hide” function of MS Excel to hide any row or column.
Do not leave any blank row between deduction entries
Do not use “Percentage” or “Accounting” type
Some Fields Explained
Negative Amounts : Negative amounts are possible only in column L - in Salary Sheet
General Instructions for Preparing Data in Excel Format - Form 24Q
VERY IMPORTANT
The Columns in the Excel Templates are similar to the form prescribed by the Income Tax Department.
This Template is prepared on 29th May, 2006 and stands good as on this date.
DO’S
Actual data must start from row No 2 as row No 1 is for headings.
Check for correct date format. ( dd/mm/yyyy ) in all date columns.
All amount cells must be of type “numeric”
DONT’S
Do not put totals / sub-totals
Do not rename the worksheet names viz. Deductor, Challan, Deductor, Salary.
Do not delete/ Add any column from the Template-Salary files . If you do so the program will not work
Do not use “hide” function of MS Excel to hide any row or column.
Do not leave any blank row between deduction entries
Do not use “Percentage” or “Accounting” type
Some Fields Explained
Bank BSR Code: This is a 7 digit unique code allotted to each bank branch by RBI. BSR Code is always stamped on your
payment challan.
Section Code : eTdsWizard will automatically take the correct Section Code based on the status of the Employer. 92A for
Govt. and 92B for Others.
Column Totals : In the deductee worksheet, several columns are total values of two or more columns. eTdsWizard will check
for these totals.
Negative Amounts : Negative amounts are possible only in column L - in Salary Sheet
Note (4) referred in Salary Sheet - Column H point no. 332
Salary includes wages, annuity, pension, gratuity [other than exempted under section 10(10)],
fees, commission, bonus, repayment of amount deposited under the Additional
Emoluments (Compulsory Deposit) Act, 1974, perquisites (including value of any other fringe benefit or
amenity not covered under Chapter XII-H of the Income-tax Act, 1961),
profits in lieu of or in addition to any salary or wages including payments made at or in connection with
termination of employment, advance of salary, any payment received in respect of any period of leave
not availed[other than exempted under section 10(10AA)], any annual accretion to the
balance of the account in a recognised provident fund chargeable to tax in accordance with rule 6 of Part A of the
Fourth Schedule of the Income tax Act, 1961, any sums deemed to be income received by the employee in
accordance with sub-rule (4) of rule 11 of Part A of the Fourth Schedule of the Income tax Act, 1961, any
contribution made by the Central Government to the account of the employee under a pension scheme
referred to in section 80CCD or any other sums chargeable to income-tax under the head 'Salaries'.
or
h
yee in
any
e
