Re: Pf Calculation Sheet In Excel - Xls Download

Dear All,

It would be a great help for me if someone could provide me with the calculation procedures for PF, ESI, and gratuity in Excel sheets.

Thanks,
Payal

Hi Payal,

ESI is contributed from both sides by the Employee and the Employer. It is calculated based on the Gross salary per month, with a maximum ceiling of Rs. 10,000 per month. The contribution from both sides is as follows:

Employee Side - 1.75% of gross/month
If the gross salary of an employee is Rs. 8,000 per month, the ESI contribution would be 8,000 * 1.75% = Rs. 140.

Employer Side - 4.75% of gross/month
The ESI contribution would be 8,000 * 4.75% = Rs. 380.

On the other hand, PF is contributed at a rate of 12% of the basic salary only from both sides, the employee as well as the employer.

Regards,
Amit Seth.

Hi friend,

I am enclosing herewith an Excel sheet with formulas and examples. It will help you to get a clear idea and also assist you in your work.

Thanks,
GrHrm

Dear Payal,

Regarding the Excel sheet provided by the HR team, please apply a condition that if Gross > 10000, ESI contribution is zero. This modification will enable the system to automatically assign a zero value for individuals with a salary exceeding Rs. 10000.

Truly Yours,
Kumar H. P

Dear Amit,

I have a clarification about the below line as quoted by you. If I am not wrong, please confirm for me: is the Gross limit the maximum above which the employee can opt for PF? I mean, is it similar to the limit of the basic salary of Rs 6,500? Please clarify this for me.

PF is calculated based on the Gross salary per month, with a maximum ceiling of Rs 10,000 per month.

Regards,
Amith R.

Dear Amith,

Please go through the mentioned line once again. ESI is contributed from both sides - employee as well as employer. It is calculated based on the gross salary per month, with a maximum ceiling of Rs. 10,000 per month. I hope it is clear now at your end.

Regards,

Amit Seth.

Hi,

ESIC challan and calculation for you.

Dear Sir,

I have one doubt regarding pension. According to the formula, the pension is calculated in this manner: last drawn wages x no. of years of service / 70. However, I would like to know more about that 70.

Please clarify my doubt.

With Regards,
K. Ravi Kumar
E-mail: kasinaravikumar@gmail.com
Ph: 09989111149

Hi,

PF & ESI Calculation

PF: 12% of the Basics for Both (Employer & Employee). PF Calculation is up to 6500 only. Anything above 6500 should not be calculated for the rest of the basic salary. Basics PF contribution is 12% for both employee and employer.

- Basics PF 12% (Employee & Employer Contribution Equal Level)
- 5000 600

ESI:
Employee Contribution = 1.75%
Employer Contribution = 4.75%

Gross Salary ESI 1.75% (Employee) 4.75% (Employer)
- 10000 175 475

For salaries above 10000, they are not eligible for ESI.

Regards,
Vinoth.R 😄

I have changed my job last year. I transferred my PF from my previous employer to the current employer's PF account. For the past few months, I have been trying to find out the status of the PF transfer. I finally got the details from my previous employer. I am doubtful that there has been a mistake, and the transferred amount is incorrect.

I worked with my previous employer from August 2003 till October 2006 and contributed x rupees towards the PF. As per my understanding, the employer should also contribute the same amount, and interest will be added to this total. However, the total amount transferred is much less. I have contacted my previous employer for details, but I doubt I will receive a proper response. Is there a way I can obtain this information from the PF office?

Thanks

Hi Amith,

How are you? I wish you a very happy Diwali. You have a lot of good information that will help me greatly.

Thanks & Regards,

Akhil
Asst. Mgr - HR & Admin

Thank you, Manoj.
Very helpful contribution. If you have any other labor law excel sheets, please share with me. I have good experience in soft skill activities, but I think in HR, I am lacking this exposure. So, I need your help to upgrade my knowledge. Please help.
Regards,
Vishal Trivedi
09825413635

During third-party verification, is there any chance that they can trace a company's name and address details?

During third-party verification, is there any chance that they can trace a company's name and address details with the PF number provided?

Hi Payal,

Please find enclosed attachment for deduction of PF and ESIC. For gratuity, this is the formula:
BASIC + DA [as applicable] * 15 * Number of years of service / 26 as per the applicable acts.

Best of luck,
Santosh

Dear All,

Please check the calculation for P.F. I think we need to calculate using the upper value of Basic & DA. Please check this and then move forward.

1. LCI0001 1921 09/18/2007 Jitendra Prasad Maurya Carpenter Highly Skilled 07/24/1979 Ram Awadh Prasad 4300 36 36 16 20 6 397 198 198 198 662 827 2,480 48 48 2,432 2,430 397 48 48 15 33 48 4 397 2.00 0.04

