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.

Solution →
  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 || Capital Gain Excel Import → Syntax Error

      Root Cause of the Error → The error occurs when a client enters a special character (') in the Capital Gain Excel template. Solution → Open the Capital Gain Excel template intended for import into the software. Identify and remove any instances of ...

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

    • Income Tax || Data Feeding - Capital Gain

      What is Capital Gains Tax in India: Capital Gains Tax is a tax on the profit or gain that an individual or a business entity earns from the sale of capital assets. The capital assets can include property, stocks, bonds, gold, or any other asset. The ...

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

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