IAS 19 (Employee Benefits Tool)

IAS 19 – Employee Benefits Toolkit

Upload Excel or enter manually. Generates DC & DB workings, journal entries, and an actuary‑style PDF report — all in your browser.

1) Data Input

Upload Excel Manual Entry

Upload Excel (.xlsx)

Expected sheets: DC_Data and DB_Employees.

Plan Types Defined Contribution Defined Benefit

Reporting Date

Manual Employee Data

Employee ID	Name	Age	Current Salary	Years of Service	Plan (DC/DB)	DC Rate % (if DC)

Tip: Leave DC Rate blank to use the global DC rate below.

2) Actuarial & Accounting Assumptions

Discount rate (DB) %

Salary growth (DB) %

Attrition / turnover (DB) %

Benefit formula (per service‑year) %

Simplified PUC: Accrued benefit ≈ benefit% × service years × final salary.

Retirement age

Global DC employer rate %

Note: Educational, simplified implementation of Projected Unit Credit for DB obligations. For material balances, consult a qualified actuary.

Summary

Messages / Validation

Defined Contribution – Calculations

Defined Benefit – Key Results

Journal Entries

Disclosures (IAS 19)

Client‑side demo. No data leaves your browser.