Need Help with Correct PF Interest Calculation Formula for Exempted Units – Any Excel Formats?

Respected all, I have been working in the HR Department for the last 8 years. We are managing our own PF trust according to the guidelines of RPFC (Government of India), which means we are an exempted unit. Recently, our management has handed over the charge of the PF trust to me. The Enforcement Officer of PF has suggested changing our PF interest calculation formula because our current formula is incorrect. I kindly request you to please provide me with the PF interest calculation formula (format) in Excel for an exempted establishment.

Regards,
Saurabh
Email: [Email Removed For Privacy Reasons]

Hopefully, it will help you. Just put your opening balance, if any, and each month's contribution; interest will be calculated automatically.