TDS Return Form27 ver4 80 by 5L4HcUW

VIEWS: 27 PAGES: 320

									    e-TDS Return Preparation Software
   From June 1, 2003 onwards it is mandatory for all corporate entities to file their e-TDS returns in electronic form. The file
   formats for preparation of e-TDS return have been notified by Income Tax Department. The guidelines for preparation
   and submission of e-TDS returns are also available on NSDL web site http://tin-nsdl.com.

   Deductors may take help of this software for preparing the e-TDS return. After preparing the e-TDS return with the help
   of this software, deductors may pass the e-TDS return file through the 'e-TDS File Validation Utility' to verify format level
   accracy of the e-TDS return and control totals mentioned on Form 27A. In case user finds any error in e-TDS return, he
   may rectify the same in this excel file itself and regenerate the e-TDS return file. This software and e-TDS File Validation
   Utility are freely downloadable from http://tin-nsdl.com

   Guidelines for using this software are as follows:

1 Before using this software, users are requested to download and go through "Deductors's Manual" from
  http://tin.nsdl.com. This manual is freely downloadable from the web-site. Users should also download "e-TDS File
  Validation Utility".

2 This software is in the form of an MS-Excel file. The excel file contains three sheets viz. "form26", "challan" and "annex".
  The contents of the three sheets are almost same as that of physical TDS returns. When user opens this file, a
  message is displayed on the screen i.e. 'Enable macros' or 'Disable macros'. User should click on 'Enable macros'.


   First of all user needs to fill the "Total no. of challans" and "Total no. of dedutee records" in the space given in the first
   row of sheet - "form26". Example: in the example given below total no. of challans are 14 and Total no. of deductee
   records are 10
      Total no. of challans            14              Total no. of deductee records                             10
   Note: No. of deductee records means no. of deductions made during the year (ie. No.of rows filled in sheet
   'annex'. For example there are 100 deductees and every deductee is paid every motth and tax deducted. In such
   case total no. of deductee records would be 100 X 12 = 1,200.

3 After user fills up the no. of challans and deductee records, user may fillup the required details in other columns

4 Now the user should fill up deductor details and challan details in sheet- challan and dedutee details in sheet-annex.
  User is required to fill up only those cells which are in white colour

5 At some of the places users may use the drowdown box to fill up the appropriate value. For example in sheet- form26
  state (address) of the deductor is to be filled up. When user selects the appropriate cell an arrow will appear on the right
  side of the cell. User may click on the arrow and select the appropriate value. Following picture shows the dropdown list.




6 Deductors should fill up all amount fields and "rate at which tax deducted" field upto a maximum of two decimal
  only. Furhter all data should be filled in proper format:
        Date fields: All date fields should be filled in proper date format e.g. dd/mm/yyyy or mm/dd/yyyy
        Amount fields: All amount fields should be in number format. No special character like '/' or '-' etc. should be used.


7 User may also take a print out of these two sheets after duly filling up the same and verify the contents from its records


8 User needs to fill up details in excel file in normal manner only. User should not suffix the details with spaces or prefix
  with zeros.

9 Once the user is satisfied that he has filled up all the details required to be filled up in the form, he may click on the
  "create file" botton given at the end of sheet - form26. Once the user clicks on the botton the e-TDS return file is
  generated and saved as "abc.txt" in C drive of the machine.

10 User must pass this file through e-TDS File Validation Utility to ensure format level accuracy of the file. In case file
   contains any errors, user may rectify the same in the excel file itself. After rectifying the errors, user must again pass the
   rectified file through e-TDS File Validation Utility. If the file is format wise correct, FVU will generate an upload file which
   should be submitted to TIN-FC in a CD/floppy along with physical Form 27A or directly to NSDL through the online
   upload facility at www.tin-nsdl.com.
Total no. of challans                                   Total no. of deductions in 'deductee' sheet
                                                                       Form No. 27
                                                                      (See Rule 37A)

   Statement of deduction of tax from interest, dividends or any other sum payable to (I) persons, not being companies, who are non-residents but not
    ordinarily residents, and (ii) companies which are neither Indian companies nor companies which have made the prescribed arrangements for the
                                                     declaration and payment of dividentd within India
 1 Particulars of the person making deduction of tax
   (a) Name
   (b) Address: Flat/ Door/ Block No.
       Name of premises/ Building
       Road/ Street/ Lane
       Area/ Locality
       Town/District/City                                                                                              PIN
       State

   (c ) Tax Deduction Account Number
   (d) Permanent Account Number

 2 Has address of the person making deduction of tax changed

 3 Status as difined within the meaning of section 204 read with rule 30


                                                                    VERIFICATION

   I,
   hereby certify that all the particulars furnished above are correct and complete.

   Place:
                                                            Name of person responsible for deducting tax at source
                                                                                                                                                    -
                                                            Designation
   Date:
   Assessment Year
   Financial Year
   Quarter

   If this is a revised return, please mention Provisional Receipt No. of original return
   Regular/Correction Return                                                                                Regular return

                                                 Click here to generate e-TDS return
ANDAMAN AND NICOBAR ISLANDS    1
ANDHRA PRADESH                 2
ARUNACHAL PRADESH              3
ASSAM                          4
BIHAR                          5
CHANDIGARH                     6
DADRA & NAGAR HAVELI           7
DAMAN & DIU                    8
DELHI                          9
GOA                           10
GUJRAT                        11
HARYANA                       12
HIMACHAL PRADESH              13
JAMMU & KASHMIR               14
KARNATAKA                     15
KERALA                        16
LAKHSWADEEP                   17
MADHYA PRADESH                18
MAHARASHTRA                   19
MANIPUR                       20
MEGHALAYA                     21
MIZORAM                       22
NAGALAND                      23
ORISSA                        24
PONDICHERRY                   25
PUNJAB                        26
RAJASTHAN                     27
SIKKIM                        28
TAMILNADU                     29
TRIPURA                       30
UTTAR PRADESH                 31
WEST BENGAL                   32
CHATISHGARH                   33
UTTARANCHAL                   34
JHARKHAND                     35
FOREIGN COUNTRY               99
         Details of tax deducted and paid to the credit of the Central Government
S. No.     Section     TDS (Rs.) Surcharge Education          Interest Others (Rs.) Total Tax
            code                     (Rs.)     Cess (Rs.)       (Rs.)               deposited
                                                                                      (Rs.)
Cheque/ DD BSR Code   Date on which    Transfer voucher /     Whether TDS
   No.                tax deposited   Challan serial number   deposited by
                                                              book entry ?
                                                                Yes / No
Annexure
Details of amount paid/credited during the financial year and of tax deducted at source under Inco
Notes:        1. In the field 'Reason of non-deduction / lower deduction, if any'
                   Write 'A' if the 'lower deduction' or 'no deduction' is on account of a certificate under Section 197.
                   Write 'B' if no deduction is on account of declaration under section 197A.
                   Otherwise leave it blank
              2. Please do not insert or delete any row or coloumn.
              3. Please do not leave any row blank.
              4. Please enter the name of the state from the drop down list in the 'address 6' field. Do not enter the state co
              5. All the dates should be entered in proper date format
              6. Please do not make totals of amounts at the end.
              7. If the length of the particulars provided is more than the length specified in header, the remaining characte
Deductee code      Permanent
    ('01' for Account Number
companies and        (PAN) of
   '02' non-        deductee
  companies)       (length 10)
paid/credited during the financial year and of tax deducted at source under Income Tax Act, 1961
 e field 'Reason of non-deduction / lower deduction, if any'
 te 'A' if the 'lower deduction' or 'no deduction' is on account of a certificate under Section 197.
 te 'B' if no deduction is on account of declaration under section 197A.
herwise leave it blank
 se do not insert or delete any row or coloumn.
 se do not leave any row blank.
 se enter the name of the state from the drop down list in the 'address 6' field. Do not enter the state code.
he dates should be entered in proper date format
 se do not make totals of amounts at the end.
e length of the particulars provided is more than the length specified in header, the remaining characters will be truncated.
                  Name of Deductee

              (maximum length 75)
r Income Tax Act, 1961




aracters will be truncated.                Address      of   the   deductee
                         Address1          Address2                  Address3

                (maximum length 25)   (maximum length 25)      (maximum length 25)
     Address4              Address5            Address 6
                                            (name of State)
(maximum length 25)   (maximum length 25)
Address 7    Amount payable        Date on which   Whether          Section under
(PIN code)   before deduction of   amount paid/    Grossing up is   which tax
             Tax                   credited        required         deducted
                                                   (Yes/No)
Rate at     Amount of tax   Date on which   Date on which     Bank Branch Challan number
which tax   deducted        tax deducted    tax paid to the   Code        given by bank
deducted                                    credit of         (maximum
                                            Central           length 7)   (maximum
                                            Government                    length9)
Date of         Reason of non-
furnishing of   deduction / lower
tax deduction   deduction, if any
certificate     (refer notes above)
ANDAMAN AND NICOBAR ISLANDS    1
ANDHRA PRADESH                 2
ARUNACHAL PRADESH              3
ASSAM                          4
BIHAR                          5
CHANDIGARH                     6
DADRA & NAGAR HAVELI           7
DAMAN & DIU                    8
DELHI                          9
GOA                           10
GUJRAT                        11
HARYANA                       12
HIMACHAL PRADESH              13
JAMMU & KASHMIR               14
KARNATAKA                     15
KERALA                        16
LAKHSWADEEP                   17
MADHYA PRADESH                18
MAHARASHTRA                   19
MANIPUR                       20
MEGHALAYA                     21
MIZORAM                       22
NAGALAND                      23
ORISSA                        24
PONDICHERRY                   25
PUNJAB                        26
RAJASTHAN                     27
SIKKIM                        28
TAMILNADU         29
TRIPURA           30
UTTAR PRADESH     31
WEST BENGAL       32
CHATISHGARH       33
UTTARANCHAL       34
JHARKHAND         35
FOREIGN COUNTRY   99

								
To top