A provident fund register that reconciles: derived, not typed

A provident fund register is a simple idea that goes wrong in a predictable way. Someone starts it in a spreadsheet, the balances are typed in each month, a loan is taken, a person leaves, a figure is corrected by hand, and a year later nobody can say whether the register agrees with what payroll deducted. This is how to run one that you can prove.

What the register has to show

For each member, at any date:

• the opening balance carried in when the register began;
• every employee contribution and employer contribution posted since;
• any loan taken against the fund, and the principal still outstanding;
• the net payable: contributions plus opening balance, less loan principal outstanding.

The rule that makes it provable: derive, never type

The balance is not a number you maintain. It is the result of a calculation over facts:

balance = opening balance + contributions posted − loan principal outstanding

If every contribution comes from a payroll run, and the opening balance was entered once, then the balance can be rebuilt from scratch at any time. If the rebuilt register matches the one you have been reading, you have proved it. If it does not, you have found an error before an auditor or a leaver does.

How a register drifts

Registers rarely fail in one dramatic way. They drift, a small error at a time, until nobody trusts them. The usual causes:

• A typed balance that someone corrected by hand after a query, with no entry to show why.
• A late joiner enrolled by hand two months after they became eligible, with the missed months never backfilled.
• A leaver whose contributions stop, while the register keeps counting them as a member.
• A loan recorded in one place and deducted in another, so the two never agree.
• A restated opening balance pasted over the old one when a new year begins.

Each of these is easy to avoid when the balance is derived and every movement is a posted entry. Each is almost impossible to untangle when it is not.

A worked example (illustrative)

Take an invented member, with an opening balance of 100,000 rupees when the register began. Over six months the employee contributes 5,000 rupees a month and the employer matches it, so 60,000 rupees of contributions are posted. A fund loan was taken, and 30,000 rupees of principal is still outstanding.

The derived balance is the opening balance plus the contributions, less the loan principal outstanding: 100,000 plus 60,000 less 30,000, which is 130,000 rupees payable.

Now the check. Add up the contributions payroll actually deducted and accrued for that member over the six months. If the total is not 60,000 rupees, the register or the payroll is wrong, and you know which month to open. A typed balance gives you no such test.

Eligibility by rule, not memory

Decide in writing who is eligible and from when (for example, from confirmation of employment) and apply it as a rule in payroll. A register where enrolment depends on someone remembering to add a person will always have gaps.

Loans against the fund

A loan against the fund reduces what is payable, and its instalments are deducted through payroll. The register should show the principal outstanding beside the contributions, so the net payable is never a surprise at a person’s last day.

Reconcile every month

1. Total employee and employer contributions in the register equal the totals deducted and accrued in the payroll run.
2. The number of members equals the number eligible on the roster.
3. Any difference has an explanation you can write in a sentence.

At the end of the road

When someone leaves, the register feeds their final settlement: the net payable is part of what is settled. A register built on derived balances turns that into a lookup instead of a research project. Any fund loan is dealt with in the same place, as described under loans and advances. And because the register is only as good as the months that feed it, the month-end checklist includes a check on contributions every time you lock.

WageVerge builds the provident fund register this way: contributions post from payroll, balances are derived, and a rebuild from payroll reproduces the register to the rupee.