home-care-ops
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.pyreconciles a shifts CSV into weekly
payroll cost, billed revenue, and margin ($ and %) with a grand total.