Bordereaux Management for MGAs

If you run an MGA, MGU, program administrator, or Lloyd’s coverholder, you already know what a bordereau is, a periodic schedule of written premium, claims, or exposure sent to a carrier or reinsurer under delegated authority. The practical problem is different. A bordereau is a report you file. A ledger is a record you can defend. Many MGAs have the first and not the second.

That gap matters because your largest variable income line, especially profit commission, is often calculated from a version of the book the carrier controls. If premium, claims, cash, producer commissions, and treaty-year accruals do not tie back to your own records, you are left arguing from spreadsheets instead of from a reconciled book. This article is about the reverse problem, which is how an MGA owns its own ledger even when every carrier wants its own bordereau format. In bordereaux management terms, we think the ledger is the half worth owning.

What a Carrier Does With Your Bordereau

On the carrier side, bordereaux management usually means ingesting the file, validating the fields, matching it to policies and claims, and using it to calculate loss ratio, commission, and profit commission. That is why many products in this market focus on extraction, workflow, and carrier reporting. They help the recipient consume your file.

For the MGA, that is not enough. We want you to be able to prove what was written, what was bound, what was remitted, what commission was paid, what was returned after cancellation, and what claims have been incurred or developed. If the carrier’s file is the only place those numbers live in a joined form, then the carrier owns the version that counts.

Where Bordereaux Reconciliation Breaks Quietly

The breakage is usually quiet, not dramatic. The same policy can appear under slightly different identifiers in premium and claims files. A mid-term endorsement can change the premium base, but the claims bordereau still points at the old policy number. A return premium after cancellation may be posted in cash but never reflected in the producer commission ledger. A claim may arrive in a different currency or with a class code that does not map cleanly to the premium file.

We treat these as normal, not as edge cases. They are the normal result of delegated authority reporting across multiple carrier templates, different policy administration systems, and different operational teams. If you rely on spreadsheet joins, the book can look close enough to move money while still being wrong enough to distort profit commission.

The most common failure points are:

• Policy numbers formatted differently in premium and claims files
• Endorsements and mid-term cancellations that change written premium after binding
• Return premium and chargebacks that are settled in cash but not in the producer ledger
• Multi-currency reporting with inconsistent exchange dates
• Coverage or class-code mappings that vary by carrier template
• Period cut-offs, especially around treaty year boundaries

The Three Ledgers an MGA Should Own

If you want an independent record, we would build three linked ledgers, not one master spreadsheet. Each answers a different question, and each should survive carrier-specific reporting formats.

1. Written and Bound Premium

This is the book as sold and bound, not just the amounts remitted. It should include policy number, insured name, producer, effective and expiration dates, coverage class, carrier or program, treaty year, written premium, bound premium, endorsements, cancellations, and currency. If you do not preserve the history of endorsements and cancellations, you will not be able to explain why the carrier’s premium bordereau differs from your own.

2. Cash, Commission, and Producer Splits

This ledger should show what the carrier remitted, what commission was earned, what was paid to each producer, and what was clawed back through chargebacks or return premium. In an MGA with a retail network, this is where the operational truth lives. A policy can be bound, then cancelled, then reinstated, and the producer still needs the correct net commission after all three events.

3. Claims and Loss Development

This ledger should track claim number, policy number, date of loss, report date, incurred amount, paid amount, case reserve, recovery, claims handler, and treaty year. If claims are delegated to a TPA, or third-party administrator, you still need the ability to connect claims movement to the premium book and to the period in which profit commission is measured.

Each ledger can exist on its own. The point is that they should also be joinable. If one file uses a policy number with a leading zero and another drops it, or one file keys off the endorsement number and another does not, the join has to be normalized in your system, not improvised at month-end. For a related example, see billed is not collected, which makes the same point about fee runs.

Profit Commission Is an Accrual Problem Before a Payment Problem

Profit commission is the payment, often from a carrier or syndicate, that depends on the profitability of the program or treaty year. The exact formula varies, but the ingredients are usually some combination of earned premium, claims incurred, expenses, ceding commission, and agreed profit share. Our view is that you should model the accrual yourself for every bordereau, even if the carrier ultimately makes the payment.

That means you need to know the carrier’s formula, the thresholds, the exclusions, and the accounting basis. Is loss ratio measured on incurred claims or paid claims? Are IBNR reserves, incurred but not reported, included? Are there sliding scales? Is profit commission measured by treaty year, underwriting year, or calendar year? Does the calculation reset after a portfolio transfer or termination?

A simple internal model does not need to be perfect to be useful. It needs to be reproducible. If the carrier says the accrual is 8.2 percent and your book says 6.9 percent, you should be able to identify whether the gap comes from a missing endorsement, an unposted return premium, a claims reserve movement, or a period mismatch.

The practical test is simple. Can you explain your own accrual from source records without asking the carrier to rebuild it for you? If not, you do not own the number, even if it appears on your income statement.

How to Treat Carrier Templates as Configuration

Many MGAs start with seven separate workbook habits because each carrier asks for a different bordereau layout. That works until the eighth carrier arrives, or until one carrier changes its template and every downstream formula breaks.

