Add Employee in Salary Details Through Excel For Correction Return

For Correction Return in Salary details, apart from the manual creation of the Employee, 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 where the Employees need to be added. The following screen will appear:

add-employee-in-salary-details-through-excel-in-correction

Click on add-data-using-excel-button following screen will appear:

figure-add-employees-using-excel
Figure - Add Employees using Excel

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

2. Prepare the Employee data in the blank sheet, make sure about the following:
i. Do not repeat the entries already present in the Return
ii. Enter correct value in the calculative fields

3. In order to upload this Excel file enter the 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.

validate-add-employees-using-excel

If the data is correct then the following screen will appear :

import-data-of-salary-details-update-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.

Modify PAN in Salary Details Through Excel For Correction Return

For Correction Return of the salary details, apart from manual modification of the PAN of Employee, it can also be modified through Excel and get imported into the system. 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. In order to do so, select the Correction Return of the Salary Details which needs to be rectified. Select the Batch for which the PAN Number need to be corrected the following screen will appear:

add-employee-in-salary-details-through-excel-in-correction

Click on add-data-using-excel-button following screen will appear:

figure-pan-modification-using-excel
Figure - Pan Modification using Excel

First click on “Modify Employees”, then click on “PAN Modification”.

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

2. Prepare the PAN Modification Data in the Pre-defined blank sheet, make sure about the following:
i. The ‘SD No.’ , ’PAN of the Employee’ , and ‘Name of Employee’ as per Justification Report need to be placed in the Excel Sheet and the correct PAN under ‘NEW PAN’ has to be entered for each Record.

3. In order to import this data into the system enter the Excel file path.

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.

validate-excel-in-pan-modify-correction

If the data is correct then the following screen will appear :

update-pan

Click on update-pan-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.

Bulk Nullify in Salary Details Through Excel For Correction Return

For Correction Return of Salary Details, apart from manual nullification of the Employee Salary Details, this can also be done through Excel and get imported in system. This would save effort in entering data through formats of the software interface.
Importing data from Excel can be done in 3 steps:
1 Export the desired record in the Excel sheet and store it 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 Financial year, Quarter 4, Company Name of the Return for which the Employee details need to be nullified. The following screen will appear:

add-employee-in-salary-details-through-excel-in-correction

Click on add-data-using-excel-button following screen will appear :

figure-bulk-deletion-using-excel
Figure - Bulk Deletion using Excel

First click on “Modify Employees”, then click on “Bulk Nullify”.
The system gives the following options:
• To nullify all the Salary details select “ALL” from dropdown
• To nullify the employees of the specified salary details, select “ the specified Salary details”

Select the desired option and click on bulk-delete-button to export the data to Excel file
2. Prepare the data in this Excel sheet. Keep only those employee records which need to be nullified. Remove all the other employee records. Do not tamper any data in the Excel file.
3. In order to upload the data from the Excel sheet enter the Excel file path.
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 validate-exccel-file-button here, the system will validate the excel data.

validate-excel-of-data-bulk-deletion-in-correction

If the data is correct then the following screen will appear :

delete-records

Click on delete-records-button The exiting record will get deleted from the system and a new nullified record will get added.
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.