Skip to content
Cash Flow

Cash-Flow Forecasting Made Simple: A Practical Guide for Alberta, Saskatchewan, and BC Small Businesses

How to build a 13-week cash flow forecast in an afternoon, why thirteen weeks specifically, and what to do when it shows you a problem.

Phil Krahn, B.Com.

Founder & Principal

5 min read
Cash-Flow Forecasting Made Simple: A Practical Guide for Alberta, Saskatchewan, and BC Small Businesses
Cash Flow

Profitable businesses do not fail because of profit. They fail because on a particular Friday there was not enough money in the account to make payroll.

Profit and cash are different things, and the gap between them is where most small business crises live. A contract that pays in ninety days against a payroll that runs every two weeks is a cash problem regardless of how good the margin looks.

A cash flow forecast is how you see that collision coming while there is still time to do something about it.

Why thirteen weeks

Long enough to see a shortfall while you still have options. Short enough that the numbers are grounded in real invoices and real commitments rather than optimism.

A twelve-month forecast is a planning document — useful for direction, mostly guesswork past month four. A four-week forecast is a bank balance with extra steps. Thirteen weeks — one quarter — is the window in which you can still act: chase a receivable, delay a purchase, arrange a facility, have a conversation with a supplier.

Building it: the whole method

Open a spreadsheet. Thirteen columns, one per week. Rows in four blocks.

Block 1: Opening cash

One line. The actual balance across all operating accounts at the start of week one. Take it from the bank, not from the books — you want the real number, today.

Each subsequent week's opening balance is the previous week's closing balance.

Block 2: Cash in

Not revenue. Cash actually landing in the account, in the week it lands.

  • Receipts from existing invoices. Go through your accounts receivable ageing and place each invoice in the week you realistically expect payment. Not the due date — the realistic date. If a customer has paid at day 45 for two years, they will pay at day 45 again.
  • Expected new sales, converted to cash on your normal terms
  • Other inflows: loan draws, GST refunds, tax refunds, owner contributions, asset sales

The discipline here is separating what is committed from what is hoped for. Keep them on separate lines so you can see the forecast with and without the hopeful half.

Block 3: Cash out

Everything leaving the account, in the week it leaves.

  • Payroll — the largest and most rigid. Map the actual pay dates.
  • Source deduction remittances — usually the 15th of the following month
  • Rent, loan payments, and lease payments — fixed dates
  • Supplier payments from your accounts payable, by expected payment date
  • GST remittances — these are large and lumpy and people forget them constantly
  • [Corporate tax](/services/personal-corporate-tax) instalments
  • Insurance, utilities, subscriptions
  • Owner draws

Block 4: Closing cash

Opening + in − out. Carry it forward to the next week.

That is the whole model. It is arithmetic, not accounting.

Reading it

Any week that goes negative is the point of the exercise. You now have advance warning — several weeks of it — rather than discovering it on the day.

The lowest point is the number that matters most. If your trough is $4,000 in week nine, you are running with almost no margin and any single late payment becomes a crisis.

The shape tells you about your business. Sawtooth patterns around payroll are normal. A steady downward slope means you are structurally spending more than you collect, and no amount of forecasting fixes that — it is a business model problem.

What to do when it shows a shortfall

In roughly the order you should try them:

  1. Accelerate collections. Call the three largest overdue accounts today. This is the fastest lever and the one most owners are most reluctant to pull.
  2. Delay discretionary spending. The equipment purchase moves to next quarter.
  3. Talk to suppliers early. A supplier asked for extra time before the due date will usually agree. The same supplier asked after is much less accommodating, and you have spent credibility you did not need to spend.
  4. Draw on a facility if you have one. Establishing a line of credit is much easier before you need it — which is exactly why you should do it while the forecast still looks healthy.
  5. Defer owner draws. Unpleasant, but faster than most alternatives.
  6. Talk to your bank early. Banks respond well to an owner who arrives with a forecast and a plan, and badly to one who arrives having already bounced a payment.

Keeping it alive

Update weekly. It takes fifteen to twenty minutes once it exists. Replace last week's forecast with actuals, add a new week at the end, adjust anything that has changed.

Compare forecast to actual. This is how the model gets better. If you consistently forecast collections optimistically by ten days, you learn that about yourself and adjust.

Keep it in one place. One file, one owner, updated on a set day.

Common mistakes

Forecasting revenue instead of cash. The most common error by a distance. An invoice is not cash. Cash is when the money arrives.

Using invoice due dates. Your customers' actual behaviour is a better predictor than your terms.

Forgetting GST and payroll remittances. Large, periodic, and easy to omit — which is exactly the combination that produces an unexpected shortfall.

Being optimistic. A forecast that tells you what you want to hear is worse than none, because it delays action.

Building it once. A forecast is a living tool. Built in January and never touched, it is a historical document by March.

Where this fits

For most of our clients, the 13-week forecast is the single most valuable thing we build. It is not sophisticated. It is a spreadsheet with four blocks of rows and thirteen columns. But it converts a vague anxiety about money into a specific, dated, actionable picture — and that changes how owners make decisions.

If you would like help building one, or a second look at one you already have, get in touch or call (403) 700-9434. It is usually an afternoon of work and a permanent change in visibility.

cash flowforecastingplanning13-week

Phil Krahn, B.Com.

Founder & Principal

25+ years in finance, from night auditor to VP Finance to founding Big Country Accounting Group. Serving businesses and families across Alberta, Saskatchewan, and British Columbia.

Questions about your own situation?

General writing only goes so far. Thirty minutes on the phone is free, and you will get a straight answer about your actual circumstances.

All articles

Related reading

CallFree consultation