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.