Excel Import Error "challan is not getting mapped"

Excel Import Error "challan is not getting mapped"

Excel Import Error "challan is not getting mapped"




Possible Resolution

To solve this excel import issue, here are some suggestions are given below.

1.  All mandatory details should be filled in the "Challan Details" Sheet.
* Challan number
* Deposit Date 
* BSR Code 
* Book entry - Yes/No
* TDS/TCS Amount


2. In  "Challan Details" Sheet, date format should be dd-mm-yy




3. In the Excel template, it is to be checked that the Challan No. is selected from the drop-down or not in "Deductee Transactions sheet".






Hope This Helps.

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

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

    • Express TDS - FORM 27EQ for TCS RETURN

      Express TDS - FORM 27EQ for TCS RETURN Form 27EQ refers to the quarterly statement of TCS that reflects the details of the TDS u/s 206C of the Income Tax Act of 1961. It can also be called as the statement that furnishes the Tax Collected at Source ...

    • TDS || Excel Import → Import of already in progress

      Root Cause of the Error → This issue occurs when Excel is importing data and encounters a malfunction, causing it to get stuck midway through the process. Solution → To resolve the error, click the "Clear Excel Import Flag" button. After that, click ...

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