30-min call with RobBook a proof-of-concept call
Job 04 · Delegated authority

// 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.

Book a proof-of-concept call30 minutes with Rob
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.

Draft bordereauMonth end
Contract reference
Reporting period
Rows
Totals
PolicyPremiumTax
Illustration, not a real bordereau
Checked
row by row
Exceptions listFor your sign-off
Missing policies
Outside authority
Tax and fees
Blank fields
RowIssueSource
Illustration, not a real report

// 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

Copies only, never logins
No reporting platform access
01

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.

02

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.

03

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.

04

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.

Before the proof of conceptAgreed with the owner
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

Same bordereaux
row by row
On the same 20 to 30 bordereauxYour team's correctionsThe AI exceptions list
Bound policies missing from the reportScored on your bordereauxScored on your bordereaux
Rows outside the authority's classes, limits or territoryScored on your bordereauxScored on your bordereaux
Transaction type matching what changedScored on your bordereauxScored on your bordereaux
Premium, commission, tax and fee fields agreeing with the policyScored on your bordereauxScored on your bordereaux
Required fields left blankScored on your bordereauxScored on your bordereaux
Each exception citing its clause or pageScored on your bordereauxScored on your bordereaux
The table is empty for now. It fills only when the test runs on reports your team has already sent.Your reviewer's call settles it.

// 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

Ranked with you
One job live at a time
  1. 01

    Claims bordereaux

    Each claim row checked against the claim file and the settlement authority, with claims open past six months flagged for the carrier.

    Next
  2. 02

    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.

    Then
  3. 03

    Carrier audit packs

    The files a carrier's on-site review asks for, gathered from your records ahead of the visit.

    After that

// 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?
No. It drafts the exceptions list and nothing else. Your team corrects the report, signs it off and sends it through whatever channel the carrier or syndicate uses, as it does today.
Each of our carriers wants a different template. Does that matter?
No. Send each carrier's template with its bordereaux, and the draft checks every report in the columns that carrier asks for. Lloyd's business is checked against the Coverholder Reporting Standards fields your syndicate requires.
Can it tell when a risk was written outside our authority?
Yes, when the binding authority and its schedule are in the sample. Each row is compared with the classes, limits, territory and policy period allowed, and anything outside is listed with the clause. Whether it was referred and approved is checked against the referral records you send.
Does it work out the surplus lines tax?
No. It compares the tax and fee fields on the bordereau with your filing records and the state table your compliance lead approves, and lists any row that disagrees. Working out, filing and paying tax stay with your licensed staff.
Does this cover claims bordereaux?
Not in this test, which covers risk and premium bordereaux. Claims bordereaux, checked against claim files and settlement authority, could be a later job once this one is live.
Rob Eason

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.