Most small teams watch revenue. Revenue is the friendly number - it goes up, it feels like progress, it fits in a celebration. The trouble is that revenue can be climbing while the bank account quietly drains, and by the time that shows up it is usually payday and the money is not there.

Forecasting cash flow is the fix, and it is not the spreadsheet nightmare it sounds like. For a team of two to ten with no finance department, a useful forecast takes about half an hour to build and fifteen minutes to keep alive.

Profit is an opinion. Cash is a fact.

Profit counts what you have earned. Cash counts what is actually in the account today. Those are not the same thing, and the gap between them is where small businesses get hurt.

You can close a great month on paper - big invoices sent, profit-and-loss looking healthy - and still be unable to cover payroll, because the invoice that made the month "profitable" is not due to be paid for another 45 days. Revenue tells you the business is working. Cash flow tells you whether it survives the month.

What a forecast actually is

A cash flow forecast is just a forward look at money in and money out, lined up by when the money actually moves - not when it was promised or invoiced. You pick a horizon, and for each period you write down what you genuinely expect to receive and pay, then carry the balance forward.

For most small teams the next three to six months is the right horizon. Far enough ahead to give you time to react, close enough that your guesses are still grounded. The number that matters is the running balance: the closing cash at the end of each period. That single column is the early-warning system.

The only inputs you need

  • Opening balance. What is in the account right now.
  • Money in. Expected payments, dated by when they will actually land - not the invoice date. When in doubt, be late and be conservative.
  • Money out. Split it in two: the fixed, predictable costs (payroll, rent, recurring tools) and the lumpy ones that are easy to forget.
  • Net and running balance. Money in minus money out for the period, then added to the previous balance. That part is just arithmetic.

Build one in thirty minutes

  1. Start with today's actual bank balance. Not the invoiced total, the real cleared number.
  2. List everything that leaves on a schedule - payroll, rent, software, loan payments. These are your fixed outflows and they barely change month to month.
  3. Add the lumpy outflows to the months they actually fall in - quarterly tax, annual insurance, a big contractor invoice, an annual renewal. This is the step that saves teams.
  4. List the money you expect in, dated honestly. Push optimistic dates back. A deal that is "closing soon" is not cash.
  5. Project it forward three to six months and read the running balance. You are not looking at the totals - you are looking for the lowest point, and when it happens.

Here is what that looks like for a small team carrying a modest buffer.

A simple four-month forecast
Opening balance: $8,000. Illustrative figures.
MonthInOutNetRunning
January$12,000$9,500+$2,500$10,500
February$7,000$9,500-$2,500$8,000
March$6,000$13,000-$7,000$1,000
April$14,000$9,500+$4,500$5,500
The profit-and-loss for this quarter looks fine. But March - a slow revenue month landing on top of quarterly tax and an annual insurance renewal - drops the account to $1,000. The forecast shows that in January, with two months to chase a payment early, delay a purchase, or hold a little back. Without it, March is a phone call from the bank.

You are not forecasting to predict the future. You are forecasting to give yourself time.

The mistakes that catch small teams

  • Counting income on the invoice date. Won is not paid. Date the money to when it clears, and add a buffer for the clients who always run late.
  • Forgetting the lumpy outflows. Quarterly tax, annual insurance, renewals, a contractor's final invoice - they do not appear monthly, so they ambush whichever month they land in. They belong in the forecast the moment you know about them.
  • No floor. Decide a minimum cash level - one month of fixed costs is a common rule - and treat it as a hard line, not a hope. The forecast exists to keep you above it.
  • Building it once. A forecast is only useful if it rolls. A model you made in January and never touched is a museum piece by March.

Set aside tax as the money arrives

The most common cash shock for a small team is a tax bill that was always coming and was never put aside. The fix is boring and it works completely: every time money comes in, move a fixed percentage to a separate account and pretend it does not exist. When the bill arrives, it is already paid for.

Rates, thresholds, and rules vary depending on where you operate and how you are set up, so confirm your own percentage with an accountant. The discipline is the same everywhere - set it aside on the way in, not scrambling at the deadline.

Make it a habit, not a project

The teams that never get blindsided are not the ones with the most elaborate model. They are the ones who open a simple forecast every week or two and roll it forward. Fifteen minutes, update the actuals, push the horizon out one more period. That is the entire discipline, and it is what turns cash from a recurring panic into something you can see coming.