Sl. No. EMP. CODE DOJ NAME DESIGNATION Grade DOB Father's Name Salary OT-01/07/08 to 31/07/08 OT-01/07/08 to 31/07/08 Total OT OT<=16 Hrs in a month Site Allowance(OT>16 hours) Days Jul' 08 Days Aug' 08 Earnings Deductions Net payable salary Net payable salary (Rounded) PF Wages Employee's Contribution Employer's contribution PF Admin Charges (1.10%) EDLI Wages EDLI Charges (.5%) EDLI Admin Charges (.01%) WD WD Basic ( Conv All Site All. HRA OT Project All. Total Earning PF (12%) Reg. amt Recv. Total Deduction EPF (12%) Total EPF (3.67%) EPS (8.33%) Total

1

198 662 827 2,480 48 48 2,432 2,430 397 48 48 15 33 48 4 397 2.00 0.04

Corrected and formatted the text for better readability.

Hi,

I have to design a questionnaire on Compensation for management trainees. If anyone has a format, please provide. It would be really helpful.

Dear friends,

Please help me with this issue. I joined a company called Elcome as a network engineer, and at that time, my PF number was MH-95817-A-187. However, after 6 months, I was transferred to another company called Elcosoft, where my probation period was extended, and my payroll details were changed. At this time, a new PF number, xxxxxxxxx-026, was assigned to me.

Now, the previous company, Elcome, is not part of Elcosoft anymore. They have provided me with a new PF number. Please guide me on how I can confirm that my PF is not being mishandled by the company.

Please let me know the percentage of contribution in PF from both the employer and employee sides, as well as the percentage of the employer's contribution to the pension scheme. Thank you.

Please let me know about the different forms required for ESI and PF submissions. Additionally, I would also like information on various acts like Bonus and Gratuity.

Hi all,

I want the details of the employer contribution in PF, including administrative charges and all. Can anybody guide me on that?

Thank you!

Dear Amit,

I am working as HR and I want a different kind of performance evaluation system or process.

Kindly help me out on the same. It's very urgent; we have to present to our management in the next 2 days.

Awaiting your valuable feedback.

Regards,
Ravi

Hi, my name is Archana. I have just joined this forum. Could someone help me understand what 8.33% is related to in PF calculation? If PF calculation involves both 12% from the employee and employer side, please assist me. 🤔

ESI is contributed from both sides, by the employee as well as the employer. It is calculated based on the gross salary per month; if it is 10,000 Rs./month or less, then ESIC is applicable.

The contribution from both sides is as follows:

Employee Side - 1.75% of gross per month. So, if an employee's gross salary is 10,000/month, the ESI contribution would be 10,000 * 1.75% = ### Rupees per employee.

Employer Side - 4.75% of gross per month. The ESI contribution would be 10,000 * 4.75% = ### Rupees per employee.

On the other hand, PF is contributed at a rate of 12% of the basic salary from both the employee and the employer.

The employer's PF breakdown is 3.67% for Provident Fund and 8.33% for the pension fund as of January 8, 2009.

Regards,
Gopal

Whereas PF is contributed at 12% of the basic salary from both the employee and the employer.

Employer PF breakdown is 3.67 for Provident Fund and 8.33 will be for the pension fund as of January 8, 2009.

This is okay, I think.

Regards,
Gopal

Dear All,

Can you please tell me whether the Overtime Allowance is to be included while calculating the ESI? For example, an employee is getting Rs. 8000/- as Gross Salary, and his Overtime Allowance is Rs. 1000/-. In this case, do we have to include the Overtime Allowance to calculate the ESI for both Employee's and Employer's contributions? Please clarify, and if you have any proof for this, please send it to my email ID mentioned below.

Regards, P.K. Sudarsan
[Login to view]

Hi, can anyone show me how the salary is calculated in the Excel sheet? I have a doubt. Please, can anyone show me in the Excel sheet.

Hi all,

I'm a new member. My name is Pramod :-P. Please find attached a formula sheet for your reference.

Dear All,

It would be a great help for me if someone can provide the calculation procedure for service tax, payroll taxation, and returns in Excel sheets.

Thanks,
Gururaju Acharya

Hi friends,

Here, I am attaching the PF calculation format. It is useful to easily determine the PF amount.

Regards,
Nageswararao

Hope it will help you.

Pradhuman Singh

Hi,

It would be much helpful for me if someone could provide me with the calculation procedure of Gratuity and its conditions.

Regards,
Salman

Hi Dear All,

Please give me clarification regarding whether PF is payable after deducting LOP or not. Because the law states to charge PF on the amount paid to the employees, i.e., Basic + DA + any allowance - LOP * 12%. Please clarify in this regard.

