Reinsurance

Bordereaux Cut-Off Dates: Stop Late Data Breaking Month-End

On this page

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 stageTiming (illustrative)Main owner
Expected bordereaux list10 working days before period endReinsurance accounting
Pre-close chase3 working days before period endReinsurance accounting, brokers
Bordereaux cut-offWorking day 2, 12:00Financial controller
Validate, reconcile, accrueWorking days 3–4Reinsurance accounting
Close sign-offWorking day 5Financial controller, CFO
True-up of estimatesWorking day 3 of next monthReinsurance 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.

DateWhat it meansWho sets it
Reporting period endLast day of the month or quarter the bordereau coversTreaty wording
Bordereaux due dateWhen the cedent or broker must send the fileTreaty reporting clause
Cut-offLast moment the file can enter this closeFinance team receiving the data
Ledger closeWhen journals for the period are lockedGroup finance timetable
Settlement due dateWhen the balance must be paidTreaty 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.

StageWhenWhat happensWho actsWhat breaks if skipped
Build expected listWD-10List every bordereau due, by treaty, from reporting clausesReinsurance accountingMissing files are noticed only at close
Pre-close chaseWD-3Remind cedents and brokers of the cut-off and log known delaysAccounting, brokersLate files arrive with no warning
Period endWD0Transactions for the period stopOperationsOne period mixes two months of data
Cut-offWD2, 12:00Files received are processed; later files waitFinancial controllerClose timetable slips
Validate and reconcileWD3Check totals, shares and periods against registersReinsurance accountingWrong figures reach the ledger
Estimate missing dataWD3–WD4Accrue missing bordereaux using the agreed methodAccounting, controllerReinsurance positions understated
Sign-offWD5Review estimates, variances and the late listController, CFOUnexplained swings in results
True-upNext month WD3Reverse estimates and book actualsReinsurance accountingDouble 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 tierExample criteriaCut-off ruleIf the file is late
Tier 1Largest premium or claims flowsSoft cut-off up to WD3 if the delay was notifiedController approves a specific estimate
Tier 2Mid-sized, stable treatiesHard cut-off at WD2Standard estimate method
Tier 3Small or run-off treatiesHard cut-off; quarterly processing allowedStanding accrual, reviewed quarterly
Structurally lateDue date falls after closePermanent estimate each periodBasis 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:

StepFigure (illustrative)
Ceded premium, last three months410,000; 395,000; 425,000
Three-month average (estimate booked)410,000
Actual bordereau received after close452,000
True-up booked next month42,000
True-up as % of estimate10.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

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

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

The Quarterly Close for Reinsurance: Cutting Reconciliation Time Without Sacrificing Controls

The quarterly close for reinsurance consumes weeks of manual reconciliation. Learn how close orchestration cuts reconciliation time while strengthening financial controls and audit readiness.

Read more
Reinsurance

Claims Bordereaux Lag: Building Earlier Reserve and Cash Forecasts

Claims bordereaux lag delays reserving and cash forecasting. Learn how reinsurers can build earlier reserve estimates and liquidity forecasts despite incomplete and late-arriving claims data.

Read more
Insurance

How to Automate Bordereaux Processing for Insurance Carriers

Insurance CTOs need a practical way to improve bordereaux processing automation without disrupting core operations. This guide explains the architecture, data, security, integration, and delivery decisions behind bordereaux processing automation.

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.