A Simple Cash Flow Forecast You Can Build in 20 Minutes

Most small business owners find out about a cash problem the same way: the balance is lower than expected and a bill is due tomorrow. A forecast doesn't prevent every surprise, but it turns most of them into something you saw coming weeks earlier and had time to plan around. It's also a lot simpler to build than it sounds — you don't need accounting software or a finance background, just your bank balance and a rough sense of what's coming in and going out.

Why "profitable" isn't the same as "safe"

A forecast answers a different question than your profit and loss statement does. Profit tells you whether your business makes sense over time. Cash flow tells you whether you can cover Thursday's payroll and Friday's supplier invoice. A business can be profitable on paper and still come up short in a given week, because income and expenses rarely land on the same schedule — you might collect from a big job three weeks after you paid for the materials that went into it. A forecast is the tool that catches that timing gap before it catches you.

The four-week version

You don't need a 12-month projection to get value out of this — a rolling four-week view is usually enough to spot trouble early and still simple enough that you'll actually keep it updated. Here's the basic version:

1. Start with today's actual cash balance. Not what you think it should be — what's actually in the account right now.
2. List money coming in, week by week. Customer payments you're expecting, with realistic dates, not the date the invoice was sent. If a customer usually pays two weeks late, forecast it that way, not on faith.
3. List money going out, week by week. Payroll, rent, loan payments, supplier bills, taxes you've set aside — anything with a known or roughly known due date.
4. Run the balance forward. Starting balance, plus that week's income, minus that week's expenses, equals your projected ending balance for the week. That number becomes next week's starting balance.
5. Watch for the week the number goes negative — or just gets uncomfortably low. That's the point of the whole exercise. A shortfall three weeks out is a plan. A shortfall you notice the day before is a scramble.

None of this needs to be precise. Round numbers and best guesses are fine. The goal isn't a perfect prediction — it's an early warning system.

Where people get it wrong

The most common mistake is forecasting income too optimistically and expenses too vaguely. Owners tend to enter customer payments on the date they're due rather than the date they're actually likely to arrive, and they tend to forget expenses that aren't monthly and predictable — a quarterly insurance payment, an annual software renewal, a piece of equipment that's overdue for replacement. Those irregular costs are exactly the ones that blow up a forecast, because they're easy to forget until the bill shows up.

The second mistake is treating the forecast as a one-time exercise. Built once and never touched again, it's stale within a couple of weeks. Built as a short weekly habit — ten minutes on a Monday morning to update the actuals and push the numbers forward — it stays useful and starts catching real problems before they happen.

You already have the inputs

If you've been tracking your sales and expenses at all, you already have most of what a forecast needs — it's really just those numbers laid out by week instead of by month, with a bit of judgment about timing layered on top. The habit matters more than the tool: a rough forecast you actually update beats a detailed one that sits untouched.

In Clovemi, your Cash & Daily Close and Reports views show you exactly where your cash stands today, so the "starting balance" part of a forecast is never a guess. Start free — no credit card required.