WorkflowMGAs & Delegated Authority

Profit Commission Calculation

Profit commission calculation from the binder's own clauses, shown step by step so both sides agree the number

One commission figure both sides can check, shown step by step.

See one case, screen by screen ↓
demo76sfor six agents to build the figure — terms read, bordereaux tied, reserves applied, carrier's figure explained
demo66bordereaux33 premium and 33 claims bordereaux totalled and tied to the carrier's ledger and cash
target100%of the difference with the carrier explained by clause
demo$879,053what one late kitchen-fire reserve would take off the MGA's income — seen on the curve before anyone argues
In short

What is Profit Commission Calculation?

Under many binding authority agreements the MGA earns a commission that slides with the program's loss ratio, plus a share of the profit once the underwriting year has developed. The calculation applies the binder's clauses — pivot, slope, cap, floor, expense allowance, deficit carry-forward and profit commission cap — to the premium and claims totals at the valuation date. Profit Commission Calculation does that from the contract and the bordereaux, and shows every step.

How to choose AI solutions for insurance →

Updated

The problem

Why the profit commission takes weeks to agree

Many binders pay the MGA a commission that slides with the program's loss ratio, plus a profit commission once the underwriting year has developed. The formulas sit in two or three clauses of the binding authority agreement, each with its own pivot, slope, cap, floor, expense allowance and deficit carry-forward — often drafted years earlier and rarely examined in detail at signature.

At each adjustment the MGA's finance team and the carrier's program accountant each paste the same premium and claims bordereaux into their own workbook, strip out cancellations, fees and taxes by hand, and pick an IBNR. They reach different figures. The reasons are small and familiar — an unagreed reserve study, cancellations booked after the valuation date, an expense allowance on written instead of earned premium — and the emails go back and forth for weeks while settlement and month-end close slip.

demo$481,222between the MGA's and the carrier's figure on one underwriting year
typical12monthsprofit commission usually waits after expiry under the older clauses
Where an adjustment's days goestimated
By hand20 days
With the solution1 days
  • Re-reading the binder's commission clauses2 → 0.1 d
  • Pasting and cleaning the bordereaux5 → 0.2 d
  • Settling which reserves and IBNR count3 → 0.2 d
  • Running the sliding scale and profit commission2 → 0.1 d
  • Reconciling with the carrier's figure8 → 0.4 d

Estimated split for one binder's annual adjustment, by hand and with the solution.

How it works

How an adjustment moves

Six specialist agents read the binder, total the bordereaux and explain the carrier's figure; the head of finance decides and signs.

What comes in
Binder and bordereaux in66 bordereaux · clauses, premium, claims, reserve letter, carrier statement
Agents at work
Binder terms reader11 terms from the contract
Then
Bordereau totaller
Reserve and IBNR checker
Then
Commission calculatorcurve + cited worksheet
Then
Counterparty reconciler
Statement drafter
A person decides
Head of financedecides and signs; carrier countersigns
What comes out
Signed statement
Variance explained
Settlement
One case, step by step

One adjustment, from valuation date to two signatures

