There is a grim statistic that every founder should hear early: a large share of businesses that fail were profitable on their income statement right up until the end. They did not fail because they could not sell; they failed because on some Tuesday there was not enough cash in the account to make payroll or pay a supplier. Profit is an accounting opinion about a period. Cash is the cold fact of what is actually in the bank. A cash flow forecast is the tool that keeps the two from drifting dangerously apart.
Why profit and cash are not the same
The gap between the two comes from timing. You might make a big sale in March, record it as revenue, and celebrate a profitable month, yet not collect the money until May. Meanwhile you paid your staff and your rent in March. On paper you profited; in your account you went backward. Several everyday events open this gap:
- Customers who pay on 30, 60, or 90 day terms while your bills are due now.
- Inventory you buy in advance and only sell weeks later.
- Loan repayments, which drain cash but are not an expense on the P&L.
- Tax bills that arrive as a lump sum long after the income was earned.
Building the forecast step by step
A cash flow forecast is just a calendar of money in and money out, usually laid out week by week or month by month for the next three to twelve months. You can build a useful one in a spreadsheet in an afternoon.
- Start with your opening balance: the cash you actually have today.
- List expected cash in: customer payments by the date you truly expect them to arrive, not the invoice date, plus any loans or owner contributions.
- List expected cash out: payroll, rent, suppliers, taxes, loan repayments, and everything else, on the dates they leave the account.
- Calculate the running balance: opening balance plus cash in minus cash out, carried forward to the next period.
The moment the running balance dips toward zero or below, you have found your danger zone, and you have found it in advance rather than on the day it hits.
Using the forecast to make decisions
A forecast is only valuable if it changes behavior. When it shows a squeeze coming in eight weeks, you have a menu of options while there is still time to use them: chase overdue invoices, ask a supplier for longer terms, delay a non-urgent purchase, arrange a line of credit before you desperately need it, or offer a small discount for early payment. All of these are easy to arrange from a position of foresight and nearly impossible to arrange in a panic.
The forecast also improves everyday choices. Thinking about hiring? The forecast shows whether you can carry the extra payroll through a slow season. Considering a bulk purchase for a discount? The forecast shows whether tying up that cash leaves you exposed. It turns big decisions from gut feelings into visible trade-offs.
Keeping it honest and up to date
Two habits make a forecast trustworthy. First, be conservative: assume customers pay late, because many do, and do not count money you merely hope to win. Second, update it regularly, ideally every week, by comparing what you predicted to what actually happened. Over time your estimates sharpen, and the forecast becomes eerily accurate. That feedback loop is where the real skill develops.
You do not need fancy software to start. A simple spreadsheet with dates across the top and line items down the side will do the job for most small businesses. What matters is not the tool but the habit of looking forward, so that the state of your bank account weeks from now is something you understand rather than something that surprises you.
This article is for general information only and is not professional financial, legal, or accounting advice. Consult a qualified professional before making decisions for your own business.