An actuarial valuation is the ultimate manifestation of the phrase "Garbage In, Garbage Out." A consulting actuary utilizes incredibly sophisticated, multi-generational calculus driven by stochastic mortality matrices and macroeconomic yield curves.
However, if the Excel spreadsheet provided by the Human Resources department mistakenly classifies a massive housing allowance as "Basic Salary," all of the mathematical precision in the world will not prevent the corporation from booking a horrific, multi-million-dollar phantom liability.
For HR Directors charged with coordinating the year-end IAS 19 valuation with the Finance department, here is the ironclad playbook for preparing a pristine census file.
The Four Non-Negotiable Data Pillars
A standard actuarial valuation requires, at an absolute minimum, the following fields for every single active employee on the payroll cutoff date (e.g., December 31st).
1. Accurate Dates of Birth
Actuaries do not project liabilities in a vacuum; they project them based on human lifespans. If your master HRIS system defaults empty birthdates to "01/01/1900," the actuary’s software will instantly assume you have 124-year-old employees actively working on oil rigs. This completely shatters the mortality tables and the age-banded turnover decrements. Ensure Dates of Birth are strictly formatted and logical.
2. The True "Date of Joining"
The End-of-Service Gratuity (EOSG) multiplier scales exponentially based on continuous tenure.
The Danger Zone: Many corporations have undergone complex mergers, spin-offs, or transitioned employees between regional subsidiaries. If an employee was hired in 2010 but internally transferred to a new legal payroll entity in 2020, does the HR system say their hire date is 2020? If so, the actuary will assume they have 4 years of service instead of 14, dangerously under-reporting the liability. You must provide the Actuarial Continuous Hire Date.
3. Basic Salary Isolation
Labor Law explicitly dictates that the EOSG is calculated almost exclusively on the "Last Basic Wage."
In the GCC, total compensation packages often blur the lines with transportation fleets, schooling allowances, and heavy localized cost-of-living adjustments. Your census file must surgically isolate the pure Monthly Basic Salary in a standalone column. If you accidentally provide "Total Gross Compensation," the actuary might literally double your corporate liability overnight.
4. The Exit Registry
An actuary cannot accurately predict how many people will resign next year if they do not know how many resigned last year.
You must provide a separate tab detailing every employee who exited the firm over the previous 12 months. This exit registry must include:
- Their exact exit date.
- The reason for exit (Resignation vs. Termination vs. Death).
- The exact physical cash amount paid to them in final settlement.
The actuary requires the exact physical cash amount to build the "Movement Schedule" bridging the opening liability to the closing liability.
The Sanity Check
Before forwarding the CSV file to your actuarial consultant, standardise the formatting. Remove arbitrary commas embedded in salary numbers, ensure the currency is unified (do not mix USD expats with SAR locals in the same column without an explicit mapping key), and secure the document with a robust corporate password.
A clean census file guarantees a fast, cheap, and flawlessly audited actuarial report.
Need Help With Your IAS 19 Valuation?
Our qualified actuaries can help you with discount rate selection, assumption setting, and full IAS 19 valuations.
Get a Quote