To import data from an Excel workbook the follow the steps given below:

  • Create Blank Excel sheet
  • Enter data in the above sheet
  • Validate and import data from the excel sheet

Create Blank Excel sheet

A pre-defined format has been provided in the Regular Return Menu. In order to do this, click on Regular Return > Import from Excel > Create Blank Excel Sheet :-

create-blank-excel-sheet

The following window will be displayed:

selection-of-relevant-tds-or-tcs-formFigure 8-1 Selection of relevant TDS/TCS Form

Select the relevant to a TDS / TCS Form and the relevant file type i.e. xls or xlsx files. Save the same in the selected destination folder.

Enter data in the created Excel sheet

Provide the Challan and Deductee details in the Excel workbook as per displayed columns headers.

Note: Guidelines for placement of data are provided within the Excel workbook and should be strictly followed.

Validate and Import data from the excel sheet

In order to import the excel sheet, click on the option ‘Import from Excel’ and select ‘Import Transactions’.

import-transactions

The following window will be displayed:

validate-excelFigure 8-2 Validate Excel

Select the Financial Year, Quarter, Form No. and Company Name for which the data needs to be imported. Browse and select the Excel file and select the relevant Import type from the options provided. Cick on the validate-exccel-file-button button to validate the selected excel file. This file will be validated and only after successful validation, this file will be ready for getting imported in the software.

Note: Please ensure that the Excel workbook is correctly selected.

If there is any error in the selected Excel file, then the same would be displayed in a separate sheet in this file only.
Additionally, you can select the option of colour coding where in the errors will be highlighted using the different colour conventions.
Make the relevant corrections and save this document. Now once again you need to import the corrected excel sheet (as described above) and validate the same.

After validation is successful you will get the following interface where every Challan and its deductee detail can be checked and verified by user.

verify-imported-dataFigure 8-3 Verify Imported Data

Once it is verified, you should click on import-data-button button to start transferring data into the software database.

Note: The data gets transferred into the system only after ‘Import Data’ is clicked upon and confirmed subsequently.

After the import is completed you can go to the respective Form where the data was imported and you are ready to generate the file for return submission

Need more help with this?
TDSMAN - Support

Was this helpful?

Yes No
You indicated this topic was not helpful to you ...
Could you please leave a comment telling us why? Thank you!
Thanks for your feedback.