Why 13 Weeks?
The 13-week cash flow forecast is the single most important financial tool for any business between $1M and $20M in revenue. Not the P&L. Not the balance sheet. The 13-week forecast. Here's why: your income statement tells you if you're profitable on an accrual basis. Your bank balance tells you what you have today. But neither answers the question that actually keeps founders up at night: "Can I make payroll eight weeks from now?"
Thirteen weeks — roughly one fiscal quarter — is the sweet spot. It's long enough to see around corners (upcoming tax payments, seasonal revenue dips, large vendor invoices) but short enough that the projections are still based on real, known data rather than speculative assumptions.
The Anatomy of the Forecast
A properly constructed 13-week cash flow forecast has three layers:
Layer 1: Known Cash Inflows
These are payments you are highly confident you will receive:
- Contracted recurring revenue: Monthly subscriptions, retainers, or contracts where the customer has already signed and is actively paying.
- Accounts receivable aging: Invoices that have already been sent. Use your historical collection rate to estimate timing.
- Guaranteed grants or credits: Approved SR&ED refunds, IRAP grants, or other government funding that has been confirmed but not yet deposited.
Layer 2: Known Cash Outflows
These are payments you know you'll need to make:
- Payroll: Include salaries, employer CPP/EI contributions, health benefits, and any contractor payments. Map every pay period into the exact week it hits your bank account.
- Rent and fixed costs: Office lease, software subscriptions, insurance premiums.
- Tax remittances: GST/HST installments, corporate tax installments, payroll source deductions. Missing a CRA remittance triggers penalties immediately.
- Accounts payable: Vendor invoices you've received. Plug them into the week you plan to pay them, not the week they were received.
Layer 3: The Uncertainty Band
This is where good forecasting separates from great forecasting. Layer 3 captures the range of outcomes for variable items:
- New sales pipeline: Deals in your CRM at various stages. Don't put a $200k deal at 100% — assign probability weights.
- Variable expenses: Marketing spend you could dial up or down, hiring plans that could be delayed, capital expenditures that aren't yet committed.
By modeling Layer 3 in three scenarios — best case, base case, and worst case — you get a visual "cone" of where your cash position could land in 13 weeks. If the worst-case scenario shows you running out of cash in week 9, you have 9 weeks to act.
How We Build This at APX
- Week 1: We extract your Xero/QBO data, your Stripe/billing data, and your CRM pipeline data into a single connected spreadsheet or BI tool.
- Week 2: We build the 13-week model with all three layers and present the initial "state of cash" to the founder.
- Ongoing: Every Monday morning, the model is refreshed automatically. Actuals from the past week replace forecasts. Your founder receives a one-page dashboard by the 10th business day.
Common Mistakes We See
Mistake 1: Using the P&L as a Cash Flow Proxy
Revenue recognition and cash collection are not the same thing. You can be "profitable" on paper and still run out of cash if your clients take 60+ days to pay.
Mistake 2: Forecasting Monthly Instead of Weekly
Monthly forecasts hide lethal mid-month cash troughs. Payroll might hit on the 15th and 30th, but a major client payment doesn't arrive until the 28th. A weekly view catches this.
Mistake 3: Not Updating Weekly
A 13-week forecast is a rolling, living document. Every week, week 1 becomes actuals, weeks 2–13 get re-forecast, and a new week 13 is added. If you're not refreshing it weekly, you're flying with a stale map.
Get Started
If you don't currently have a 13-week cash flow forecast, book a 15-minute call with our team. We'll walk you through our implementation process and show you what the forecast looks like for businesses at your stage.