- A 13-week forecast covers one quarter, week by week, so you can see tight weeks before they arrive.
- It tracks cash actually coming in and going out, not profit.
- Update it every week: replace last week's guesses with real numbers and add a new week at the end.
Why 13 weeks?
Thirteen weeks is one quarter of a year. It's long enough to see big bills coming (quarterly taxes, insurance renewals, equipment payments) and short enough that your guesses stay reasonably accurate. Weekly detail matters because practice cash moves in lumps: payroll every two weeks, rent on the 1st, insurance payments in batches.
Instant access to this template and every CareCFO white paper, template and checklist.
- How the template is laid out
- Where to get the numbers
- The weekly routine (15 minutes)
How the template is laid out
Open a spreadsheet. Put the weeks across the top (Week 1 to Week 13) and these rows down the side:
- Starting cash: your bank balance at the start of the week.
- Cash in: insurance payments, patient payments, membership fees, anything else.
- Cash out: payroll, rent, supplies, lab, loan payments, software, taxes, owner draws.
- Ending cash: starting cash + cash in − cash out. This becomes next week's starting cash.
- Minimum cash buffer: the lowest balance you're comfortable with. Highlight any week that falls below it.
Week 1: start with $85,000. Collect $28,000 from insurance and $6,000 from patients. Pay $22,000 payroll, $9,000 rent and $3,500 supplies. End at $84,500.
Week 2: collect $31,000 and pay $3,500 in supplies. No payroll this week. End at $112,000.
Week 3: collect $33,000. Pay $22,000 payroll, $3,500 supplies and a $2,800 loan payment. End at $116,700.
Week 4: collect $30,000. Pay $3,500 supplies and an $18,000 quarterly tax estimate. End at $125,200.
Notice that Week 1 is the low point: payroll and rent land in the same week. That's exactly the kind of thing a forecast makes visible.
| Week 1 | Week 2 | Week 3 | Week 4 | |
|---|---|---|---|---|
| Starting cash | $85,000 | $84,500 | $112,000 | $116,700 |
| Insurance payments | $28,000 | $25,000 | $27,000 | $24,000 |
| Patient payments | $6,000 | $6,000 | $6,000 | $6,000 |
| Payroll | −$22,000 | — | −$22,000 | — |
| Rent | −$9,000 | — | — | — |
| Supplies | −$3,500 | −$3,500 | −$3,500 | −$3,500 |
| Loan payment | — | — | −$2,800 | — |
| Estimated taxes | — | — | — | −$18,000 |
| Ending cash | $84,500 | $112,000 | $116,700 | $125,200 |
Where to get the numbers
- Insurance payments: look at the last 8–12 weeks of deposits for a typical weekly amount.
- Payroll: your payroll provider shows exact amounts and dates.
- Fixed bills: rent, loans, software and insurance are on your bank statement every month.
- Big one-time items: quarterly taxes, annual renewals, planned purchases. Put them in the week they're due.
The weekly routine (15 minutes)
- Replace last week's estimates with what actually happened.
- Notice where your guesses were off and adjust future weeks.
- Delete the week that just ended and add a new Week 13.
- Look for any week that dips below your minimum buffer, and decide now what to do about it.
This guide is general educational information, not tax, legal or financial advice for your specific situation.