The sheets I actually use with clients.
These are working spreadsheets, not lead magnets. No signup, no email required, nothing to unsubscribe from later. Download them, delete the example rows, and use them.
13 Week Cash Forecast
Most owners manage cash off the bank balance, which is a lagging number that includes money already spoken for. This shows you the low point coming eight weeks out instead of finding it on a Thursday.
- One column per week for thirteen weeks
- Contracted revenue in, payroll and remittances out
- Calculates your lowest closing balance and the week it lands in
Labour Productivity Tracker
Hours allowed versus hours used, by job and by crew member. Built around the problem that no two jobs look alike, so standards are set per unit of work rather than per job.
- Set your hours per unit once, per fixture, per opening, per square
- Any job becomes a stack of units you already have numbers for
- Rolls up by crew member so the raise question has an answer
Cash vs Insurance Model
Whether to go in network usually gets argued on rate per visit, which is the wrong unit. Your scarce resource is clinical hours, so this compares contribution per clinical hour after net collections, denials and billing cost.
- Cash against Medicare, BCBS and one other payer, side by side
- Credentialing lag and the AR ramp modelled month by month
- Shows the trough, which is the month people run out of money
If you get stuck setting either of these up, or you would rather someone build the finance rhythm around them, get in touch. And if you are building your own advisory practice rather than running a business, the practice templates are over at the academy.