Harrowgate Specialty Underwriters writes the Corner Table Restaurant Program under binder HSU-CPI-24, fronted by Calder Point Insurance Company. It is Monday 12 October 2026: the first adjustment of underwriting year 2024, as at 30 September 2026. Here is what happens, screen by screen, in the working solution.

  1. 01Monday morning

    The binder, drawn as its curve

    Rachel Dunmore · Head of Finance

    Rachel opens the calculator. The sliding scale is drawn the way the binder writes it — a 32.50% cap, a slope through 27.50% at a 55% loss ratio, a 22.50% floor — with the profit commission as a band above it. The program is the dot: a 56.18% loss ratio, $13,598,371 of commission income, with its earlier valuations as a trail behind it.

    “Calder Point’s statement for Corner Table 2024 is $481,222 below ours — three differences explained.”

  2. 029 seconds

    Eleven terms, read from the signed binder

    Binder terms reader

    Clauses 14 and 15 and Schedule 4 sit beside a margin note for every term the calculator uses: provisional rate, sliding scale, loss-ratio definition, valuation dates, profit commission, expense allowance, deficits, payment and IBNR. One question came up — clause 14.2 says “two decimal places” but not which way — and was confirmed as half up with Marcus Leland on 28 Sep.

    Never infers a term the binder does not state; every parameter quotes its clause.

  3. 0341 seconds

    66 bordereaux, tied to the carrier's ledger and cash

    Bordereau totaller

    33 premium and 33 claims bordereaux — 18,406 premium lines and 2,977 claim lines — totalled by underwriting year to 30 Sep. Two duplicate claim rows for Harbor Light Oyster Bar ($41,800) came out; 11 flat cancellations from the October bordereau ($214,300) stay out of this adjustment; policy fees and surplus lines taxes are excluded as clause 14.3 says.

    Late items are reported, never moved between periods.

  4. 046 seconds

    The agreed IBNR, and the two that were not

    Reserve and IBNR checker

    Three views of IBNR for 2024 side by side: $3,182,000 in the Schedule 4 letter signed by both sides on 2 Oct, Calder Point’s Q3 reserve study at $3,744,000, and Harrowgate’s own actuary at $3,050,000. Only the letter is used. Using the study instead would move the loss ratio to 57.37% and cost Harrowgate $335,098.

  5. 052 seconds

    The worksheet, every line with its source

    Commission calculator

    Earned premium $47,181,700; incurred $26,506,100; loss ratio 56.18%. Adjusted rate 27.50 − 0.50 × 1.18 = 26.91%, so $12,696,595 of commission and $278,373 back to Calder Point. Profit after the expense allowance and the 2023 deficit of $1,346,948 is $4,508,880; the profit commission at 20% is $901,776. Net due to Harrowgate now: $172,515.

    “Arithmetic is exact to the cent and rounded as clause 14.2 says.”

  6. 06One click

    Any line opens the words behind it

    Rachel Dunmore · Head of Finance

    Rachel clicks the adjusted rate. Clause 14.2 opens with the operative words marked — 27.50% at a loss ratio of 55.00%, 0.50 point per point to a maximum of 32.50% or a minimum of 22.50%, rounded to two decimal places — read from the signed binder of 18 Dec 2023, page 14.

  7. 07After the valuation date

    The next claim, put on the curve

    Reserve and IBNR checker

    On 6 Oct the reserve on Copper Kettle Brasserie in Savannah — a kitchen fire of 22 Nov 2025 — went from $380,000 to $1,850,000. Put on the curve, the dot slides to a 59.29% loss ratio and a 25.36% rate; income falls to $12,719,318, down $879,053. The 50% of profit commission paid now stays covered, so nothing would be clawed back.

    “Not in this adjustment — clause 14.3 measures losses at 30 Sep. It moves the 2027 one.”

  8. 0811 seconds

    The carrier's figure, explained in three lines

    Counterparty reconciler

    Calder Point’s statement of Fri 9 Oct shows $13,117,149. The bridge from Harrowgate’s figure takes three steps, each with its clause: IBNR from an unagreed reserve study ($335,098, clause 14.3 and Schedule 4), cancellations booked after the valuation date ($134,900, clause 14.3), and the expense allowance on written instead of earned premium ($11,224, clause 15.2).

    Recommends; never accepts or disputes on Harrowgate’s behalf.

  9. 09Decided

    She holds each figure, and the reply is ready

    Rachel Dunmore · Head of Finance

    For each difference Rachel chooses “Hold our figure” or “Accept theirs”. The reply to Marcus Leland is drafted from her decisions — the three differences, each with its clause and amount, and the worksheet linked — and is sent only when she says.

  10. 10Signed

    Two signatures, one figure

    Rachel Dunmore · Head of Finance

    Rachel signs calculation statement PCS-2024-01 for a net $172,515, below the $500,000 second-signature limit. Her signature is recorded with the worksheet, the binder version and the bordereaux it used. Marcus Leland countersigns through the shared statement link, and the settlement instruction goes to Calder Point’s treasury: $172,515 to Harrowgate by 11 Nov.

    The statement drafter never sends or settles before both signatures.

