For the assistance of employers
30.04.2023
Dear friends,
On the repeated requests from some employers directly as well as through their employees/pensioners, for their assistance, we have prepared a "Template (30-04-2023) for Higher Wages at Employer's end". It will be useful for Employers to convert wage data into uploadable Text file as required by EPFO. Instructions for filling the Excel File (Data to be filled in PINK CELLS only): The rules related to the calculation of Interest on Provident Fund Contributions are laid down under Para 60 of the Employees' Provident Fund Scheme 1952. The interest is credited on a monthly running balance basis. The closing balance for the year will be Opening balance + Contributions - withdrawal (if any) + Interest. It consists of 5 excel sheets:
1. Validations for the document: To be uploaded by employer for adding Monthly Wage Details.
2. PF Interest Rate: As per the latest Annual Report of EPFO.
3. PF Interest Calculation: How is the PF Interest calculated.
4. Excel file: Which data is to be fed in the file for each employee to get the calculations done automatically.
5. Uploadable Text file: Which data is to be uploaded in the EPFO portal by employers. ALL ARE REQUESTED TO PLEASE READ "FILES TO BE REFERRED BY EMPLOYER TO UPLOAD HIGHER WAGES DATA" (https://bit.ly/42bYE91) AND INSTRUCTIONS SHEETS CAREFULLY BEFORE PROCEEDING
Though every care is taken in preparing this file based on our understanding of the scheme, however, we are developing it for the first time on demand of various stakeholders especially small organisations. In case someone notices any mistake and considers improvement in the calculations, he/she must send the filled EXCEL FILE to Mr. Neeraj Bhargava, Jaipur at pensionseva.jpr@gmail.com for looking into the same immediately along with their organisation details like Name of organisation, Code number, Type of organisation i.e., Exempted/Unexempted, etc.
It has been noticed that EPFO is modifying Higher Wages Help File Structure frequently. Please check EPFO portal regularly.
Disclaimer: It is to be clarified that these files are indicative/suggestive only and have been prepared voluntarily to the best of our ability. However, there might be any mistake in its development and as such everyone concerned is requested to please cross-check the details/calculations/output before uploading the same on the portal. These are only for their assistance.
Parveen Kohli
9810306699
From India, Gurgaon
Acknowledge(0)
Amend(0)
330.04.2023
Dear friends,
On the repeated requests from some employers directly as well as through their employees/pensioners, for their assistance, we have prepared a "Template (30-04-2023) for Higher Wages at Employer's end". It will be useful for Employers to convert wage data into uploadable Text file as required by EPFO. Instructions for filling the Excel File (Data to be filled in PINK CELLS only): The rules related to the calculation of Interest on Provident Fund Contributions are laid down under Para 60 of the Employees' Provident Fund Scheme 1952. The interest is credited on a monthly running balance basis. The closing balance for the year will be Opening balance + Contributions - withdrawal (if any) + Interest. It consists of 5 excel sheets:
1. Validations for the document: To be uploaded by employer for adding Monthly Wage Details.
2. PF Interest Rate: As per the latest Annual Report of EPFO.
3. PF Interest Calculation: How is the PF Interest calculated.
4. Excel file: Which data is to be fed in the file for each employee to get the calculations done automatically.
5. Uploadable Text file: Which data is to be uploaded in the EPFO portal by employers. ALL ARE REQUESTED TO PLEASE READ "FILES TO BE REFERRED BY EMPLOYER TO UPLOAD HIGHER WAGES DATA" (https://bit.ly/42bYE91) AND INSTRUCTIONS SHEETS CAREFULLY BEFORE PROCEEDING
Though every care is taken in preparing this file based on our understanding of the scheme, however, we are developing it for the first time on demand of various stakeholders especially small organisations. In case someone notices any mistake and considers improvement in the calculations, he/she must send the filled EXCEL FILE to Mr. Neeraj Bhargava, Jaipur at pensionseva.jpr@gmail.com for looking into the same immediately along with their organisation details like Name of organisation, Code number, Type of organisation i.e., Exempted/Unexempted, etc.
It has been noticed that EPFO is modifying Higher Wages Help File Structure frequently. Please check EPFO portal regularly.
Disclaimer: It is to be clarified that these files are indicative/suggestive only and have been prepared voluntarily to the best of our ability. However, there might be any mistake in its development and as such everyone concerned is requested to please cross-check the details/calculations/output before uploading the same on the portal. These are only for their assistance.
Parveen Kohli
9810306699
From India, Gurgaon
Acknowledge(0)Amend(0)
Showing error from mAY 2012 as payable amount is not calculated in coloumn No.7
From India, Jabalpur
Acknowledge(0)Amend(0)
From India, Jabalpur
Acknowledge(0)Amend(0)
After preparing the file as per your format, the following message appeared on the employer portal at the time of uploading the .txt file:
"Invalid file, kindly upload a valid file as per the format given in the instructions."
Kindly guide.
Regards.
From India, Shimla
Acknowledge(0)Amend(0)
"Invalid file, kindly upload a valid file as per the format given in the instructions."
Kindly guide.
Regards.
From India, Shimla
Acknowledge(0)Amend(0)
Thanks, Mr. Praveen Kohli for the post. I have basic questions in mind as mentioned below regarding higher pension:
1. How many organizations are paying Employers' contribution beyond the statutory limit, which is currently 15,000/- per month? My gut feeling is that it may be 30% of total EPFO-covered organizations. Therefore, it will be a gain only for approximately 30% of organizations.
2. All past accumulations, including interest, will be transferred from the EPF Account to the EPS Account. This will result in less accumulation in the EPF account. Moreover, there will be a 1.16% additional contribution, i.e., at present, 8.33% will be 9.49%, which will again impact EPF accumulation.
3. If the money is in the EPF account, the employee and their family can enjoy it even after the death of the employee. But in the EPS fund, when both the self and spouse expire, the money will vanish.
4. In the future, EPFO may change the formula for pension calculation, and as it appears today, in the future, it may be less.
There is a possibility of many other ifs and buts in the future. One should make a decision after considering all pros and cons.
S K Bandyopadhyay (WB, Howrah) CEO-USD HR Solutions +91 98310 81531 skb@usdhrs.in USD HR Solutions – To strive towards excellence with effort and integrity
From India, New Delhi
Acknowledge(0)Amend(0)
1. How many organizations are paying Employers' contribution beyond the statutory limit, which is currently 15,000/- per month? My gut feeling is that it may be 30% of total EPFO-covered organizations. Therefore, it will be a gain only for approximately 30% of organizations.
2. All past accumulations, including interest, will be transferred from the EPF Account to the EPS Account. This will result in less accumulation in the EPF account. Moreover, there will be a 1.16% additional contribution, i.e., at present, 8.33% will be 9.49%, which will again impact EPF accumulation.
3. If the money is in the EPF account, the employee and their family can enjoy it even after the death of the employee. But in the EPS fund, when both the self and spouse expire, the money will vanish.
4. In the future, EPFO may change the formula for pension calculation, and as it appears today, in the future, it may be less.
There is a possibility of many other ifs and buts in the future. One should make a decision after considering all pros and cons.
S K Bandyopadhyay (WB, Howrah) CEO-USD HR Solutions +91 98310 81531 skb@usdhrs.in USD HR Solutions – To strive towards excellence with effort and integrity
From India, New Delhi
Acknowledge(0)Amend(0)
Sir,
I have uploaded the file of one employee and received the following error message:
"Please enter a valid value for Pension Contribution to be paid along with interest."
The messages are for line numbers 68 to 75.
I have attached the Excel and text files for your reference.
Please suggest a solution.
Regards,
AP Sathe
From India, Jabalpur
Acknowledge(0)Amend(0)
I have uploaded the file of one employee and received the following error message:
"Please enter a valid value for Pension Contribution to be paid along with interest."
The messages are for line numbers 68 to 75.
I have attached the Excel and text files for your reference.
Please suggest a solution.
Regards,
AP Sathe
From India, Jabalpur
Acknowledge(0)Amend(0)Engage with peers to discuss and resolve work and business challenges collaboratively - share and document your knowledge. Our AI-powered platform, features real-time fact-checking, peer reviews, and an extensive historical knowledge base. - Join & Be Part Of Our Community.
EPS - Form No. 10-D Pension Claim Form Aadhaar.pdf
EPS-Explanation on full salary for Pension-Gist of SC judgment on KeralaHC.docx