home-care-ops

v1.0.0 MIT health updated 2026-09-27

Turns a shifts CSV (caregiver, date, hours, pay rate, bill rate) into weekly reconciliation totals — payroll cost, billed revenue, and margin in dollars and percent — plus a grand total. Use for weekly home-care billing review and caregiver margin checks.

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

Home Care Ops

Overview

Every week of home-care shifts is the same question: what did we pay the caregivers, what did we bill the clients, and what margin is left. This skill answers it from a simple CSV — one row per shift with caregiver, date, hours, pay rate, and bill rate. It prints per-ISO-week totals (payroll cost, billed revenue, margin dollars and percent) and a grand total across all weeks. Shifts that land in different ISO weeks are grouped separately, so a week that straddles a month boundary still reconciles cleanly.

Installation

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


   chmod +x scripts/billing.py

No pip install needed — standard library only.

Configuration

The shifts CSV has five columns (header row required):


caregiver,date,hours,pay_rate,bill_rate
Maria Santos,2026-09-21,8,18,32
James Turner,2026-09-22,7,20,35

| Column | Format | |-------------|------------------------------| | caregiver | Caregiver name (any text). | | date | YYYY-MM-DD. | | hours | Positive number (decimals OK).| | pay_rate | Hourly pay rate, positive. | | bill_rate | Hourly bill rate, positive. |

Inputs

scripts/billing.py --csv FILE

One flag, one CSV. Rows with bad dates or non-positive numbers exit nonzero with a plain-language error naming the row.

Worked example


$ ./scripts/billing.py --csv examples/sample-shifts.csv
week 2026-W39  (4 shifts)
  payroll cost:   $532.00
  billed revenue: $938.00
  margin:         $406.00 (43.3%)
week 2026-W40  (2 shifts)
  payroll cost:   $264.00
  billed revenue: $466.00
  margin:         $202.00 (43.3%)

TOTAL (6 shifts)
  payroll cost:   $796.00
  billed revenue: $1,404.00
  margin:         $608.00 (43.3%)

Two weeks of shifts for two caregivers: $1,404 billed against $796 payroll, a $608 margin (43.3%). Names in examples/sample-shifts.csv are fictional.

Not medical advice

This skill reconciles scheduling and billing data only. It has nothing to do with clinical care — no care plans, no assessments, no staffing decisions.

Version history

Changelog

1.0.0 — 2026-09-27

  • Initial release: scripts/billing.py reconciles a shifts CSV into weekly
  • payroll cost, billed revenue, and margin ($ and %) with a grand total.

← back to catalog