Reinsurance Premium and Commission Accounting
This dataset provides comprehensive records of ceded premiums, reinsurance commissions, profit commissions, premium adjustments, and bordereaux reporting for both treaty and facultative reinsurance agreements. It enables detailed financial tracking, regulatory compliance, and performance analysis for reinsurance transactions between insurers and reinsurers.
Sample rows
preview · 8 of 600 rows · all 23 columns| transaction_idstring | commission_typestring | profit_commission_amountfloat | is_settlement_finalboolean | adjustment_reasonstring | treaty_typestring | treaty_idstring | ceding_company_idstring | reinsurer_idstring | policy_numberstring | bordereaux_referencestring | transaction_datedate | effective_datedate | expiry_datedate | ceded_premium_amountfloat | premium_currencystring | commission_ratefloat | commission_amountfloat | commission_currencystring | premium_adjustment_amountfloat | reporting_period_startdate | reporting_period_enddate | remarksstring |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| TXN000001 | Standard | 0 | false | blank | Treaty | TRT-2021-0001 | CED-US-Franklin | RE-GB-Lloyds | POL-US-10001 | BDX-2021-0001 | 2021-03-15 | 2021-03-01 | 2022-02-28 | 250000.45 | USD | 10 | 25000.05 | USD | 0 | 2021-03-01 | 2021-03-31 | Regular premium for annual renewal |
| TXN000002 | Standard | 0 | false | Endorsement for additional premium | Treaty | TRT-2022-0002 | CED-DE-MunichRe | RE-FR-AXA | POL-DE-20543 | BDX-2022-0005 | 2022-06-10 | 2022-06-01 | 2023-05-31 | 195000 | EUR | 12.5 | 24375 | EUR | 5000 | 2022-06-01 | 2022-06-30 | Endorsement for premium increase |
| TXN000003 | Sliding Scale | 8000 | false | blank | Facultative | FAC-2023-0003 | CED-CA-Manulife | RE-US-Chubb | POL-CA-33021 | blank | 2023-02-05 | 2023-01-15 | 2023-12-31 | 1200000 | CAD | 45 | 540000 | CAD | 0 | blank | blank | High value placement for large commercial risk |
| TXN000004 | Profit | 4000 | false | blank | Treaty | TRT-2022-0003 | CED-JP-TokioMarine | RE-SG-GIC | POL-JP-41009 | BDX-2022-0006 | 2022-09-17 | 2022-09-01 | 2023-08-31 | 110000.35 | JPY | 2.5 | 2750.01 | JPY | 0 | 2022-09-01 | 2022-09-30 | Profit commission only for renewal |
| TXN000005 | Standard | 0 | true | blank | Treaty | TRT-2023-0004 | CED-IN-ICICI | RE-UK-Hiscox | POL-IN-90087 | BDX-2023-0002 | 2023-04-20 | 2023-04-01 | 2024-03-31 | 75000 | INR | 9 | 6750 | INR | 0 | 2023-04-01 | 2023-04-30 | Final settlement for treaty renewal |
| TXN000006 | Other | 0 | true | Full cancellation | Facultative | FAC-2022-0005 | CED-AU-QBE | RE-CH-Zurich | blank | blank | 2022-11-20 | 2022-11-01 | blank | 350000 | AUD | 0 | 0 | AUD | -350000 | blank | blank | Policy cancelled after inception |
| TXN000007 | Standard | 0 | false | blank | Treaty | TRT-2021-0005 | CED-FR-AXA | RE-DE-Hannover | POL-FR-60009 | BDX-2021-0007 | 2021-07-02 | 2021-07-01 | 2022-06-30 | 96000 | EUR | 7.5 | 7200 | EUR | 0 | 2021-07-01 | 2021-07-31 | Regular premium for treaty |
| TXN000008 | Sliding Scale | 0 | false | blank | Treaty | TRT-2023-0006 | CED-GB-Aviva | RE-FR-Scor | POL-GB-80012 | BDX-2023-0004 | 2023-06-11 | 2023-06-01 | 2024-05-31 | 210000 | GBP | 80 | 168000 | GBP | 0 | 2023-06-01 | 2023-06-30 | Sliding scale commission for high retention |
| TXN000009 | Other | 0 | false | Endorsement | Treaty | TRT-2022-0008 | CED-IT-Generali | RE-CH-SwissRe | POL-IT-20233 | BDX-2022-0009 | 2022-12-15 | 2022-12-01 | 2023-11-30 | 53000 | EUR | 6 | 3180 | EUR | 25000 | 2022-12-01 | 2022-12-31 | Endorsement for premium increase |
| TXN000010 | Sliding Scale | 0 | false | blank | Facultative | FAC-2022-0010 | CED-US-Prudential | RE-NL-NN | blank | blank | 2022-08-04 | 2022-07-20 | 2023-07-19 | 700000 | USD | 95 | 665000 | USD | 0 | blank | blank | Near maximum sliding scale commission |
| TXN000011 | Standard | 0 | false | blank | Treaty | TRT-2021-0011 | CED-ES-Mapfre | RE-DE-MunichRe | POL-ES-90333 | BDX-2021-0011 | 2021-10-22 | 2021-10-01 | 2022-09-30 | 67000 | EUR | 10 | 6700 | EUR | 0 | 2021-10-01 | 2021-10-31 | Standard commission for treaty |
| TXN000012 | Profit | 7000 | false | blank | Treaty | TRT-2023-0012 | CED-SG-SingLife | RE-JP-TokioMarine | POL-SG-80221 | BDX-2023-0012 | 2023-09-15 | 2023-09-01 | 2024-08-31 | 85000 | SGD | 0.5 | 425 | SGD | 0 | 2023-09-01 | 2023-09-30 | Profit commission only for treaty renewal |
| TXN000013 | Other | 0 | true | blank | Facultative | FAC-2021-0013 | CED-GB-DirectLine | RE-US-Chubb | POL-GB-40056 | blank | 2021-04-09 | 2021-03-25 | 2022-03-24 | 420000 | GBP | 3.5 | 14700 | GBP | 0 | blank | blank | Facultative placement for commercial risk |
| TXN000014 | Standard | 0 | false | blank | Treaty | TRT-2023-0014 | CED-CA-Intact | RE-CA-Manulife | POL-CA-48901 | BDX-2023-0014 | 2023-10-20 | 2023-10-01 | 2024-09-30 | 110000 | CAD | 11 | 12100 | CAD | 0 | 2023-10-01 | 2023-10-31 | Standard renewal premium for treaty |
| TXN000015 | Other | 0 | true | Correction | Treaty | TRT-2022-0015 | CED-NL-NN | RE-DE-Hannover | blank | BDX-2022-0015 | 2022-05-18 | 2022-05-01 | 2023-04-30 | 65000 | EUR | 8 | 5200 | EUR | -10000 | 2022-05-01 | 2022-05-31 | Correction after audit, negative adjustment |
| TXN000016 | Other | 0 | true | Full cancellation | Facultative | FAC-2023-0016 | CED-AU-Suncorp | RE-JP-Mitsui | blank | blank | 2023-08-10 | 2023-08-01 | blank | 90000 | AUD | 0.5 | 450 | AUD | -90000 | blank | blank | Full cancellation before expiry |
| TXN000017 | Standard | 0 | false | blank | Treaty | TRT-2021-0017 | CED-IT-Generali | RE-FR-AXA | POL-IT-98233 | BDX-2021-0017 | 2021-12-29 | 2021-12-01 | 2022-11-30 | 78000 | EUR | 6.5 | 5070 | EUR | 0 | 2021-12-01 | 2021-12-31 | Annual premium settlement |
| TXN000018 | Standard | 0 | false | blank | Treaty | TRT-2022-0018 | CED-IN-HDFC | RE-SG-GIC | POL-IN-78643 | BDX-2022-0018 | 2022-04-25 | 2022-04-01 | 2023-03-31 | 43000 | INR | 7 | 3010 | INR | 0 | 2022-04-01 | 2022-04-30 | Quarterly premium for treaty |
| TXN000019 | Sliding Scale | 0 | false | blank | Facultative | FAC-2021-0019 | CED-CH-Baloise | RE-DE-MunichRe | POL-CH-76342 | blank | 2021-09-19 | 2021-09-01 | 2022-08-31 | 160000 | CHF | 65 | 104000 | CHF | 0 | blank | blank | Sliding scale commission for facultative risk |
| TXN000020 | Standard | 0 | false | blank | Treaty | TRT-2021-0020 | CED-US-Travelers | RE-GB-Lloyds | POL-US-11023 | BDX-2021-0020 | 2021-05-20 | 2021-05-01 | 2022-04-30 | 130000 | USD | 12 | 15600 | USD | 0 | 2021-05-01 | 2021-05-31 | Regular premium settlement |
What the 600 rows show
from the 600-row sampleProfit (commission type) stands out: mean profit_
- 30%is_
settlement_ final = true - 0.0median profit_
commission_ amount - 2treaty types
- 45premium currencies
- 45commission currencies
- 165reinsurers
Median 0.0, from 0.0 to 10,500.
- string 12
- float 5
- date 5
- boolean 1
Columns
23 columns in four groups| column | type | description | example |
|---|---|---|---|
| Text 12 columns | |||
transaction_id | string | Unique identifier for each premium and commission transactionunique | TXN000001 |
treaty_type | string | Type of reinsurance agreement (Treaty or Facultative)Treaty · Facultative | Treaty |
treaty_id | string | Unique identifier for the reinsurance treaty or facultative placement | TRT-2021-0001 |
ceding_company_id | string | Unique identifier for the ceding insurance company | CED-US-Franklin |
reinsurer_id | string | Unique identifier for the reinsurer | RE-GB-Lloyds |
policy_number | string | Policy number associated with the ceded premium (if applicable)optional | POL-US-10001 |
bordereaux_reference | string | Reference number or code for the bordereaux reportoptional | BDX-2021-0001 |
premium_currency | string | Currency code for the ceded premium amount (ISO 4217) | USD |
commission_type | string | Type of commission (Standard, Profit, Sliding Scale, etc.)Standard · Profit · Sliding Scale · Other | Standard |
commission_currency | string | Currency code for the commission amount (ISO 4217) | USD |
adjustment_reason | string | Reason for premium adjustment (e.g., audit, correction, endorsement)optional | Full cancellation |
remarks | string | Additional notes or comments about the transactionoptional | Standard treaty premium |
| Numbers 5 columns | |||
ceded_premium_amount | float | Amount of premium ceded to the reinsurer0 or more | 250000.45 |
commission_rate | float | Commission rate as a percentage (e.g., 10.5 for 10.5%)0 to 100 | 10 |
commission_amount | float | Commission amount paid to the ceding company or reinsurer0 or more | 25000.05 |
profit_commission_amount | float | Amount of profit commission paid (if applicable)0 or more · optional | 0 |
premium_adjustment_amount | float | Adjustment amount applied to the ceded premium (positive or negative)optional | 0 |
| Dates and times 5 columns | |||
transaction_date | date | Date when the premium or commission transaction occurred | 2021-03-15 |
effective_date | date | Effective date of the reinsurance coverage for this transaction | 2021-03-01 |
expiry_date | date | Expiry date of the reinsurance coverage for this transactionoptional | 2022-02-28 |
reporting_period_start | date | Start date of the reporting period for the bordereauxoptional | 2021-03-01 |
reporting_period_end | date | End date of the reporting period for the bordereauxoptional | 2021-03-31 |
| True or false 1 column | |||
is_settlement_final | boolean | Indicates if the transaction is a final settlement (true) or provisional (false) | false |
Use it for
An insurance dashboard
The is_
settlement_ final rate, profit_ commission_ amount by commission_ type and a breakdown of adjustment_ reason. Excel, Power BI or Tableau. Why do the 75 Profit rows have a mean profit_
commission_ amount of 4,800? A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
- Transactions600TXN0000010StandardTXN0000050StandardTXN0000060Other
A software demo
Believable transactions with treaty_
type, treaty_ id and ceding_ company_ id to fill a screen in front of a buyer.
This dataset600 rows23 columns
Yours1,000 rows23 columns
blueprint · reinsurance-premium-and-commission-accounting
Behind this dataset
Same schema. As many rows as you need.
These 600 rows came out of a blueprint — 23 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
- Ceded premium = gross premium × cession percentage (quota share)
- Ceded premium calculated per treaty terms
- Bordereaux: detailed reporting to reinsurers (monthly/quarterly)
- Premium bordereaux vs loss bordereaux
- Ceding commission received from reinsurer
- Profit commission calculated annually
- Deposit premium vs final premium adjustment
- Portfolio premium on inception
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-premium-and-commission-accounting