Bordereaux Cut-Off Dates: Stop Late Data Breaking Month-End
On this page
- At a Glance
- What Are Bordereaux Cut-Off Dates?
- Why Does Late Bordereaux Data Break Month-End?
- What Does a Month-End Bordereaux Calendar Look Like?
- How Should You Set Bordereaux Cut-Off Dates for Each Treaty?
- Who Owns Each Bordereaux Cut-Off Date?
- How Does Insurnest Support the Close Window?
- What Should Finance Change Before the Next Close?
- Key Terms
- Sources
- Frequently Asked Questions
Last reviewed: November 2026
Bordereaux that arrive a day after close force finance to estimate, reverse and explain the same numbers twice.
When nobody owns the cut-off, every month-end becomes a negotiation with cedents and brokers.
Bordereaux cut-off dates fix the last moment bordereaux data can enter a period's close.
Anything later is estimated now and trued up next month, on a calendar every cedent and broker knows in advance.
At a Glance
| Close stage | Timing (illustrative) | Main owner |
|---|---|---|
| Expected bordereaux list | 10 working days before period end | Reinsurance accounting |
| Pre-close chase | 3 working days before period end | Reinsurance accounting, brokers |
| Bordereaux cut-off | Working day 2, 12:00 | Financial controller |
| Validate, reconcile, accrue | Working days 3–4 | Reinsurance accounting |
| Close sign-off | Working day 5 | Financial controller, CFO |
| True-up of estimates | Working day 3 of next month | Reinsurance accounting |
What Are Bordereaux Cut-Off Dates?
Bordereaux cut-off dates are the deadlines after which bordereaux data for a period is no longer processed into that period's close.
They sit between the treaty's reporting terms and the company's own close timetable.
Confusion usually starts because several different dates get called "the deadline". The table separates them.
| Date | What it means | Who sets it |
|---|---|---|
| Reporting period end | Last day of the month or quarter the bordereau covers | Treaty wording |
| Bordereaux due date | When the cedent or broker must send the file | Treaty reporting clause |
| Cut-off | Last moment the file can enter this close | Finance team receiving the data |
| Ledger close | When journals for the period are locked | Group finance timetable |
| Settlement due date | When the balance must be paid | Treaty settlement clause |
The bordereaux due date is contractual, while the cut-off is an internal decision.
If the due date falls after your cut-off, that treaty will be estimated every month by design.
Why Does Late Bordereaux Data Break Month-End?
Late bordereaux data breaks month-end because the ledger closes on time whether or not the file has arrived. The gap has to be filled with an estimate.
What happens when a bordereau arrives after cut-off?
A bordereau that arrives after cut-off creates three pieces of work: an estimate this month, a reversal next month and a true-up to actual figures.
Each step is a chance for error. A missed reversal double counts premium, and an unexplained true-up looks like a swing in performance.
Why do cut-off problems often start in the treaty wording?
Cut-off problems often start in the treaty wording because reporting clauses are agreed at placement, long before finance designs its close.
For example, a treaty that allows bordereaux 45 days after quarter end can never meet a working-day-5 close.
That treaty needs a standing estimate method, not a monthly chase.
What Does a Month-End Bordereaux Calendar Look Like?
A month-end bordereaux calendar walks every expected file from the chase list to the true-up. The timings below are illustrative, so fit them to your own close.
| Stage | When | What happens | Who acts | What breaks if skipped |
|---|---|---|---|---|
| Build expected list | WD-10 | List every bordereau due, by treaty, from reporting clauses | Reinsurance accounting | Missing files are noticed only at close |
| Pre-close chase | WD-3 | Remind cedents and brokers of the cut-off and log known delays | Accounting, brokers | Late files arrive with no warning |
| Period end | WD0 | Transactions for the period stop | Operations | One period mixes two months of data |
| Cut-off | WD2, 12:00 | Files received are processed; later files wait | Financial controller | Close timetable slips |
| Validate and reconcile | WD3 | Check totals, shares and periods against registers | Reinsurance accounting | Wrong figures reach the ledger |
| Estimate missing data | WD3–WD4 | Accrue missing bordereaux using the agreed method | Accounting, controller | Reinsurance positions understated |
| Sign-off | WD5 | Review estimates, variances and the late list | Controller, CFO | Unexplained swings in results |
| True-up | Next month WD3 | Reverse estimates and book actuals | Reinsurance accounting | Double counting |
What should happen before period end?
The work before period end is about knowing what to expect.
An expected bordereaux list, built from each treaty's reporting clause, turns "what is missing?" into a simple comparison.
The pre-close chase then confirms which files will be late. Known delays can be estimated calmly rather than discovered on working day 2.
What happens inside the cut-off window?
Inside the cut-off window, files are received, validated and reconciled against premium and claim registers.
The window is short, so any manual rekeying becomes the bottleneck.
Validation should check the period covered, currency, shares and totals before any figure reaches a journal.
Our guide to manual bordereaux reconciliation across cedents explains why this step stalls.
How should late bordereaux be handled after close?
Late bordereaux should be logged with the date received, processed in the next period and matched to the estimate they replace.
The late log becomes evidence. It shows which cedents or brokers miss cut-off repeatedly, and it supports a conversation at renewal.
Claims files are often the latest of all, as our article on why claims bordereaux lag explains.
How do quarter-end and year-end change the calendar?
Quarter-end and year-end tighten the calendar because external reporting, audit and board timetables leave less room for late data.
IFRS 17 applies to annual periods beginning on or after 1 January 2023. It measures groups of insurance contracts using estimates of future cash flows.
Estimates made at cut-off flow into those figures, so their basis should be documented and reviewable.
Our guide to the quarterly close for reinsurance covers the wider timetable.
How Should You Set Bordereaux Cut-Off Dates for Each Treaty?
Bordereaux cut-off dates should be set by treaty tier. A single rule for every treaty either delays the close or hides material late data.
| Treaty tier | Example criteria | Cut-off rule | If the file is late |
|---|---|---|---|
| Tier 1 | Largest premium or claims flows | Soft cut-off up to WD3 if the delay was notified | Controller approves a specific estimate |
| Tier 2 | Mid-sized, stable treaties | Hard cut-off at WD2 | Standard estimate method |
| Tier 3 | Small or run-off treaties | Hard cut-off; quarterly processing allowed | Standing accrual, reviewed quarterly |
| Structurally late | Due date falls after close | Permanent estimate each period | Basis reviewed when actuals arrive |
How should a missing bordereau be estimated?
A missing bordereau should be estimated with a method chosen in advance and applied the same way every month.
Changing method at close is how estimates lose credibility.
Here is a hypothetical example for one quota share treaty:
| Step | Figure (illustrative) |
|---|---|
| Ceded premium, last three months | 410,000; 395,000; 425,000 |
| Three-month average (estimate booked) | 410,000 |
| Actual bordereau received after close | 452,000 |
| True-up booked next month | 42,000 |
| True-up as % of estimate | 10.2% |
A 10.2% true-up is not a failure on its own. A run of true-ups in the same direction, however, means the method needs changing.
A growing book, for example, will always be underestimated by a trailing average. A seasonal book needs the same month from last year instead.
Who Owns Each Bordereaux Cut-Off Date?
Each bordereaux cut-off date needs one named owner. Reinsurance accounting runs the calendar and the financial controller owns the cut-off and the estimates.
The CFO signs off material judgements, especially at quarter-end.
What should cedents, brokers and reinsurers each commit to?
Cedents, brokers and reinsurers should each commit to the part they control.
The cedent sends complete files by the due date, and the broker forwards them without delay.
The receiving finance team publishes its cut-off calendar for the year and confirms receipt of every file.
Lloyd's set out a similar principle for delegated authority data in a 2020 market bulletin.
Corrections were to be made no later than submission of the next bordereau.
A fixed correction window like this stops errors rolling forward from one month to the next.
How Does Insurnest Support the Close Window?
Insurnest supports the close window with Bordereaux Calculation & Reconciliation, which works on the files that arrive before cut-off.
It takes bordereaux statements in each reinsurer's own Excel layout, participation master data, premium and claim registers, and settlement advices.
It calculates premium and claim allocation per reinsurer and reconciles them against those records in one variance view.
Status is shown per reinsurer, such as "3 of 4 positions matched", so the controller can see what is ready to post.
It does not set cut-offs, chase late files or send alerts. It surfaces mismatches, and your accounting team decides why they occurred and how to book them.
What Should Finance Change Before the Next Close?
Finance should make the calendar visible and the estimates repeatable before the next close. None of these steps needs a new system.
- Build the expected bordereaux list from every treaty's reporting clause.
- Tier treaties and publish one cut-off rule per tier.
- Flag treaties whose due date falls after your close and give them a standing estimate method.
- Keep a late log by cedent and broker, and review it before each renewal.
- Track true-ups as a percentage of estimates every month.
- Agree a correction window, so errors are fixed by the next bordereau.
Key Terms
- Cut-off: The last moment data can enter a period's close.
- Bordereaux due date: The contractual date by which a cedent or broker must send a bordereau.
- Accrual: An estimate booked for data that has not yet arrived.
- True-up: The adjustment booked when actual figures replace an estimate.
- Working day (WD): A business day counted from period end, used to schedule the close.
- Correction window: The agreed time within which errors in a bordereau must be fixed.
Sources
- IFRS Foundation: IFRS 17 Insurance Contracts
- Lloyd's: Market Bulletin Y5311 – Conditions of Trade for Delegated Authorities Data (27 October 2020)
- Insurnest: Bordereaux Calculation & Reconciliation
Frequently Asked Questions
What is a bordereaux cut-off date?
A bordereaux cut-off date is the last point at which bordereaux data for a period can be processed into that period's close. Data arriving later is booked in the next period, while a documented estimate covers the gap so the current month still reflects the business ceded or assumed.
Why do late bordereaux break the month-end close?
Late bordereaux break the month-end close because ceded premium, claims and balances for the affected treaties are missing when journals are posted. Finance then has to estimate, reverse and true up, which adds work, creates variances and makes reinsurance positions harder to explain to management and auditors.
How should a missing bordereau be estimated at month-end?
A missing bordereau should be estimated with a method agreed in advance, such as a recent monthly average, the estimated premium income spread evenly, or a flash figure from the cedent. The basis should be recorded, reversed next period and compared with the actual bordereau when it arrives.
Who should set bordereaux cut-off dates?
Bordereaux cut-off dates should be set by reinsurance accounting with the financial controller, then shared with brokers and cedents. The dates must fit the reporting terms in each treaty, the group close timetable and the capacity of the team that validates and reconciles incoming bordereaux.
How do you measure whether bordereaux cut-off dates are working?
Bordereaux cut-off dates can be measured by the share of expected files received before cut-off, the number and value of accruals, the size of true-ups the following month and late arrivals by cedent or broker. Trends across several closes show whether the calendar is realistic.
Can automation help with bordereaux cut-off dates?
Automation helps with bordereaux cut-off dates mainly inside the close window, by speeding up calculation and reconciliation once files arrive. Automation does not make cedents send data earlier, so the calendar, the chase list and the escalation route still need people who own them.
What is the difference between a hard and a soft bordereaux cut-off?
A hard bordereaux cut-off means no data is processed after the set time and anything late is estimated. A soft cut-off lets material late data in if it arrives before journals are posted. A practical design uses soft cut-offs only for the largest treaties and hard ones elsewhere.
Should quarter-end use the same bordereaux cut-off as month-end?
Quarter-end often needs a stricter bordereaux cut-off than month-end because external reporting, audit and board timetables are tighter. Keeping the same calendar shape helps, but material estimates should be reviewed with the controller earlier and the expected bordereaux list checked before period end.

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 →