Instructions for Import CSV at Point No. 26 (i)(B)(a) of Form 3CD. | ||||
---|---|---|---|---|
Option 1 – “Import CSV" | ||||
1. | Download the template from the link (“Template”) provided. | |||
2. | Click on the template; provide a file name to save the file. | |||
3. | Update the data as per the headings provided in the template. | |||
4. | Ensure that the filled template is saved in .CSV format. The same can be done through --> Go to File --> Save As --> Provide File name to save the Template --> | |||
Select Save as type as “CSV (Comma delimited) (*.csv)” --> Save. | ||||
5. | Import the updated CSV file by Clicking on “Import CSV”. |
Key points to be considered while filling CSV file | |||
In “CSV Template”, the data provided should comply with the below requirements: | |||
1. | The drop down values of “Section” should be given as the simplified codes mentioned below: |
Drop down | Code to be specified in CSV(case sensitive) |
Sec 43B (a) -tax, duty, cess, fee etc. | 43Ba |
Sec 43B (b) -provident/superannuation/gratuity/other fund | 43Bb |
Sec 43B(c) - sum referred to u/s 36(1)(ii) | 43Bc |
Sec 43B (d) -interest from public financial institution etc. | 43Bd |
Sec 43B (e) - interest on loan from scheduled bank | 43Be |
Sec 43B (f) - leave encashment | 43Bf |
Sec 43B(g)- Indian railways for use of railway assets | 43Bg |
2. | “Amount” field should be Numeric, Non- negative and non- decimal. |
Option 2 – Fill Data | |||
1. | Select “Fill data”, enter all the required details .To add rows select “Add” and update the details. | ||
2. | To delete rows select the row which is to be deleted and then click on “Delete”. | ||
3. | Click on “Save” to go back to Clause 26(i). | ||
Note: | |||
This option shall be used if there is limited number of data. |