// MGAs and coverholders · Month-end reporting
Every bordereau row checked against your authority and the policies you bound, before it goes out.
Each month an MGA reports what it wrote under a carrier's or a syndicate's authority. This tests whether AI can check each row of the risk and premium bordereau against the binding authority and the bound policies, then list every exception for the person who signs the report off, on copies of 20 to 30 bordereaux you already sent.
- Past bordereaux
- 20 to 30
- Reporting platform or system login
- None
- Who signs off and sends
- Your staff
// The one job
The month closes. An exceptions list is ready before the bordereau leaves.
Today someone exports the month's binders, policies, endorsements and cancellations from your management system, lays them out in the carrier's or Lloyd's columns, and checks them by hand. Is every bound policy on the report? Is each risk inside the classes, limits and territory the authority allows? Do premium, commission, taxes and fees agree with the policy? Whatever they find is fixed or explained before the report is signed and sent.
In the proof of concept, AI reads the binding authority, the bound policies and your draft bordereau, then writes an exceptions list: each row with its problem, the clause or policy page behind it, and the likely fix. It changes nothing in the report and sends nothing. Your reviewer, the person on your team who prepares or signs off the most bordereaux, compares that list with the corrections your team really made.
row by row
// What makes bordereaux hard
Three sets of rules meet in one spreadsheet
Start with the contract. The NAIC's model Managing General Agents Act has an MGA render accounts detailing all transactions to the insurer at least monthly, and expects the contract's underwriting guidelines to set a maximum annual premium volume, the basis of the rates, the types of risk, maximum limits, exclusions, territorial limits, cancellation provisions and the longest policy period allowed. The insurer must review the MGA's underwriting and claims work on site at least twice a year. Each of those terms is something a bordereau row can break, so the draft reads your authority first and turns every clause into a check.
For Lloyd's business the layout comes from Lloyd's Coverholder Reporting Standards, Version 5.2, the version Lloyd's still lists. Fields shown in red must always be reported; yellow ones apply only to some classes or territories. A report names its contract by the UMR, the unique market reference, or by the agreement number when the coverholder doesn't know it, and a multi-section agreement needs its section reference. Policies belong to the agreement's year of account, not the year they were issued. Each row gets a transaction type: new, renewal, endorsement when money changes, amendment when nothing financial does, or reinstatement. Gross written premium goes in before taxes and fees, leaving out instalment charges and any terrorism premium or fee shown as a separate transaction.
US rows carry extra rules. When premium is in US dollars or the coverholder is based in the US, each risk takes a US classification, and a surplus lines risk that is exempt from tax is still classed as US surplus lines, never as Exempt. Surplus lines rows need the surplus lines broker's name, address and license number and the state of filing. North Carolina brokers enter the letters SSN or FEIN instead of a number, and a New Jersey filing needs the 14-character transaction number from the broker who filed it. Lloyd's doesn't ask for US taxes a surplus lines broker pays and reports, yet tax information that is missing or wrong where it is required gets the policy rejected.
The report also has to agree with state filings. From July 1, 2026, Florida's Surplus Lines Service Office requires the UMR on every filing where Underwriters at Lloyd's, London is the insurer. Its bulletin says the number is on the declarations page, sometimes labeled Authority Reference Number or Contract Number, has at most 17 characters starting with B and four digits for the Lloyd's broker, and goes in even when it matches the policy number. New Jersey asks surplus lines producers to file each binding authority agreement and its amendments with its surplus lines office, by email since July 2024. Illinois has surplus line producers report and pay tax twice a year, by February 1 and August 1, with a separate fire marshal tax report each February. So the draft compares tax and fee columns with the filing records you send. None of this is legal or tax advice.
Your reviewer will look hardest for the misses that cost most later: a policy bound in the month that never reached the report, an endorsement sent as an amendment although premium moved, a risk beyond the authority's territory or limits with no referral on file, a cancellation with no return premium row, and written premium for the year running toward the annual cap. Each exception names the row, the clause or policy page, and what would clear it.
// What you send
Past bordereaux and everything behind them
20 to 30 past bordereaux
Risk and premium bordereaux as they went to the carrier or the syndicate, from more than one authority if you write under several, including a month that came back with queries.
The authority and the policies
Each binding authority agreement with its schedule and endorsements, plus the month's bound policies, endorsements and cancellations as exports or declarations pages.
What your team corrected
The draft before review and the version that went out, or the query list the carrier sent back. The difference between them is the answer key.
NDA first, then copies
The NDA is signed before any bordereau moves. We never log in to your management system, a carrier's or Lloyd's reporting platform, or a stamping office. Add your surplus lines filing records, so the tax and fee check has something to compare.
// Before it starts
Set down before the first bordereau moves
The owner agrees four things in writing.
- Reviewer
- The owner's pick, usually whoever prepares or signs off the monthly bordereaux.
- Success criteria
- Which exceptions the draft must find, and which checks your carriers care about most
- Sample
- Chosen by your reviewer from bordereaux already sent, across your authorities
- Price
- A range for the live month
// How the test is judged
Your team's corrections next to the exceptions list
| On the same 20 to 30 bordereaux | Your team's corrections | The AI exceptions list |
|---|---|---|
| Bound policies missing from the report | Scored on your bordereaux | Scored on your bordereaux |
| Rows outside the authority's classes, limits or territory | Scored on your bordereaux | Scored on your bordereaux |
| Transaction type matching what changed | Scored on your bordereaux | Scored on your bordereaux |
| Premium, commission, tax and fee fields agreeing with the policy | Scored on your bordereaux | Scored on your bordereaux |
| Required fields left blank | Scored on your bordereaux | Scored on your bordereaux |
| Each exception citing its clause or page | Scored on your bordereaux | Scored on your bordereaux |
// After a yes
About 30 days of month-end reports
With your reviewer's yes, the next month-end goes through the same check, for about 30 days.
A person on your team signs off every bordereau. The AI never edits or submits a report, never files with a stamping office or a regulator, never pays a tax, and never contacts a carrier, a syndicate, an insured or a retail agent. Your staff decide which exceptions to fix, explain or refer.
Live reports are judged by the same reviewer, on the criteria set for the test.
// Later, in order
What could follow bordereaux checks
- 01Next
Claims bordereaux
Each claim row checked against the claim file and the settlement authority, with claims open past six months flagged for the carrier.
- 02Then
Authority usage tracking
Premium written, limits used and classes bound tracked through the year against the authority, so a cap shows before it is reached.
- 03After that
Carrier audit packs
The files a carrier's on-site review asks for, gathered from your records ahead of the visit.
// One hard limit
A person on your team signs off and sends every report.
The proof of concept reads copies and drafts an exceptions list. It never signs off or submits a bordereau, never files with a stamping office or a regulator, never binds, quotes or declines a risk, and never contacts a carrier, syndicate, insured or retail agent. Nothing here is legal, tax or regulatory advice. Commercial lines only, never personal lines.
Priced per job: a range before the test, a fixed price before you sign.
The range comes on the call, after we hear how many authorities you report under and how many rows a typical month carries.
// Questions
What delegated authority teams ask
Will it submit the bordereau to the carrier or to Lloyd's?
Each of our carriers wants a different template. Does that matter?
Can it tell when a risk was written outside our authority?
Does it work out the surplus lines tax?
Does this cover claims bordereaux?

Rob Eason, founder
// Book a proof of concept call
Bring bordereaux your team already sent.
A 30-minute call with Rob Eason. Say which firm you're with, your role, how many authorities you report under, and that bordereaux are the job. Every bordereau and binding authority stays with you until the NDA is signed.
- Co-owned a 60-employee financial services firm and sold his share to his partner.
- Ran GOSO Technologies, a Boston solar company rated 5/5 across 24 Google reviews.
- 5/5 across 83 reviews in HighLevel's Certified Admin Directory.
- 4.3/5 from 6 Google reviews of Massmarket AI.
- Every directory and Google review, critical ones included, is shown word for word at massmarket.ai/reviews.
- Takes every proof-of-concept call himself.
