Excel export and Import Procedure

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 Export :
Exporting a Blank Excel Template:
  1. Go to the "Tools" section within the TDS software.
  2. Look for the option labeled "Download Excel Template" and click on it.
  3. A menu will appear where you need to select the appropriate form for which you want to export the data. Choose the relevant form and proceed.
      
  1. After selecting the form, the software will prompt you to specify the location where you want to save the Excel template. Navigate to your desired location and click on the "Save" button.

Exporting a Filled Excel Template:
  1. Navigate to the "Export/Import" section in the software.
  2. Look for the option labeled "Export in Excel" and click on it.
  3. Similar to exporting a blank template, select the appropriate form you want to export.
      
  1. Proceed to specify the location where you want to save the filled Excel template and click on the "Save" button.

Excel Import :
  1. First, ensure that you have filled in the necessary details within the Excel template you wish to import.
  2. Navigate to the "Export/Import" section within the TDS software.
  3. Look for the option labeled "Import From Excel" and click on it.
      
  1. You will be prompted to select the proper form for the data you are importing. Choose the relevant form.
  2. Next, you'll need to browse your computer to locate the Excel template file you wish to import. When browsing, you may be asked whether you're dealing with a new client code or an existing one. Select the appropriate option.
  3. Enter the Deductor Code as required by the software.
  4. Finally, proceed with the import process as guided by the software.
This detailed explanation should help users better understand and execute the import and export processes within the TDS software using Excel.

    • Related Articles

    • 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: To initiate a correction, first download and import the consolidated file into the software. To do so, click on "Click Here ...

    • How to import finacle file in e-TDS

      How to import finacle file in e-TDS Finacle is banking software, which is providing a report in a text format. The report consist of  all financial transaction details,  like payment  date ,tds deducted amount and amount paid detail during the ...

    • Zen TDS || Process to generate TDS Return (Salary / Non Salary / Non Resident / TCS)

      TDS, or Tax Deducted at Source, is a mechanism established under the Income Tax Act to ensure a steady collection of taxes from various income sources. In this system, any company or individual making a payment is mandated to deduct a certain ...

    • 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 ...

    • ExpressTDS || Download TDS Return Data in Excel

      Steps to Download TDS Return Data in Excel Format via ExpressTDS You can download TDS return data for both regular and correction returns in Excel format. Ensure transactions have been created in the return before proceeding. Here’s how: Download TDS ...