I have Attached PF & ESI CALCULATION SHEET EXAMPLE
PF Calculation Sheet | Month | 31 | |||||||||||
S.No. | P.F. Code | Employee Name | Gross Salary | Working Days | Basic Salary | Employee Contribution | Employers Contribution | Total Employers Contribbution | |||||
E.P.F. | E.P.F. | F.P.F. | E.P.F. + F.P.F. | ||||||||||
1 | 10000 | 31 | 5000 | 600 | 183 | 417 | 600 | This is the general method which | |||||
2 | 10500 | 28 | 4742 | 569 | 174 | 395 | 569 | everyone should applies according | |||||
3 | 8000 | 31 | 4000 | 480 | 147 | 333 | 480 | to PF authority. | |||||
4 | 7000 | 31 | 3500 | 420 | 128 | 292 | 420 | after this calculation you have to | |||||
5 | 5500 | 31 | 2750 | 330 | 101 | 229 | 330 | calculate 1.61 % admin, inspection etc. charges | |||||
6 | 15200 | 31 | 7600 | 912 | 279 | 633 | 912 | by employer side. | |||||
7 | 16000 | 31 | 8000 | 960 | 294 | 666 | 960 | and which you have to fill in PF Challan | |||||
8 | 8500 | 30 | 4113 | 494 | 151 | 343 | 494 | ||||||
9 | 5500 | 31 | 2750 | 330 | 101 | 229 | 330 | Account No. 1 | 12 % + 3.67 % | 23,839 | |||
10 | 4600 | 31 | 2300 | 276 | 84 | 192 | 276 | Account No. 2 | 1.10% | 1,673 | |||
11 | 4500 | 31 | 2250 | 270 | 83 | 187 | 270 | Account No. 10 | 8.33% | 12,673 | |||
12 | 12500 | 31 | 6250 | 750 | 229 | 521 | 750 | Account No. 21 | 0.50% | 761 | |||
13 | 13000 | 31 | 6500 | 780 | 239 | 541 | 780 | Account No. 22 | 0.01% | 15 | |||
14 | 13000 | 31 | 6500 | 780 | 239 | 541 | 780 | 38,961 | |||||
15 | 11500 | 31 | 5750 | 690 | 211 | 479 | 690 | ||||||
16 | 11500 | 31 | 5750 | 690 | 211 | 479 | 690 | ||||||
17 | 10500 | 31 | 5250 | 630 | 193 | 437 | 630 | ||||||
18 | 11000 | 31 | 5500 | 660 | 202 | 458 | 660 | ||||||
19 | 11000 | 28 | 4968 | 596 | 182 | 414 | 596 | ||||||
20 | 11500 | 28 | 5194 | 623 | 190 | 433 | 623 | ||||||
21 | 10000 | 31 | 5000 | 600 | 183 | 417 | 600 | ||||||
22 | 6000 | 31 | 3000 | 360 | 110 | 250 | 360 | ||||||
23 | 44000 | 31 | 22000 | 2640 | 807 | 1833 | 2640 | ||||||
24 | 25000 | 31 | 12500 | 1500 | 459 | 1041 | 1500 | ||||||
25 | 20000 | 15 | 4839 | 581 | 178 | 403 | 581 | ||||||
26 | 16500 | 23 | 6121 | 735 | 225 | 510 | 735 | ||||||
322300 | 152127 | 18256 | 5583 | 12673 | 18256 | ||||||||
Click Here To Download Pf & Esi Calucation Sheet
Mail to HR for PF Withdrawal with Sample
Whenever a company announces employee training session for skills development then it is supposed to…
If you are planning to immediately resign from your job but you can have your…
If you have been invited to serve in an honorary position at any institution and…
Violating the policy of the company will not be accepted by any organization and if…
Whether it is poor performance or unprofessional behavior that you have experienced at the restaurant…
If there is retaliation that you have observed in a particular team or department then…
View Comments
Hello Sir
I need to understand the PF & ESI cacluation for the year 2012 with a extream scenerio need your help.
Regards
Amardeep Tanwar
Hi,
Please help me with EPF calculation sheet
Regards
Kamala
Please help me with EPF calculation sheet
Hi
I want to know about ESI & PF with details and how to calculate the same.
i am at Bangalore
Daily weges how much pay contractor. Perpeson
hello i want to know ESI & pf calculation
i will help u... sent me..
dear kalpana sent mail i will clear excel sheet sent you samrj007@gmail.com
dear kamala sent mail i will clear excel sheet sent you samrj007@gmail.com
Dear Sir
Plese Provide Up to march-2015 PF & Esi Employee & Employer Caluation and PF & ESI Limet
Plese Provide Up to march-2017 PF & Esi Employee & Employer Caluation and PF & ESI Limet
dear sonia sent mail i will clear excel sheet sent you samrj007@gmail.com
HAI FRDS : PLS HELP ESI AND P CALUCATING
dear sonia sent mail i will clear excel sheet sent you samrj007@gmail.com