Who it’s for

Built for both sides of the binder.

The same adjustment, seen by the four people who carry it — what it looked like in spreadsheets, and what it looks like now.

RD
Rachel DunmoreHead of Finance, Harrowgate Specialty Underwriters
Signs for the MGA
Before
“Every year I rebuild the same sum and Calder Point gets a different answer.”
Now
Starts from a worksheet where every line names its clause or bordereau total, decides each difference with the carrier, and signs.
ML
Marcus LelandProgram accountant, Calder Point Insurance Company
Countersigns for the carrier
Before
Reconciles 30 programs’ bordereaux to cash, and pays and claws back their commission from figures he has to rebuild.
Now
“Show me which clause and which total, and I’ll sign it.” He sees both, through the shared statement link, and countersigns.
TR
Tomás ReyesProgram underwriter, Corner Table Restaurant Program
Reads the curve
Before
“One fire and my year’s profit commission is gone” — and he finds out at the next adjustment.
Now
Sees on the curve what a large loss would do to the year before it lands in an adjustment.
HA
Helen AchebeAudit senior, Brightwater & Lowe LLP
Re-performs it
Before
“I need to re-perform it, not trust it” — at year end, from someone else’s workbook.
Now
Reads any calculation line by line, with the clause and the bordereau total behind each one.
Built on the engine

6 agents. Each with one job, and hard limits.

Six specialist agents read the binder, total the bordereaux and explain the carrier's figure; the head of finance decides and signs.

Binder terms reader

Reads the commission, profit commission and reserve clauses of the binding authority agreement and every endorsement into the calculator’s terms: provisional rate, pivot, slope, cap, floor, rounding, loss-ratio definition, valuation dates, expense allowance, deficit years, profit commission cap and payment split.

  • Never infers a term the binder does not state
  • Every term quotes its clause
  • Where the contract is silent or ambiguous, asks the finance team
Bordereau totaller

Reads premium and claims bordereaux in each delegate’s own layout, totals them by underwriting year to the valuation date, excludes fees and taxes as the binder says, and ties them to the carrier’s ledger and cash.

  • Never edits a bordereau line
  • Late items are reported, never moved between periods
  • Reports duplicates and anything booked after the valuation date
Reserve and IBNR checker

Applies the IBNR the binder’s reserve schedule makes binding, compares it with any other study, and watches large losses every morning for reserve moves after the valuation date.

  • Never sets or changes a reserve
  • Unagreed studies are shown, not used
Commission calculator

Runs the sliding scale and the profit commission with deficits and caps, using only the binder terms and the agreed totals, and writes the worksheet with a source for every line.

  • Never rounds or nets differently from the clause
  • No step without a source
  • Arithmetic exact to the cent
Counterparty reconciler

Reads the carrier’s statement, rebuilds its figure from its own inputs, and bridges from one figure to the other one difference at a time — amount, clause, both readings and the evidence.

  • Never accepts or disputes for the MGA
  • Explains 100% of the difference or says what is left
Statement drafter

Drafts the calculation statement, the reply to the carrier and the settlement instruction.

  • Never sends or settles before both signatures
Head of finance

Decides each difference and signs; carrier countersigns. The agents propose; a named person decides.

Ask in plain words

Ask about any rate, clause or claim

The finance team can ask about any rate, clause, claim or difference with the carrier — or try a loss on the curve. Every answer points to its clause.

Why is the adjusted commission 26.91%?

The loss ratio is 56.18%: incurred $26,506,100 — paid, outstanding and the agreed IBNR of $3,182,000 — over earned premium of $47,181,700. Clause 14.2 starts at 27.50% at 55.00% and takes off 0.50 point for each point above, so 27.50 − 0.50 × 1.18 = 26.91%, rounded to two decimals. That is $12,696,595, so $278,373 of the provisional commission goes back to Calder Point.

What would the Copper Kettle fire do to our commission?

