Reinsurance Recoverables and Collectibility
This dataset provides a detailed record of outstanding reinsurance recoverables, capturing paid losses, case reserves, and IBNR amounts ceded to reinsurers. It includes aging information, dispute status, and reinsurer credit ratings, enabling thorough collectibility assessment and risk analysis for insurance portfolios. Ideal for financial reporting, risk management, and regulatory compliance in the insurance industry.
Sample rows
preview · 8 of 800 rows · all 15 columns| recoverable_idstring | dispute_statusstring | recoverable_age_daysinteger | recoverable_currencystring | policy_idstring | claim_idstring | reinsurer_idstring | reinsurer_namestring | reinsurer_credit_ratingstring | recoverable_typestring | recoverable_amountfloat | recoverable_due_datedate | collectibility_assessmentstring | last_update_datedatetime | notesstring |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| RCV00001 | none | 25 | EUR | POL500001 | CLM100001 | REIN001 | TransEuro Re | AA | paid_loss | 325000.25 | 2024-05-30 | high | 2024-06-24T11:12:31 | Timely settlement expected based on prior history of quick payments. |
| RCV00002 | none | 14 | JPY | POL500002 | CLM100002 | REIN002 | Asia Pacific Re | A+ | case_reserve | 4875 | 2024-06-10 | high | 2024-06-24T10:31:25 | Short-term reserve for recent claim, expected to clear within this quarter. |
| RCV00003 | none | 9 | USD | POL500003 | CLM100003 | REIN003 | Continental Reinsure | BBB | paid_loss | 1250000.75 | 2024-06-15 | high | 2024-06-24T09:52:10 | Large paid loss for property damage, reinsurer confirmed prompt release. |
| RCV00004 | none | 2 | USD | POL500004 | CLM100004 | REIN004 | MidAmerica Re | AA- | case_reserve | 0 | 2024-06-22 | high | 2024-06-24T08:03:30 | Reserve for potential liability, claim not yet substantiated. |
| RCV00005 | none | 20 | NOK | POL500005 | CLM100005 | REIN005 | Nordic ReGroup | A | paid_loss | 150000.5 | 2024-06-04 | high | 2024-06-24T12:15:19 | Loss paid for auto insurance, documentation complete. |
| RCV00006 | none | 35 | ZAR | POL500006 | CLM100006 | REIN006 | African Re | BBB+ | paid_loss | 95500 | 2024-05-20 | high | 2024-06-24T13:02:55 | Recent motor claim, insurer expects full recovery next month. |
| RCV00007 | none | 1 | HKD | POL500007 | CLM100007 | REIN007 | Hong Kong Re | BBB- | IBNR | 0.75 | 2024-06-23 | high | 2024-06-24T07:25:18 | Micro-policy IBNR, expected to finalize by end of week. |
| RCV00008 | none | 45 | CHF | POL500008 | CLM100008 | REIN008 | Swiss Alpine Re | AA+ | paid_loss | 4200000.1 | 2024-05-10 | high | 2024-06-24T13:59:41 | Major fire claim, full settlement agreed by reinsurer. |
| RCV00009 | none | 9 | BRL | POL500009 | CLM100009 | REIN009 | Brazilian Life Re | A- | case_reserve | 7500.99 | 2024-06-15 | medium | 2024-06-24T10:18:36 | Reserve for pending health claim, awaiting medical receipts. |
| RCV00010 | none | 3 | AED | POL500010 | CLM100010 | REIN010 | Gulf Regional Re | BBB | case_reserve | 2000 | 2024-06-21 | high | 2024-06-24T08:45:12 | Small reserve for travel policy claim, documents under review. |
| RCV00011 | none | 21 | CAD | POL500011 | CLM100011 | REIN011 | Canadian Surety Re | A | paid_loss | 275000 | 2024-06-03 | high | 2024-06-24T12:27:08 | Confirmed payout for property theft, reinsurer acknowledged receipt. |
| RCV00012 | none | 54 | GBP | POL500012 | CLM100012 | REIN012 | London Guarantee Re | AA | paid_loss | 5000000 | 2024-05-01 | high | 2024-06-24T14:21:09 | High-priority claim for corporate fire, expedited by reinsurer. |
| RCV00013 | none | 0 | HKD | POL500013 | CLM100013 | REIN007 | Hong Kong Re | BBB- | IBNR | 0.25 | 2024-06-24 | high | 2024-06-24T08:00:00 | Routine IBNR for small travel policy, no issues expected. |
| RCV00014 | none | 19 | AUD | POL500014 | CLM100014 | REIN013 | Australia Re | A+ | paid_loss | 101000 | 2024-06-05 | high | 2024-06-24T11:33:46 | Automotive claim, reinsurer confirmed quick turnaround. |
| RCV00015 | none | 2 | CHF | POL500015 | CLM100015 | REIN008 | Swiss Alpine Re | AA+ | case_reserve | 0 | 2024-06-22 | high | 2024-06-24T08:21:07 | Zero-value reserve set for micro-policy, claim not submitted. |
| RCV00016 | none | 1 | AED | POL500016 | CLM100016 | REIN014 | Emirates Re | BBB | IBNR | 1 | 2024-06-23 | high | 2024-06-24T10:01:01 | IBNR for travel policy, claim expected within days. |
| RCV00017 | none | 18 | INR | POL500017 | CLM100017 | REIN015 | SouthAsia Re | AA- | paid_loss | 189500 | 2024-06-06 | high | 2024-06-24T13:23:25 | Medical claim, prompt recovery expected via direct settlement. |
| RCV00018 | none | 8 | NOK | POL500018 | CLM100018 | REIN016 | Nordic ReGroup | A | case_reserve | 8000 | 2024-06-16 | medium | 2024-06-24T09:05:43 | Reserve for pending accident claim, awaiting photos. |
| RCV00019 | none | 22 | CHF | POL500019 | CLM100019 | REIN017 | Swiss Alpine Re | A+ | paid_loss | 115000 | 2024-06-02 | high | 2024-06-24T12:01:02 | Flood damage claim, reinsurer has agreed to full payout. |
| RCV00020 | none | 12 | EUR | POL500020 | CLM100020 | REIN018 | TransEuro Re | AA | case_reserve | 6250 | 2024-06-12 | medium | 2024-06-24T11:43:37 | Reserve for legal liability, documents pending. |
What the 800 rows show
from the 800-row sampleResolved (dispute status) stands out: mean recoverable_
- 14median recoverable_
age_ days - 3recoverable types
- 4collectibility assessments
- 14reinsurer credit ratings
- 66reinsurers
- 193reinsurer names
Median 14, from 0 to 1,380.
- string 11
- integer 1
- float 1
- date 1
- datetime 1
Columns
15 columns in three groups| column | type | description | example |
|---|---|---|---|
| Text 11 columns | |||
recoverable_id | string | Unique identifier for the reinsurance recoverable recordunique | RCV00001 |
policy_id | string | Unique identifier for the insurance policy associated with the recoverable | POL500001 |
claim_id | string | Unique identifier for the insurance claim related to the recoverable | CLM100001 |
reinsurer_id | string | Unique identifier for the reinsurer entity | REIN001 |
reinsurer_name | string | Name of the reinsurer | TransEuro Re |
reinsurer_credit_rating | string | Credit rating of the reinsurer (e.g., A+, AA, BBB) | AA |
recoverable_type | string | Type of recoverable (paid_loss, case_reserve, IBNR)paid_loss · case_reserve · IBNR | paid_loss |
recoverable_currency | string | Currency code for the recoverable amount (e.g., USD, EUR) | EUR |
dispute_status | string | Current status of any dispute regarding the recoverable (none, pending, resolved, rejected)none · pending · resolved · rejected | none |
collectibility_assessment | string | Assessment of the likelihood of collecting the recoverable (high, medium, low, doubtful)high · medium · low · doubtful | high |
notes | string | Additional notes or comments regarding the recoverableoptional | Timely settlement expecte… |
| Numbers 2 columns | |||
recoverable_amount | float | Outstanding amount to be recovered from the reinsurer0 or more | 325000.25 |
recoverable_age_days | integer | Number of days the recoverable has been outstanding0 or more | 25 |
| Dates and times 2 columns | |||
recoverable_due_date | date | Date when the recoverable was due from the reinsurer | 2024-05-30 |
last_update_date | datetime | Timestamp of the last update to this recoverable record | 2024-06-24T11:12:31 |
Use it for
An insurance dashboard
Recoverable_
age_ days by dispute_ status and a breakdown of recoverable_ currency. Excel, Power BI or Tableau. Why do the 91 resolved rows have a mean recoverable_
age_ days of 521.8? A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
- Recoverables800RCV0000125noneRCV0000214noneRCV000039none
A software demo
Believable recoverables with policy_
id, claim_ id and reinsurer_ id to fill a screen in front of a buyer.
This dataset800 rows15 columns
Yours1,000 rows15 columns
blueprint · reinsurance-recoverables-and-collectibility
Behind this dataset
Same schema. As many rows as you need.
These 800 rows came out of a blueprint — 15 columns with generation rules behind each one. Open it in Data Factory to retune a column, add your own, wire in foreign keys, and run it at the size you actually need.
Rules it was built with
- Recoverables = ceded paid + ceded case reserves + ceded IBNR
- Aged recoverables: current, 30, 60, 90+ days
- Reinsurer credit rating: A.M. Best, S&P, Moody's
- Allowance for uncollectible reinsurance
- Collateral held: letters of credit, trust accounts
- Disputes with reinsurers documented
- Arbitration or litigation for disputes
- Commutation: buyout of obligations
Open the blueprint in Data Factory
1 credit per row. New accounts start with 25 free credits.
- Exports
- CSV, JSON, JSONL, Parquet, SQL, Excel, TSV, XML
- Licence
- yours to use, including commercially
- API slug
- reinsurance-recoverables-and-collectibility