zava-claims-export

Claims Report

Automate the boring part of claims reporting: take a raw export and return a report a manager would be happy to open — headline numbers up top, breakdowns and charts on a Dashboard, and a tidy, filterable Claims Detail table behind it.

The report design lives in the THEME block at the top of scripts/build_report.py. That block is the reference template — colours, fonts, and number formats. Edit it once and every future report inherits it.

When to Use

Trigger when the user has a flat claims/loss/incident export (one claim per row) and wants it turned into a formatted, summarized report. The canonical input is the columns below; the script tolerates minor header-name variation.

When NOT to Use

• The user wants a written narrative (memo, summary letter) → use docx.
• The user wants slides for a meeting → use pptx.
• The user wants a clickable/interactive dashboard → use canvas.
• A generic spreadsheet task with no claims structure → use xlsx.
• The export is not row-per-claim (e.g. already a pivot/summary) — reshape it first, or fall back to xlsx.

Expected Input Schema

Column	Example	Notes
Claim Number	CN202504990	Row key; blank / "Total" rows are dropped
Claimant Name	David King
Location	9607 Maple Dr, Bellevue, WA 98004	City/State/ZIP parsed out
Damage Type	Mold damage - moderate severity; Water damage	Split into primary / severity / other
Status	Open - Claim is under investigation	Short status kept for grouping
Date Filed	2026-04-11	ISO or common date formats
Estimated Cost	10608	Numeric; missing values are counted, never invented

See references/schema.md for full parsing rules and how to add a column.

Workflow

1. Find the input. If the user attached a file, use that path. Otherwise look in input/ for the claims export (Glob input/**/*.xlsx). If nothing is found, ask the user for the file — do not invent data.
2. Build the report into scratch space (never write to output/ directly):

   python scripts/build_report.py --in "<input.xlsx>" --out working/claims_report.xlsx --title "Insurance Claims Report"
   

   The script prints a one-line summary (claims=… skipped_rows=… total_cost=… avg_cost=…) and notes any claims missing a cost. Read that line back to the user in plain language.
3. Publish to the user surface with the artifact tool (output/ is read-only to direct writes):

   CopyArtifact(surface="output", source="working/claims_report.xlsx",
                destination="Claims Report.xlsx")
   

4. Confirm delivery (blocking): Glob output/**/* must show the file before you tell the user it's ready. If it's missing, re-run step 3.
5. Summarize the headline numbers (total claims, total & average estimated cost, open vs closed, top damage type) so the user gets value in the chat even before opening the file. Ground every number in the script's output — never estimate.