Regulatory returns and registers

Regulatory returns are built from templates, filled from the books and the policy and claims data, checked, and signed off by three people before they are submitted.

Templates

Actuarial > Return templates lists the returns. Three starter templates are installed: a quarterly premium and claims return, an annual solvency return, and a complaints and claims register summary. Each template has cells (a reference, a section, a label and either a figure from the system or a formula on other cells) and checks (rules that must hold, with the message shown when they fail). You can change the cells and checks, or add your own templates, to match your regulator's forms.

Formulas use cell references, + - * / and brackets, and SUM over a range, such as SUM(A1:A5).

Preparing a return

Actuarial > Regulatory returns > Prepare a return takes the template and the period and fills every cell. The return shows each figure and any check that fails.

Change a figure overrides a cell with a reason; the change and the original value are kept on the return.

Sign-off

1. The preparer prepares it.
2. Reviewed: someone else checks it.
3. Approve: a third person approves it. A return with failing checks cannot be approved.
4. Submitted: records the date and the regulator's reference.

Excel downloads the return at any stage. The return records who prepared, reviewed and approved it, and when.

Registers

Claims register downloads every claim in the period with its dates, amounts and status. Complaints register downloads every complaint with when it was received, acknowledged and resolved, the outcome, compensation and whether it was reported to the regulator.

Limits

The templates are starting points, not the official forms of a particular regulator. Returns are downloaded and filed through the regulator's own system; there is no direct electronic submission.