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 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 - Deductee/employee master import from excel

      Express TDS - Deductee/employee master import from excel  Step 1 - Go into deductee master and click on import deductee  Step 2- Now click on "downlaod excel template " Enter detail in excel template  you are required to browse the excel file  from ...

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

    • Excel import - Tax Rate should be numeric

      Excel import  - Tax Rate should be numeric Solution  This error comes when TDS details (24q,26q,27q,27eq) are imported from Excel Template and the tax rate is not entered in the numeric format Open excel template > "deductee detail" sheet Select a ...

    • TDS FVU Generation error - "Challan details mentioned in the statement not present in the challan file imported"

      Error in TDS > FVU Generation > Warning file generates TDS FVU Generation error - "Challan details mentioned in the statement not present in the challan file imported"              Solution: This error comes when the entered challan is not matching ...