Home Care Agency monthly financial report
A home care report should show hours next to dollars. Billed hours, paid hours and overtime explain almost every move in profit.
The six numbers for a home care agency
| Number | How to work it out | What it warns you about |
|---|---|---|
| Hours billed against hours paid | Billed hours ÷ paid caregiver hours | Travel, training and unbilled time |
| Overtime, share of payroll | Overtime pay ÷ caregiver pay | Short staffing showing up in margin |
| Private pay, share of revenue | Private-pay billing ÷ revenue | The part of revenue that pays fast |
| Days to collect | What clients and payers owe ÷ monthly revenue × 30 | Slow payers stretching weekly payroll |
| Caregiver wages, share of revenue | Caregiver pay ÷ revenue | Bill rates falling behind wages |
| Weeks of payroll in the bank | Cash ÷ weekly payroll | How long you could carry a late payer |
Use these six in place of the general ones on the template's Report tab.
What to watch in a home care agency
- Overtime creeping up as caregivers leave
- Insurance-backed claims past 45 days
- One large client ending service
Not sure how much cash you should hold? Use the home care agency cash calculator.
Get this done for you every Monday
One Page CFO reads your QuickBooks, builds your 13-week cash forecast and your one-page report, and a CFO checks both. $500 a month.