USE CASE: LOSS RUN ANALYSIS
Turn Hours of Claims Review into Minutes with AI
Loss run analysis is one of the most tedious and error-prone workflows in insurance underwriting. Kolena’s AI automates the extraction, normalization, and analysis of loss run data, allowing underwriters to evaluate historical claims and risk exposure in minutes instead of hours.
The Challenge: Manual and Error-Prone Analysis
Insurance underwriters rely on loss run analysis to assess an applicant's claims history and determine their risk profile. But when historical loss data spans multiple carriers, formats, and years, the process becomes a time sink. Underwriters are dealing with:
Fragmented Sources
Data arrives from PDFs, Excel files, scanned documents, and even email attachments — each in a different format.
Inconsistent Schemas
Loss data tables vary by carrier, requiring manual normalization before analysis.
Complex Categorization
Reviewers must separate losses vs. expenses, outstanding vs. paid — across hundreds of rows.
Manual Compilation
Results are manually merged into one spreadsheet, increasing risk of errors and missed entries. Even for experienced teams, each analysis can take 1–3 hours, and when errors occur such as missed rows, misclassified expenses, or typos — the results can derail underwriting decisions.
The Solution: Automating with Kolena AI
Kolena automates every step of loss run analysis, from ingestion to final spreadsheet output, with transparent reasoning and configurable Excel templates.
Before Kolena
- 2+ hours of manual data entry per loss run
- Frequent errors from missing rows or misclassified values
- Difficult to update existing analyses when new data arrives
- New business analysis slowed by volume from 10–20 carriers
After Kolena
- Analyses completed in under 10 minutes
- Seamless Excel integration — data fits into existing spreadsheet templates
- Higher accuracy with automated grouping, filtering, and validation
- Faster onboarding for new business — even when data arrives in mixed formats
Why Choose Us
Kolena’s AI agents are purpose-built for insurance workflows like loss run analysis, risk evaluation, and compliance reporting.
Excel Templating
Seamlessly connects Kolena’s AI outputs to your existing spreadsheets — no new systems or retraining needed.
Chained Prompts + Data Analysis
Runs multi-stage analysis for complex tables, ensuring both extraction and grouping are handled accurately across carriers and years.
Email Integration
Submit loss runs directly from your inbox — Kolena processes them in the background and returns structured outputs to your shared drive or workspace.
“Kolena's AI not only generated massive time savings and improved process reliability, it directly enabled onboarding of additional clients, demonstrating that automation isn’t just about operational efficiency but drives measurable business growth.”
Director of Underwriting
Midsized Insurance Carrier
See the Impact at Scale
Read a case study that walks through how one underwriting team rolled this AI workflow into production and realized $100K in annual time savings.
Download Case StudySee the Output From Your Docs
The free workflow lets you upload one loss run and see the exact spreadsheet Kolena produces.
Try Free AI WorkflowReady to Transform Your Underwriting?
Accelerate your loss run analysis with Kolena’s AI