In order to Import data from Excel sheets for Deductee Entry Without Challan, click on the option Import from Excel > Import Transactions :-
The following screen will get displayed:
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.
Enter Deductee without Challan : Select this option in order to import the deductees without challan.
Click on the 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 the details ofevery Challan and its deductee and also the deductees without any challan, can be checked and verified by user.
Once it is verified, you should click on 
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