Appendix A: Data Validation

The facility business data submitted by Lloyd’s will be validated by APRA as follows.

For facility business data, the total of all premiums received and the total of gross payments made will be deducted from earned premium and gross payment data submitted in GRF 440 (see below).

a) Earned premium submitted in information provided by Lloyd’s under Lloyd’s Security Trust Fund Determination No 1, less the premium received for all facilities, is expected to reconcile to within 5% of the total of the earned premium shown in field 15b on the individual policy records submitted by insurers or as calculated by APRA from the gross annualised premium (field 15a). APRA will expect Lloyd’s to explain the source of any greater discrepancy.

b) Gross claim payments submitted in information provided by Lloyd’s under Lloyd’s Security Trust Fund Determination No 1, less the gross payments received for all facilities, is expected to reconcile to within 5% of the gross payments for each accident year calculated from the individual claim records submitted. Discrepancies in the most recent accident years will be compared with the amount of payments made for all facilities.

While it is appreciated that more extensive reconciliation could be attempted, this could require significant changes to the existing reporting requirements to APRA or the submission of other information (such as management accounts) from insurers that would not be in standard formats.

APRA will expect that where Lloyd’s needs to demonstrate the reason for a discrepancy between the individual records submitted to the database and its aggregate data reported to APRA in the above forms, Lloyd’s will share such additional reports with APRA as required.