Insurance Brokerage
A broker's register that leads on retention, not on last year's commission.
The short answer
Insurance Brokerage is a back-office register for brokers and agencies inside Odoo. It holds carriers, products, policies and claims, computes commission from the premium and the rate rather than letting anyone type it, and derives renewal dates from each policy's own end date. The board leads on renewal rate and loss ratio, and puts commission well down the list.
Last updated
What it is for
A brokerage is bought and sold on one thing: whether the book renews. Commission is what that book paid you last year, which is useful history and a poor forecast, and it is still the figure most software puts first. Meanwhile the retention number a buyer would actually price is either not calculated at all or calculated in a way that flatters it, by counting policies that have not been tested yet. The other number belongs to the carrier. A loss ratio that drifts costs you the appointment, and losing an appointment takes the whole book with it however much premium you wrote.
- Platform
- Odoo
- Category
- Regulated records
- Works with
- Odoo 18 · Odoo 19
- Technical name
insurance_brokerage- Status
- Direct from webbox
- Pricing
- Paid
What is inside it
- 01
Retention
Renewal rate is policies renewed over policies that reached term. Active and draft policies are excluded, because a policy still mid-year has not been tested and counting it inflates the rate.
- 02
Loss ratio
Approved and paid claims over premium in force, sitting second on the board. Submitted claims stay out, so the number does not move every time somebody reports a windscreen.
- 03
The book
Policies move draft, quoted, active, then renewed, lapsed or cancelled, each state with its own colour. Commission is computed from premium and rate, so repricing cannot leave a stale figure behind.
- 04
Claims
A claim belongs to a policy and keeps the amount claimed apart from the amount approved. The gap between the two is the argument you are having with the carrier.
What it looks like in practice
-
One lapse moves the renewal rate, and the rate names the call nobody made
Six policies renewed and one lapsed on a book where several more are still mid-term and therefore untested.
Only policies that reached term enter the denominator, so mid-term business cannot pad the rate. The lapsed policy stays on the book with its premium and commission attached, and renewal dates derive from each policy's end date so the pipeline cannot drift out of step.
- Renewal rate
- 85.7%
- Lapsed premium
- $320
- Lapsed commission
- $64
Figures from the module's own demo data, on a fresh install. Install with demo data and open the Insurance dashboard.
RetentionThe book
-
The carrier's number sits above commission on the board
Approved and paid claims across the book stand against the premium currently in force.
Loss ratio is computed from those two figures and nothing else. Submitted claims are left out, because counting them would swing the ratio before anyone had decided whether a loss was even covered.
- Claims approved and paid
- $16,150
- Premium in force
- $29,350
- Loss ratio
- 55%
Figures from the module's own demo data, on a fresh install. Install with demo data and read the second tile on the Insurance dashboard.
Loss ratioClaims
-
A client holding two policies is harder to lose than a client holding one
Active policies are spread unevenly across the policyholders on the book, and some hold only one.
Cross-sell ratio divides active policies by policyholders and earns a tile, because it moves before the renewal rate does. Products carry the carrier and the default commission rate, so a second policy starts from the agreement you actually have.
- Cross-sell ratio
- 1.8
- Clients
- eight
Figures from the module's own demo data, on a fresh install. Install with demo data and open the Insurance dashboard.
The bookRetention
What it deliberately does not do
- No invoicing or accounting
- Premium and commission are figures on the policy. Nothing posts to Odoo accounting, and there is no premium collection, receipt or reconciliation.
- No carrier integration
- No EDI, no rating API, no policy download and no bordereau upload. The quoted state is something your staff set, not a price a carrier returned.
- No document generation
- No policy schedule, certificate of insurance or renewal notice is produced as a document.
- No premium finance or instalments
- A policy carries a payment frequency, but no instalment schedule is generated and nothing is tracked as outstanding.
- No commission reconciliation against carrier statements
- The module computes what you are owed. Matching that to what actually arrived is not in scope.
Questions
Can I install this on Odoo Online?
Does it connect to carriers for rating or policy download?
Will it tell me whether the carrier paid me correctly?
What groups ship, and does it work across companies?
Have something to build?
Tell us the problem. We'll come back with a plan, a price, and who'd actually build it.
- Free scoping call
- Reply within 1 business day
- No lock-in