A cash flow forecast is a simple spreadsheet that shows money coming in and money going out, week by week, for the next three to six months. Most small business owners in BC skip this because it sounds like extra accounting work, then get surprised by a tight month they could have seen coming. Start with one tab, four columns (week, cash in, cash out, running balance), and update it every Friday for fifteen minutes.
What is a cash flow forecast, actually
It is not the same as a budget and it is not your profit and loss statement. A forecast tracks when cash actually lands in your bank account and when it actually leaves, not when you invoiced or when an expense was incurred. A contractor who invoices $8,000 in March but gets paid in May has zero cash flow benefit in March, even though the sale shows up on the books that month.
This distinction matters most for businesses with payment terms, like consultants, agencies, and trades who invoice net 30. Profit on paper means nothing if the rent cheque bounces first.
How far ahead should you forecast
Thirteen weeks is the standard window most accountants recommend, because it is long enough to spot a squeeze coming and short enough to stay accurate. A full year forecast is useful for planning but gets unreliable past about eight weeks for most small businesses, since too much can shift.
- Weekly for 13 weeks. Gives you time to act before a shortfall, whether that means delaying a purchase or following up on an overdue invoice.
- Monthly for the rest of the year. Rougher numbers, just enough to flag seasonal slow months, like the usual January to February dip in retail and hospitality.
What to put in the cash in column
List every invoice you expect to collect that week, based on your actual payment history, not the terms on the invoice. If clients typically pay 10 days late, build that lag into the forecast instead of using the due date. Include GST or HST refunds if you are in a refund position, any planned loan draws, and owner contributions if you are putting personal money in.
Be honest about collection speed here. Overestimating how fast clients pay is the single most common reason small business forecasts turn out wrong.
What to put in the cash out column
This is usually easier because most expenses are predictable: rent, payroll, loan payments, insurance, software subscriptions. Where people miss money is on the irregular stuff.
- GST or PST remittances. If you are a BC business registered for GST, note your filing period and the actual remittance date, not just the invoice amounts collected. Missing a GST remittance deadline triggers penalties and interest from the CRA.
- Payroll remittances. Source deductions are due to the CRA by specific dates depending on your remitter type, and late remittances carry penalties that start at 3% and climb.
- Corporate tax instalments. If your corporation owes over the CRA threshold for instalments, those quarterly payments need their own line.
- Annual or seasonal costs. Business licence renewals, insurance premiums, WorkSafeBC assessments, and equipment replacement all land once or twice a year and catch owners off guard if they are not on the calendar.
Building the running balance and spotting trouble early
Add your starting bank balance, add cash in, subtract cash out, and carry the total forward each week. The number you actually care about is the lowest point in the thirteen weeks, not the final one. If week 7 shows your balance dropping close to zero or negative, that is your warning, four to six weeks before it happens, which is enough time to act.
Options at that point include following up on overdue invoices harder, negotiating a short payment delay with a supplier, drawing on a line of credit before you need it, or holding off on a planned purchase. All of these work better when you are not already in the hole.
Common mistakes that make a forecast useless
- Using invoice totals instead of expected payment dates. This is the most common error and the one that makes a forecast too optimistic to be useful.
- Forgetting GST, PST, or payroll remittance dates. These are fixed obligations that do not move, unlike supplier payments you might be able to delay.
- Never updating it. A forecast built once in January and ignored until June is a historical document, not a tool. Fifteen minutes a week keeps it accurate.
- Mixing up profit and cash. A profitable month on your income statement can still be a negative cash month if clients are slow to pay or you just bought inventory.
Good forecasting depends on clean, up to date bookkeeping records, since you cannot predict collection patterns from invoices that are three months behind in your accounting software. If your books in QuickBooks Online or Xero are current, pulling the numbers for a forecast takes an afternoon. If you are also preparing to apply for financing, a solid cash flow forecast strengthens the package described in our post on getting your books ready for a bank loan or mortgage application.
When to bring in help
A spreadsheet forecast works fine for a sole proprietor or a straightforward small business with steady, predictable revenue. It gets harder when you have multiple revenue streams, seasonal swings, payroll with several employees, or you are trying to plan around a major purchase or expansion. At that point, a bookkeeper or accountant who already knows your numbers can build a more reliable model and flag remittance deadlines you might miss. If you want help setting one up, have your last six months of bank statements and your GST filing frequency ready, and get in touch with Sarv Accounting Services to walk through it.
Frequently asked questions
How often should I update my cash flow forecast?
Weekly, ideally on the same day each week, so you are comparing actual results to what you predicted. Fifteen minutes is usually enough once the spreadsheet is set up.
What is the difference between cash flow and profit?
Profit is revenue minus expenses recorded when they happen, regardless of when cash actually moves. Cash flow only counts money that has actually landed in or left your bank account, which is why a profitable business can still run out of cash.
Do I need accounting software to forecast cash flow?
No, a basic spreadsheet works fine for most small businesses. Software like QuickBooks Online or Xero can generate cash flow reports automatically, which saves time once your books are current, but it is not required to get started.