TemplateAll practices8 min read

13-week cash forecast template for practices

A profit and loss statement tells you whether you made money last month. A cash forecast tells you whether you'll be able to make payroll next month. This template shows you how to build one in any spreadsheet in about an hour.

The short version
  • 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.

In plain English
It's a budget for your bank account. You list every dollar you expect to come in and go out each week, so you can see the low points coming and plan around them instead of being surprised.
Free with email
Keep reading the full template

Instant access to this template and every CareCFO white paper, template and checklist.

What's inside
  • How the template is laid out
  • Where to get the numbers
  • The weekly routine (15 minutes)
{{error}}

We'll also send one practical finance note a month. Unsubscribe anytime. We never sell or share your email. Privacy policy.

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:

  1. Starting cash: your bank balance at the start of the week.
  2. Cash in: insurance payments, patient payments, membership fees, anything else.
  3. Cash out: payroll, rent, supplies, lab, loan payments, software, taxes, owner draws.
  4. Ending cash: starting cash + cash in − cash out. This becomes next week's starting cash.
  5. Minimum cash buffer: the lowest balance you're comfortable with. Highlight any week that falls below it.
Worked example
The first four weeks of a forecast

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.

Copy this layout into Excel or Google Sheets and extend it to 13 columns.
Week 1Week 2Week 3Week 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)

  1. Replace last week's estimates with what actually happened.
  2. Notice where your guesses were off and adjust future weeks.
  3. Delete the week that just ended and add a new Week 13.
  4. Look for any week that dips below your minimum buffer, and decide now what to do about it.
Free tool
A/R cash calculator
Find out how much cash is waiting in your receivables.
Try it

This guide is general educational information, not tax, legal or financial advice for your specific situation.

← Previous guide
Production vs. collections: where the dental revenue gap comes from
Next guide →
Provider compensation models compared
Get Started Today

Want these numbers for your practice, every month?

We track all of this for you and explain what it means in plain English. Start with a free 30-minute consultation.

Schedule a Free Consultation