Struggling with PF Monthly Returns? Need Help Matching Accounts with Challan from Head Office?

Hello seniors, I want to know how to calculate the PF accounts for PF monthly returns challan. We receive the challan from the head office, which is in Chennai. When I submit the challan to auditors, they inform me that the accounts are not matching. Can anyone provide me with an Excel sheet to calculate the accounts?

Thanks & Regards,
Ravichandran.K

Dear Ravichandra, please refer to the attached file. The calculations and examples will clear your doubts. For any further clarification, feel free to write or discuss.

Regards