A better approach, in our view, is to treat carrier templates as configuration, not as separate operating systems. The source data should stay in your own canonical model. Each carrier’s format should be a mapping layer that translates your record into the fields that carrier wants. Lloyd’s publishes reporting standards with a premium template and a claims template for coverholders, which is a useful model for the shape of a canonical record.

The honest test is simple. What does it cost you to add the eighth carrier?

• If the answer is another custom workbook, the process is still manual.
• If the answer is a mapping update with no change to the underlying ledger, you have a system.
• If the answer involves re-keying the same policies in several places, the work is being duplicated instead of normalized.

This is where bordereaux management software, policy administration systems, and carrier portals need to be separated in your thinking. The policy admin system captures the transaction. The carrier portal receives the report. The thin reconciliation layer in the middle is what keeps the MGA’s own book defensible.

Which Layers to Build and Which to Buy

We do not think you need to build everything. You do need to know which layer must stay under your control.

• Policy administration system should stay the system of record for binding, endorsements, cancellations, producers, and policy history.
• Bordereaux vendor or MGA software is useful for template generation, file ingestion, and carrier-specific reporting, especially when you have many programs.
• Carrier portal is the carrier’s view, not your ledger, and that is worth accepting.
• Reconciliation layer should remain yours. It ties premium, cash, commission, and claims together and preserves the history needed to defend every number.

If you buy only carrier-facing tooling, you may reduce file preparation time while leaving the core problem untouched. You will still have to answer the question that matters most to the owner. What do we believe the book is, independent of the carrier’s statement?

What to Keep When a Program Ends or Moves

Program termination and portfolio transfer are where weak records become expensive. Once a program winds down, you may still have open claims, return premium, late endorsements, chargebacks, and a profit commission calculation that closes much later than the last bordereau filing.

At minimum, we would keep the full transaction history for every policy, all carrier submissions, all accepted remittances, all commission statements, all producer settlements, and all claims movements by treaty year. You also need the mapping logic that explains how old carrier fields were translated into your canonical record. Without that, a future audit or dispute becomes a manual forensic exercise.

The point is not archival for its own sake. It is continuity. If a portfolio transfers, you should still be able to reproduce the book as it stood on the transfer date and reconcile any later movements against it.

A Useful Way to Evaluate Your Current Setup

We ask three questions about each program:

• Can we reproduce written premium, cash, commission, and claims from our own source records without using the carrier’s statement as the starting point?
• Can we explain every difference between our book and the carrier’s by policy, endorsement, claim, or timing?
• Can we model profit commission ourselves, to the same treaty-year basis the carrier uses?

If the answer to any of those is no, the problem is not just bordereaux production. It is bordereaux reconciliation, and it belongs in the core operating model rather than in the monthly reporting scramble.

Why Bordereaux Management Matters Now

Delegated authority business is growing, and so is the pressure for cleaner reporting. Insurance Journal, reporting on the TMPAA State of Program Business study, puts program business at about 79 billion dollars in 2022, up from 53.8 billion in 2020. That kind of growth does not reduce the reporting burden. It multiplies it. The more programs you add, the more often the gaps between premium, claims, and cash show up.

There is also a practical difference between AI extraction and reconciliation. Extraction helps a carrier ingest your file faster. It does not solve the MGA’s need to own a reconciled book. If your margin depends on data you cannot independently recreate, speed alone will not fix the risk.

For operators who want a broader example of reconciliation-shaped finance work, we have written about finance systems in fintech, including our fintech software development work. The specific domain is different, but the core problem is the same. Keep the internal record strong enough to challenge a counterparty statement. We also cover the receivables side in the company that owes you is the only one keeping score.

Own the Book Behind Every Bordereau

If you are choosing between another bordereau tool and a reconciliation layer you control, the simplest question is this. Which one helps you own the book that your income depends on? Start there, and treat bordereaux management as the part of the work that produces files while the ledger stays yours. To see how we approach reconciliation work, start with Better Software.

Frequently Asked Questions

What Is a Bordereau Report in Insurance?

A bordereau report is a periodic report, usually a spreadsheet or structured file, that lists the premium written, claims reported, exposure bound, or related data for delegated authority business. We would add that it is not, by itself, an MGA’s independent ledger, which still has to reconcile back to source transactions.

Is It Bordereau or Bordereaux?

Bordereau is singular and bordereaux is plural. In insurance, people often use bordereaux management to describe the process of producing, validating, and reconciling those recurring reports across programs and carriers. We use the singular for one report and the plural for the process and for several reports.

What Is Bordereaux Management in Insurance?

Bordereaux management is the process of producing, validating, and reconciling recurring bordereau reports across programs and carriers. On the carrier side it means ingesting the file and matching it to policies and claims. For an MGA, we think it also has to include a reconciled book that the MGA controls.

What Goes in a Premium Bordereau Versus a Claims Bordereau?

A premium bordereau usually carries policy and financial data such as policy number, insured, dates, premium written, endorsements, cancellations, commission, and currency. A claims bordereau carries claim-level data such as claim number, date of loss, paid amount, reserve, and incurred amount. We key both to the same normalized identifiers.

What Is MGA Profit Commission?

Profit commission is the payment, often from a carrier or syndicate, that depends on the profitability of the program or treaty year. Its ingredients are usually earned premium, claims incurred, expenses, ceding commission, and an agreed profit share. We recommend that an MGA model the accrual itself even when the carrier makes the payment.