insurance-ops

v1.0.0 MIT professional updated 2026-09-27

Never miss a renewal — read a CSV of client policies (client, policy type, expiry date) and get an outreach list bucketed into 30-day and 60-day windows from today, plus anything already expired. Use when an insurance agent needs a call-down list for renewals.

$ skillbank install insurance-ops@1.0.0
# pins exactly 1.0.0 · README + changelog included

Insurance Ops

Overview

Renewals are the cheapest revenue an agency has — and the easiest to miss. Insurance Ops reads a CSV of client policies (client, policy type, expiry date) and buckets them into outreach windows measured from today: already expired (call today), due within 30 days (urgent outreach), due within 60 days (early outreach), and everything beyond 60 days for reference. Sorted most-urgent first, so you always know who to call next.

Everything runs on your own machine. The script reads your CSV and prints the report — nothing is uploaded anywhere.

Installation

1. Copy the insurance-ops/ directory anywhere convenient. 2. Make the script executable (Unix):


   chmod +x scripts/renewal.py

No pip install needed — standard library only.

Configuration

One CSV file with a header row (a starter lives at references/sample-policies.csv):


client,policy_type,expiry_date
Maya Chen,Auto,2026-10-12
Luis Vega,Home,2026-11-20

| Column | Required | Description | |---------------|----------|---------------------------------------------| | client | yes | Client name. | | policy_type | yes | Policy type (Auto, Home, Life, Renters...). | | expiry_date | yes | Expiry date in YYYY-MM-DD. |

Dates are relative to today by default; pass --today YYYY-MM-DD to pin the reference date (handy for testing or planning ahead).

Inputs

| Command | Arguments | Returns | |--------------------------------------------|-------------------------|----------------------------------------------------------------------| | ./scripts/renewal.py <policies.csv> | [--today YYYY-MM-DD] | Outreach list: expired, due within 30 days, due within 60 days, later renewals. |

Bad input (missing file, missing columns, malformed dates, blank client names) prints a one-line explanation to stderr and exits 1 — never a traceback.

Worked example


$ ./scripts/renewal.py references/sample-policies.csv --today 2026-09-27
Renewal outreach - as of 2026-09-27
================================================================

ALREADY EXPIRED - call today:
  2026-09-10  Tom Becker            Auto          17 days ago

DUE WITHIN 30 DAYS - urgent outreach:
  2026-10-12  Maya Chen             Auto          in 15 days
  2026-10-27  Nadia Frost           Renters       in 30 days

DUE WITHIN 60 DAYS - early outreach:
  2026-11-20  Luis Vega             Home          in 54 days

Later renewals (beyond 60 days, no action yet):
  2027-01-15  Priya Nair            Life          in 110 days

Version history

Changelog

1.0.0 — 2026-09-27

  • Initial release: scripts/renewal.py builds a renewal outreach list from
  • a policies CSV (client, policy type, expiry date), bucketed into expired, 30-day, and 60-day windows from today, with --today override.

  • Playbook: references/renewal-outreach-script.md — call/email wording for
  • each outreach window.

← back to catalog