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 KDK 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 || Export and Import Capital Gain Data via Zerodha Excel Template

      Steps to Export and Import Capital Gain Data via Zerodha Excel Template Exporting Capital Gain (Tax P&L) Data from Zerodha Step 1: Access the Tax P&L Section Log in to your Zerodha account. Click on the Reports tab. Step 2: Select Tax P&L Choose the ...

    • Zen IT || Steps to Import Capital Gain Data Using Broker Template

      Steps to Import Capital Gain Data Using Broker Template The Capital Gain module allows users to import transaction data directly through a predefined Broker Template (Excel format). This feature helps in reducing manual data entry and ensures ...

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