Think about a small landscaping business wrapping up its best quarter in years. Sales are up, new contracts are signed, and the owner feels good enough to hire two more crew members. Then February rolls around. Clients haven’t paid their invoices yet, payroll is due, and the truck needs a $4,000 repair. The business is profitable on paper. It just doesn’t have the cash to cover what’s due this week.
This happens more often than people think, and it has nothing to do with how good the business actually is. A restaurant can be fully booked and still struggle to make payroll. A contractor can have a full pipeline of jobs and still bounce a check for materials. Profit and cash are two different things, and most owners learn that the hard way, usually at the worst possible moment. A cash flow forecast is how you stop finding out the hard way. It’s not complicated, and you don’t need an accounting degree to build one. You need a habit, a spreadsheet, and about twenty minutes a week. Firms like Magic Books build and maintain forecasts for owners who’d rather hand this off entirely, but even a simple version you build yourself puts you miles ahead of guessing.
So let’s get into what a forecast actually is, and how to build one that you’ll actually use.
What a Cash Flow Forecast Really Is
Strip away the jargon and a cash flow forecast is just this: how much money do you expect to have, and when. That’s it. You’re not predicting the future with perfect accuracy. You’re making an educated guess based on what you already know, then checking that guess against reality every week or two.
Most owners already track sales and expenses somewhere, whether that’s QuickBooks, a spreadsheet, or the back of a napkin. A forecast takes that same information and lays it out across time, so you can see the weeks or months where cash gets tight before you’re standing in the middle of one.
There’s no single right way to build one, but a rolling 13-week forecast tends to work well for most small businesses. It’s long enough to catch problems coming, like a slow month or a big tax payment, but short enough that your estimates stay reasonably accurate. Longer forecasts, stretching six months or a year out, are useful too, though they work better as a general planning tool than something you check week to week. Most owners end up keeping both, a short-range forecast they trust and update constantly, and a longer one they revisit monthly to see where the business is headed.
Building the Model, Step by Step
You don’t need fancy software for this. A spreadsheet with a few rows does the job.
Start with your current cash balance:
This is the actual number in your bank account today, not what you think you’ll have after that invoice clears.
List your expected inflows:
This covers things like sales you’re confident about closing, and payments from clients who owe you money already, sorted by roughly when you expect the money to land. Be honest about this part. If a client always pays 15 days late, forecast it as 15 days late, not on the invoice due date.
List your expected outflows:
Payroll, rent, loan payments, inventory, insurance, software subscriptions, all of it. Include the irregular ones too, quarterly taxes, annual insurance renewals, that truck repair you know is coming eventually even if you don’t know exactly when.
Calculate your projected balance:
Starting balance, plus inflows, minus outflows, week by week or month by month. That final number tells you whether you’re heading into a comfortable stretch or a tight one.
Here’s a simplified example. Say a business starts the month with $10,000 in the bank. It expects $18,000 in client payments and has $22,000 in payroll, rent, and supplier costs due. That leaves a projected balance of $6,000, which sounds fine, until you notice that $15,000 of those payments aren’t expected until the last week of the month, while $14,000 of the payroll and rent is due in the first ten days. On paper, the month works out. Week by week, there’s a real gap that needs covering, whether through a line of credit, a delayed purchase, or a nudge to a slow-paying client.
That’s the entire value of forecasting. It’s not the monthly total that gets businesses into trouble. It’s the timing.
This is roughly the same exercise a fractional CFO runs for growing companies, just scaled down and simplified for an owner who’s also doing ten other jobs. You don’t need to hire one to get the benefit of thinking this way. You just need to sit down with the numbers on a regular basis and ask the same question a CFO would: given what’s coming in and going out, do we actually have enough cash on the days it’s needed, not just by the end of the month.
Where Most Owners Go Wrong
A few mistakes show up again and again, and they’re worth watching for.
The first is being too optimistic about collections. Owners tend to forecast based on when an invoice is due, not on when the client historically actually pays. If your average client pays two weeks late, your forecast should reflect that pattern, not the payment terms on the invoice.
The second is forgetting irregular expenses. Monthly bills are easy to remember because they show up every month. It’s the quarterly tax payment, the annual software renewal, or the equipment that finally gives out that catches people off guard, because those costs don’t have a monthly rhythm to remind you.
The third, and probably the most common, is building the forecast once and never touching it again. A forecast is only useful if it reflects what’s actually happening, which means it needs updating every week or two as new invoices, expenses, and payments come in. This is also where strong bookkeeping habits matter more than people expect. If your books are current and accurate, updating a forecast takes a few minutes. If your bookkeeping is months behind, you’re not forecasting anymore, you’re reconstructing history before you can even start.
A fourth mistake worth naming is treating the forecast as a solo project. Whoever handles sales knows which deals are actually close to closing and which ones keep slipping. Whoever manages purchasing knows which suppliers expect payment upfront and which extend terms. A forecast built entirely from the owner’s head, without checking in with the people closer to the day-to-day numbers, tends to miss things that would have been obvious to someone else on the team.
This is also why a lot of owners eventually weigh handling the books themselves against bringing in professional help. Forecasting well depends entirely on the quality of the numbers feeding it, and clean, current books make that possible. Solid financial controls around invoicing and expense tracking also make a real difference here, since a forecast is only as reliable as the data behind it. Same goes for a consistent month-end close, which gives you a clean starting point to forecast from instead of guessing where you actually stand.
Seasonal businesses have an extra layer to think about too. If your revenue swings depending on the time of year, your forecast needs to account for that ahead of time rather than reacting to it once the slow months hit. It’s worth taking a hard look at whether your business can comfortably ride out a slow season before you’re actually in one.
Making It a Habit
None of this needs to be complicated to be useful. A simple weekly check-in, comparing your forecast to what actually happened, will teach you more about your business’s cash patterns than most financial reports ever will. Over time, you’ll start noticing your own patterns too. Which clients pay late. Which months run tight. Where you have more breathing room than you thought.
The businesses that get caught off guard usually aren’t the ones with the worst numbers. They’re the ones who never looked closely enough to see the gap coming. A forecast, kept up to date and checked regularly, closes that gap before it becomes a problem. It also changes the kinds of decisions you get to make. Instead of reacting to a cash crunch after it hits, you see it coming weeks out, which gives you room to delay a purchase, follow up on an overdue invoice, or line up a short-term loan on your own terms rather than under pressure.
If building and maintaining one feels like more than you have time for on top of running the business, that’s exactly the kind of work Magic Books handles for owners every day, alongside the bookkeeping and CFO support that keeps the numbers behind it accurate. Either way, the sooner you start looking ahead instead of just at what’s already happened, the fewer surprises you’ll run into.
