Hello,
I have to deduct the final TDS of my staff for March salary, for which I have to calculate the final TDS liability of employees. Can anyone provide me with an Excel format in which I can input data and obtain the results of the amount that I have to deduct?
From India, New Delhi
Acknowledge(0)
Amend(0)
I have to deduct the final TDS of my staff for March salary, for which I have to calculate the final TDS liability of employees. Can anyone provide me with an Excel format in which I can input data and obtain the results of the amount that I have to deduct?
From India, New Delhi
Acknowledge(0)Amend(0)
Importance of Accurate TDS Calculation
Excel formats can provide incorrect results. Also, if you deduct less than the entire salary, it will be disallowed during the scrutiny by the income tax department under section 143(3), 192(B), and 37, in conjunction with section 201(1) of the Income Tax Act. Therefore, the first step is to obtain Form 12BB from the employee. In Form 12BB, the employee will provide the necessary details for TDS calculation. You can access the format at http://www.incometaxindia.gov.in/For...TRFORM12BB.pdf.
Steps for Accurate TDS Deduction
Next, calculate the tax as per the Income Tax Act and regulations. Then, review the amount you have deducted thus far. Any remaining balance should be recovered in March. If needed, you can seek expert assistance in calculating the deductions from the website mentioned in the footnote.
From India, Kolkata
Acknowledge(0)Amend(0)
180Excel formats can provide incorrect results. Also, if you deduct less than the entire salary, it will be disallowed during the scrutiny by the income tax department under section 143(3), 192(B), and 37, in conjunction with section 201(1) of the Income Tax Act. Therefore, the first step is to obtain Form 12BB from the employee. In Form 12BB, the employee will provide the necessary details for TDS calculation. You can access the format at http://www.incometaxindia.gov.in/For...TRFORM12BB.pdf.
Steps for Accurate TDS Deduction
Next, calculate the tax as per the Income Tax Act and regulations. Then, review the amount you have deducted thus far. Any remaining balance should be recovered in March. If needed, you can seek expert assistance in calculating the deductions from the website mentioned in the footnote.
From India, Kolkata
Acknowledge(0)Amend(0)CiteHR is an AI-augmented HR knowledge and collaboration platform, enabling HR professionals to solve real-world challenges, validate decisions, and stay ahead through collective intelligence and machine-enhanced guidance. Join Our Platform.
Circular No 1-2018 Processing of income-tax returns under section 143(1) of the Income-tax Act .pdf
SALARY CALCULATOR & INCOME TAX.zip
Income Tax Calculation 2009-10 - Salaries.xls