Most small businesses that run into trouble were profitable on paper. The problem is rarely that the idea was bad. It is that the money ran out at the wrong moment, usually because nobody saw a slow stretch coming. A cash flow forecast is the tool that fixes that, and you do not need an accountant or expensive software to build one.
This guide covers what a cash flow forecast is, why it matters more than your profit and loss statement in the short term, and how to build a simple one you can actually keep updated.
Cash flow is not the same as profit
Profit is what is left after you subtract expenses from revenue over a period. Cash flow is the actual movement of money in and out of your bank account, and the timing is everything. You can book a $10,000 sale in March, feel profitable, and still fail to make payroll in April because the client does not pay until May. Profit says you are fine. Cash flow says you have a problem. In the short term, the bank balance is what keeps the doors open.
What a forecast actually is
A cash flow forecast is a simple month by month projection of three things: the cash you expect to come in, the cash you expect to go out, and the balance you are left with. Line those up across the next 6 to 12 months and you can see, before it happens, which months are tight and which have room to spare.
The three pieces you need
Opening balance. This is the cash you have in the bank at the start of the month. For the first month it is your real balance today. For every month after that, it is the closing balance of the month before.
Cash in. Every source of money you expect to receive that month: customer payments, deposits, loans, owner contributions. The key is to record it in the month you actually expect the money to land, not the month you sent the invoice.
Cash out. Everything you expect to pay: rent, payroll, software, materials, taxes, loan repayments, your own draw. Again, record it in the month the money leaves, not the month the bill is dated.
Closing balance is opening balance plus cash in minus cash out. That closing balance carries forward as next month's opening balance, and the chain continues.
A quick example
Say you start January with $8,000 in the bank. You expect $12,000 in customer payments and $14,000 in costs, because a large inventory order landed this month. January closes at $6,000. February brings $12,000 in and $9,000 out, closing at $9,000. March is your slow month: $6,000 in and $10,000 out. That forecast shows March closing at $5,000, still positive but thinning fast.
Here is where the value shows up. It is only January, and you already know March is going to be tight. You have two full months to act: chase a slow paying client, delay a purchase that is not urgent, or line up a small buffer. Without the forecast, March arrives as a nasty surprise. With it, March is just a number you planned around.
How far ahead should you look
Twelve months is the sweet spot for most small businesses. Anything shorter and you miss seasonal swings and annual costs like insurance or tax bills. Anything longer and the estimates get too speculative to trust. Keep a rolling twelve month view: every time a month ends, add a new month at the far end so you always have a full year in front of you.
How to keep it honest
A forecast is only useful if it reflects reality, so two habits matter. First, be conservative on timing. If a client usually pays in 45 days, do not forecast the cash in 30. Second, update it. Once a month, drop in what actually happened and roll the forecast forward another month. Over time your estimates get sharper, because you are comparing them against real results.
Build it once, then just maintain it
You can start with a blank spreadsheet and the structure above. If you would rather not build the formulas from scratch, our P&L and Cash Flow Dashboard ($39) gives you a ready made forecast where you enter your numbers and it handles the running balances, the month by month view, and the profit and loss picture alongside it. If you want the full set of finance tools, the Financial Command Center bundle ($79) includes it with three other templates.
The forecast itself is simple arithmetic. The advantage comes from doing it before you need it. Businesses that check cash flow once a month make calm decisions. Businesses that only look when the balance is already low make panicked ones. Build the forecast once, spend fifteen minutes a month keeping it current, and you turn cash from your biggest source of stress into something you simply manage.