Need Help with Excel Formulas for CTC and Statutory Compliance Calculations?

Dear All,

Can anyone provide an Excel sheet of all the formulas for the calculation of CTCS and statutory compliance?

Regards,
Harsha.M

Hi Harsha,

Please find the attached sheet of CTC Structure. Just check whether it is useful for you.

Regards,
Rajneesh Srivastav
Mob: 9920714522

It's good, thanks. Sorry for putting you in trouble, but I need a sheet in which, after inputting the basic salary figure, we should get:

1. Employee and employer's PF contribution figure
2. Admin charges, EDLI charges, etc.

Please help me. I want to verify it with the sheet I have created. Thank you in advance.