Cash Flow Forecasting: See What's Coming Before It Arrives

Jason Medlin
May 18
5 min read

Black-and-white photo representing forward-looking cash flow forecasting for small business

How do you know if you'll have enough cash next month?

For most business owners, the answer is: check the bank balance and hope for the best.

That works until it doesn't. Until a big expense hits that you forgot about. Until a client pays late. Until you realize you can't make payroll and it's already Friday.

A cash flow forecast changes everything. Instead of reacting to what already happened, you see what's coming before it arrives. You make decisions with time on your side instead of with your back against the wall.

What Is a Cash Flow Forecast?

A cash flow forecast is a projection of money coming in and going out over a future period. Usually weekly for the next 13 weeks, or monthly for the next 12 months.

It answers the question: based on what I know right now, what will my cash position be in two weeks? Six weeks? Three months?

It's not a budget. A budget tells you what you planned to spend. A forecast tells you what's actually going to happen based on real commitments, real invoices, and real patterns.

It's not a profit and loss statement. P&L shows revenue and expenses, but cash and profit are different things. You can be profitable on paper and still run out of cash.

A cash flow forecast is its own tool. It tracks the actual movement of dollars in and out of your bank account, projected forward.

Why Most Owners Fly Blind

Most small business owners don't forecast cash. They manage by gut feel and bank balance. There are a few reasons why:

It feels complicated. Forecasting sounds like something only big companies with finance teams do. Spreadsheets, formulas, assumptions — it seems like a lot of work.

The business is unpredictable. "I don't know what's coming in next month, so how can I forecast it?" Revenue varies. Clients are unpredictable. It feels pointless to project something you can't control.

Checking the bank feels like enough. If there's money in the account, you're fine. If it's tight, you hustle. This has worked so far.

The problem is that checking the bank only shows you today. It doesn't show you the quarterly tax payment due in three weeks. The slow season coming in six weeks. The payroll hitting the same day as rent. By the time you see the problem in your bank balance, it's already a crisis.

The 13 Week Rolling Forecast

The most practical cash flow tool for small businesses is a 13 week rolling forecast. Here's how it works:

You project cash inflows and outflows for each of the next 13 weeks. Every week, you update it: add a new week at the end, update your projections based on what you now know, and see how your cash position is trending.

Why 13 weeks? It's a quarter. Long enough to see patterns and problems coming. Short enough that your projections are still meaningful. Beyond 13 weeks, you're really just guessing.

The rolling part is key. This isn't a one-time exercise you do in January and forget. It's a living document that you update weekly. Each week, reality replaces your projections for the past week, and you extend your view one more week into the future.

What a Forecast Reveals

Once you start forecasting, you see things you couldn't see before:

Timing gaps. You might have plenty of revenue but still get squeezed because money goes out before it comes in. A forecast shows you when these gaps will hit so you can plan for them.

Seasonal patterns. Maybe cash is always tight in February or August. Once you see the pattern, you can prepare: build reserves during strong months, delay big purchases until you're through the slow period.

The real cost of growth. Growth eats cash. You have to spend money on inventory, labor, and capacity before you collect revenue from the increased sales. A forecast shows you whether you can fund the growth or if you'll run dry halfway through.

Decision timing. Can you afford to hire next month? Should you take that equipment loan? Is this the right time for a distribution? A forecast gives you real answers instead of gut feelings.

How to Build a Basic Forecast

You don't need fancy software. A spreadsheet works fine. Here's the structure:

Start with your current cash balance. What's in the bank right now? That's your starting point.

Project cash inflows for each week. What money do you expect to receive? Include invoices you've sent (adjusted for when clients typically pay), recurring revenue, expected new sales. Be realistic, not optimistic.

Project cash outflows for each week. What money will go out? Payroll, rent, loan payments, vendor bills, estimated taxes, subscriptions. Include everything that will actually leave your account.

Calculate the weekly change and running balance. Inflows minus outflows equals your weekly change. Add that to your starting balance and you have your projected ending balance for each week.

Update weekly. Every week, compare what actually happened to what you projected. Adjust your future projections based on new information. Add a new week at the end.

When You Need a Cash Flow Forecast

Cash flow forecasting isn't just for businesses in trouble. It's most valuable when:

→ You're growing and need to know if you can fund the growth

→ You're considering a hire, equipment purchase, or other big decision

→ You have seasonal revenue or lumpy income

→ You're paying yourself (or want to) and need to know if it's sustainable

→ You've ever been surprised by a cash crunch

→ You want to make decisions proactively instead of reactively

If any of these apply, a cash flow forecast will change how you run your business.

This Is What a Fractional CFO Does

Bookkeeping tells you what happened. A CFO tells you what's coming and what to do about it.

Cash flow forecasting is one of the core tools in the CFO toolkit. It's the difference between flying blind and flying with instruments. It's the difference between hoping you'll have enough cash and knowing.

At Bottomline Capital, we build and maintain cash flow forecasts for our advisory clients. We update them monthly (or more often during high-growth or tight-cash periods), use them to model decisions, and make sure our clients always know what's coming.

If you're tired of checking your bank balance and hoping for the best, let's talk about getting you a real forecast. Book a free consultation and we'll figure out what visibility you need.