Salary - TDS Software eTDS Software from Fast Facts by suchenfz

VIEWS: 40 PAGES: 24

									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

								
To top