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 || Challan-Wise Summary of Mapped Transactions

      Procedure to View Mapped Challan Transactions in ExpressTDS Begin by logging into the ExpressTDS platform using your credentials. Accessing Mapped Challan Transactions Option 1: Using Challans Overview Select Deductor: Choose the appropriate deductor ...
    • 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 || Edit/Delete Deductee Transactions Process

      Step 1: Navigate to the Deductor Master Log in to the software and go to the Deductor Master. Select the relevant company or deductor for which the TDS return has been created. Navigate to the Return Summary and select the desired return. Step 2: ...
    • ExpressTDS || Correction Return - Deductee Transactions - Mark Nil Process

      This guide outlines the steps for marking deductee transactions as NIL in ExpressTDS, whether handling single or bulk corrections. Steps for Performing Corrections Access the Correction Section Company/Deductor Selection: Navigate to the relevant ...