Reinsurance Bordereaux Sign-Off: Approval Limits and Tests
On this page
- Key Takeaways
- What Is Reinsurance Bordereaux Sign-Off?
- Who Should Approve a Cedent Bordereau at Each Variance Size?
- Which Controls Make Up a Bordereaux Sign-Off Test Plan?
- What Should a Bordereaux Sign-Off Record Capture?
- What KPI Targets Show Bordereaux Sign-Off Is Working?
- How Does Insurnest Help Before a Bordereau Is Signed Off?
- Key Terms
- Sources
- Frequently Asked Questions
Last reviewed: November 2026
The Q3 premium bordereau was signed off on a Friday by the analyst who had prepared it. It was booked on Monday.
In December, the auditor asked who approved a USD 140,000 difference. The log showed one name, twice.
Reinsurance bordereaux sign-off is the recorded approval that a cedent's file has been checked, explained and is fit to book.
It matters because a bordereau booked without sign-off flows straight into technical accounts, reserves and settlements.
This guide gives you a variance-based approval matrix, a seven-control test plan, a sign-off record template, KPI targets and one tested month.
Key Takeaways
- Size decides the approver. Bigger variances go to more senior people.
- Preparer never approves. Segregation is tested on the whole population.
- Book only what is signed. No ledger posting before the sign-off date.
- Open variances need owners. A reason, a name and a clear date.
What Is Reinsurance Bordereaux Sign-Off?
Reinsurance bordereaux sign-off is the control point between receiving a cedent's file and booking its figures.
For UK firms, PRA rule 12.1 requires data used for technical provisions to be "appropriate, complete and accurate".
Bordereaux feed that data, so sign-off is where you evidence it. Back-loaded files need it too; see historical bordereaux loading for reinsurers.
Lloyd's delegated-authority platform has a similar step: its premium bordereaux procedure lists "final approval of processed bordereaux".
Who Should Approve a Cedent Bordereau at Each Variance Size?
Approval of a cedent bordereau should depend on the size of the variance between reported and calculated values.
Use whichever of the percentage or amount test puts the file in the higher band. Thresholds below are illustrative; set your own.
| Variance band | Approver | Second check | Evidence | Sign-off within |
|---|---|---|---|---|
| Nil, or ≤0.5% and ≤USD 5,000 | Bordereaux analyst (not the preparer) | None | Reconciliation result, tie-out | 3 working days |
| >0.5% to 2%, or ≤USD 25,000 | Bordereaux team lead | Analyst's cause note | Variance reason, cedent query ref | 5 working days |
| >2% to 5%, or ≤USD 100,000 | Technical accounting manager | Underwriter informed | Cause, correction plan | 7 working days |
| >5%, or >USD 100,000 | Head of Technical Accounting | Underwriter agrees | Written decision: book, adjust or hold | 10 working days |
| Unmapped treaty, wrong period, unexplained negatives | No sign-off: hold | Not applicable | Rejection note to cedent | Same day |
Unexplained negatives are covered in negative premiums in reinsurance bordereaux.
Can a reinsurance bordereau be signed off with an open variance?
A reinsurance bordereau can be signed off with an open variance only within the approver's band and with the variance documented.
The record needs a cause, an owner and a clear date. An illustrative limit is 60 days before it escalates one band.
If the cedent must correct the file, route it through bordereau resubmission handling instead.
Which Controls Make Up a Bordereaux Sign-Off Test Plan?
A bordereaux sign-off test plan is seven controls, each with a test step, frequency, sample, evidence, threshold and owner.
| Control | Test step | Frequency | Sample | Evidence | Threshold | Owner |
|---|---|---|---|---|---|---|
| C1 Expected vs received | Match the treaty reporting schedule to the receipt log | Monthly | All treaties | Receipt log | 0 unlogged files | Bordereaux manager |
| C2 Control totals | Re-add rows; tie premium, claims and row count to cedent statement | Each file | 100% | Tie-out sheet | Difference 0 | Analyst |
| C3 Share recalculation | Our share = 100% amount x signed line; compare to file | Each file | 100% | Reconciliation output | Within band | Analyst |
| C4 Approval in band | Match approver role to the matrix band | Monthly | All files above band 1 | Sign-off log | 0 exceptions | Internal control |
| C5 Segregation | Preparer ID differs from approver ID | Monthly | 100% | Sign-off log | 0 exceptions | Internal control |
| C6 Booked equals signed | Ledger postings match signed amounts and dates | Monthly | 25 random postings | Ledger extract | 0 differences | Technical accounting |
| C7 Aged open variances | Each open variance has cause, owner, clear date | Monthly | 100% | Variance register | None over 60 days | Bordereaux manager |
C2 catches a file that does not add up to itself. C3 catches a file that adds up but is wrong for your line.
Add rate checks on reinsurance bordereaux where premium depends on applied rates.
How do you test segregation of duties in bordereaux sign-off?
To test segregation of duties in bordereaux sign-off, test the full month's log, not a sample.
- Export the sign-off log with preparer ID, approver ID and timestamps.
- Flag rows where the two IDs match, or where the approver edited the file after preparation.
- Flag approvals timed before the preparation was complete.
- Report any exception to the Head of Technical Accounting the same week.
What Should a Bordereaux Sign-Off Record Capture?
A bordereaux sign-off record should capture enough for a reviewer to repeat the decision without asking anyone.
BORDEREAUX SIGN-OFF RECORD
Cedent / treaty / UY : [name] / [treaty ref] / [year]
Bordereau : [premium | claims], period [from-to],
version [n], received [date]
Control totals : rows [n], premium [amt], claims [amt]
tie to cedent statement: [yes | no]
Reported vs calculated : [amt] vs [amt]; variance [amt] [%]
Variance band : [1-4 | hold]
Cause : [text]; cedent query ref [ref]
Open variance : [none | amount, owner, clear date]
Prepared by / date : [ID] [date]
Approved by / date : [ID, role] [date]
Booking reference : [ledger batch], posted [date]
Version numbers matter when files are replaced; period comparison shows what changed between them.
What KPI Targets Show Bordereaux Sign-Off Is Working?
KPI targets that show bordereaux sign-off is working measure speed, quality and control breaches separately.
| KPI | Formula | Illustrative target |
|---|---|---|
| Timeliness | Files signed within band limit / files received | ≥95% |
| First-time sign-off | Files signed without resubmission / files signed | ≥85% |
| Approval exceptions | Approvals outside the matrix | 0 |
| Booked before sign-off | Postings dated before sign-off | 0 |
| Aged open variances | Open variances over 60 days | 0 |
What does one month of bordereaux sign-off testing look like?
One month of bordereaux sign-off testing, illustrated below for October 2026, shows how the KPIs and controls read together.
| Test | Result | Status | Action |
|---|---|---|---|
| Files received (C1) | 42 of 42 expected logged | Pass | None |
| Timeliness | 38 / 42 = 90.5% | Miss | Two claims files waited on underwriter review |
| First-time sign-off | 35 / 42 = 83.3% | Miss | Raise template issues with two cedents |
| Segregation (C5) | 1 file prepared and approved by one ID | Fail | Re-approve; restrict system rights |
| Approval in band (C4) | 1 band-3 file approved by a team lead | Fail | Manager re-approval; retrain |
| Booked equals signed (C6) | 25 of 25 matched | Pass | None |
Two failures in one month are a finding, not a trend. Repeat the test in November before changing the matrix.
How Does Insurnest Help Before a Bordereau Is Signed Off?
Reinsurance Bordereaux Reconciliation does not run a sign-off or approval workflow.
It calculates each reinsurer's premium share and claim liability from configured participation, with reinsurer-level net positions.
It compares those values with bordereaux, master, premium, claim and settlement records, and shows which positions match and which need review.
That gives C3 its evidence. Your team still investigates each variance and decides who signs.
Key Terms
- Variance band: The size range of a reported-versus-calculated difference that sets who may approve it.
- Segregation of duties: The rule that the person who prepares a file does not approve it.
- Control totals: Row counts and sums used to prove a file is complete.
Sources
- Prudential Regulation Authority: Technical Provisions, rule 12.1
- Lloyd's: Delegated Data Manager premium bordereaux standard operating procedure
- Insurnest: Reinsurance Bordereaux Reconciliation
Frequently Asked Questions
What is reinsurance bordereaux sign-off?
Reinsurance bordereaux sign-off is the recorded approval that a cedent's bordereau has been checked, its variances explained, and its figures are fit to book to the reinsurer's ledger.
Who should approve a cedent bordereau at each variance size?
Approval of a cedent bordereau should rise with variance size: an analyst for nil variances, then team lead, manager and Head of Technical Accounting above 5% or USD 100,000.
Can a reinsurance bordereau be signed off with an open variance?
A reinsurance bordereau can be signed off with an open variance only inside the approver's band, with a written cause, a named owner and a clear date, normally within 60 days.
Which controls make up a bordereaux sign-off test plan?
A bordereaux sign-off test plan covers expected versus received files, control totals, share recalculation, approval within band, segregation of duties, booked equals signed, and aged open variances.
How do you test segregation of duties in bordereaux sign-off?
To test segregation of duties in bordereaux sign-off, extract the month's sign-off log and check that every preparer ID differs from the approver ID. The threshold is zero exceptions.
What should a bordereaux sign-off record capture?
A bordereaux sign-off record should capture the treaty, period, file version, control totals, calculated versus reported values, variance band, cause, preparer, approver, date and booking reference.
What KPI targets show bordereaux sign-off is working?
KPI targets that show bordereaux sign-off is working include 95% signed within the band time limit, 85% first-time sign-off, and zero approvals outside the matrix or bookings before sign-off.
What does one month of bordereaux sign-off testing look like?
One month of bordereaux sign-off testing, illustrated for October 2026, found 42 files, 90.5% signed on time, one segregation breach and one approval above the approver's band.

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 →