Description
This cash flow model template is delivered as both an Excel template (.xlsx) and a companion Google Sheets version, so you can work in whichever tool your team already uses.
Most cash flow surprises don’t show up on a monthly P&L until it’s too late to react. The 13-Week Cash Flow Forecast gives you a rolling, week-by-week view of exactly when cash comes in and goes out — so you can spot a squeeze weeks before it hits your bank balance, not after.
Built for SMB owners, founders, and fractional CFOs who need board- or bank-ready cash visibility without hiring a consultant to build it. Delivered as an Excel workbook with a companion Google Sheets version, both driven by a simple weekly transaction register so updates take minutes, not hours.
What’s included
- 13-week rolling cash flow model (auto-advances as weeks close)
- Weekly transaction register — cash in / cash out by category
- Opening and closing balance tracking with minimum-buffer alerts
- Built-in scenario toggle (Base / Upside / Downside)
- Executive dashboard with at-a-glance KPI cards and trend chart
- Currency selector — not hardcoded to AUD or USD
- Instructions tab with setup walkthrough
- Excel (.xlsx) and Google Sheets versions
Who it’s for
SMB owners managing tight working capital, founders preparing for a raise or a bank conversation, and fractional CFOs who need a fast, credible weekly cash view for multiple clients without rebuilding a model from scratch each time.
Key features of this 13-week cash flow forecast
A monthly P&L tells you whether the quarter was profitable; it doesn’t tell you whether payroll clears next Friday. This forecast operates on the same weekly cadence that the SBA and SCORE recommend for active cash management, so a squeeze shows up with enough lead time to actually do something about it — delay a purchase, chase a late invoice, or draw on a credit line.
The scenario toggle means you’re not stuck with one static projection: flip between Base, Upside, and Downside views to stress-test how a slow month or a big new contract would ripple through your cash position over the next 13 weeks.
Unlike a generic budget template, this model is purpose-built for short-horizon cash visibility — not annual planning — which is the tool banks, investors, and turnaround advisors actually ask to see when working capital is tight.
Frequently asked questions
What file format is this in?
Both a fully editable Excel (.xlsx) workbook and a Google Sheets version are included.
How often do I need to update it?
Weekly — the transaction register is designed to take a few minutes per week to update, and the model auto-advances as each week closes.
Does this replace a full 3-statement financial model?
No — it’s focused specifically on short-term cash visibility. For a full 3-statement model, pair this with a broader financial model if you need one.
Instant digital download. Delivered as an editable Excel workbook and Google Sheets link — no subscription, no software to install. 7-day guarantee — if the document doesn’t fit your needs, let us know.
Related toolkits: NDIS providers managing weekly cash and budget-vs-actual reporting should also see the NDIS provider financial model.
