What is a 13-week cash flow forecast?
A 13-week cash flow forecast is a rolling, week-by-week projection of the cash coming into and going out of your practice over the next quarter. You start from today's real bank balance, add your recent actual spend, estimate each future week by when money will actually clear, fix any week that would go negative, then extend the model to a full thirteen weeks. It is the single tool that keeps payroll and a quarterly tax payment from landing in the same week and catching you off guard, even when nothing went wrong clinically.
Excel template, no cost. It is also the free takeaway onbusiness finance 101 for practice owners.
01 · The definition
What a 13-week cash forecast actually is
A 13-week cash forecast is a short, forward-looking model of your bank account. Not your profit, not your revenue, your cash: the actual dollars that will be in the account each week for the next quarter. You build it from real numbers, you update it weekly, and it rolls forward so you always have a full thirteen weeks in view.
The word that matters is rolling. Each week you drop off the week that just closed and add a fresh week at the far end, so the model never runs out of runway and never goes stale. It is the difference between driving with a windshield and driving with a rearview mirror. Your financial statements tell you what already happened; this shows you what is coming.
02 · The horizon
Why thirteen weeks, and not a month or a year?
One quarter
Long enough to see collisions
Thirteen weeks is a full quarter, so a payroll run, a quarterly tax payment, and a large one-off outflow all show up on the calendar weeks before they hit. That lead time is where the decisions get made.
Still grounded
Short enough to trust
A quarter is close enough that your week-by-week estimates are real. Push the horizon out to a year and the weekly numbers become guesses. The forecast is only useful while it stays honest.
Weekly, not monthly
Cash moves by the week
A monthly view hides the squeeze inside the month, when a big outflow lands the week before a deposit does. Cash trouble happens week to week, so the model has to as well.
03 · The method
How to build a 13-week cash forecast
Five steps. You do not need special software, and the template on this page already has the running-balance math wired in. If you do only one financial exercise this quarter, do this one.
- 01
Start from today's real bank balance
Open the model with the actual balance in the account right now, not an estimate and not last month's number. Everything downstream is only as honest as this starting point, so pull it straight from the bank.
- 02
Add your last week of actual spend
Drop in what really left the account last week. It anchors the model in reality and shows you the shape of a normal week, which is the pattern you will project forward.
- 03
Estimate the next several weeks by when cash clears
Place each expected inflow and cost in the week you actually expect the money to move, not the week the invoice is dated. Timing is the whole point. A bill due the 30th and paid the 3rd belongs in the week it clears.
- 04
Fix any week that goes negative
If a week ends below zero, find a bill you can pay a little later or an elective cost you can shift, and keep the running balance positive. You are looking for the collisions before they happen, while you still have moves.
- 05
Extend to a full thirteen weeks
Once the near weeks hold together, stretch the model to a full quarter. Now payroll runs and a tax payment show up on the calendar weeks ahead, so a hire or a piece of equipment becomes a decision instead of a gamble.
04 · The reason it matters
It prevents the cash surprise
Profit and cash are not the same number, and the gap between them is where owners get caught. You can post a strong month on the P&L and still find the account tight, because collections arrive late, a tax payment comes due, and payroll does not wait. Nothing went wrong clinically. The timing just collided.
A 13-week forecast makes that collision visible while you can still do something about it. You see the negative week coming three, five, eight weeks out, and you have room to move a bill, time a purchase, or pull a collection forward. Without the forecast you learn the same thing on the day the balance drops, when your only options are bad ones.
05 · Accountability
Who should own the forecast?
Two things have to be true. The owner reads it every week, and one person is accountable for keeping it current. If nobody owns the updating, the model drifts out of date and quietly stops being trusted, which is the same as not having it.
In a smaller practice a capable bookkeeper can maintain it while you watch the running balance. As the practice grows and the inflows and outflows get more complex, this becomes core CFO work, because the forecast is only as good as the judgment behind the estimates. When I build a client's command center, the 13-week forecast is one of the first instruments on it, and keeping it honest is part of the standing cadence. More on that whole forward-looking layer is inthe fractional CFO guide.
Free, no strings
Get the 13-week cash forecast template
The same template I set up for owners, with the running-balance math already built in. Enter your beginning balance and your expected weekly cash, and it shows you the red weeks before they arrive. No cost.
Prefer the full walkthrough? It is the free takeaway onbusiness finance 101.
06 · Questions owners ask
The 13-week cash forecast, common questions
What is a 13-week cash flow forecast?
It is a rolling, week-by-week projection of the cash moving into and out of your practice over the next quarter. You begin from today's actual bank balance, add recent real spend, estimate each future week by when the money will clear, and adjust any week that would go negative before extending to a full thirteen weeks. It shows you the cash squeeze before it hits, instead of when the balance drops.
Why 13 weeks and not a month or a year?
Thirteen weeks is one quarter, which is long enough to see payroll runs, a quarterly tax payment, and large one-off outflows coming, but short enough that your week-by-week estimates are still grounded in reality. A one-month view is too short to catch a collision forming, and an annual forecast is too coarse to trust at the weekly level where cash actually moves.
How do you build a 13-week cash forecast?
Start from today's real bank balance, add your last week of actual spend to anchor the model, then estimate each future week by when cash will actually clear rather than the invoice date. Fix any week that would go negative by shifting a bill or an elective cost, then extend the model to a full thirteen weeks. Update it every week so it always rolls forward a full quarter.
What is the difference between a cash forecast and a P&L?
A P&L tells you whether you were profitable over a period. A cash forecast tells you whether you will have money in the account each week. They are not the same, because payment timing, taxes, and debt payments move on their own schedule. You can be profitable on paper and still short on cash, and the gap between the two is exactly what a 13-week forecast makes visible.
Who should own the 13-week cash forecast in a practice?
The owner should read it every week, and someone should be accountable for keeping it current. In a smaller practice that can be a capable bookkeeper maintaining it while the owner watches the running balance. As the practice grows, this is core CFO work, because the forecast is only useful if someone with a forward view is updating the estimates and flagging the collisions.
How often should I update it?
Weekly. The word rolling is the point: each week you drop off the week that just closed, add a fresh thirteenth week at the far end, and true up your estimates against what actually cleared. A forecast you build once and never touch goes stale fast. One updated every week stays accurate and keeps a full quarter of runway in view.
Where can I get a 13-week cash forecast template?
You can download my 13-week cash forecast template free from this page, the same one I set up for owners. It is also the free takeaway on my business finance 101 guide. Enter your beginning balance and your expected weekly cash, and it does the running-balance math so you can see red weeks before they arrive.
Keep reading
Business finance 101 for practice owners
The four numbers to watch, cash versus profit, and the forecast in its full context.
The pillar guideFractional CFO for medical practices
Where the forecast fits in the forward-looking layer a CFO owns for you.
Quick answersFractional CFO FAQ
The common questions owners ask about cost, timing, and how the work runs.
When you are ready
Want this built into a live command center?
The template gets you started today. When you want the forecast maintained beside a P&L rebuilt by provider and a ranked opportunity list, the Margin Map is a fixed-scope, $7,500 diagnostic that builds exactly that.