If you only ever build one financial model, make it this one. A 13-week cash flow forecast is the single most practical tool for avoiding the kind of cash surprise that derails an otherwise healthy business — a tax bill you forgot about, a big customer paying late, payroll landing the same week as a large vendor payment.
Why 13 Weeks Specifically
Thirteen weeks — roughly one quarter — hits a sweet spot. It's short enough that the numbers stay accurate: you know most of what's coming in and going out over the next three months with real confidence, unlike a 12-month projection where later months are closer to guesswork. It's also long enough to actually act on what you see — if week nine shows a cash shortfall, you have two months of runway to fix it before it happens.
What Goes Into the Model
At its core, the model is simple arithmetic, repeated week by week:
Starting cash (the actual bank balance at the start of the week) + Cash inflows (customer payments, other income expected that week) − Cash outflows (payroll, rent, vendor payments, loan payments, taxes, everything else) = Ending cash (which becomes next week's starting cash)
The entire model is that formula repeated across 13 columns, one per week.
Inflows to include
- Customer payments (based on when they'll actually be received — not when the invoice was issued)
- Any other expected income: interest, refunds, asset sales, financing proceeds
Outflows to include
- Payroll (including the actual pay dates, not just monthly totals)
- Rent and recurring fixed costs
- Vendor and supplier payments (based on actual due dates)
- Loan or credit line payments
- Taxes (payroll, sales, estimated income tax — these are the outflows most often forgotten)
- Owner draws or distributions, if applicable
The single biggest accuracy driver is using actual expected dates, not averages. "We spend about $40K a month on payroll" is far less useful than knowing payroll hits on the 15th and the last day of the month, in specific amounts.
Building It From Your QuickBooks Online Data
The raw material for this model — historical payment timing, recurring vendor bills, payroll dates — already lives in your accounting system. Pulling clean, organized transaction data out of QuickBooks Online (rather than rebuilding history by hand) is usually the fastest way to get an accurate starting model. If your QuickBooks Online data itself is messy or inconsistent, that inaccuracy carries straight into the forecast — see The Real Cost of Manual QuickBooks Data Entry for how that compounds over time.
How to Use It Week to Week — Not Just Build It Once
A cash flow forecast built once and never touched again is nearly worthless after about three weeks. The model earns its value from being updated:
- Each week, replace the forecasted numbers for the week just ended with actuals.
- Add a new week 13 weeks out, so the model always looks a full quarter ahead.
- Note where actuals diverged from what was forecasted, and why — late customer payments and surprise expenses are the two most common culprits.
- Adjust upcoming weeks based on what you're learning.
This weekly discipline is what turns the forecast from a one-time exercise into an early warning system.
Common Mistakes
Building it once and letting it go stale. A forecast is only useful while it's current.
Using averages instead of actual dates. Smoothing everything into monthly averages hides the exact week where a cash crunch would actually happen.
Ignoring timing mismatches. Revenue recognized this month and cash received next month are very different things for this model — it only cares about when cash actually moves.
No clear owner. If updating the forecast isn't explicitly someone's job every week, it quietly stops happening within a month or two.
Download the Template
Grab our free, pre-built QuickBooks Online import template to pull clean transaction and vendor data out of QuickBooks Online as the starting point for your own 13-week model.
FAQs
How accurate is a 13-week forecast?
The first few weeks are typically very accurate, since most of those cash movements are already known (signed contracts, scheduled bills, payroll dates). Accuracy naturally decreases toward week 13, which is normal — the model still provides an early warning even when the far-out weeks shift.
Do I need software for this?
No — a well-built spreadsheet is enough for most businesses. The discipline of weekly updates matters far more than the tool used to build it.
How is this different from a full budget?
A budget is an annual plan covering the whole business at a category level. A 13-week cash flow forecast is narrower and more granular — it's specifically about cash timing over the near term, at a level of detail (actual payment dates) a budget typically doesn't include.
Want this built and maintained for you?
A 13-week cash flow model is one of the most common deliverables in a fractional CFO engagement — see What Is a Fractional CFO? or schedule a consultation to have one built and kept current for your business.