How to Build a 13-Week Cash Flow Forecast (That Your Bank Will Actually Respect)

The 13-week cash flow forecast is, bar none, the most useful financial document a small business can produce. Banks love it because it shows disciplined financial management. Investors trust it because it reveals whether you understand your own business. And you'll love it because you'll stop being surprised by your bank balance.

Here's how to build one that actually works.

Why 13 weeks, specifically?

Thirteen weeks is one quarter — short enough to forecast with reasonable accuracy, long enough to see problems coming with time to act. Monthly forecasts are too broad to be actionable; daily forecasts are too granular to maintain. Weekly, for 13 weeks, is the professional standard.

Step 1: Start with your opening balance

Pull the actual cash balance from your business bank account(s) as of today. This is Week 0 — your starting point. Include all accounts that fund operations.

Step 2: Map your cash inflows

For each of the next 13 weeks, estimate what cash will actually hit your account — not what revenue you expect to earn, but what cash you expect to receive.

Sources to include:

• Collections on outstanding invoices (check your AR aging — when do clients actually pay?)
• Expected new sales (be conservative — use your worst-case scenario)
• Any scheduled loan draws or investment tranches
• Tax refunds or government credits you expect to receive

The most common mistake here: confusing accrual revenue with cash receipts. If your terms are Net 30 and clients routinely pay in 45 days, model 45 days.

Step 3: Map your cash outflows

Now list every cash payment you'll make in each of the 13 weeks:

• Payroll (most predictable — anchor the whole forecast to payroll dates)
• Rent and fixed overhead (enter the exact dates)
• Supplier payments (when do you actually pay, not when the invoice is due?)
• CRA remittances (payroll source deductions, HST/GST — know your remittance schedule)
• Loan payments (principal + interest, exact dates)
• Owner draws (if applicable — must be included to be honest)

Step 4: Calculate your weekly net and running balance

Week N Cash Balance = Week N-1 Balance + Inflows(N) – Outflows(N)

Do this for all 13 weeks. The running balance column is the most important column — it shows you where the danger zones are before they arrive.

Step 5: Flag the red weeks

Any week where your projected balance falls below your comfort floor (typically 2–4 weeks of operating expenses) needs attention. You now have time to act:

• Accelerate a collection call on a large receivable
• Delay a discretionary purchase by one week
• Draw on your line of credit proactively rather than reactively
• Have a frank conversation with a supplier about payment timing

A simple template structure

	Wk 1	Wk 2	Wk 3	…	Wk 13
Opening balance	$42,000	$38,500	$51,200	…
Total inflows	$12,000	$28,000	$9,500	…
Total outflows	$15,500	$15,300	$16,800	…
Closing balance	$38,500	$51,200	$43,900	…

Update it every week — without exception

The forecast only works if it's maintained. Every Monday morning, take 15 minutes to:

1. Record actual inflows and outflows for the prior week
2. Compare actuals to your forecast (the variance is your learning)
3. Roll the forecast forward one week
4. Adjust future weeks based on what you now know

After three months of maintaining this discipline, you'll have a remarkably accurate picture of your business's cash behaviour — and that knowledge is genuinely valuable.

---

Need help setting up your first 13-week forecast? Book a free session — we'll build the template together and walk you through the first iteration.