Bordereaux Analyst

How bordereaux move through Brisc. From the system that writes them to the ledger that acts on them.

Every bordereau has a sender and a receiver, and each side has its own systems of record. Brisc sits between them: it reads what arrives in any layout, checks it against your contracts and your own history, and once your team signs off, updates your systems, by API or as a file they load: bordereau data, the paid bordereau and cash calls. Your systems stay the system of record.

The map

Where does Brisc sit?

On top of the systems that produce bordereaux and the ones that act on them, on either side of the exchange. Brisc reads the files those systems produce and updates them after review, by API or as a file they load. The only things it keeps for itself are the record of what it has seen and the trail of who decided what. The wider picture, who sends, who receives and where Brisc sits, is on Where Brisc fits.

SENDER · CEDENT, MGA, COVERHOLDER IN TRANSIT RECEIVER · CARRIER, REINSURER, SYNDICATE YOUR SYSTEMS BRISC KEPT · REVIEWED Policy, claimsdata warehouse Treaty termsfinance totals Target layoutcarrier, reinsurer Inbox, uploadscheduled pull Contractbinder, treaty Bankstatements Reinsurancesystem, GL, lake extract terms, totals layout file arrives terms cash lines posts Extractyour file Checkbefore it leaves Producein their layout Bordereaupremium or claims email, portal, broker Ingestany layout Mapto one schema Validatenamed checks Reconcileto cash Postdata, payments, calls Lineageeach output row traced to its source records Program recordevery row, every version compare, then update Review queuea person acknowledges or acts flags breaks
The same platform runs either lane, depending on which side of the exchange you sit. Brisc keeps two things of its own: the lineage of every row it produces, and the program record that every new file is compared against. Everything else stays in your systems.
Ingestion

What happens when a bordereau arrives?

Six steps run in order on every file, premium or claims, before a single check fires.

01 · ARRIVE

Files come in the way they already travel

Forwarded to a dedicated inbox, uploaded with the reporting month, or pulled on a schedule from your storage. Most arrive as Excel; CSV is read too, and password-protected workbooks open.

02 · OPEN

Real-world workbooks open cleanly

The header row is found even when it isn’t row one. Sheets that share the main layout are combined, summary and pivot tabs are left out, and every row is stamped with its source sheet.

03 · RECOGNISE

The layout is fingerprinted

Each sender’s set of columns gets a fingerprint. A known layout applies its saved mapping automatically. Column order doesn’t matter.

04 · MAP ONCE

A new layout is mapped once, guided

An unfamiliar file opens a guided mapping: its columns and sample rows on screen, with suggested mappings to confirm. Mappings are versioned, and every row records which version produced it.

05 · NORMALISE

One schema, whatever arrived

Dates, amounts, Y/N flags, state codes and claim statuses are made consistent. Broker naming variants resolve to one name. Blank rows are dropped and counted.

06 · IDENTIFY

Every row knows if it’s new

A composite identity and a content hash tell new rows, changed rows and unchanged rows apart. A changed row becomes a new version; the old one is kept.

The detail on formats and standardisation is on bordereaux ingestion and processing.

Column drift

What happens when a sender changes their template?

Templates drift every renewal. Brisc compares the new layout with the mappings it already holds for the program, applies the changes that are safe, and pauses the file for the rest, with the reason in plain English, before anything is written. Brisc updates the mapping and the same file resumes with no re-upload. Every change it applies is written to the run summary.

The changeWhat Brisc doesOutcome
Columns reordered Nothing to do. The fingerprint ignores order. Applied
Column added The saved mapping still applies. The new column is set aside and noted in the run summary. Applied
Column renamed to a known alias Matched through the alias catalogue. The mapping learns the new spelling. Applied
Column removed Applied and noted, as long as the column wasn’t part of how rows are identified. Applied
Column renamed to something unfamiliar A suggested match goes to review with the reason shown. Key fields and money fields wait for a person. Suggested
An identifying column removed The file pauses with a plain-English reason. Brisc updates the mapping and the same file resumes. Paused, then resumed
Too little overlap, or two saved layouts fit equally well The file pauses and shows the closest saved layouts. Brisc picks or adjusts one and the file resumes. Paused, then resumed

Suggestions are confirmed by a person before they change a mapping. Key fields and money fields are remapped only by a person.

What Brisc keeps

What is each new file checked against?

Against your contracts, and against Brisc’s own record of the program: every row it has received, in every version, with what changed and when.

The last version you accepted

The baseline for every version-to-version check. A premium that moved, a claim that reopened or a row that vanished shows up against it, with before and after side by side.

The way you report

Each program is set as inception to date, month to date, or changes only. A missing row means something different on each, and the checks know which. Monthly movements roll up into inception-to-date figures.

Every version kept

A changed row becomes a new version and the old one is kept. Each row carries the file, sheet and mapping version it came from, so any figure can be traced back to its source.

Validation

Which checks run?

Named checks run at ingestion on every file and every version. Each is switched on, ordered and tuned per program. A check whose fields aren’t in your file says so, rather than passing or failing by default. Every check is named in the validation check library.

Version to version

Every row against the last version you accepted: silent premium changes, disappearing rows, claims moving backwards, indemnity dropping, open claims vanishing without being closed.

Footing

Does each row add up? Incurred, paid, reserves and expenses on claims; net to facility, commission and share applied on premium. Set up per program.

