Need a Simple Spreadsheet for Tax Calculation Using Salary and Investment Details?

Does anyone have a spreadsheet that can be used for tax calculation by entering the salary components and investment details?

Thanks,
Monoswi

Hi,

I am attaching a file which gives you a comprehensive calculation of tax. I hope this serves your purpose.

Regards,
Abhilash

Hi Abhilash,

Thank you for posting such an informative Excel sheet for tax calculation. Could you please explain what TDS is in the sheet and how it is computed?

Regards,
Abhishek Srivastava

Hi Abhishek,

The TDS in the sheet represents the amount of tax you would like to deduct for each of the employees in the months listed. Typically, the total tax payable is equally divided across all the months. However, in some companies, tax is deducted in three installments in the months of January, February, and March.

Please let me know if you have any questions.

Regards,
Abhilash