Zero Premium Records in Reinsurance Bordereaux: Scorecard
On this page
- Key Takeaways
- What Are Zero Premium Records in Reinsurance Bordereaux?
- Which Kinds of Zero Premium Rows Appear on Reinsurance Bordereaux?
- What Staged Checklist Classifies Zero Premium Records?
- How Is Materiality Scored for Zero Premium Records?
- What Does a Filled Zero Premium Scorecard Look Like?
- Which Formulas Isolate Zero Premium Rows in a Bordereau?
- How Does Insurnest Treat Zero Premium Rows in Reconciliation?
- Key Terms
- Sources
- Frequently Asked Questions
Last reviewed: November 2026
The quarter's bordereau balanced to the cent. Fifty-eight rows had sum insured and a premium of exactly zero.
Some were harmless address changes. Three were large commercial risks that nobody had rated.
Zero premium records in reinsurance bordereaux are rows that carry exposure but no ceded premium for the period.
Each one is either a legitimate nil-value transaction or premium the reinsurer is owed for risk it already carries.
This guide gives you seven zero-row types, a staged classification checklist, a materiality score grid and a filled scorecard.
Key Takeaways
- Zero is not blank. A blank premium is missing data; a zero is a stated value that needs a reason.
- Classify before you chase. Most zero rows are legitimate; score them to find the few that are not.
- Read rows in context. Master premiums, instalments and reinstatements explain many zeros.
- Repeats raise the score. A zero row that returns next quarter is a process fault.
What Are Zero Premium Records in Reinsurance Bordereaux?
Zero premium records in reinsurance bordereaux are risk rows with a ceded premium of nil in the period reported.
Refunds and reversals are different: they are covered in negative premiums in reinsurance bordereaux.
Why does a zero premium row still matter to a quota share reinsurer?
A zero premium row still matters to a quota share reinsurer because the risk is shared whether or not premium arrived.
The Munich Re glossary says a quota share reinsurer shares "all premiums and losses" in the agreed percentage.
A missing premium on a ceded risk breaks that balance. Your exposure to premium reconciliation will show the gap.
Which Kinds of Zero Premium Rows Appear on Reinsurance Bordereaux?
Zero premium rows on reinsurance bordereaux fall into seven kinds, and only one is plainly an error.
| Row type | How it looks | Evidence to request | Usually |
|---|---|---|---|
| Nil endorsement | Name or address change, same sum insured | Endorsement schedule | Legitimate |
| Free cover or no-charge extension | Added benefit, no premium | Policy wording, treaty cover for it | Check treaty |
| Master policy certificate | Certificates at nil; premium on master | Master row and premium total | Legitimate if matched |
| Instalment timing | Instalment not billed in period | Instalment schedule | Timing |
| Cancel and reinstate | Reinstated row at nil | Both transactions, dates | Check pair |
| Rounding or currency | Tiny premium rounded to 0 | Original currency premium | Low value |
| Missing premium | New risk, sum insured, no rating | Rating sheet | Error |
For instalments, see reinsurance premium instalment tracking.
What Staged Checklist Classifies Zero Premium Records?
A staged checklist classifies zero premium records in five steps, each with an owner and a clear output.
| Stage | Check | Owner | Output |
|---|---|---|---|
| 1. Isolate | Count zero rows, blank rows and sum insured on each | Bordereaux analyst | Zero-row extract |
| 2. Classify | Assign each row a type from the table, with evidence | Bordereaux analyst | Typed list |
| 3. Treaty test | Free cover covered? Master premium matched? Pair complete? | Technical accountant | Pass or query |
| 4. Score | Apply the materiality grid by type | Bordereaux manager | RAG per type |
| 5. Resolve | Query red and amber items; close green with evidence | Technical accountant | Query log, closure note |
Run stage 1 on every bordereau. Run stages 2 to 5 when zero rows exceed your agreed tolerance.
How can a master policy premium explain zero-value certificate rows?
A master policy premium can explain zero-value certificate rows when the scheme's premium is booked once at master level.
Sum premium across all rows with the same master reference. A positive total closes the certificates; a nil total is a missing premium.
How should cancel-and-reinstate pairs be read on a bordereau?
Cancel-and-reinstate pairs on a bordereau should be read as one event, never as two separate rows.
If the cancellation refunded premium and the reinstatement shows zero, the risk is back on cover without premium. Query it.
How Is Materiality Scored for Zero Premium Records?
Materiality for zero premium records is scored 0 to 3 on four factors, giving a total from 0 to 12.
| Factor | 0 | 1 | 2 | 3 |
|---|---|---|---|---|
| A. Row type | Documented legitimate | Timing | Free cover not checked, or open pair | Missing premium |
| B. Sum insured as % of treaty total | Below 0.1% | 0.1–0.5% | 0.5–2% | Above 2% |
| C. Seen on prior bordereau | No | – | Once | Twice or more |
| D. Evidence | Full | Partial | – | None |
RAG rule: 0–3 green, 4–7 amber, 8 or more red. The bands are illustrative; agree yours with the treaty underwriter.
What Does a Filled Zero Premium Scorecard Look Like?
A filled zero premium scorecard, shown below, comes from an illustrative Q2 2026 property quota share bordereau.
The treaty's total sum insured is 1.5bn and the quota share is 40%. The bordereau holds 58 zero rows with 25.5m sum insured.
| Row type | Rows | Sum insured | A | B | C | D | Score | RAG | Action |
|---|---|---|---|---|---|---|---|---|---|
| Nil endorsement | 21 | 6.3m | 0 | 1 | 0 | 0 | 1 | Green | Close with schedule |
| Instalment timing | 14 | 4.2m | 1 | 1 | 2 | 1 | 5 | Amber | Confirm billing dates |
| Master certificates | 9 | 2.7m | 0 | 1 | 0 | 0 | 1 | Green | Master total matched |
| Cancel and reinstate | 6 | 1.8m | 2 | 1 | 0 | 1 | 4 | Amber | Ask for reinstatement premium |
| Free cover extension | 5 | 1.5m | 2 | 1 | 0 | 1 | 4 | Amber | Check treaty wording |
| Missing premium | 3 | 9.0m | 3 | 2 | 0 | 3 | 8 | Red | Query cedent now |
At an illustrative 0.15% rate, the three red rows carry 13,500 of missing premium at 100%. The 40% ceded share is 5,400.
The money is small; the precedent is not. Unrated large risks on a quota share are an underwriting control failure.
Confirm the cedent's rates with rate checks on reinsurance bordereaux.
Which Formulas Isolate Zero Premium Rows in a Bordereau?
Formulas that isolate zero premium rows in a bordereau need columns for premium, sum insured, policy, transaction type and master reference.
Assume D premium, E sum insured, F policy number, G transaction type and H master reference.
Zero premium with exposure =AND(ISNUMBER(D2), D2=0, E2>0)
Blank premium (missing) =ISBLANK(D2)
Zero rows in file =COUNTIFS(D:D,0)
Sum insured on zero rows =SUMIFS(E:E,D:D,0)
Master premium present =SUMIFS(D:D,H:H,H2)>0
Cancellation exists =COUNTIFS(F:F,F2,G:G,"Cancellation")>0
Zero on prior bordereau =COUNTIFS(Prev!F:F,F2,Prev!D:D,0)>0
Microsoft documents both COUNTIFS and SUMIFS for multi-criteria counts and sums.
How Does Insurnest Treat Zero Premium Rows in Reconciliation?
Reinsurance Bordereaux Reconciliation does not classify or score zero premium rows. The checklist above is your team's work.
It calculates each reinsurer's premium share from configured participation and checks those calculations against reference and master data.
It compares the results with bordereaux and premium records, and shows which positions match and which need review.
The platform identifies the difference. Your team decides whether a zero row explains it.
Key Terms
- Nil endorsement: A policy change that carries no additional or return premium.
- Master policy: A single policy covering a scheme, with members shown as certificates.
- Materiality score: A points total that ranks issues by size, type, repetition and evidence.
Sources
- Munich Re: Reinsurance Glossary
- Microsoft Support: COUNTIFS function
- Microsoft Support: SUMIFS function
- Insurnest: Reinsurance Bordereaux Reconciliation
Frequently Asked Questions
What are zero premium records in reinsurance bordereaux?
Zero premium records in reinsurance bordereaux are rows that carry sum insured or exposure but show a ceded premium of exactly nil for the reporting period.
Why does a zero premium row still matter to a quota share reinsurer?
A zero premium row still matters to a quota share reinsurer because the reinsurer shares the risk and its losses, even when no premium for that risk reached the bordereau.
Which kinds of zero premium rows appear on reinsurance bordereaux?
Zero premium rows on reinsurance bordereaux are usually nil endorsements, free cover, master policy certificates, instalment timing, cancel-and-reinstate pairs, rounding, or missing premium errors.
What staged checklist classifies zero premium records?
A staged checklist classifies zero premium records in five steps: isolate the rows, classify each with evidence, test against the treaty, score materiality, then query or close.
How can a master policy premium explain zero-value certificate rows?
A master policy premium can explain zero-value certificate rows when the scheme premium sits on one master row. Sum premium by master reference; a nil total is an error.
How should cancel-and-reinstate pairs be read on a bordereau?
Cancel-and-reinstate pairs on a bordereau should be read together. A reinstatement row showing zero premium after a cancellation that refunded premium leaves exposure ceded without premium.
How is materiality scored for zero premium records?
Materiality for zero premium records is scored 0 to 3 on four factors: row type, sum insured share, repetition and evidence. Totals of 8 or more are red.
Which formulas isolate zero premium rows in a bordereau?
Formulas that isolate zero premium rows in a bordereau use COUNTIFS and SUMIFS for counts and sum insured, plus tests for blank premium, master totals and repeats.

Hitul Mistry
CEO, Insurnest
An InsurTech leader with more than a decade of experience across insurance and technology, focused on solving business problems with the help of technology. Has worked with brokers, insurance carriers, and reinsurance firms across the India, UAE, and US markets.
View LinkedIn profile →