
Insurance dashboard
Are we writing profitable business, and how fast are claims settled?
- Earned premium
- Loss ratio
- Combined ratio
- Days to settle a claim
Insurance dashboards
Four dashboards for an insurer or MGA: premium, loss ratio and combined ratio by line with claims and fraud, the claims phone line, what policyholders say after a claim, and expenses against plan. Open any of them to see it in full, then use it as a template for your own data.



Three of the four examples. All figures are sample data.
The examples
Click a board to see all of it. Click Use template to start your own copy in Mammoth. All figures are sample data.

Are we writing profitable business, and how fast are claims settled?

Are claimants getting through when they call?

Would policyholders recommend us after a claim?

Are expenses running to plan by line and region?
Definition
An insurance dashboard is one screen that shows whether the book is profitable and claims are handled well: earned premium, the loss ratio, the expense ratio and the combined ratio, by line of business and region, beside how long claims take to settle and how many are large or referred for fraud. The data usually comes from the policy administration system, the claims system and the general ledger.
Losses and expenses against premium, month by month.
The book that is pulling the ratio up.
Settlement time, large claims and fraud referrals.
The metrics
Eight numbers. Most depend on a definition agreed first, such as whether premium is written or earned.
How much premium have we earned?
Written premium spread over each policy's term, by line, region and month.
How much of the premium goes on claims?
Claims incurred, paid plus the change in reserves, against earned premium for the same period.
How much goes on running the business?
Acquisition and operating expenses from the ledger against premium.
Does underwriting make money?
Loss ratio plus expense ratio. Under 100 percent is an underwriting profit.
How fast are claims paid?
Days from first notice of loss to settlement, by line and claim size.
How many claims are over our threshold?
Claims above an agreed amount, by line and region. They move the loss ratio more than volume does.
How many claims are sent for investigation?
Claims referred to the fraud team by source of the referral, and what was found.
Do policyholders renew?
Policies renewed against policies due, by line and by whether the customer claimed.
How to build one
From one of the examples above to a live dashboard on your own data.
Start from any of the four boards above.
Upload a spreadsheet, or connect one of 100+ tested connectors.
Fix and combine your data once. Mammoth repeats those steps for you.
The dashboard updates on a schedule and flags data that fails a check.
Public, password-protected or sign-in only, on every plan.
14-day Pro trial · No credit card
FAQ
Last reviewed against the template catalogue.
Start from one of these templates or your own spreadsheet. Share it with as many people as you like, free.
More dashboard examples