A cash flow forecast is a forward-looking estimate of cash in and cash out, mapped to dates—so you can see how much cash you could have on hand in the future
A cash flow forecast is a forward-looking estimate of cash in and cash out, mapped to dates—so you can see how much cash you could have on hand in the future. That’s different from “we’re profitable this month,” because profit includes non-cash items and ignores timing. RBC describes cash flow as the difference between cash coming in and cash going out, and a forecast as a way to estimate future cash on hand. RBC Royal Bank
What it’s not: a perfect prediction. It’s a decision tool. If you update it regularly and stress-test it, it becomes your early-warning system.
Cash flow forecasting is how you stop managing the business from the bank app.
A strong forecast helps you:
BDC’s projection guidance also recommends building scenarios (optimistic / most likely / pessimistic) so you can anticipate the impact of changes before they hit your chequing account. BDC.ca
You don’t need a 40-tab spreadsheet to get value. Most businesses need:
This is the “operating forecast.” It’s close enough to reality to manage weekly. It’s also the format many lenders like because it ties to real payment behaviour (AR collections, AP timing, payroll cadence).
This is the “planning forecast.” It’s what you use for bigger decisions: expansion, a second location, a major equipment purchase, or refinancing.
Rule of thumb: run the business on the 13-week forecast, and steer the business with the 12-month projection.
The biggest forecasting errors I see aren’t “math” issues—they’re calendar issues.
If you file monthly or quarterly, CRA says your filing and payment deadline is one month after the end of the reporting period (with examples like July 31 period end → Aug 31 deadline). Canada
Annual filers can have different deadlines based on fiscal year-end and whether there is business income. Canada
How to forecast it: create a “GST/HST payable” line that grows with sales (or with collected tax, if you track it that way), and then drops on your actual remittance dates.
CRA sets due dates based on remitter type and average monthly withholding amounts. For example, CRA lists regular remitters as monthly (due the 15th day of the next month) and provides quarterly remitter due dates (April 15, July 15, Oct 15, Jan 15) for eligible employers. Canada
How to forecast it: don’t just forecast net payroll. Forecast the remittance cash-out on its due date.
A usable forecast is simple, consistent, and updated. Here’s the build:
Start with today’s cleared bank balance (not “what QuickBooks says,” not “what’s in AR”). RBC recommends entering your current bank balance for accuracy before adding expected inflows and subtracting expected outflows. RBC Royal Bank
Most inflows fall into:
Underwriter-style tip: lenders trust forecasts that tie to a collection pattern, not hope. If your average customer pays in 45 days, don’t put their invoices into next week’s inflow.
Most outflows fall into:
BDC explicitly flags planning for big-ticket items (like buying a truck, updating computers, etc.) inside projections. BDC.ca
Those big items belong in your 13-week if they’re inside the window.
Your forecast should answer one question: Do we go negative—and when?
BDC recommends building scenarios (optimistic, most likely, pessimistic). BDC.ca
A simple way to do this without tripling your work:
Quick scenario levers (choose 2–3 only):
If a $60,000 invoice slips from Week 6 to Week 9, the cash impact is not “$0” — it’s three weeks of financing that gap.
Simple check:
Cash gap created = invoice amount – cash you can delay elsewhere
This is why owners with “good revenue” still run tight: timing.
A practical buffer is based on cash-out volatility, not vibes.
Starter rule:
Buffer ≈ 2–4 weeks of core cash-out (payroll + rent + core suppliers)
Then stress-test it: if your downside case goes negative even with the buffer, you don’t have a buffer—you have a funding need.
A lender doesn’t fund your spreadsheet—they fund your ability to repay.
Most underwriting still maps back to the 5Cs: character, capacity, capital, collateral, and conditions.
426589587-Credit-Risk-Assessment
Here’s how your cash flow forecast fits:
Banks often use conditions precedent (things that must be true before funds are lent) and covenants (clauses that allow monitoring after lending).
635929286-Untitled
Monitoring is designed to catch warning signs before a missed payment—because a prudent lender doesn’t want the first signal to be “NSF.”
635929286-Untitled
Contrarian but fair take: if you can’t maintain a basic 13-week forecast, you’re not “too busy”—you’re operating without instruments. Even if you don’t borrow, that’s a risk.
If you’re buying equipment, the wrong move is treating it like “a monthly payment problem.” It’s usually a timing + buffer problem: deposits, installation, training downtime, and tax timing.
A clean approach:
If you’re exploring payments, start with: <a href="https://www.mehmigroup.com/calculators/equipment-calculator">equipment payment estimator</a>.
If you need to translate lease quoting into something comparable, use: <a href="https://www.mehmigroup.com/blogs/how-to-calculate-lease-rate-percentage">how to calculate lease rate percentage</a>.
When your forecast shows a dip, you have three broad levers:
If the shortfall is structural or you’re funding growth, you may need financing. Do the math before you apply:
If you’re refinancing existing payments to free up working capital, model it with: <a href="https://www.mehmigroup.com/calculators/refinance-calculator">refinance savings calculator</a> and review: <a href="https://www.mehmigroup.com/blogs/how-to-refinance-your-business-loan-in-ontario">how refinancing can improve cash flow</a>.
Use this as your “forecast quality control”:
Business: Ontario metal fabrication shop (B2B), 18 employees
Situation: Sales were up, but cash was tight. They planned to add a CNC upgrade and hire two welders.
What the owner believed: “We can afford it—revenue is strong.”
What the 13-week forecast showed: A six-week window where cash went negative due to:
Fix (in order):
Result: The shop avoided a last-minute “panic funding” situation and entered the equipment install with a buffer that survived the downside scenario.
If you already have numbers (even rough ones), run them through the <a href="https://www.mehmigroup.com/calculators/cash-flow-calculator">free cash flow calculator</a>, then build a 13-week view. If you want, Mehmi can review your forecast the way an underwriter would—what looks credible, what will raise questions, and what to fix before you make a funding or expansion decision.
Weekly for a 13-week forecast. The value is in catching timing issues early—especially around payroll and tax remittances.
Yes. GST/HST is often “cash you’re holding for CRA,” and deadlines can be one month after period-end for monthly/quarterly filers. Canada
Payroll source deductions. Your due dates depend on your remitter type (monthly, accelerated, etc.), and regular remitters are typically due by the 15th of the next month. Canada
Yes—especially for growth, refinancing, or any file where timing is the risk. A forecast supports the “capacity” part of underwriting and helps lenders get comfortable with repayment planning.
426589587-Credit-Risk-Assessment
A weekly 13-week forecast: opening cash + cash in – cash out = closing cash. Keep categories consistent and update weekly.
Try to fix timing before adding debt: improve collections and align supplier payment timing. If you still need liquidity, calculate payment impact and DSCR before applying so you’re not guessing. mehmigroup.com
.avif)
.svg){kind=small}