Services · Diagnostic

Pension/Gratuity Calculation reports

PGC

Reviews or prepares pension/gratuity calculations, including employee data, assumptions, calculation methodology, reconciliation and reporting support.

What changes

More reliable financial data, better reporting, stronger audit readiness and improved system-enabled finance operations.

What you get

  1. Validated employee benefit data set with exception log PGC004
  2. Gratuity and pension calculation workbook reconciled to payroll and the general ledger PGC005
  3. Liability movement and disclosure support schedule with proposed accounting entries PGC006
  4. Pension and gratuity calculation report with management action plan PGC007

What has to come first

Who is involved

From the National Society's side. This is what the engagement asks of your people.

Your own staff work alongside the adviser throughout, so this is a commitment of their time as well as the Centre's. Ask in the request and you are given the day estimate per role before anything is signed.

RoleWhat they do
HR Manager and payroll teamOwn benefit rules and employee master data; resolve data exceptions
Head of Finance and finance teamOwn accounting, reconciliation and reporting; book the entries
Senior managementOversight of staff cost and benefit sustainability
Board / Finance CommitteeGovernance oversight where benefit schemes are material
External actuaryPerforms the valuation where a defined benefit scheme requires it
External auditorsAudit evidence and accounting treatment of benefit balances
Staff representativesConsulted where benefit rules are interpreted or changed

How it is measured

IndicatorTargetEvidence
Employee benefit data validated with every exception resolved or dispositioned 100% of exceptions Exception log (PGC004)
Calculation schedules reconciled to payroll and the general ledger with no unexplained differences 0 unexplained differences Reconciliation in PGC005; Finance sign-off
Calculation report with proposed entries delivered ahead of the year end close 4 weeks before close Endorsed report (PGC007)
External audit raises no material finding on employee benefit balances 0 material findings Audit report and management letter

Tools

5 of 8 ready to download. The rest are in development and listed so you know they are coming.

  • PGC001 Pension/Gratuity Calculation Software: For automating the calculations. Software-Requirement In development
  • PGC002 Actuarial Tools: For assessing future liabilities. Placeholder In development
  • PGC003 Gantt Chart: For managing the timeline of the calculation process. Placeholder In development
  • PGC004 Employee benefit data validation checklist and exception log Template XLSX
  • PGC005 Gratuity and pension calculation workbook with payroll and GL reconciliation Template XLSX
  • PGC006 Liability movement and disclosure support schedule Template XLSX
  • PGC007 Pension and gratuity calculation report with management action plan Template DOCX
  • PGC008 Actuarial data request pack Template DOCX

Standards

  • IFRS / GAAP accounting standards
  • HNS HR policy, recruitment procedures and local labor law
  • External audit management letters and prior year adjustments
  • Pension fund agreements and scheme rules

Describe the problem, not the service

You do not need to know which of the 124 to ask for.