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:
Click on following screen will appear:
Click on 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 the system will validate the excel data.
If the data is correct then the following screen will appear :
Click on 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:
Click on following screen will appear:
First click on “Modify Employees”, then click on “PAN Modification”.
Click on 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 the system will validate the excel data.
If the data is correct then the following screen will appear :
Click on 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:
Click on following screen will appear :
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 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 here, the system will validate the excel data.
If the data is correct then the following screen will appear :
Click on 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