E-tds Return Preparation Software

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://tinnsdl.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 "deductee". 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

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

Total no. of ch

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

0 Form No. 26

(See sections 193, 194,194A, 194B, 194BB, 194C,194D,194EE, 194F, 194G, 194H, 194I, 194J, 194K and rule 37)

Annual Return of deduction of tax under section 206 of I. T Act, 1961 in respect of all payments other than "Salaries" for the year ending 31st March, ……. 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 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:

Date: Assessment Year Financial Year Regular/Correction Return If this is a revised return, please mention Provisional Receipt No. of original return

0

0

Total no. of deductions in 'deductee' sheet

Form No. 26 (See sections 193, 194,194A, 194B, 194BB, 194C,194D,194EE, 194F, 194G, 194H, 194I, 194J, 194K and rule 37)

turn of deduction of tax under section 206 of I. T Act, 1961 in respect of all payments other than "Salaries" for the year ending 31st March, ……. of the person making deduction of tax

s: Flat/ Door/ Block No. f premises/ Building Street/ Lane ocality istrict/City

PIN

duction Account Number ent Account Number s of the person making deduction of tax changed

ifined within the meaning of section 204 read with rule 30

VERIFICATION

fy that all the particulars furnished above are correct and complete.

Name of person responsible for deducting tax at source Designation

rrection Return

Regular return

evised return, please mention Provisional Receipt No. of original return

Click here to generate e-TDS return

ANDAMAN AND NICOBAR ISLANDS ANDHRA PRADESH ARUNACHAL PRADESH ASSAM BIHAR CHANDIGARH DADRA & NAGAR HAVELI DAMAN & DIU DELHI GOA GUJRAT HARYANA HIMACHAL PRADESH JAMMU & KASHMIR KARNATAKA KERALA LAKHSWADEEP MADHYA PRADESH MAHARASHTRA MANIPUR MEGHALAYA MIZORAM NAGALAND ORISSA PONDICHERRY PUNJAB RAJASTHAN SIKKIM TAMILNADU TRIPURA UTTAR PRADESH WEST BENGAL CHATISHGARH UTTARANCHAL JHARKHAND FOREIGN COUNTRY

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 99

S. No.

Details of tax deducted and paid to the credit of the Central Government Section TDS (Rs.) Surcharge Education Interest Others (Rs.) Total Tax code (Rs.) Cess (Rs.) (Rs.) deposited (Rs.)

Cheque/ DD BSR Code No.

Date on which tax deposited

Transfer voucher / Challan serial number

Whether TDS 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 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' nondeductee companies) (length 10)

aid/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' ite 'A' if the 'lower deduction' or 'no deduction' is on account of a certificate under Section 197. ite '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. e dates should be entered in proper date format se do not make totals of amounts at the end. 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)

Income Tax Act, 1961

haracters will be truncated. Address1 (maximum length 25)

Address Address2 (maximum length 25)

of

the

deductee Address3

(maximum length 25)

Address4

Address5

(maximum length 25)

(maximum length 25)

Address 6 (name of State)

Address 7 (PIN code)

Amount of payment (Rs.)

Date on which amount paid/ credited

Paid by book entry or otherwise

Section under which tax deducted

Rate at which tax deducted

Amount of tax deducted

Date on which tax deducted

Date on which Bank Branch Challan number tax paid to the Code given by bank credit of Central (maximum Government length 7) (maximum length9)

Date of Reason of nonfurnishing of tax deduction / lower deduction deduction, if any certificate (refer notes above)

ANDAMAN AND NICOBAR ISLANDS ANDHRA PRADESH ARUNACHAL PRADESH ASSAM BIHAR CHANDIGARH DADRA & NAGAR HAVELI DAMAN & DIU DELHI GOA GUJRAT HARYANA HIMACHAL PRADESH JAMMU & KASHMIR KARNATAKA KERALA LAKHSWADEEP MADHYA PRADESH MAHARASHTRA MANIPUR MEGHALAYA MIZORAM NAGALAND ORISSA PONDICHERRY PUNJAB RAJASTHAN

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27

SIKKIM TAMILNADU TRIPURA UTTAR PRADESH WEST BENGAL CHATISHGARH UTTARANCHAL JHARKHAND FOREIGN COUNTRY

28 29 30 31 32 33 34 35 99