TDS Calculation on Salary in Excel | How to Deduct Monthly TDS from Salary and Create Pay Slip

Section 192 of Income-tax Act puts an obligation on employer to deduct tax at the time of making payment of salary to employee.

This video will show you how to calculate TDS amount on salary in excel sheet in very simple way. You can also see how to generate pay slip in excel.

If you have any query you can ask in comment.

Watch other useful video:-

How to Calculate HRA with Example

GST Reconciliation in excel

Prepare TDS return guide

Download TDS Certificate from Traces

Subscribe to get more video like this

[simpleirfan]

What about there's a one time bonus?

[fuytgkj]

In the calculation of HRA Exemption 10% Of Basic+Dearness allowance should be taken. But in your video you are taking only Basic pay. Which is correct

[sambarvada]

Can we get a link for the template, the one mentioned in comments route to a website.

[manishsurve]

How to divide monthly TDS of employee if he worked less than standard working days??