On Screen enquiry of TDS deductions , challans and TDS certificate with several filter tools

FAQ'S Regarding TDS:-

1.What is eTDSXL?

Sol. eTDSXL is a light weight software to prepare the annual returns as per NSDL norms for section 24,26 and 27 in electronic format. This is a Microsoft excel based software and requires Microsoft Excel 97 onwards application.

2. When I open any excel file it shows Invalid! or blank in the place of Serial No.?

Sol. Please close all files in excel. Open Microsoft Excel Select Menu Tools->Macro->Security and Select the option Medium in the place of High. Also remember to select "Enable Macro" option while opening any of the eTDSXL file.

3. In Form 26 after entering all the information why I receive the error of "Missing Challan Information" in problem list?

Sol. While entering data please ensure the following things

#The value in "Date of payment to credit of Central Govt." column in deductee information is same as the value mentioned in the column "Date of Transfer Voucher / Challan" in Challan Payment sheet.

#The Value mentioned in "Bank-Branch Code" column in deductee information is same as the value mentioned in the column "Bank-Branch Code" in Challan Payment sheet.

#The Value mentioned in "Challan No given by Bank / Tr. Voucher No." column in deductee information is same as the value mentioned in the column "Challan No given by Bank / Tr. Voucher No." in Challan Payment sheet.

4. Why I am getting error like Invalid Rate of TDS?

Sol. Please ensure that the amount mentioned in deductee details sheet in column "Rate at which TDS deducted" the TDS rate is restricted to 2 i.e. 2.13% is correct where as 2.125% is not allowed.

5. How to enter a data in Form 24 Excel File?

Sol. Form 24 is divided into 4 different sheets

Deductor Information:

Enter the information about Assessee / Employer. This information is mandatory.

Deductee Information:

Enter the master information of the employee like Name, PAN, Join/Resignation dates etc. along with salary details. Here enter the Gross Salary amount in column No. 105. In column No. 106 enter the Taxable amount of u/s 10 allowance.

Perquisites Information:

Enter the details of the perquisites given to employee. You have to take care of the Sr. No. and Name that you have mentioned in this Sheet and it should be same as mentioned in Deductee Details sheet.

Challan Payment:

Mention here the challan details by which you made the payment to the Income Tax department on behalf of the Employee. the Challan date should not be more than the date of your computer. Here you may enter the consolidated details of challan.

Additional Information:

If you are generating form 16 from eTDSXl software then you have to enter the information in this sheet. This sheet allows you to enter the information about income from other sources, Under chapter 88 investment details, house property etc. As well as you have to enter the bifurcation of Challan payments in Challan Information Sheet.

6. Why it displays error "Run time error 13 Type mismatch when I click on Step 4 Button in startup sheet?

Sol. Please ensure that you have entered the 0 (zero) in place of blanks where the amounts are not applicable.

7. What to do if the error comes as "3089|Invalid Flag For Tax Payable/Refundable", "3070|Invalid Tax Payable or Refundable/Not equal to Col. 225-228 (Old)/Not equal to Col. 226-230 (New)" and 990| ERROR_INVALID_RECORD _LENGTH in error file generated by NSDL utility?

Sol. This error normally occurs when your value in Net Tax Payable (226) column is not matching with Total income Tax deducted at source (230) i.e. TDS Income Tax+ TDS Surcharge + Education Cess.