Excel Import Error → Challan not getting mapped

ExpressTDS || Excel Import Error → Challan Not Getting Mapped


Step 1: Log In and Access Deductor Master
  1. Visit https://www.expresstds.com/ and log in with your credentials.
  2. Navigate to the Deductor Master section.
  3. Select the deductor or company for which the correction return needs to be filed.

Step 2: Locate the Return
  1. To solve this excel import issue, here are some suggestions are given below.
Step 3:  Ensure that all mandatory fields are accurately filled in the "Challan Details" sheet. Below are the specific instructions for each field:
  • Challan No.: Enter the challan number exactly as per the deposited details.
  • Deposit Date: Use the date format dd-MM-yyyy when entering the deposit date.
  • BSR Code: Provide the correct BSR code of the bank branch where the payment was made.
  • Minor Head / Type of Payment:
    • Select '200' for TDS payable by the taxpayer.
    • Select '400' for TDS under regular assessment raised by the Income Tax Department.
  • Book Entry: Indicate whether the challan details are from a book entry by selecting "Yes" or "No".
    • Yes: Applicable for government authorities/agencies where all transactions are handled through the treasury.
  • Section: Specify the applicable section under which TDS/TCS is being deposited.
  • TDS/TCS Amount: Enter the total TDS/TCS amount.
    • Ensure the challan mapped to the deductee does not exceed the actual TDS/TCS amount available in the challan.

Ensure all details are correct and consistent with the actual challan and deposit records to avoid errors.

      

Step 4:  When working with the Excel template for TDS/TCS filings, ensure the following steps are followed to manage challan mapping correctly:
  1. Challan Selection: Verify that the Challan No. in the Deductee Transactions sheet is selected from the provided drop-down list.
      
  1. Handling the "Utilization Summary for Over-Mapped Challan" Error: If this error appears while importing the challan:
    1. Unmap all transactions from the challan in the dashboard, then remap them accurately.
    2. Download the error report to review the over-mapped details. Correct these details in the Deductee Transactions sheet of the Excel template and reimport the file.
                  
                  

By following these steps, you can ensure accurate challan mapping and avoid errors during the import process.

    • Related Articles

    • ExpressTDS || Create Deductee Transactions Process

      Steps to Create Deductee Transactions in a TDS Return Step 1: Navigate to the Deductor Master and select the relevant company or deductor. Go to the Return Summary and select the created return. Step 2: Click the "View" option for the created return. ...

    • ExpressTDS || Challan Mapping

      Summary of the Three Methods for Mapping Challans Process 1: Manual Mapping Open the Deductee Transactions and click the action icon. Select Mapped Challan to individually assign a challan to each deductee transaction. Process 2: Excel Export and ...

    • ExpressTDS || Steps to Import Transactions via Text File (Challan/Deductee Entry)

      Steps to Import Transactions via Text File (Challan/Deductee Entry) Follow the steps below to import transaction records into the system using a TXT file: Step 1: Navigate to the Deductor Master Go to the Deductor Master section. Select the relevant ...

    • TDS || Deductee/Employee Master → Import from Excel

      To import the Deductee/Employee Master through an Excel sheet, follow these steps: Download the "Deductee/Employee Master Excel Template": Navigate to "Master" → "Deductee/Employee Master". In the "Excel Import" dropdown menu, click on "Template ...

    • ExpressTDS || Employee/Deductee master Creation

      How to Create Employee/Deductee Master in ExpressTDS Step 1: Visit www.expresstds.com and log in with your username and password and navigate to the Deductor Master page. Choose the relevant company or deductor from the list of deductors. Step 2: On ...