The reserve went from $380,000 to $1,850,000 on 6 Oct, after the valuation date. Added to 2024, the loss ratio moves to 59.29%, the rate to 25.36% and the profit commission to $754,039. Total income falls to $12,719,318 — $879,053 less, about 60 cents per dollar of loss. The $450,888 paid now stays covered, so nothing would be clawed back.

Why is Calder Point’s figure $481,222 lower?

Three differences, each in the binder wording: IBNR from an unagreed reserve study (clause 14.3 · Schedule 4, $335,098), cancellations booked after the valuation date (clause 14.3, $134,900), and the expense allowance on written, not earned, premium (clause 15.2, $11,224). Together they explain the whole $481,222.

How much more loss before the 50% paid now is clawed back?

About $4,340,000 of further incurred loss on 2024. At that point the loss ratio is 65.38% and the profit commission falls to $449,918, below the $450,888 paid now, and the difference would be repaid within 30 days. Copper Kettle uses 34% of that headroom.

Every screen

The working solution, as it ships.

13 screens from the working solution, on its sample data. Pick one to see it large.

The curveThe binder's sliding scale and profit commission drawn as a curve, the program as a dot with its earlier valuations, and the readout beside it.
The worksheetPremium, losses, sliding-scale commission, profit commission and settlement — every line with its clause or bordereau, and how the figure was built.
The source of a lineClause 14.2 opened from the adjusted rate, with the operative words marked and the page of the signed binder.
Next claimA late reserve increase put on the curve: the new loss ratio, rate and income, and whether the profit commission paid now stays covered.
Binder termsClauses 14 and 15 and Schedule 4, with a margin note for each of the 11 terms read into the calculator and the one question answered.
Bordereaux33 months of premium and claims totals tied to the carrier's ledger, with the duplicates, late items and exclusions the totaller found.
Losses and reservesLoss ratio by underwriting year and age, three IBNR views with the agreed one used, and the large losses.
Variance with the carrierThe bridge from the MGA's figure to the carrier's in three steps, each explained by clause, and the two calculations side by side.
The reply to the carrierHold or accept each difference; the reply is drafted from those decisions and sent only when the head of finance says.
Calculation statementThe statement for settlement, clause by clause, with the net due, the balance for later adjustments and the signatures needed.
Signed and countersignedBoth signatures on the statement, the settlement instruction sent, and every step on the activity record.
ProgramsEvery binder and every underwriting year still open for adjustment — loss ratio, rate, profit commission, deficits and holds, each on its own curve.
SettingsValuation dates, which IBNR counts, the large-loss watch, the MGA-law hold, rounding, auto-agree tolerance and who signs.
Governance

Built to be checked: cited, signed by both sides, on the record.

Every line cites its clause or bordereauEach worksheet line names the clause or bordereau total behind it. Click it to see the binder’s words, or the bordereau months it came from.
Reserves are never set by the agentsCase reserves are the claims administrator’s; IBNR is the figure agreed under the binder’s reserve schedule. Unagreed studies are shown beside it, never used.
A person decides, the carrier countersignsThe head of finance decides each difference and signs the statement; above $500,000 a second signature is needed; the carrier’s program accountant countersigns before anything settles.
The valuation date holdsLosses and cancellations after the valuation date are reported and wait for the next adjustment — never moved between periods to change this one.
Interim profit held where the law asksWhere the MGA sets reserves, a setting holds interim profit — one year after earned for property, five years for casualty — the periods in state MGA laws based on NAIC Model 225.
An auditor can re-perform itEach signature is recorded with the worksheet version, the binder version and the bordereaux it used, and every agent step and human decision is on the activity record. Rule changes are versioned.
Configuration

Your rules, beside the binder's

Contract terms come from the binder. Everything else is a setting, and every change is versioned.

SettingDefaultChoose from
Valuation datesAnnually at 30 September, first at 33 monthsFrom the binder, clause 14.4
IBNR used in the calculationAgreed under the binder's reserve scheduleReserve schedule · carrier's latest study · own actuary
Watch reserve moves after the valuation date$250,000$100,000 · $250,000 · $500,000
Hold interim profit where the MGA sets reservesOnOn · off
Rate roundingTwo decimals, half upTwo decimals, half up · two decimals, down · four decimals
Agree automatically within$5,000Any amount
Recalculate when a bordereau landsEvery open underwriting year, every monthOn · off
Second signatureAbove $500,000 · Chief Financial OfficerAbove $250,000 · above $500,000 · always
Connections

