Type Mismatch, Error in excel import

Zen IT || Excel Import → Type Mismatch, Error in excel import


Root Cause of the Error:  The error stems from either erroneous data entry in the Excel sheet or alterations to the format of the specific Excel file.

  1. Validate Date Format: Verify that dates adhere strictly to the format "dd/MM/yyyy".
  2. Remove Special Characters: Ensure that the Date column contains no spaces or any other special characters.

Note: Prioritize accuracy by importing the Shares Tab for details entered in the Shares Template.
For data entered in the Equity_mutualFund Sheet, select the Mutual Fund Tab in the software before importing the Excel sheet.                 

To Check system Settings 
  1. To check and set the time zone:
    1. Set Time Zone → "(UTC+05:30) Chennai, Kolkata, Mumbai, New Delhi"
    2. Click "OK" to save the changes.
  1. To set the region format to English (United States):
    1. Go back to the Control Panel.
    2. Click on "Region"
    3. In the Formats tab, select "English (United States)" from the Format drop-down menu.
    4. Click "Apply" and then "OK" to save the changes.
  1. To set the short date format to dd/MM/yyyy:
    1. In the same Region window, go to the "Additional settings..." button in the Formats tab.
    2. In the dialog box that opens, go to the "Date" tab.
    3. In the Short date dropdown menu, select "dd/MM/yyyy"
    4. Click "OK" to save the changes.
These steps should help you achieve the desired settings on your system.
    • Related Articles

    • Income Tax || Import capital gain data via Excel template

      Step 1: Navigate to the Transaction section and select "Capital Gain". Step 2: Choose the special Excel sheet made for Capital Gain from the options. Step 3: Fill in all the info about your capital gains into the Excel sheet. Step 4: Click the button ...
    • Computation error regarding Depreciable Asset mismatch

      Computation error regarding  Depreciable Asset mismatch  Possible Resolution The capital gain shown in the  deprecation chart  is should be equivalent which has entered in the capital gains head (Depreciable Asset) Go into transaction → business and ...
    • Income Tax Xml upload error regarding schedule 112A

      Income Tax  Xml upload error regarding schedule 112A  - "In Schedule 112A , Col 6 Total Sale Value in not equal to Col. 4*Col. 5 " Possible Regulation  The main reason of this error that value of  "No. of Shares/Units " and "Sale-price per Share/Unit ...
    • Zen IT || AIS Import Process

      What is the Annual Information Statement (AIS) ? The Annual Information Statement (AIS) serves as a comprehensive snapshot of a taxpayer's information as displayed in Form 26AS. Taxpayers are afforded the opportunity to furnish feedback regarding the ...
    • Section 112A – Income Tax on Long Term Capital Gain

      Introduction to Section 112A – Income Tax on Long Term Capital Gain  Vide Finance Bill 2018, the Government has come up with an insertion to section 112A under the Income Tax Act, 1961.  The new section 112A has been inserted in order to levy ...