insurance-ops
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.pybuilds a renewal outreach list from - Playbook:
references/renewal-outreach-script.md— call/email wording for
a policies CSV (client, policy type, expiry date), bucketed into expired, 30-day, and 60-day windows from today, with --today override.
each outreach window.