Simplifying ESI-PF Calculations: How One Excel Sheet Automates Your Monthly and Annual Tasks

Hi All,

I have attached an Excel sheet that integrates all ESI-PF based statutory preparations on a monthly and annual basis. The interesting part of the Excel Sheet is that it requires only one data entry point. This data is then automatically referenced in all other necessary places. I am continuously working on improving its automation.

Please feel free to get in touch with me for the implemented version of the same.

Regards,
Anand

Hello Anand,

The Excel sheet you have prepared was good, but if the Excel sheet would include only calculations of PF & ESI, that would be more useful.

Cheers!
Prasad

Try using these Excel sheets for various purposes.

Hi,

This is Priya. I want to learn the calculation of salary and other deductions made for an employee in the industry. Please help me out to improve and learn more on this part.

Regards,
Priyananjayyanamath

Hi, I am Rakesh. Can anyone help me with where to deposit PF, ESIC, and PT? Where are the challans available, and how should the challans be filled? In whose name should the deposits be made, and should they be done monthly or yearly?

Please find the attached file for all forms. For any clarification, feel free to write or discuss.

Regards,
Prasenjit Mitra
[Phone Number Removed For Privacy Reasons]

Hi, I am Vamsi. Can anyone help me by providing easy formulas for PF, ESI, and PT calculation? I know the rates, but calculating salaries for around 900 employees and checking whether PF, ESI, and PT are correct for each employee is becoming tough. I need an IF condition formula or any easy formula for calculation and setting conditions. For example, if an employee is earning ₹16,000/- P.M, then ESI should be zero, and if they are earning ₹15,000/-, then ESI should be 1.75% on ₹15,000/-. I require one formula that can be applied to all employees. I hope this is understandable to solve my issue.