Dear All,
I am submitting herewith the combined sheet of PF calculation and challan in Excel format as per the requirement of some HR fellows. I hope it will be useful for you.
Provident Fund:
Note: PF is always calculated on BASIC + DA.
Total PF contribution: 25.61%
Employers Contribution:
12% (3.67% PF + 8.33% Pension) + 1.61% Administrative charges (1.10% Adm charges + 0.50% EDLIF Charges) = 13.61%
Note: Pension value of 8.33% is always constant, whereas PF value can vary depending on the Basic & DA.
Please study the following cases:
Case 1:
If Basic + DA = 6500, then the contribution will be as follows: Pension 8.33% (541) and PF value (239)
Case II:
If Basic + DA > 6500, then the contribution will be as follows: Pension 8.33% (constant value 541) and PF will be: excess amount - 541. For example, if Basic + DA is 12000, then Pension will be 541/- and PF will be 899/-
(calculation: 12000*12% - 541 = 899/-)
Case III:
If Basic + DA < 6500, then the contribution will be as follows: Pension 8.33% and PF 3.67% of basic + DA
Example: if basic is 5500, then Pension will be 5500*8.33% = 458 and PF will be 5500*3.67% = 202/-
Employees Contribution:
12% goes to PF amount only.
PF Calculation Sheet:
1. Mention your location name if existing
2. Number of employees eligible for PF
3. PF salary - Basic + DA amount
4. Employees contribution - 12% fixed value
5. Employers contribution for PF Variable (calculation as defined above)
6. Employers contribution - 8.33% fixed value
7. PF > 6500 means Basic + DA > 6500 (See Case II)
Some other useful info regarding PF:
Form No. Purpose
13 (revised) - For transferring the Provident Fund account of a member from one establishment to another establishment covered under the act/scheme
19 - To be submitted by a member to withdraw his Provident Fund dues on leaving service/retirement/termination.
10-C - For claiming - Refund of Employer share (with form no.19)
10-D - To be submitted by the first claimant i.e., member or widow/widower or orphan nominee as the case may be
31 - For the use of Provident Fund members to avail advances/withdrawals as provided in the scheme
Rate of Interest: 8.5%
Note: If you have any confusion regarding the formulas provided, please let me know. If still confused, I will submit a demo sheet. Please revert back to me.
Thank you.
From India, Pune
Acknowledge(0)
Amend(0)
73I am submitting herewith the combined sheet of PF calculation and challan in Excel format as per the requirement of some HR fellows. I hope it will be useful for you.
Provident Fund:
Note: PF is always calculated on BASIC + DA.
Total PF contribution: 25.61%
Employers Contribution:
12% (3.67% PF + 8.33% Pension) + 1.61% Administrative charges (1.10% Adm charges + 0.50% EDLIF Charges) = 13.61%
Note: Pension value of 8.33% is always constant, whereas PF value can vary depending on the Basic & DA.
Please study the following cases:
Case 1:
If Basic + DA = 6500, then the contribution will be as follows: Pension 8.33% (541) and PF value (239)
Case II:
If Basic + DA > 6500, then the contribution will be as follows: Pension 8.33% (constant value 541) and PF will be: excess amount - 541. For example, if Basic + DA is 12000, then Pension will be 541/- and PF will be 899/-
(calculation: 12000*12% - 541 = 899/-)
Case III:
If Basic + DA < 6500, then the contribution will be as follows: Pension 8.33% and PF 3.67% of basic + DA
Example: if basic is 5500, then Pension will be 5500*8.33% = 458 and PF will be 5500*3.67% = 202/-
Employees Contribution:
12% goes to PF amount only.
PF Calculation Sheet:
1. Mention your location name if existing
2. Number of employees eligible for PF
3. PF salary - Basic + DA amount
4. Employees contribution - 12% fixed value
5. Employers contribution for PF Variable (calculation as defined above)
6. Employers contribution - 8.33% fixed value
7. PF > 6500 means Basic + DA > 6500 (See Case II)
Some other useful info regarding PF:
Form No. Purpose
13 (revised) - For transferring the Provident Fund account of a member from one establishment to another establishment covered under the act/scheme
19 - To be submitted by a member to withdraw his Provident Fund dues on leaving service/retirement/termination.
10-C - For claiming - Refund of Employer share (with form no.19)
10-D - To be submitted by the first claimant i.e., member or widow/widower or orphan nominee as the case may be
31 - For the use of Provident Fund members to avail advances/withdrawals as provided in the scheme
Rate of Interest: 8.5%
Note: If you have any confusion regarding the formulas provided, please let me know. If still confused, I will submit a demo sheet. Please revert back to me.
Thank you.
From India, Pune
Acknowledge(0)Amend(0)
thanxxxxxx alotzzzzzzzzzzzz vijeta i hv designed it for easy calculation.....any confusion can be revert back to me....
From India, Pune
Acknowledge(1)
Amend(0)
From India, Pune
Acknowledge(1)Amend(0)
Provident Fund:
Note: PF is always calculated on BASIC + DA.
Total PF contribution: 25.61%
Employers' Contribution: 12% (3.67% PF + 8.33% Pension) + 1.61% Administrative charges (1.10% Admin charges + 0.50% EDLIF Charges) = 13.61%
Note: Pension value of 8.33% is always constant, whereas PF value can vary depending on the Basic & DA.
Please study the following cases:
Case 1: If Basic + DA = 6500, then the contribution will be as follows: Pension 8.33% (541) and PF value will be (239).
Case II: If Basic + DA > 6500, then the contribution will be as follows: Pension 8.33% (constant value 541) and PF will be the existing amount - 541. For example, if Basic + DA is 12000/-, then it will be like this: Pension will be 541/- and PF will be 899/- (calculation: 12000*12% - 541 = 899/-).
Case III: If Basic + DA < 6500, then the contribution will be as follows: Pension 8.33% and PF 3.67% of Basic + DA. For example, if Basic is 5500/-, then Pension will be 5500*8.33% = 458 and PF will be 5500*3.67% = 202/-.
Employees' Contribution: 12% goes to PF amount only.
PF Calculation Sheet:
1. Mention your location name if existing.
2. Number of employees eligible for PF.
3. PF salary, which is Basic + DA amount.
4. Employees' contribution, 12% fixed value.
5. Employers' contribution for PF, variable (calculation as defined above).
6. Employers' contribution, 8.33% fixed value.
7. PF > 6500 means Basic + DA > 6500 (See Case II).
Note: Formulas are given in the sheet. Please ask where you are confused, and if still confused, then I will submit a demo sheet… please revert back to me.
Thank you.
From India, Pune
Acknowledge(4)
Amend(0)
Note: PF is always calculated on BASIC + DA.
Total PF contribution: 25.61%
Employers' Contribution: 12% (3.67% PF + 8.33% Pension) + 1.61% Administrative charges (1.10% Admin charges + 0.50% EDLIF Charges) = 13.61%
Note: Pension value of 8.33% is always constant, whereas PF value can vary depending on the Basic & DA.
Please study the following cases:
Case 1: If Basic + DA = 6500, then the contribution will be as follows: Pension 8.33% (541) and PF value will be (239).
Case II: If Basic + DA > 6500, then the contribution will be as follows: Pension 8.33% (constant value 541) and PF will be the existing amount - 541. For example, if Basic + DA is 12000/-, then it will be like this: Pension will be 541/- and PF will be 899/- (calculation: 12000*12% - 541 = 899/-).
Case III: If Basic + DA < 6500, then the contribution will be as follows: Pension 8.33% and PF 3.67% of Basic + DA. For example, if Basic is 5500/-, then Pension will be 5500*8.33% = 458 and PF will be 5500*3.67% = 202/-.
Employees' Contribution: 12% goes to PF amount only.
PF Calculation Sheet:
1. Mention your location name if existing.
2. Number of employees eligible for PF.
3. PF salary, which is Basic + DA amount.
4. Employees' contribution, 12% fixed value.
5. Employers' contribution for PF, variable (calculation as defined above).
6. Employers' contribution, 8.33% fixed value.
7. PF > 6500 means Basic + DA > 6500 (See Case II).
Note: Formulas are given in the sheet. Please ask where you are confused, and if still confused, then I will submit a demo sheet… please revert back to me.
Thank you.
From India, Pune
Acknowledge(4)Amend(0)
Dear [Recipient's Name],
Thank you for the informative content you provided. It is straightforward and concise, making it accessible to the majority of people. I have a query and would appreciate your assistance. Could you please explain the calculation of the pension offered by the RPFC for an employee who retires upon reaching the age of 58, with a basic salary of Rs. 6500 and a DA of Rs. 1400?
I would be grateful for your response.
Many thanks and regards,
Bhupesh Joshi
From India, Mumbai
Acknowledge(0)Amend(0)
Thank you for the informative content you provided. It is straightforward and concise, making it accessible to the majority of people. I have a query and would appreciate your assistance. Could you please explain the calculation of the pension offered by the RPFC for an employee who retires upon reaching the age of 58, with a basic salary of Rs. 6500 and a DA of Rs. 1400?
I would be grateful for your response.
Many thanks and regards,
Bhupesh Joshi
From India, Mumbai
Acknowledge(0)Amend(0)
Hi Tiwari,
Thanks a lot for the excellent information you provided. It is clear and easy to follow, making it accessible for new individuals.
Once again, I appreciate you sharing the details of PF calculation.
Regards,
Venu
From India, Hyderabad
Acknowledge(0)Amend(0)
Thanks a lot for the excellent information you provided. It is clear and easy to follow, making it accessible for new individuals.
Once again, I appreciate you sharing the details of PF calculation.
Regards,
Venu
From India, Hyderabad
Acknowledge(0)Amend(0)
hi venu.really its a very motivative for me.........hope ths wil be useful for u all..........thanx a lotzzzzzzzzzz
From India, Pune
Acknowledge(1)
Amend(0)
From India, Pune
Acknowledge(1)Amend(0)
Our business is in steel manufacturing and ingot division. I am interested in understanding the importance of providing workers with proper body protection from heat and flying metals. Specifically, I would like to know if it is necessary to supply leather aprons with full sleeves. What are the regulations regarding this matter?
Regards,
Debajit Roy
From India, Mumbai
Acknowledge(0)Amend(0)
Regards,
Debajit Roy
From India, Mumbai
Acknowledge(0)Amend(0)
Dear All,
This is chandra sekhar, (HR/ Dept.)
Thanks for pf calcu. sheet.to Mr.Abshiek tiwari, I had made sample of sheet with has been used for our company in a sample format purpose i hope you like this & it may helpfull to all.
Regards,
Chandra sekhar
HR.executive
(ROSHNI DEVELOPERS/ INDU GROUP)
9848335631/ 9963144154
From India, Hyderabad
Acknowledge(1)Amend(0)
This is chandra sekhar, (HR/ Dept.)
Thanks for pf calcu. sheet.to Mr.Abshiek tiwari, I had made sample of sheet with has been used for our company in a sample format purpose i hope you like this & it may helpfull to all.
Regards,
Chandra sekhar
HR.executive
(ROSHNI DEVELOPERS/ INDU GROUP)
9848335631/ 9963144154
From India, Hyderabad
Acknowledge(1)Amend(0)
Dear All,
I am submitting herewith the combined sheet of PF calculation and challan in Excel format as per the requirement of some HR colleagues. I hope it will be useful for you.
Provident Fund:
Note: PF is always calculated on BASIC + DA.
Total PF contribution: 25.61%
Employers Contribution: 12% (3.67% PF + 8.33% Pension) + 1.61% Administrative charges (1.10% Admin charges + 0.50% EDLIF Charges) = 13.61%
Note: The Pension value of 8.33% is always constant, while the PF value can vary depending on the Basic & DA.
Please study the following cases:
Case 1: If Basic + DA = 6500, then the contribution will be as follows: Pension 8.33% (541) and PF value (239).
Case II: If Basic + DA > 6500, then the contribution will be as follows: Pension 8.33% (constant value 541) and PF will be: excess amount - 541. For example, if Basic + DA is 12000, then it will be as follows: Pension will be 541 and PF will be 899. (Calculation: 12000 * 12% - 541 = 899)
Case III: If Basic + DA < 6500, then the contribution will be as follows: Pension 8.33% and PF 3.67% of Basic + DA. For example, if the basic is 5500, then Pension will be 5500 * 8.33% = 458 and PF will be 5500 * 3.67% = 202.
Employees Contribution: 12% goes to PF amount only.
PF Calculation Sheet:
1. Mention your location name if existing.
2. Number of employees eligible for PF.
3. PF salary, this is Basic + DA amount.
4. Employees contribution of 12% fixed value.
5. Employers contribution for PF variable (calculation as defined above).
6. Employers contribution of 8.33% fixed value.
7. PF > 6500 means Basic + DA > 6500 (See case II).
Note: Formulas are provided. Please ask if you are confused, and if you are still confused, I will submit a demo sheet. Please revert back to me.
Thank you,
Darshan Palkar
Pune
---
Dear Sir,
I want to know how the final amount of PF is calculated, including the interest rate.
My last basic was 6000, and PF was 12%, i.e., 720. I worked there for 9 months.
Then, I want to calculate the final PF amount that I will get as I have submitted the PF withdrawal form.
Please inform me if you know this.
Thanks for your posting.
Darshan Palkar
Pune
From India, Pune
Acknowledge(0)Amend(0)
0
0
I am submitting herewith the combined sheet of PF calculation and challan in Excel format as per the requirement of some HR colleagues. I hope it will be useful for you.
Provident Fund:
Note: PF is always calculated on BASIC + DA.
Total PF contribution: 25.61%
Employers Contribution: 12% (3.67% PF + 8.33% Pension) + 1.61% Administrative charges (1.10% Admin charges + 0.50% EDLIF Charges) = 13.61%
Note: The Pension value of 8.33% is always constant, while the PF value can vary depending on the Basic & DA.
Please study the following cases:
Case 1: If Basic + DA = 6500, then the contribution will be as follows: Pension 8.33% (541) and PF value (239).
Case II: If Basic + DA > 6500, then the contribution will be as follows: Pension 8.33% (constant value 541) and PF will be: excess amount - 541. For example, if Basic + DA is 12000, then it will be as follows: Pension will be 541 and PF will be 899. (Calculation: 12000 * 12% - 541 = 899)
Case III: If Basic + DA < 6500, then the contribution will be as follows: Pension 8.33% and PF 3.67% of Basic + DA. For example, if the basic is 5500, then Pension will be 5500 * 8.33% = 458 and PF will be 5500 * 3.67% = 202.
Employees Contribution: 12% goes to PF amount only.
PF Calculation Sheet:
1. Mention your location name if existing.
2. Number of employees eligible for PF.
3. PF salary, this is Basic + DA amount.
4. Employees contribution of 12% fixed value.
5. Employers contribution for PF variable (calculation as defined above).
6. Employers contribution of 8.33% fixed value.
7. PF > 6500 means Basic + DA > 6500 (See case II).
Note: Formulas are provided. Please ask if you are confused, and if you are still confused, I will submit a demo sheet. Please revert back to me.
Thank you,
Darshan Palkar
Pune
---
Dear Sir,
I want to know how the final amount of PF is calculated, including the interest rate.
My last basic was 6000, and PF was 12%, i.e., 720. I worked there for 9 months.
Then, I want to calculate the final PF amount that I will get as I have submitted the PF withdrawal form.
Please inform me if you know this.
Thanks for your posting.
Darshan Palkar
Pune
From India, Pune
Acknowledge(0)Amend(0)CiteHR.AI
(Fact Checked)-The final amount of PF is calculated based on the formula: PF amount + interest accrued. For 9 months with a basic of 6000 and 12% PF, the final amount would include the interest as per the prevailing rate at the time of withdrawal. It's advisable to check with the PF department for the exact amount. (1 Acknowledge point)
0
0
Dear Mr.Darshan, gud quest Your contri wil be like ths Empr 720/- Emp 720/- total contri 1440/- PM Note: Rate of interest on PF amount is 8.5%
From India, Pune
Acknowledge(0)Amend(0)
From India, Pune
Acknowledge(0)Amend(0)
As asked by some of my HR fellows regarding forms and rate of interest, please find the following details:
Form No. Purpose
13 (revised) - For transferring the Provident Fund account of a member from one establishment to another establishment covered under the act/scheme.
19 - To be submitted by a member to withdraw his Provident Fund dues on leaving service, retirement, or termination.
10-C - For claiming a refund of the Employer's share (with form no. 19).
10-D - To be submitted by the first claimant, i.e., member, widow/widower, or orphan nominee as the case may be.
31 - For the use of Provident Fund members to avail advances/withdrawals as provided in the scheme.
Rate of interest: 8.5%
From India, Pune
Acknowledge(0)Amend(0)
Form No. Purpose
13 (revised) - For transferring the Provident Fund account of a member from one establishment to another establishment covered under the act/scheme.
19 - To be submitted by a member to withdraw his Provident Fund dues on leaving service, retirement, or termination.
10-C - For claiming a refund of the Employer's share (with form no. 19).
10-D - To be submitted by the first claimant, i.e., member, widow/widower, or orphan nominee as the case may be.
31 - For the use of Provident Fund members to avail advances/withdrawals as provided in the scheme.
Rate of interest: 8.5%
From India, Pune
Acknowledge(0)Amend(0)
Dear Abhi, Could you tell me something about the withdrawal of PF fund. Which part can be withdrawn and what are the necessities to withdraw. Thanks & Regards Rakesh Bisht
Acknowledge(0)Amend(0)
0
0
Acknowledge(0)Amend(0)CiteHR.AI
(Fact Checked)-[response] The withdrawal of PF fund can include amounts like PF balance, pension, and interest upon certain conditions. Forms 19, 10-C, 10-D are used for withdrawal. (1 Acknowledge point)
0
0
Dear Abhisekh Sir,
I am working in the HR Department and am new to the PF field. Could you please clarify some of my doubts as follows:
1. Is there an eligibility age limit for an employee for PF contributions and Pension contributions? If so, what is the limit?
2. What about the deduction applicability of PF and Pension for employees earning more than 6500 basic + DA?
3. What about the deduction applicability of PF and Pension for employees over 58 years old?
4. Our company has no basic limit for PF remittance purposes.
Kindly help.
Regards,
Arabindo Patro
09379187533
From India, Mumbai
Acknowledge(0)Amend(0)
I am working in the HR Department and am new to the PF field. Could you please clarify some of my doubts as follows:
1. Is there an eligibility age limit for an employee for PF contributions and Pension contributions? If so, what is the limit?
2. What about the deduction applicability of PF and Pension for employees earning more than 6500 basic + DA?
3. What about the deduction applicability of PF and Pension for employees over 58 years old?
4. Our company has no basic limit for PF remittance purposes.
Kindly help.
Regards,
Arabindo Patro
09379187533
From India, Mumbai
Acknowledge(0)Amend(0)
heyii patro sure i ll send u .......asap...........nd thanx for ur appreciation...ur many queries will be solve pls read the total article..........and all other detail i ll send u .. thanx
From India, Pune
Acknowledge(0)Amend(0)
From India, Pune
Acknowledge(0)Amend(0)
Hi Abhisek, Good and very usefull for all new comers, I would apprciate if you could focus on gratuity and benefits to employees. Regards, Ravi
From India, Hyderabad
Acknowledge(0)Amend(0)
From India, Hyderabad
Acknowledge(0)Amend(0)
Dear Mr.Abhi
If an employee is willing to contribute more percentage of amount to PF up to what limit he can contribute and what is the formalities to be met if an employee willing to contribute more percentage than 12%.If an employee whose salary is more than 6500/- month and not willing to contribute for PF is there any provision available for him for doing so.If So How?
Regards
Suman
From India, Hyderabad
Acknowledge(1)
Amend(0)
0
0
If an employee is willing to contribute more percentage of amount to PF up to what limit he can contribute and what is the formalities to be met if an employee willing to contribute more percentage than 12%.If an employee whose salary is more than 6500/- month and not willing to contribute for PF is there any provision available for him for doing so.If So How?
Regards
Suman
From India, Hyderabad
Acknowledge(1)Amend(0)CiteHR.AI
(Fact Checked)-The employer can't contribute more than 12% to an employee's EPF. For an employee earning over ₹6500 who doesn't want to contribute, there's no provision. Thank you for your query. (1 Acknowledge point)
0
0
Dear Abhi,
Thank you very much for the information you have provided.
Let me introduce myself first of all. My name is Dipak. I am a postgraduate individual with a specialization in HR. I completed my post-graduation from Gujarat University. I am from Ahmedabad and recently received an assignment in a U.S. pharmaceutical company.
Thank you for the detailed information. Let's stay in touch. You can reach me at my personal email: dr54@rediffmail.com.
Thanks once again. Take care and have a happy Independence Day, happy Rakhi, and a happy weekend, buddy! :-D
From India, Ahmadabad
Acknowledge(0)Amend(0)
Thank you very much for the information you have provided.
Let me introduce myself first of all. My name is Dipak. I am a postgraduate individual with a specialization in HR. I completed my post-graduation from Gujarat University. I am from Ahmedabad and recently received an assignment in a U.S. pharmaceutical company.
Thank you for the detailed information. Let's stay in touch. You can reach me at my personal email: dr54@rediffmail.com.
Thanks once again. Take care and have a happy Independence Day, happy Rakhi, and a happy weekend, buddy! :-D
From India, Ahmadabad
Acknowledge(0)Amend(0)
Dear Abhishek,
Thank you very much for your PF calculation divisions and examples, which really helped me and cleared my long days of confusion and doubt. Once again, thank you for your help.
Regards,
Gopal.
[IMG]https://www.citehr.com/misc.php?do=email_dev&amp;email=Z29waV9pcnBtXz IwMDZAeWFob28uY28uaW4=[/IMG]
From India, Mumbai
Acknowledge(0)Amend(0)
0
0
Thank you very much for your PF calculation divisions and examples, which really helped me and cleared my long days of confusion and doubt. Once again, thank you for your help.
Regards,
Gopal.
[IMG]https://www.citehr.com/misc.php?do=email_dev&amp;email=Z29waV9pcnBtXz IwMDZAeWFob28uY28uaW4=[/IMG]
From India, Mumbai
Acknowledge(0)Amend(0)CiteHR.AI
(Fact Checked)-[response] The user's reply contains a friendly acknowledgment of the PF calculation information provided. It does not require any corrections. (1 Acknowledge point)
0
0
Hello,
Could you please let me know about the PF registration rules at the earliest?
1) Is it that if the company has a flat 20 employees - registration is mandatory irrespective of basic?
OR
2) Is it that employees whose basic is less than 6500, if such 20 employees are on the roll, then we have to register for PF?
OR
Is it that now the 6500 slab is revised to Rs. 10,000 for the IT sector?
Could you please give me details of any site which will give the latest PF rules?
Your help would be of great significance.
Thanks,
Shalene
From India, Mumbai
Acknowledge(0)Amend(0)
0
0
Could you please let me know about the PF registration rules at the earliest?
1) Is it that if the company has a flat 20 employees - registration is mandatory irrespective of basic?
OR
2) Is it that employees whose basic is less than 6500, if such 20 employees are on the roll, then we have to register for PF?
OR
Is it that now the 6500 slab is revised to Rs. 10,000 for the IT sector?
Could you please give me details of any site which will give the latest PF rules?
Your help would be of great significance.
Thanks,
Shalene
From India, Mumbai
Acknowledge(0)Amend(0)CiteHR.AI
(Fact Checked)-The Employee Provident Fund (EPF) Act mandates registration for companies with 20 or more employees, regardless of basic salary. The current threshold for mandatory registration is not linked to the basic salary amount. For the latest PF rules, refer to the official EPFO website. (1 Acknowledge point)
0
0
As per the new amendment, registration is mandatory for 10 employees. The current maximum Basic+DA limit is Rs. 6500/- per month. One can seek permission to pay above Rs. 6500/- per month. The slab for the IT sector, I believe, is the same.
Email:
From India, Ahmadabad
Acknowledge(0)Amend(0)
Email:
From India, Ahmadabad
Acknowledge(0)Amend(0)
As per the rules, if there are 10 or more employees, then registration is mandatory. The current maximum Basic+DA limit is Rs. 6500/- per month. After reaching the amount of 6500/-, the calculation will be done automatically. There are no such rules to pay above 6500/- per month because I am already working on it. Mine is a construction company, and I have prepared several sheets that are already attached to everyone subscribed to HR site. This was done by me, not by abhi.
Chandra Sekhar
HR Executive
From India, Hyderabad
Acknowledge(0)Amend(0)
0
0
Chandra Sekhar
HR Executive
From India, Hyderabad
Acknowledge(0)Amend(0)CiteHR.AI
(Fact Checked)-[response] Based on the latest Provident Fund rules, contributions are mandatory for employees with a Basic+DA limit of Rs. 6500. Contributions above this limit are not required. (1 Acknowledge point)
0
0
Hi,
Can I tell you one thing? The PF sheet has been sent by me. I am sorry to say that Abhi has posted a sample sheet. In the same vein, I have corrected and cleared the administration charges, as indicated in the proper challan copy. I have also highlighted my name in the PF wages sheet as K. Chandra Sekhar.
From India, Hyderabad
Acknowledge(0)Amend(0)
Can I tell you one thing? The PF sheet has been sent by me. I am sorry to say that Abhi has posted a sample sheet. In the same vein, I have corrected and cleared the administration charges, as indicated in the proper challan copy. I have also highlighted my name in the PF wages sheet as K. Chandra Sekhar.
From India, Hyderabad
Acknowledge(0)Amend(0)
Dear Sir,
I could not download the PF and calculation sheet. Can you help me?
essceeca
Chandu: As you mentioned that you cannot download the PF sheet, I have just sent you the attachment along with the Excel statement. Please check your email at chandu0147@gmail.com for the information. Feel free to email me with any queries.
Regards,
Chandra Sekhar
9848335631/9963144154
From India, Hyderabad
Acknowledge(0)Amend(0)
I could not download the PF and calculation sheet. Can you help me?
essceeca
Chandu: As you mentioned that you cannot download the PF sheet, I have just sent you the attachment along with the Excel statement. Please check your email at chandu0147@gmail.com for the information. Feel free to email me with any queries.
Regards,
Chandra Sekhar
9848335631/9963144154
From India, Hyderabad
Acknowledge(0)Amend(0)
pl answer to my query/ whether PF deduction is to be made under PF Misc Provision act, if the payment is less than Rs.6500/-.
Acknowledge(0)Amend(0)
Acknowledge(0)Amend(0)
Dear all Let me know how to apply pf for employees, what are all the documents we need to submit
From India, Madras
Acknowledge(0)Amend(0)
From India, Madras
Acknowledge(0)Amend(0)
Hi Chandra Sekhar,
I understand that you had prepared the wages sheet, and I have some additional information regarding the PF application for employees. Once you receive the updated calculation sheet with the new names added, please include the details of new employees in your company. Subsequently, issue a PF number and provide the Employees' Provident Fund Organisation form to the new employees. This form includes the SSN allotment, which you should share with your PF consultant to regularize the PF numbers.
If you are inquiring about PF withdrawal application, you will need to complete the following forms:
1) Form 19 - EPFScheme 1952
2) Form 10C - EPS 1995
Please attach a copy of the SSN form with these documents.
Best Regards,
Chandra Sekhar
Email: chandu0147@gmail.com
Phone: 9848335631
From India, Hyderabad
Acknowledge(0)Amend(0)
I understand that you had prepared the wages sheet, and I have some additional information regarding the PF application for employees. Once you receive the updated calculation sheet with the new names added, please include the details of new employees in your company. Subsequently, issue a PF number and provide the Employees' Provident Fund Organisation form to the new employees. This form includes the SSN allotment, which you should share with your PF consultant to regularize the PF numbers.
If you are inquiring about PF withdrawal application, you will need to complete the following forms:
1) Form 19 - EPFScheme 1952
2) Form 10C - EPS 1995
Please attach a copy of the SSN form with these documents.
Best Regards,
Chandra Sekhar
Email: chandu0147@gmail.com
Phone: 9848335631
From India, Hyderabad
Acknowledge(0)Amend(0)
Hi all,
I have some BSC queries. Please shed some light on these.
- Are there any slabs in the pay structure for deducting PF? (Meaning any minimum/maximum basic salary amount, below which PF cannot be deducted)
- How to prepare a salary structure for a new joiner who is supposed to receive an in-hand salary of ₹10,000 (please provide an example).
- Lastly, what are the rules and regulations for ESI? How would it be deducted from the monthly basic pay, and are there also minimum and maximum salary limits for ESI?
I am waiting for feedback from all my helpful friends on CiteHR.
From India, Delhi
Acknowledge(0)Amend(0)
0
0
I have some BSC queries. Please shed some light on these.
- Are there any slabs in the pay structure for deducting PF? (Meaning any minimum/maximum basic salary amount, below which PF cannot be deducted)
- How to prepare a salary structure for a new joiner who is supposed to receive an in-hand salary of ₹10,000 (please provide an example).
- Lastly, what are the rules and regulations for ESI? How would it be deducted from the monthly basic pay, and are there also minimum and maximum salary limits for ESI?
I am waiting for feedback from all my helpful friends on CiteHR.
From India, Delhi
Acknowledge(0)Amend(0)CiteHR.AI
(Fact Checked)-The user's reply contains accurate questions related to PF, salary structure, and ESI. It shows a good understanding of payroll concepts. (1 Acknowledge point)
0
0
Hello friends,
I want to enter the stock market. Please guide me on how to open an account, how to purchase shares, how to analyze market conditions and company information, how dividend calculations work, and on which value dividends are paid.
Thanks in advance.
From India, Kolhapur
Acknowledge(0)Amend(0)
0
0
I want to enter the stock market. Please guide me on how to open an account, how to purchase shares, how to analyze market conditions and company information, how dividend calculations work, and on which value dividends are paid.
Thanks in advance.
From India, Kolhapur
Acknowledge(0)Amend(0)CiteHR.AI
(Fact Checked)-[response] Your inquiry about entering the stock market is beyond the scope of the original post, which focused on PF calculations. Consider consulting a financial advisor for guidance on stock market investments. (1 Acknowledge point)
0
0
Hi Dear, But what to do in the calculation sheet PF>6500 SHUOLD we enter as 1 or 12000? Please confirm this.. otherwise you have done a gr8 work thnkx a lot...:icon1: Priya
From India, Bangalore
Acknowledge(0)Amend(0)
From India, Bangalore
Acknowledge(0)Amend(0)
Thanx nayan,priya,chandu,brinal ,bhatti and thanx to all of u....for ur appreciation................... Priya pls see case III.or wat exactly u want to kno pls specify......i ll let u kno........
From India, Pune
Acknowledge(0)Amend(0)
From India, Pune
Acknowledge(0)Amend(0)
Abhi, in the XLS, there is a column where it's mentioned PF>6500. What should we enter in that column? :icon1: Abhi, if you don't mind, can I have your other email ID so that I can be in touch with you for any queries? Thanks a lot again... Priya
From India, Bangalore
Acknowledge(0)Amend(0)
0
0
From India, Bangalore
Acknowledge(0)Amend(0)CiteHR.AI
(Fact Checked)-The column "PF>6500" in the Excel should be filled based on whether the Basic + DA amount is greater than 6500 as per the instructions provided. Sharing personal contact details should be done in compliance with data protection regulations. (1 Acknowledge point)
0
0
Dear Abishek Tiwari,
It was really useful. Thanks for sharing. Please let me know what I should mention in the 7th column (PF>6500). I mean, I am asking for the exact figure that I should put if my Basic plus DA is equal to Rs. 13,802/-. Should I put Rs. 7,302, which is the excess difference between my actual salary and Rs. 6,500? Kindly confirm.
Thanks,
Venkat
From India, Madras
Acknowledge(0)Amend(0)
0
0
It was really useful. Thanks for sharing. Please let me know what I should mention in the 7th column (PF>6500). I mean, I am asking for the exact figure that I should put if my Basic plus DA is equal to Rs. 13,802/-. Should I put Rs. 7,302, which is the excess difference between my actual salary and Rs. 6,500? Kindly confirm.
Thanks,
Venkat
From India, Madras
Acknowledge(0)Amend(0)CiteHR.AI
(Fact Checked)-[response] The correct figure to put in the 7th column (PF>6500) when Basic + DA is Rs. 13,802 should be Rs. 7,302, which is the excess over Rs. 6,500. Confirming this is the right approach. (1 Acknowledge point)
0
0
May i know how many employee should requried for deducting PF & ESI and what should be Salary amount ?
From India, Delhi
Acknowledge(0)Amend(0)
0
0
From India, Delhi
Acknowledge(0)Amend(0)CiteHR.AI
(Fact Checked)-The number of employees required for PF & ESI deduction is usually 20 or more, and the salary amount is typically Basic + DA. Refer to the latest labor laws for exact details. (1 Acknowledge point)
0
0
Hi Abhi,
Thank you for your help, but I would like to clarify one more thing. What is the full form of EDLIP (A/c 21 = Total basic*.50% which is part of the administrative charges on the employer side)?
Abha Singh
From India, Mumbai
Acknowledge(0)Amend(0)
Thank you for your help, but I would like to clarify one more thing. What is the full form of EDLIP (A/c 21 = Total basic*.50% which is part of the administrative charges on the employer side)?
Abha Singh
From India, Mumbai
Acknowledge(0)Amend(0)
Hi Abhi,
Thank you for your help, but there is one more thing I would like to clarify. What is the full form of EDLIP? (A/c 21 = Total basic * 0.50%, which is part of the administrative charges on the employer's side).
Abha Singh
From India, Mumbai
Acknowledge(0)Amend(0)
Thank you for your help, but there is one more thing I would like to clarify. What is the full form of EDLIP? (A/c 21 = Total basic * 0.50%, which is part of the administrative charges on the employer's side).
Abha Singh
From India, Mumbai
Acknowledge(0)Amend(0)
Hi all,
Instead of using Excel for PF challans and other returns, the software is a very easy and good way. That kind of software can be downloaded from http://www.nextechss.com/EPF30Installer.exe.
From India, Nagpur
Acknowledge(0)Amend(0)
0
0
Instead of using Excel for PF challans and other returns, the software is a very easy and good way. That kind of software can be downloaded from http://www.nextechss.com/EPF30Installer.exe.
From India, Nagpur
Acknowledge(0)Amend(0)CiteHR.AI
(Fact Checked)-The software mentioned in the reply can help automate the PF process, but ensure it aligns with legal requirements and data security. (1 Acknowledge point)
0
0
good job but need some modification in the format and please change the word "OFGANISATION" it is ORGANISATION, and other wise Good.
From India, Mumbai
Acknowledge(0)Amend(0)
0
0
From India, Mumbai
Acknowledge(0)Amend(0)CiteHR.AI
(Fact Checked)-The correction regarding the word "OFGANISATION" to "ORGANISATION" is accurate. The format modification request is noted. Great input! (1 Acknowledge point)
0
0
Dear HRfriends All of you are doing great service to our HR community. I ve been immensely benefitted . Kindly do one more favour by sending me the ESI Declaration in Form No. 1 Thanks Regards Kumar
From India, Hyderabad
Acknowledge(0)Amend(0)
From India, Hyderabad
Acknowledge(0)Amend(0)
Hi Dear I have put some formula for 6500 clause,you have to put basic,rest every thing will get calculated.Please let me know your view. Thanks Saurav
From India, Madras
Acknowledge(0)Amend(0)
From India, Madras
Acknowledge(0)Amend(0)
Hello Everyone,
I have a question. My company is a small-scale company with 10 employees. We are interested in starting a Provident Fund (PF). Could you please inform me if it is possible for us to initiate it? If yes, could you also guide me through the process? If not, kindly explain the reasons why.
Please respond at your earliest convenience.
Regards,
Deepali
From India, Pune
Acknowledge(0)Amend(0)
I have a question. My company is a small-scale company with 10 employees. We are interested in starting a Provident Fund (PF). Could you please inform me if it is possible for us to initiate it? If yes, could you also guide me through the process? If not, kindly explain the reasons why.
Please respond at your earliest convenience.
Regards,
Deepali
From India, Pune
Acknowledge(0)Amend(0)
Theres lot of consusion with many organization where some take 12 % as EE and ER and some 12 % as EE and 13.61 % as ER, What is the present rate of % for EE & ER as per laws
From India, Bangalore
Acknowledge(0)Amend(0)
0
0
From India, Bangalore
Acknowledge(0)Amend(0)CiteHR.AI
(Fact Checked)-The present rate for Employee's contribution is 12%, and for Employer's contribution, it is 12% (3.67% PF + 8.33% Pension) + 1.61% administrative charges, totaling 13.61%. This is as per the latest laws and regulations. (1 Acknowledge point)
0
0
Dear Sir, how can i fill esic monthly challan from salary sheet send me all data step by step. Regards Gaurav Mehta
From India
Acknowledge(0)Amend(0)
From India
Acknowledge(0)Amend(0)
Please advice on how to calculate PF if the basic salary is 15000 per month and also advice eligibility to get PF in karnataka
From Oman, Muscat
Acknowledge(0)Amend(0)
0
0
From Oman, Muscat
Acknowledge(0)Amend(0)CiteHR.AI
(Fact Checked)-PF calculation for a basic salary of 15000: Employee contributes 12%, i.e., 1800. Employer contributes 12% (3.67% PF + 8.33% Pension), i.e., 1800. Eligibility for PF: All employees in Karnataka are eligible for PF. (1 Acknowledge point)
0
0
Dear Sir,
Could somebody provide a sample Excel sheet of PF contributions for both employers and employees under different AC numbers for the month of January 2018?
Regards,
Bijay
Email: bijaykumar1981@gmail.com
From India, Bhubaneswar
Acknowledge(0)Amend(0)
0
0
Could somebody provide a sample Excel sheet of PF contributions for both employers and employees under different AC numbers for the month of January 2018?
Regards,
Bijay
Email: bijaykumar1981@gmail.com
From India, Bhubaneswar
Acknowledge(0)Amend(0)CiteHR.AI
(Fact Checked)-[response] Your request aligns with the information provided on PF contributions in the original post. It's recommended to create the Excel sheet based on the guidelines shared in the original content. (1 Acknowledge point)
0
0
kya feb and march 2017 ke liye bhi iss excel sheet ko use kr skte hai if no plz update and snd new version.
From India, Moradabad
Acknowledge(0)Amend(0)
0
0
From India, Moradabad
Acknowledge(0)Amend(0)CiteHR.AI
(Fact Checked)-The Excel sheet can be used for February and March 2017 as well. No need for an update. Thank you for checking. (1 Acknowledge point)
0
0
please send new format for pf contributions uploading files
From India, Vijayawada
Acknowledge(0)Amend(0)
From India, Vijayawada
Acknowledge(0)Amend(0)
sir please update with information for EPF send the new rates list for epf thanking you 8427974037
From India, Nabha
Acknowledge(0)Amend(0)
From India, Nabha
Acknowledge(0)Amend(0)
i am a private school teacher my total salary is Rs9000 i want to calculate epf on Rs6500 ,is it possible or not.
From India, Lucknow
Acknowledge(0)Amend(0)
0
0
From India, Lucknow
Acknowledge(0)Amend(0)CiteHR.AI
(Fact Checked)-The EPF calculation should be based on the Basic + DA, so in this case, the EPF should be calculated on Rs. 9000. It is possible to calculate EPF on Rs. 9000. (1 Acknowledge point)
0
0
Gathering data for an AI comment.... Sending emails to relevant members...
Looking for something specific? - Join & Be Part Of Our Community and get connected with the right people who can help. Our AI-powered platform provides real-time fact-checking, peer-reviewed insights, and a vast historical knowledge base to support your search.
Salary Sheet & PF PT Calculation & Challan Nov 2010.xls
CiteHR.AI
(Fact Checked)-The user's question pertains to the importance of providing workmen with body protection in a steel manufacturing and ingot division. The provision of leather aprons with full sleeves is indeed crucial for protection from heat and flying metals, as per safety regulations in hazardous work environments. (1 Acknowledge point)