How to Build a Simple Cash Flow Forecast (With a Worked 3-Month Example)

Most people conflate a budget with a cash flow forecast, but they're actually answering two different questions. A budget tells you what should happen to your money — how much goes to rent, groceries, savings, and everything else, sliced up by category. A forecast tells you when money actually moves in and out, and what your balance looks like at each point along the way. You can have a perfectly reasonable budget on paper and still get blindsided by a cash crunch, because a budget doesn't care about timing — it just cares about totals. A forecast is the tool that actually catches a crunch coming, because it's built around timing from the start.

The 3-Month Worked Example

Let's walk through an example month by month. You start with $2,000 in the bank. In Month 1, $4,200 comes in and $3,850 goes out — a normal month, nothing unusual, and it ends with a net gain of $350. Month 2 is where things get interesting: only $3,100 comes in this time (maybe a slower sales month, or a payment that landed later than expected), and $4,600 goes out, including one large one-time expense that doesn't show up every month — something like a quarterly insurance premium or an annual software renewal. That's a net loss of $1,500 for the month. Month 3 bounces back: $5,300 in, $3,950 out, a solid net gain of $1,350 that more than makes up for Month 2's dip.

The Running Balance Is What Matters

Here's the part that actually matters, though: it's not the monthly totals, it's the running balance. Apply each month's net gain or loss to the balance you're carrying forward, and you get $2,000, then $2,350, then $850, then $2,200. Notice that Month 2 never actually dips below zero in this example — technically, nothing "goes wrong." But watching the balance fall from $2,350 down to $850 is exactly the kind of signal a forecast exists to catch. If you'd only been checking your bank balance day to day instead of forecasting ahead, you might not have noticed how thin that cushion was getting until you were already living it. Seeing it on paper weeks in advance means you actually have options: you can delay a discretionary purchase, move up an invoice, or just make peace with a tighter month because you know it's temporary and recovery is already on the calendar.

Step-by-Step: Building Your Own Forecast

Building your own version of this isn't complicated, but it does take some honesty. Start by listing every inflow you expect over the next 3 to 12 months, using realistic numbers rather than the best-case ones you're hoping for — if a client sometimes pays late, assume they'll pay late again rather than assuming this month will be the exception. Next, list every outflow: not just your regular recurring bills, but the one-time and irregular ones too, since those are exactly the expenses that catch people off guard. Insurance premiums billed annually, taxes due quarterly, a subscription that renews yearly instead of monthly — these are easy to forget precisely because they don't show up every single month. Once you've got both lists, calculate the net for each month (inflow minus outflow) and apply it to your actual current cash balance, not a hypothetical one, to get a running total month by month.

Then look for any month where that running balance drops below whatever you'd consider your minimum comfortable buffer — for some people that's a specific dollar amount, for others it's a certain number of months of expenses. Once you've flagged a tight month, you've got three real options: shift a discretionary expense to a different month, start building a small reserve now before you need it, or line up a backup source of cash ahead of time instead of scrambling when the month actually arrives. None of these options work as well once you're already inside the tight month — the whole value of forecasting is that it gives you weeks of runway to pick one calmly, instead of hours to pick one under pressure.

What Usually Gets Left Out

That Month 2 spike in the example isn't a random plot device — it's modeling exactly the kind of expense that trips people up in real life. Annual insurance premiums, quarterly estimated tax payments, a software subscription that bills yearly instead of monthly: these are all individually rare enough that they simply don't come to mind when you're sitting down and listing your "normal" monthly expenses from memory. Your brain is good at remembering what happens every month and bad at remembering what happens once a year, which is exactly backwards for building an accurate forecast. The fix is almost boring in its simplicity: pull up a full 12 months of actual bank and card statements instead of trying to recall your expenses from memory, and you'll catch nearly everything that a memory-based list would have missed. It's tedious the first time you do it and considerably faster every time after, since you'll already have the list of irregular expenses sitting in front of you.

The Short Version

If you only remember one thing from this: list your inflows and outflows month by month, don't forget the annual and quarterly items that don't happen every month, and pay attention to the running balance rather than just each month's individual net. In the example we walked through, that approach caught an $850 low point in Month 2 — still positive, still technically fine, but close enough to the edge that it was worth planning around. And it caught that weeks before it would have shown up as an actual problem in the bank account, which is the entire point of forecasting instead of just reacting after the fact.

FAQ

Educational resource only, not financial advice. The example above is illustrative; your own inflows, outflows, and timing will differ. See the U.S. Small Business Administration’s guide to managing a business for further general guidance.