How to Build a 13-Week Cash Flow Forecast

I've seen businesses with $2M in revenue go under because they couldn't make payroll on a Tuesday. Not because they weren't profitable. Because they didn't know what their bank balance would look like two weeks out.

A 13-week cash flow forecast fixes that. It's the single most useful financial tool I build for every client, and it takes about an hour to set up the first time. After that, 15 minutes a week to maintain.

Why 13 Weeks

Monthly forecasts are too vague. You might know you'll collect $150K in March, but you don't know if it's landing on March 3 or March 28. That gap can bankrupt you.

Thirteen weeks gives you a full quarter of weekly visibility. You see exactly when cash comes in, when it goes out, and whether there's a gap you need to cover. According to a QuickBooks survey, 61% of small businesses struggle with cash flow. Most of them are flying blind.

The Structure

Your forecast has three sections: money in, money out, and your running bank balance.

Money In

List every source of cash coming into the business each week. For most of my clients, this includes collections on accounts receivable, cash sales, tax refunds, loan proceeds, and any other income. Be specific. Don't lump everything into "revenue." Break it down by customer if your AR is concentrated.

Money Out

List every cash outflow by week. Payroll (usually biweekly), rent (monthly, so it hits one week per month), supplier payments, loan payments, tax remittances (HST, payroll source deductions), insurance, subscriptions, and one-time purchases. If you're running payroll for 10 employees at $55K average, that's roughly $21K every two weeks hitting your account.

Running Balance

Start with your actual bank balance today. Add money in, subtract money out, and carry the balance forward each week. The formula is simple: Opening Balance + Cash In - Cash Out = Closing Balance. That closing balance becomes next week's opening balance.

How to Build It

Open a spreadsheet. Rows are your line items (each source of cash in, each type of cash out). Columns are weeks, starting with this week and going out 13 weeks.

1. Week 1: Use actuals. Pull your current bank balance. Enter what you know is coming in and going out this week. This is your anchor.
2. Weeks 2-4: Use near-certain data. You know your payroll dates, rent due dates, and which invoices are due. Enter them on the right weeks. For AR collections, use your aging report. If a $40K invoice is 15 days past due, be honest about when it's actually going to land.
3. Weeks 5-13: Use reasonable estimates. Project based on your sales pipeline, historical patterns, and known commitments. Be conservative. If a deal might close, don't count it until you have a signed contract.

The Rules That Matter

Here's what I tell my clients about building a forecast that's actually useful.

Be conservative on collections. If a customer usually pays in 45 days, don't forecast 30. Use their actual behaviour, not their payment terms.

Include everything. CRA remittances, annual insurance premiums, equipment deposits, quarterly tax installments. The expenses that blow up cash flow are always the ones people forget.

Update weekly. Every Monday morning, replace last week's forecast with actuals, extend by one week, and adjust. This is not a set-it-and-forget-it tool. It's a living document.

Flag the danger zones. If any week shows your closing balance below $20K (or whatever your minimum comfort level is), highlight it red. That's your early warning. You have weeks to fix it, not days.

What to Do When You See a Gap

A gap means your forecast shows a week where cash out exceeds cash in and your balance dips below your comfort zone. Here's what you can do about it.

• Accelerate collections. Call your biggest receivables. Offer a small discount for early payment. Even getting one $25K invoice paid a week early can close the gap.
• Delay non-critical payments. Talk to suppliers. Most will work with you if you communicate early. Surprising them with a late payment is what damages relationships.
• Draw on your line of credit. This is literally what it's for. Plan the draw in advance so you're not scrambling.
• Adjust spending. Delay that equipment purchase by two weeks. Push the software upgrade to next month.

A Real Example

I had a client doing $1.8M in revenue. Profitable on paper. But they had one customer that represented 35% of revenue and paid on 60-day terms. Every other month, they'd hit a cash crunch when payroll landed before that big cheque. We built the 13-week forecast and immediately spotted the pattern. The fix was simple: we negotiated 30-day terms with that customer (they agreed because they'd been paying late anyway) and set up a $50K line of credit as a safety net. Cost them $200/year in standby fees. Saved them from missing payroll twice.

The Bottom Line

A 13-week cash flow forecast takes an hour to build and 15 minutes a week to maintain. It tells you exactly when you'll be short on cash, with enough lead time to do something about it. Every business with employees or significant receivables needs one. If you want help building yours, book a free call.

Next step: see it in your free Instant CFO Snapshot.