Contract and reference

Commission against the contracted rate, tax and levies by jurisdiction, and others set up per program.

Row sense

Reported before the loss happened, a sign that contradicts its transaction type, duplicates, invalid dates and identifiers, currency and FX, amounts outside the program’s usual band.

Ready for cash

Rows missing what the downstream cash match will need, flagged a month before the reconciliation fails.

Opt-in

Structural checks, and checks against the first version Brisc saw of each record. Switched on per program when you want them.

Review

What happens to a flag?

FLAG

Raised with its evidence

Every flag carries the row, the check that fired, the reason and a severity. Nothing is blocked unless you choose to block it.

DECIDE

A person acknowledges or acts

Acknowledge with a reason, one flag or many at once. The decision carries into later runs, so the same flag doesn’t return next month. A changed claim can be held for review: replace, ignore, or keep both.

TRACE

The trail is kept

Who decided, when and why, alongside a field-by-field record of what changed. That is what audit asks for.

Update your systems

What does Brisc hand to our systems?

Once flags are cleared, Brisc updates the systems you already run, by API integration or as a file they load, so nobody re-keys what has already been checked. Your own tools and agents can also pull from Brisc’s API or through MCP agent access. Every update carries the trail back to the source and the decision behind it.

BORDEREAU DATA

Validated rows into your policy, claims and data systems

Accepted premium and claims data, by API or as a load file in your schema, with the version and source of every row attached.

PAYMENTS

Payments posted against the right items

Once cash is matched in the Reconciliation Analyst and approved, the payment is posted to the policy it settles in your policy administration system by API, as it is for Helix today. Brisc records the payment; the money moves on your banking rails.

CASH CALLS

The cash-call ledger

Cash calls backed by the claims bordereau, and the entries that follow, into your reinsurance system or general ledger, by API or as a ledger file they load.

Updates run after review. Your systems stay the system of record; Brisc is how checked data reaches them.

The sender side

We send bordereaux. What does Brisc do for us?

The same engine, pointed the other way. Your extract is read and checked like any inbound file, then produced in the layout the receiving party requires.

Start from your extract

The file your policy admin system or warehouse already produces, in whatever layout it has. No reformatting first.

Check before it leaves

The same checks a careful receiver runs: footing, shares and participation against the authority in the contract, and every movement against last period.

Produce it in their layout

Each program can hold named export layouts in the receiver’s own column order. A column Brisc can’t fill is reported as empty, with the reason.

Systems of record

What does Brisc read, and what does it write?

Brisc reads the files your systems produce, and updates them after review by API or as a file they load. Bank statements are read; nothing is written to the bank.

SystemBrisc readsBrisc updates
Policy admin and claims systems Extracts and bordereaux you send or forward Validated bordereau data by API or load file; payments posted against policies by API, as with a customer’s PAS today
Reinsurance system Statements you forward; contract terms set up per program The cash-call ledger, by API or as a file it loads
General ledger Nothing read directly Reconciled entries and the cash-call ledger, by API or as files it loads
Data warehouse or lake Extract files for the sender side Golden-schema data, every row with its version and source
Contracts and binders The terms configured per program: rates, shares, authority Nothing
Bank Statements, through the Reconciliation Analyst Nothing. Statements are read only.

Reconciling bordereaux to cash is the Reconciliation Analyst. Checking reinsurance statements and cash calls against the contract is the Reinsurance Accounting Analyst.

FAQ

How it works, answered

Do we have to clean our data into a set format first?

No. Send what you send today. Brisc maps each layout once, remembers it, and copes with the usual template changes on its own. Your partners don’t have to change anything either.

Is Brisc a mapping tool or a validation tool?

Both, as one chain: ingestion, mapping, validation against your contracts and your own history, and output in the format the next party needs. Reconciliation to cash is the Reconciliation Analyst, on the same data.

Where does our data live? Does Brisc replace our systems?

Brisc keeps every version of every row it has received, with the change history and the mapping that produced it, in a dedicated tenant on Microsoft Azure. Your policy admin, claims system and ledger stay the system of record. Brisc updates them once your team has signed off, by API or as a file they load, and posts approved payments to your policy administration system by API.

What happens when a sender changes their template?

Reordered, added, removed and renamed columns are handled automatically when it’s safe, and noted in the run summary. When it isn’t, such as a missing identifying column, the file pauses with the reason in plain English before anything is written. Brisc updates the mapping and the same file resumes.

Does Brisc post into our systems, or produce files?

Both. Brisc integrates with your systems by API, as it does with a customer’s policy administration system today, or delivers a file in the layout they load. Your own tools and agents can also pull from Brisc’s API or through MCP agent access. Updates happen after review, and the money moves on your banking rails.

We send bordereaux rather than receive them. Is this for us?

Yes. Brisc checks your extract against the same library and produces the file in the column layout your carrier or reinsurer requires. A column it can’t fill is reported as empty, with the reason.

Does Brisc correct our data?

No. Checks raise flags with the row, the check and the reason. Your team acknowledges or acts, and the acknowledgement carries forward so the same flag doesn’t come back next month.

Bring last month's bordereau and the one before it.

30 minutes, no slide deck. We run both through Brisc and show you what changed between them, what the checks flag, and where every figure came from.

Book the walkthrough

Not ready for a call? Get the MGA operations report →