Reinsurance

Zero Premium Records in Reinsurance Bordereaux: Scorecard

On this page

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 typeHow it looksEvidence to requestUsually
Nil endorsementName or address change, same sum insuredEndorsement scheduleLegitimate
Free cover or no-charge extensionAdded benefit, no premiumPolicy wording, treaty cover for itCheck treaty
Master policy certificateCertificates at nil; premium on masterMaster row and premium totalLegitimate if matched
Instalment timingInstalment not billed in periodInstalment scheduleTiming
Cancel and reinstateReinstated row at nilBoth transactions, datesCheck pair
Rounding or currencyTiny premium rounded to 0Original currency premiumLow value
Missing premiumNew risk, sum insured, no ratingRating sheetError

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.

StageCheckOwnerOutput
1. IsolateCount zero rows, blank rows and sum insured on eachBordereaux analystZero-row extract
2. ClassifyAssign each row a type from the table, with evidenceBordereaux analystTyped list
3. Treaty testFree cover covered? Master premium matched? Pair complete?Technical accountantPass or query
4. ScoreApply the materiality grid by typeBordereaux managerRAG per type
5. ResolveQuery red and amber items; close green with evidenceTechnical accountantQuery 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.

Factor0123
A. Row typeDocumented legitimateTimingFree cover not checked, or open pairMissing premium
B. Sum insured as % of treaty totalBelow 0.1%0.1–0.5%0.5–2%Above 2%
C. Seen on prior bordereauNo–OnceTwice or more
D. EvidenceFullPartial–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 typeRowsSum insuredABCDScoreRAGAction
Nil endorsement216.3m01001GreenClose with schedule
Instalment timing144.2m11215AmberConfirm billing dates
Master certificates92.7m01001GreenMaster total matched
Cancel and reinstate61.8m21014AmberAsk for reinstatement premium
Free cover extension51.5m21014AmberCheck treaty wording
Missing premium39.0m32038RedQuery 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

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

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 →
ShareLinkedInX

Read our latest blogs and research

Featured Resources

Reinsurance

Negative Premiums in Reinsurance Bordereaux: Decision Table

negative premiums in reinsurance bordereaux: a decision table for genuine returns vs data errors, the evidence to request, who signs off and eight mini cases.

Read more
Reinsurance

Rate Checks on Reinsurance Bordereaux: Rule Spec & Example

rate checks on reinsurance bordereaux: a field-by-field rule spec, the exceptions to allow and a worked 1.2‰ vs 2.0‰ example that finds premium ceded cheaply.

Read more
Reinsurance

Exposure to Premium Reconciliation: Match Risk and Premium

Exposure to premium reconciliation checks that ceded sums insured and premium agree. Includes a worked implied rate test and a break table with fixes.

Read more

Meet Our Innovators:

We aim to revolutionize how businesses operate through digital technology driving industry growth and positioning ourselves as global leaders.

circle basecircle base
Pioneering Digital Solutions in Insurance

Insurnest

Empowering insurers, re-insurers, and brokers to excel with innovative technology.

Insurnest specializes in digital solutions for the insurance sector, helping insurers, re-insurers, and brokers enhance operations and customer experiences with cutting-edge technology. Our deep industry expertise enables us to address unique challenges and drive competitiveness in a dynamic market.

Get in Touch with us

Ready to transform your business? Contact us now!

We respond within one business day.