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.