ToolDox
Insurance & Risk

Loss Run Analyzer

Upload insurance loss runs and analyze claim count, severity, reserves, large losses, and loss ratio before renewal or submission.

Drop loss run CSV/XLSX here
Current file: sample-loss-run.csv
Download loss run template
Claims
4
2 open claims
Total incurred
$165,400
$41,350 average severity
Outstanding reserve
$59,000
$106,400 paid
Loss ratio
66.2%
Based on premium entered
Renewal interpretation
US claims trends often put more weight on severity, litigation environment, and open-reserve development by state. 2 claims exceed the large-loss threshold. Property is the largest driver by incurred cost.
Line of businessClaimsIncurredReserve
Property1$64,000$0
Cyber1$63,000$41,000
General Liability1$30,000$18,000
Auto1$8,400$0
Read the loss run guideClaims dashboard

Private by design

For file-based tools, processing is designed to happen in your browser. Avoid uploading confidential files to any website unless you are comfortable with the workflow and have permission to use the data.

Use responsibly

Insurance and business outputs are decision-support prompts, not quotes, coverage opinions, legal advice, or underwriting decisions.

Free access

ToolDox tools are free to use, require no signup, and are supported by clear navigation, guides, templates, and related tools.

Related Tools

Claims Analytics Dashboard
Upload claims data, track frequency and severity, and compar...
Insurance Renewal Dashboard
Upload policy schedules, track upcoming renewal dates, and c...
Insurance Submission Readiness Score
Score an SOV, loss run, bordereaux, or renewal pack before m...
Insurance Premium Change Analyzer
Compare last year versus current premium, factor in claims a...

What this loss run analyzer is for

Loss runs are one of the most important documents in commercial insurance renewal work. This tool turns a claims history spreadsheet into a first-pass view of frequency, severity, open reserves, large losses, and renewal talking points.

How brokers and risk teams can use it

Use the results before renewal meetings, underwriting submissions, claims reviews, or internal risk discussions. The tool helps you identify whether the account story is driven by many small claims, a few severe losses, open reserves, or one line of business.

Country and market coverage

The analyzer is built for major commercial insurance workflows including UK, London Market, EU, US, and Australia. It avoids country-specific legal conclusions and focuses on the core claims metrics that travel across markets.

Before and after example

A raw loss run might list claims without making the story obvious. The analyzer turns that file into renewal notes: open reserves, large losses, total incurred, average severity, loss ratio, and the line of business driving the cost. That gives a broker or risk team a cleaner first draft before they write renewal commentary.

Templates and renewal preparation

Start with the loss run CSV template, then read how to prepare loss runs for commercial insurance renewal and how to explain large losses at renewal.

Related pages