For Correction Return, apart from manual creation of the Deductee, it can also be imported into the system through Excel and get added to the list already present. This would save effort in entering data through formats of the software interface.
Importing data from Excel can be done in 3 steps:
1 Download the pre-defined blank Excel format in the desired location
2 Prepare the required data in this Excel sheet
3 Upload this data from the Excel sheet into the system

1. In order to import the data from Excel, first download the pre-defined Blank Excel format in the desired location.

Select the Correction Return which needs to be rectified. Select the batch for which the Deductee details need to be corrected, the following screen will appear:

add-or-edit-deductess-using-excel
Figure - Add / Edit Deductees using Excel

Now click on add-or-edit-deductess-excel the following screen will appear :

add-deductees-by-using-excel
Figure - Add Deductees by using Excel

Click on create-blank-excel-button to create the Excel File and save it the desired location.

2. Prepare the Deductee data in the blank sheet and make sure about the following:
i. For each deductee the correct Challan Serial number should be specified in the Excel Sheet.
ii. Make sure the Challan Serial Number is present in the challan details.

3. In order to import the data from this Excel sheet, enter the file path.

validate-excel-in-correction
Figure - Validate excel

Excel File Path: Enter the Excel file path from which the data has to be imported.
Color coding in Excel for error (this may take a few more minutes) – If there is any error in the data provided in the Excel sheet, the system will highlight the same. The user is expected to rectify the data and import the entire file again. However, in order to display these errors using the color code, check this box.

Validate Excel File: Click on validate-exccel-file-button the system will validate the excel data. If the data is correct then the following screen will appear :

import-data-of-correction-excel
Figure - Import Data of Correction Excel

Click on import-data-button the data will get imported into the system.
In case, there is any error in the data, the system will highlight the errors. The errors have to be rectified and the Excel sheet has to be imported again.

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.