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 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 ...
    • 15G/15H - Data not importing through excel

      15G/15H - Data not importing through excel  When importing 15G/15H data from excel, the message of import succesfully comes but the data is not imported. Possible Solution : -  If the UIN number entered in the excel sheet is more than 10 digits, then ...
    • How to enter different tax rate in single invoice (GSTR-1 > B2B Invoice) through excel sheet?

      Solution: Step 1: Login on GST Software Application. Step 2: Select Company, Financial Year, Filing Type as GSTR-1 and Tax Period and then Go to Proceed.              Step 3: Here Click on - Download Sample Template.              Step 4: Once the ...
    • Express TDS - Deductee/employee master import from excel

      Express TDS - Deductee/employee master import from excel  Step 1 - Go into deductee master and click on import deductee  Step 2- Now click on "downlaod excel template " Enter detail in excel template  you are required to browse the excel file  from ...
    • 3CD annexure export / import process from TDS to Income Tax

      Process to export / import 3CD Annexure from TDS to Income Tax  This process helps the user to export/ import the 3CD details entered for a particular PAN in TDS Software to the Income Tax Software using an excel template format easily. Process to ...