Regards,
Razik
Kerala

Hi all,

I am a new member. I would like to know the current balance of EPF accumulation along with the interest accrued. Is there any calculator to determine the above if I know the opening balance and the monthly contribution? Please help me.

Hello Sir/Madam,

I have worked for 14 months at Gupta Equities Pvt Ltd, and my PF amount for one side is 780, and for the other side, I have my PF of 8 months. Could you please tell me how much amount I should get from the PF Office? I submitted the PF Form after 11 months. How much interest should I get? Kindly send me the amount and the formula sheet.

My email id: govindmundhra2050@gmail.com

Hello, sir! I want to know about voluntary provident fund. Is there any fixed percentage of it, and how is it calculated? Please, sir, reply soon.

Dear Friends,

Please let me know if the ESI ceiling amount has now changed from 10,000 to 15,000. What is the calculation percentage now?

One more question: If a person has a basic pay higher than 6,500 and wants to deduct their PF, what is the procedure?

Dear Sirs,

Has there been any confirmation from ESI regarding an increase in the wage limit from ₹10,000 to ₹15,000?

Regards,
Durga S. Prasad

Hi,

Thanks for sharing valuable knowledge, but I have some doubts. Please clarify:

1. If any employee is paid a bonus on a half-yearly basis, in this case, is ESI deductible on the bonus or not?
2. If an employee is awarded a bonus quarterly, in this case, is ESI applicable on the bonus?

Please also send me the reply to amar188taksh@gmail.com.

Thanks with Regards,
Taksh

Hi,

Can anyone help me in creating a standardized leave application form to request for paid leave (PL), casual leave (CL), and sick leave (SL)?

Subject: Bonus Received Letter Format

Dear All,

Could you please provide a sample format for a bonus letter that effectively emphasizes recognizing the contributions made by employees and rewarding them accordingly?

Thank you,
Durga

Hi Payal,

In my opinion, the EPF is calculated at 12% of Basic, and that amount is then matched by the employer. For example, if the EPF amount is "X," the total deposited into the employee's account would be "X+X." Every organization with more than 20 employees must be registered for EPF.

Regarding ESI, employees with salaries between 6500 and 10,000 fall under ESI. The deductions are as follows:
- Employees' contribution: 1.75% of Basic
- Employers' contribution: 4.75% of Basic

For employees with a Basic salary exceeding 10,000, PF is optional.

Regards,
Ashi

Dear Payal,

Now this limit has been changed to Rs. 15,000. Any employee whose gross is under Rs. 15,000 will be liable for ESI deductions.

In the Excel sheet provided by GRHRM, please apply a condition that if Gross > Rs. 10,000, ESI contribution is zero. This will ensure that it directly shows a zero value for people with a salary greater than Rs. 10,000.

Truly Yours,
Kumar H.P

The Excel sheet is incorrect because the employer's contribution to PF is not 12%. Along with 12%, you need to add 1.61% as admin charges. The PF ceiling is 6500, not 10,000, and the ESIC ceiling is 15000.

Please provide information as follows for one day as per central government rules in Madhya Pradesh for B & C zones:

- Basic: 231 for B zone & 186 for C zone
- EPF employee contribution
- EPF Employer contribution
- ESIC employee contribution
- ESIC employer contribution
- Workman compensation for Zone 'C' for each employee
- January days are 31
- February days are 28

Hi, I have been working at a company for 9 months. My PF deduction is Rs. 1217, and the PF forms have been sent to the office. I would like to know how much credit is in my account.

Thank you.

Required formula for PF calculation for the salary register:
If Basic is 15000 or less than 15000 or above 15000, one formula should be applied to all these scenarios.

New unified EPF portal says to mention gross salary and EPF wages. EDLI and administrative charges to calculate on gross or EPF wages. Please confirm for employers.

To calculate salary arrears effective from April 2017, taking into account deductions such as ESIC, PF, and LOP, you can use an Excel calculator. If you have one available, please share it with me. Thank you.

Dear All,

I need a monthly salary calculator with PF and ESI only in Excel.

Simple and good information. This helped me understand various accounts in the PF challan to be filled and their percentages.

Thanks & Regards

Dear sir,

Can you please explain to me how to calculate PMPRY workings?

I am receiving a salary of Rs 18,000 per month and have been contributing to my PF every month from 2014 to 2018. After completing 10 years, I would like to know how much pension I am eligible for. Please calculate and provide the information.

I want some information regarding ESIC. Which areas to apply ESIC to the company? I know, for example, KM range from ESIC hospitals. Please share the written proof for my help in social compliance.

Suresh Makwana
9824912447