Profit tells you whether the business works. Cash tells you whether it survives next month. A plain-language way to see the gap before it opens.
A business can be profitable on paper and still run out of money. It happens when the money you are owed arrives later than the money you owe goes out. A large order that will be paid in sixty days, a rent increase, a tax instalment, a slow month in a seasonal trade: any one of them can empty the account while the year still looks fine.
The tool that catches this early is a cash flow forecast. It sounds like accounting. It is really a calendar for money. I'm Saliem Talash, I build practical tools for small businesses in Toronto, and this is how I would set one up from a blank spreadsheet in an afternoon.
The Business Development Bank of Canada (BDC) describes its free cash flow calculator as "a simple spreadsheet that lists all the money coming into your business over the next weeks or next months" and "compares it to the money going out."
That is the whole idea. You are not measuring profit. You are measuring when money actually lands in and leaves your bank account.
BDC's template has two views: a 13-week tab, to plan short-term needs over a quarter, and a 12-month tab for the longer picture. If you are starting from nothing, start with the 13 weeks. It is short enough to be accurate and long enough to see trouble coming.
Make one column per week for the next 13 weeks. Then build four blocks of rows.
1. Opening balance. The cash in your business account at the start of each week. Only the first week is typed in. Every later week starts with the previous week's closing balance.
2. Money in. One row per source. BDC's advice is to "identify all potential sources of revenue, including sales, fees, and investments," and to time each receipt by "your credit policy and when your customers pay." That last part matters most. If customers have 30 days to pay and usually take 40, put the money in the week it will really arrive, not the week you sent the invoice.
3. Money out. One row per kind of payment. BDC's list includes payroll, rent, utilities, interest, loan repayments and big purchases. Add the ones that are easy to forget: software subscriptions, insurance, card processing fees, sales tax remittances, payroll remittances, and any tax instalments.
4. Closing balance. Opening balance, plus money in, minus money out. This is the only row you really read.
To make this concrete, here is a fictional business, invented for illustration.
A two-person catering company has $9,000 in the bank at the start of the quarter. It bills corporate clients on 30-day terms. In week 3 it lands a large order and has to buy $6,000 of equipment and supplies in week 4. The client pays $11,000 in week 9.
On a profit view, that order is a good quarter. On the cash view, weeks 4 to 8 look different. Rent, wages and the usual supplies keep leaving every week, and the new money is still five weeks away. If the closing balance drops below zero in week 7, the owner knows it in week 1, not on the day a payment bounces.
That is the forecast's job: turn a surprise into a decision. In week 1 there are options. In week 7 there are only emergencies.
BDC suggests building optimistic, most likely and pessimistic versions. You do not need three spreadsheets. Copy the money-in rows twice and change only the assumptions that are genuinely uncertain:
Most likely: customers pay when they usually do.
Pessimistic: your two slowest-paying customers pay three weeks late, and one expected order does not happen.
Optimistic: the pending order lands on time.
If the pessimistic version stays above zero, you can sleep. If it does not, you now know how big the gap is and when it opens.
A forecast made once and filed is a nice document. A forecast updated every week is a management tool. BDC recommends a "13-week rolling cash flow forecast" updated weekly, and comparing projections with actual results monthly, with a deeper review each quarter.
The weekly routine takes about fifteen minutes:
Replace last week's forecast numbers with what actually happened.
Add a new week at the end, so you always see 13 weeks ahead.
Look at the lowest closing balance on the sheet and the week it falls in.
Write one line about anything that changed: a late payer, a new order, a bill that went up.
After a month you will notice which of your guesses are always wrong, and in which direction. That is valuable on its own.
BDC's articles offer several levers. In rough order of how easy they are to pull:
Invoice sooner. Send the bill as soon as the work is done, not at the end of the month.
Match your terms. BDC suggests you "match the payment terms you offer to your clients to the terms offered by your suppliers." If you pay suppliers in 30 days, giving customers 60 builds a hole into every month.
Ask for deposits. For bigger jobs, BDC suggests asking "for a deposit with the order and then a percentage of the payment at various agreed upon milestones."
Offer an early-payment discount to customers who can pay faster.
Negotiate with suppliers for longer terms before you need them.
Arrange credit early. BDC's line here is worth remembering: "It's usually easier to negotiate a line of credit when you don't really need one." Its year-planning article puts it more bluntly: "Bankers don't like surprises." A forecast is exactly the document that removes the surprise.
If your year has a busy season and a quiet one, the 13-week view will not show the whole picture. BDC calls a projection with monthly figures for the year "especially important in a seasonal business." Build the 12-month version once a year, before the quiet season, and keep the 13-week sheet rolling inside it.
One sheet, 13 weekly columns.
Opening balance, money in, money out, closing balance.
Money in timed to when customers actually pay.
Every outgoing, including tax remittances and subscriptions.
A pessimistic copy of the money-in rows.
Fifteen minutes every week to roll it forward.
One question each time: what is the lowest balance, and when?
If you want a ready-made version, BDC's calculator is free to download. I also keep simple templates for small-business routines on my own site, and longer explainers on ZELR. None of this is financial advice for your specific business; it is a habit that makes the advice you do get more useful.
BDC: Cash flow calculator
BDC: 4 key steps to plan your cash flow in the coming year
BDC: 5 tips to manage your cash flow
BDC: Techniques for better cash flow management
Drafted with AI assistance.
More from Saliem Talash: saliemtalash.vercel.app · ZELR · YouTube