Playbook · Small business 3 min read
Know your cash before the bank does.
Your invoices and bills already say when money comes in and when it goes out. A weekly forecast turns them into a warning you get weeks early.
This is how we'd set up cash forecasting for a small business. It's a playbook, not a report on a client.
The bank usually finds out first
Most owners find out about a cash crunch the hard way. A supplier payment bounces, payroll won't clear, or the bank calls about the overdraft. By then every option costs something. You pay a late fee or make an awkward call to someone you owe.
Late customers are a big part of it. Atradius found that customer cash flow bottlenecks are the top reason Canadian businesses get paid late, cited by nearly half of them. More than one-third say late payment cuts the cash they have for day-to-day operations. Your customer's cash problem becomes yours.
- 7 in 10
- Canadian businesses deal with late payment from business customers, per Atradius
- 29 days
- from invoice to payment for Canadian small businesses in the June 2026 quarter, per Xero
- 11.3 days
- late, on average, for those same payments, per Xero
The warning is already in your books
Every open invoice says who owes you, how much and when it's due. Your payment history tells you more. It shows when each customer pays. The customer on 30-day terms who always pays on day 52 isn't a surprise. That's a pattern, and you can plan around a pattern.
Bills are even easier to predict. Payroll lands on the same days and rent on the first. A regular remitter owes payroll deductions to the CRA by the 15th of the month after payday. Monthly and quarterly GST/HST filers pay one month after the period ends. That GST/HST payment is money you collected weeks ago, which is why it's so easy to spend first.
Line the two up week by week and you have a cash forecast. BDC calls a 13-week rolling cash flow forecast a simple and effective tool for preserving cash. It's a three-month window you update at the start of every week, and BDC has a free template for it. The spreadsheet isn't the hard part. Keeping it current every Monday while you run a business is.
Why an accounting app won't warn you
Accounting software records what already happened. Where it does look ahead, it usually counts each invoice on its due date and leaves you to type in a better guess for the late ones. Canadian small businesses were paid 11.3 days late on average in that June quarter. A forecast built on due dates is too rosy before it starts, and it gets worse with your slowest customers. It also has no idea how low is too low for your business, or what you could do about a bad week.
What we'd build
- Every Monday it pulls open invoices and bills from your accounting system, and your balance from the bank feed.
- It learns when each customer pays from their past invoices, and dates each open invoice by that instead of the due date.
- It adds payroll, rent, loan payments, payroll remittances and GST/HST on the dates they leave your account.
- It shows your balance for each of the next 13 weeks and marks the lowest point.
- If a week dips below the floor you set, it flags it early with options. Chase these three invoices. Move this supplier payment a week. Ask for a deposit on the next big job.
- Each week it checks last week's forecast against what happened, so its guesses improve.
- Invoices and bills
- Real pay dates
- Next 13 weeks
- Low week flagged
Want to see this mapped to your business?
AI drafts the forecast and the options. You and your accountant decide what to do, and nothing moves money on its own. The data stays in accounts you own, which is how it should work for anything that touches your money.
Start small
Take your ten biggest customers and check when they paid their last few invoices, not when those invoices were due. Then list every fixed payment for the next 13 weeks, tax remittances included. Those two lists are a rough forecast already. We can connect them to your accounting system so the forecast updates itself every Monday.
Want to see your low week coming?
Bring your open invoices and bills to a free 30-minute call. We'll sketch your next 13 weeks with you.