Tax Rate should 2/3 digit after decimal

TDS || Excel Import Error → Tax Rate should 2/3 digit after decimal


Excel Import Error → "Tax Rate should 2-3 digit after decimal"

      

Root Cause of the error →
The error occurs in the Zen TDS Excel import due to an incorrect tax rate format. The tax rate must be specified with exactly two decimal places (e.g., 5.00 or 5.12).

      

Solution →
  1. Open the Excel template and navigate to the "Deductee Detail" sheet.
  2. Locate the column "Rate at which tax deducted (423)".
  3. Select the relevant cell(s) or range of cells.
  4. On the Home tab, go to the Number Format drop-down and select Number.
  5. Right-click the selected cell(s), choose Format Cells…, and then:
    1. Select Number under the Category section.
    2. Set Decimal places to 2, as required.
      
  1. Click OK to apply the changes.
  2. Save the file and reattempt the import process in Zen TDS.
Following these steps will ensure compliance with the required tax rate format, preventing import errors.

    • Related Articles

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

    • Income Tax || TDS Details

      To enter TDS/TCS details in the software, please follow the process outlined below: Steps for Manual Entry of TDS/TCS Details : Navigate to "Transactions → Tax Detail". By default, the TDS Details section is selected. If you're entering details ...

    • TDS || E-Filing → Invalid tax deducted amount.Enter valid tax deducted amount.

      Root Cause of the Error → This issue arises from entering incorrect amounts in the TAX Amount (Income Tax) relative to the Amount Paid/Credited. If the client is using the Excel Import option, please note that the "Amount of Payment ( Rs.) (419)", ...

    • ExpressTDS || Excel Import Error → Challan Not Getting Mapped

      Step 1: Log In and Access Deductor Master Visit https://www.expresstds.com/ and log in with your credentials. Navigate to the Deductor Master section. Select the deductor or company for which the correction return needs to be filed. Step 2: Locate ...

    • 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 → Validate Date Format: Verify that dates adhere strictly to the format "dd/MM/yyyy". ...