Skip to content
Workflow · Finance close · Opening soon

Loss run summary by policy year

Export the claims and premium data you need from Excel, then load those files into the workflow. It groups the rows by policy year and coverage, adds claim totals, and calculates paid, reserved, incurred, and loss ratio against premium.

Early access opens shortly. Check back soon.

Someone typed

“summarize the loss runs by policy year and coverage: number of claims, paid, reserved and incurred losses, and the loss ratio against premium”

The agent read it as

summarize the Carrier loss runs - claims by policy year and coverage: number of claims, paid, reserved and incurred losses, and the loss ratio against Premiums by policy year and coverage, shown as a percentage.

What the agent built

3 steps, each one an ordinary Mammoth step you can open and change.

  1. File
    Carrier loss runs - claims
    CSV export · 40 rows
  2. File
    Premiums by policy year and coverage
    CSV export · 30 rows
  3. Step
    Summarize claims by year and coverage
    Step 1
  4. Join
    Add claim totals
    28 of 30 paired
  5. Step
    Calculate loss ratio
    Step 3
  6. Result
    Policy year loss summary
    30 rows
  7. Schedule
    Runs when you say
    Proposed

Checked on the sample files: every step ran, 30 rows came out, and the join paired 28 of 30 rows.

What you get back

The result of that run, the rows to look at first.

Policy year loss summarySample data30 rows
Policy yearCoverageNumber of claimsPaid lossesReserved lossesIncurred lossesLoss ratio (%)Written premium
2,022General Liability24,97004,97027.318,200
2,022Workers Comp12,42502,42515.715,400
2,022Cyber101,8001,80056.33,200
2,023Property204,3504,350·0
2,023Auto Liability11,33001,33017.17,800
2,023Umbrella15200520105,200
2,024General Liability21,6402,6004,24021.919,400
2,024Workers Comp44,5002,5507,05042.216,700
2,024Cyber102,4002,40066.73,600
2,025General Liability23,37003,37016.820,100
2,025Workers Comp12,68002,68015.617,200
2,025Cyber101,5001,50039.53,800
30 rows in the result · 12 shown, problems first. Sample data: illustrative figures, not business results.

How it works

How to use the Policy year loss summary workflow

  1. 1Get early accessWe invite people in small batches, job by job. You'll land on this workflow, already built and checked on the sample files.
  2. 2Swap in your exportsUpload your own files as they come out of your tools. The agent checks the workflow on your rows.
  3. 3Change it in words, then turn it onSay what to change and see the new result before anything saves. Then choose when it runs.

Policy year loss summary: questions

How do you summarize loss runs by policy year?
Export the claims and premium data you need from Excel, then load those files into the workflow. It groups the rows by policy year and coverage, adds claim totals, and calculates paid, reserved, incurred, and loss ratio against premium.
What export should you use?
Use the spreadsheet export that contains the claim rows and the premium rows needed for the summary. The columns should include policy year, coverage, and the values used for paid, reserved, incurred, and premium.
What happens to rows that do not match the rules?
Rows that do not match the grouping or calculation rules are left out of the summary or stay ungrouped, depending on the step. You can review them and decide whether to change the rules or clean the source file.
How do you change the rules?
Edit the step in plain words, such as changing the year field, coverage field, or the measure you want to total. Then run the workflow again on a fresh export if your source data has changed.

Get early access to this workflow

It will open already built and checked on the sample files. Swap in your own exports and see your result.

Early access opens shortly. Check back soon.

Workflows like this

Consolidate entities, compare budget to actual, build a trial balance, review month-on-month moves and work out commission.

All finance close templates →