TDS Correction → Excel export and Import Procedure

TDS || Correction → Excel export and Import Procedure

The procedure below outlines the data import and export through Excel in the TDS software, along with the correction process:
  1. To initiate a correction, first download and import the consolidated file into the software.
  2. To do so, click on "Click Here to Download Consolidated File" to request and download the file.
NOTE : Ensure you select the respective deductor, assessment year, and quarter before proceeding with the correction.

Correction Procedure:
  1. Navigate to the "Corrections" button in the software.
  2. From the drop-down list, select the option - "Correction 24Q, 26Q, 27Q, or 27EQ".
      
  1. Browse and select the consolidated file (.tds File) using the browse button [...].
      
  1. Click on Proceed, and then confirm by clicking 'YES' to import the file.
      
  1. The imported consolidate file will be displayed on the screen.
      
  1. Double click on the imported file to access further correction options.
Excel Export / Import:

We have provided the option for Excel import to facilitate the process, especially when dealing with a large number of entries. Here are the steps for Excel export/import:

      

Exporting Excel Blank Template:
  1. Select the appropriate form and releavent details (Challan, Deductee, Salary Details) in the software.
      
  1. Click on the Export button to download the Excel template.
Importing Excel Data:
  1. Once all details are filled in the Excel template, proceed to import the data.
  2. Navigate to the "Import Excel File Path" option and browse for the Excel sheet containing the filled data.
      
  1. After selecting the file, click on the Proceed button to import the data into the software.
Following these steps will ensure efficient data management and correction within the TDS software, whether through importing the consolidated file or utilizing the Excel import/export feature.

    • Related Articles

    • TDS || Excel export and Import Procedure

      To reduce complications of data entry in TDS software, a facility has been provided where the user can import data through excel and can export data in excel. The process below explains Data import and export through excel in TDS software. Excel ...

    • TDS Correction Excel Import "Error converting data type varchar to numeric"

      TDS Correction Excel Import Error:- 2147217913 Error converting data type varchar to numeric Possible Resolution To solve this excel import issue, here are some suggestions are given below.  1. In the Excel template, it is to be checked that the ...

    • eXBace || Data import and export through excel

      To reduce complications of data entry In eXBace software, a facility has been provided where the user can import data through excel and can export data in excel. The User can also validate every sheet where the data is entered at the same time. The ...

    • ZenTds || Offline Correction process for TDS return

      Process for offline correction for 24Q, 26Q, 27Q & 27EQ from TDS software: The correction from the TDS software can be processed once you have the consolidated file (.tds file). How to request and download the consolidated file through the software: ...

    • Excel import - Tax Rate should be numeric

      Excel import  - Tax Rate should be numeric Solution  This error comes when TDS details (24q,26q,27q,27eq) are imported from Excel Template and the tax rate is not entered in the numeric format Open excel template > "deductee detail" sheet Select a ...