Management information

Reports

Read-only reports built from posted premiums, receipts, claims and month-end closes. Filter them, read them here, or download them for Excel.

You can read every report here. Downloads need a signed-in user, so they are recorded in the audit history.

Available reports

4 reports · each opens with sensible defaults you can change

Aged premium debtors
Open premium lines by policy and counterparty, aged from recognition into 30-day buckets, in contract currency and carrying rand.
Amounts: Contract currency and carrying rand, in five age buckets.
Filters: legal entity, currency, as at.
Open report : Aged premium debtors
FX exposure
Open foreign-currency receivables and claim reserves per currency, valued at the latest available rate, with the indicative unrealised FX.
Amounts: Contract currency, carrying rand and rand at the latest rate.
Filters: legal entity, currency, as at.
Open report : FX exposure
Claims reserves
Outstanding reserves by claim, class and currency, with the period's movements and a reconciliation to the claim records that must be nil.
Amounts: Claim currency and carrying rand, opening to closing.
Filters: legal entity, currency, claim class, from, to.
Open report : Claims reserves
FX gains and losses
Realised FX on receipts and claim payments and unrealised FX from month-end revaluations, per period and currency, with links to every source record.
Amounts: Rand, realised and unrealised, per month and currency.
Filters: legal entity, currency, from, to.
Open report : FX gains and losses

The same rules apply to every report

Amounts in different currencies are never added together. Each currency has its own totals. FCYForeign currency: the currency a policy, premium, claim or payment is agreed in when it is not rand (ZAR). FCY amounts are kept exactly as agreed and exchange-rate movements never change them.
Rand figures are carrying values: the rand value each item holds in the books, at its recognition rate and any month-end revaluation since. ZAR carrying valueThe rand value an open foreign-currency item is currently held at in the books. It starts at the recognition-rate value and is restated at each month-end until the item is settled.
Realised FX arises when cash settles an item; unrealised FX when month-end close revalues what is still open. Realised FXThe exchange gain or loss that becomes final when an item is settled: the rand value at the settlement rate minus the carrying value of the part that was settled. Unrealised FXThe exchange gain or loss on items still open at month-end: the rand value at the closing rate minus the previous carrying value. It can change again until the item is settled.
Only posted records count. Drafts and items waiting for approval are left out.
Every download is recorded in the audit history with its filters, its row count and a SHA-256 fingerprint of the file.