Excel import - Tax Rate should be numeric

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 cell or a cell range (Rate at which tax deducted (423) )



On the Home tab, select Number from the drop-down.




Right-click the cell or cell range, select Format Cells… , and select Number.

Hope This Helps 

    • Related Articles

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

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

    • TDS || Excel export and Import Procedure

      To reduce complications of data entry in TDS software, a facility has been provided where the user can import data through excel and can export data in excel. The process below explains Data import and export through excel in TDS software. Excel ...

    • 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 || Correction → Excel export and Import Procedure

      The procedure below outlines the data import and export through Excel in the TDS software, along with the correction process: To initiate a correction, first download and import the consolidated file into the software. To do so, click on "Click Here ...