Salary details (annual tax computation of the employee) can be prepared in Excel sheets and then 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.
Click on Regular Return > Import From Excel > Create Blank Excel Sheet :-

create-blank-excel

The following screen will appear:

figure-5-16-create-blank-excel-sheet-for-salary-details
Figure 5-16 Create Blank Excel Sheet for Salary Details

Financial Year: Select the Financial Year of the Return for which the salary details have to be entered.
Select Import Type: Select 24Q Salary Details, as the blank Excel sheet with pre-defined format for Salary Details is required.
Excel File Path: Enter the desired location to save the blank Excel format.
Save: Save the Excel format in a desired location by clicking on ‘Save’

2. Prepare the complete salary data in the Excel sheet.

3. In order to do upload the data from the Excel Sheet into the system, click on Regular Return > Import From Excel > Import Transactions :-
import-transactions

The following screen will appear:

fig-import-salary-details-excel-sheet
Figure - Import Salary Details Excel Sheet

Financial Year: Select the Financial Year of the Return for which the Salary details have to be entered.
Quarter: Select Q4.
Form No: Select 24Q Salary Details
Company Name: Select Company Name for which the Salary details have to be entered.
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.
Import Type: The salary details can be imported in 2 ways:
i. New/Replace existing data : In order to overwrite the existing salary details with the imported salary detail, check this box (Warning: All the existing data in the selected Return will get removed and replaced with data in the Excel. The original data cannot be restored back).
ii. Add to the existing data : In order to add the additional salary detail, check this box.
Enter Deductee without Challan: In order to enter the deductees which are not attached to any challan, check this box.
Validate Excel File : Click on validate-exccel-file-button to validate the source Excel file.
Once the data is validated and if the data provided is correct, the system displays the following screen:

fig-import-salary-details-excel-sheet
Figure - Import Salary Details Excel Sheet

Click on import-data-button The data will get imported into the system. However, if 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.