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