Works with what the program already produces

Binding authority agreementscommission and profit commission clauses, schedules, endorsements
Premium and claims bordereauxmonthly, by underwriting year, in each delegate's own layout
Reserve letters and IBNR studiesthe agreed figure, and any other study for comparison
Claims feedlarge losses and reserve moves, read every morning
Carrier ledger and cashthe tie-out for every bordereau
Carrier statementsthe counterparty's figure, read and rebuilt
What it changes

The difference, in numbers.

Every figure is labelled: a target the solution is built to, an estimate, a typical published result, or a proven one.

target
Minutes
from a valuation date to a cited figure, not weeks of spreadsheets
By hand2–6 weeks
With agents≈ 1 day
target
100%
of the difference with the carrier explained by clause
3 of 3 differences
$481,222 explained
typical
12months
profit commission usually waits after expiry under the older clauses
Old clauseEach valuation

“demo” = seen in the working solution, on its sample program data · “target” = the design goal, measured in the live solution · “estimated” = our estimate · “typical” = published figures (LMA model profit commission clauses, Aug 2025, and Browne Jacobson on LMA3113A — 12 months after expiry under the older clauses) · interim-profit hold per NAIC Managing General Agents Act (Model 225). People, companies, programs and insureds named on this page are fictional — characters and sample data in the working solution.

Questions

What MGA and carrier finance teams ask us.

What is a profit commission calculation?

Under many binding authority agreements the MGA earns a commission that slides with the program's loss ratio, plus a share of the profit once the underwriting year has developed. The calculation applies the binder's clauses — pivot, slope, cap, floor, expense allowance, deficit carry-forward and profit commission cap — to the premium and claims totals at the valuation date. Profit Commission Calculation does that from the contract and the bordereaux, and shows every step.

How does it calculate a sliding scale commission?

The Binder terms reader takes the scale from the clause — for example 27.50% at a 55% loss ratio, 0.50 point per point, a 32.50% cap and a 22.50% floor. The Commission calculator works out the loss ratio from the agreed totals, applies the scale with the clause's rounding, and writes each step on the worksheet with its source. The result is drawn on the binder's own curve.

Does it handle deficit carry-forward and profit commission caps?

Yes. A negative profit in one underwriting year is carried into the next for as many years as the binder allows, and the profit commission is held to its cap. In the working solution the 2023 deficit of $1,346,948 is carried into 2024, and the 5.00% cap of $2,359,085 is shown as not reached.

Which IBNR does it use?

The figure the binder's reserve schedule makes binding — usually the one agreed in writing for the valuation date. Other studies, such as the carrier's latest reserve study or the MGA's own actuary, are shown beside it with their effect, but not used. Which view counts is a setting.

How does it explain the difference with the carrier's figure?

The Counterparty reconciler reads the carrier's statement, rebuilds its figure from its own inputs and bridges from one figure to the other one difference at a time, each with its amount, the clause, both readings and the evidence. It recommends; it never accepts or disputes on the MGA's behalf.

Do people stay in control?

Yes. The agents calculate and explain; the head of finance decides each difference and signs the statement, a second signer is needed above a set amount, and the carrier countersigns before anything settles. The agents never set reserves, accept or dispute, or send.

Can the carrier and our auditors see the calculation?

Yes. The carrier's program accountant sees the shared statement and worksheet and countersigns through its link. An auditor can read and re-perform any calculation, with the clause and bordereau total behind every line.

How long does it take to go live?

The Agentic Solution Engine builds and deploys it from your requirements — your binders, a sample of bordereaux and your reserve letters — and it goes live once every quality gate has passed. We will walk you through it on one of your own binders first.

See it on
your binders.

We’ll run Profit Commission Calculation on one of your own binders and a year of its bordereaux.