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
From India, Coimbatore
Acknowledge(8)
Amend(0)
23I 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
From India, Coimbatore
Acknowledge(8)+3 more
Amend(0)
Hello Anand, 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
From India, Hyderabad
Acknowledge(2)Amend(0)
From India, Hyderabad
Acknowledge(2)Amend(0)
hi, This is priya i want to learn calculation of salary and other deduction made for an employee in the industry.Plse help me out to improve and learn more on this part Regards priyananjayyanamath
From India, Bangalore
Acknowledge(1)Amend(0)
From India, Bangalore
Acknowledge(1)Amend(0)
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?
From India, Hyderabad
Acknowledge(0)Amend(0)
From India, Hyderabad
Acknowledge(0)Amend(0)
Hi Ashwini, Please find the attached file for all forms. For any clarification feel free to write or discuss. Regards, Prasenjit Mitra +91 8826726694
From India, Mumbai
Acknowledge(2)
Amend(0)
From India, Mumbai
Acknowledge(2)Amend(0)
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.
From India, Hyderabad
Acknowledge(2)Amend(0)
From India, Hyderabad
Acknowledge(2)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.
Salary Sheet & PF PT Calculation & Challan.xls
CiteHR.AI
(Fact Checked)-The PF, ESIC, and PT challans should be deposited monthly under their respective authorities' names. Challans can be accessed from the respective websites or offices. (1 Acknowledge point)