Insurance
Every figure traceable to the document it came from.
Underwriting and reserving inputs that can be traced to the document they came from, including the ones that were not used.
the worked caseTwo schedules give different insured values for one site. The reserve carries one figure with the schedule it came from; the other stays on the record.

Two worked cases on this page, both fictional and both built the way a real one is: a value, the document it was read from, the date of reading, and the value it was chosen over.
The questions you get asked
Nobody asks for more information. They ask whether one line can be defended.
These are the questions that arrive after the work is delivered, from the party entitled to disagree with it. Every property on this page exists because one of them has to have an answer that does not depend on the person who assembled the file.
- 01
Which document is this insured value from, and was it the one in force at inception?
- 02
Is this amount gross or net, and where does the file say which?
- 03
You show no prior loss at this location. Was that checked, or is it missing?
- 04
Explain the judgement, and tell me the figure you did not use.
Asked by the external auditor, by the actuarial function, and by the reviewer who returns to a reserve two years after it was set.
The buyer
Underwriting, reserving, actuarial and internal audit
Functions whose figures are audited, whose data quality is a supervisory requirement in itself, and who are asked to explain not only a number but the alternative that was rejected.
What they fuse
Three kinds of source, one answer
Each kind arrives with different licence terms, different reader restrictions and different reasons to be wrong. The record keeps them distinguishable after the fusion, which is the part that is normally lost.
Broker submissions, statements of values, loss runs and prior-year files, often inconsistent with one another.
Catastrophe, geospatial and corporate datasets under licences that restrict redistribution and retention.
Property and company registers, regulatory filings, court records and published inspection or enforcement outcomes.
Worked case one
Two documents, one figureOne site, two insured values
A renewal statement of values and a mid-term endorsement gave different insured values for the same location. Reconciliation did not mean choosing quietly: the reserve carries the endorsed figure with its document and date, the submission figure stays on the record as the value it was chosen over, and the reason is one line an auditor can read.
The figure beside this is what the reader sees: the value, its status, the source it was read from, and the value it was chosen over.
Worked case two
Two numbers that are not the same quantityTwo amounts within a few per cent of each other, measuring different things
A claims extract and a cedant bordereau each reported an amount for the same claim, close enough that a reconciliation would have called them a rounding difference. They are not the same quantity: one is incurred gross of reinsurance recoveries and the other is net. Nothing in the numbers says so, and the distinction exists only in the documents they came from. The record does not reconcile them. It carries both, states which quantity each is, and refuses to let either stand in for the other.
A different failure from the first case, on the same record and under the same four guarantees. Both are fictional; neither is a simplification of how the values are shown.
Why the record has to hold
What the rules ask for, in their own words
These are the recordkeeping obligations that make a defensible value a requirement rather than a preference. We name them because our customers are measured against them; we make no claim to certify anyone against any of them.
Data quality in technical provisions
European UnionUndertakings must have processes ensuring data used in technical provisions is complete, accurate and appropriate, and must be able to identify and explain its sources and limitations.
Internal control over financial reporting
United States, adopted by statesManagement must document and assess internal control over the preparation of statutory financial statements, including controls over the data on which those statements rely.
Disclosure of significant judgements
International, IFRS reportersAn entity must disclose the significant judgements made in applying the standard and the inputs used to measure insurance contracts.
What changes for this reader
The same work, with the evidence attached at the moment it is read
Not a claim about speed and not a claim about savings: a description of the practice on each side. Everything on the left is what people in this role do today, and almost all of it is done well by people who resent having to do it that way.
An underwriter keys the statement of values into the system, and the endorsement that superseded it stays in the file.
The bound figure carries the endorsement, its clause and its date, and the superseded statement stays on the record as what it was chosen over.
A loss run that comes back empty is treated as no prior loss at that location.
It is recorded as the loss runs searched and the date, so a nil is distinguishable from a question nobody asked.
Gross and net amounts of similar size are reconciled inside a spreadsheet only its author can read.
Each amount states which quantity it is and the document it came from, and neither is allowed to stand for the other.
The actuarial function asks where an input came from and is answered from memory, months after the fact.
Every input carries its document, clause and reading date, which is what the data-quality requirement asks for in the first place.
Explaining a reserve set two years ago means working out which version of which schedule was on the desk that day.
The file reproduces as it stood on the day the reserve was set, with the documents that were in front of the reserver.
What you get
What the record guarantees insurance readers
The four guarantees, stated in the vocabulary of this sector. They are the same four everywhere; read them in general on the guarantees page, and see them applied to a live record on the demonstration.
- One record per insured entity and per location, with its aliases and predecessor names retained.
- Every figure carries the document, the clause or page, and the date it was read, so an auditor never has to ask where it came from.
- A figure a document does not state is declared not found with the documents searched, never carried forward as zero.
- A closed reserve or a bound risk can be reproduced exactly as the file stood on the day it was set.
Primary sources
The texts behind these obligations
Insurers answer to prudential supervisors, statutory auditors and accounting standard setters, and each has written down what it expects of data and judgement. The texts listed below sit behind the obligations on this page. We name them because the reader's work is measured against them, and we do not certify any firm against them.
- Directive 2009/138/EC (Solvency II), EUR-Lex. Articles 41 and 82 on governance and data quality for technical provisions.
- Commission Delegated Regulation (EU) 2015/35, EUR-Lex. Article 19 on the data used in technical provisions: appropriateness, completeness and accuracy.
- IFRS 17 Insurance Contracts (IFRS Foundation). Measurement and disclosure of significant judgements and inputs.
Reference pages that apply to this sector
- North American Industry Classification System (NAICS)
- NACE classification
- ISO 3166 country codes
- ISO 4217 currency codes
- ISO 8601 date and time representation
- Estimating source reliability
- Reporting source conflicts
- Detecting source drift
- Data warehouse vs system of record