
Quantitative Reporting Templates (QRTs) are the standard tables that insurers complete to report figures such as their balance sheet, technical provisions, own funds, capital requirements, premiums, claims and investments to their supervisor. They are produced for each reporting period and must be consistent with each other and with the insurer’s other reporting.
We help insurers prepare, check and file these returns, either as a one-off piece of support or as a recurring service.
What the work involves
- Mapping data to the templates. Identifying where each figure comes from in your accounting, actuarial, investment and policy systems, and documenting that mapping so it can be reused.
- Collecting and preparing data. Extracting the data, cleaning it and transforming it into the structure the templates need.
- Calculating actuarial figures. Preparing or reviewing the actuarial inputs, such as technical provisions, that feed into the returns. This links closely to our reserve review work.
- Checking the returns. Running checks between templates, against the financial statements and against the previous period, and explaining any significant movements.
- Filing. Preparing the returns in the format required for submission and supporting you through the filing process.
Automating the process
QRTs are produced on a fixed timetable and many of the same steps are repeated each period. We use Python, Power Query and Power Pivot to connect to your data systems and automate the routine data processing. Once the process is set up, each new period can be produced by refreshing the data rather than rebuilding spreadsheets, which leaves more time for review.
Automated checks can be built into the same process, so that inconsistencies are flagged early rather than found at the end. The data prepared for the returns can also feed management reporting in Power BI through our business intelligence reporting and analytics service.
Planning each reporting cycle
Returns are easier to produce when the timetable is agreed in advance. We work with you to set out when each data source will be available, who prepares and who reviews each template, and how much time is left for sign-off before the submission deadline. Keeping a record of the queries raised and the movements explained in each period also makes the next cycle quicker, and gives auditors and reviewers a clear trail to follow.
Who runs it afterwards
As with our other work, the solution can be introduced gradually. Once built, it can be handed over to your in-house team with documentation, or we can keep running it each period as an outsourced service.
Related services
QRT work often sits alongside an outsourced actuarial or risk function , and within our wider actuarial, finance and risk services, which also include business planning, financial reporting and audit support.
To discuss your regulatory returns, please contact us .
Want to discuss this work for your company?
Contact us