How to Create a Cash Flow Forecast for a Small Business

Your best month on paper can be your worst month in the bank. I’ve seen this pattern repeat across businesses of all sizes: revenue is climbing, new projects are confirmed, the P&L looks strong. Then payroll hits on the 1st, a supplier invoice lands on the 5th, and the big customer payment you were counting on doesn’t clear until the 22nd. For about two weeks, a profitable business is scrambling.

A cash flow forecast exists to surface that gap before it surfaces in your bank balance. It won’t predict the future with precision. What it will do is give you enough visibility to act earlier, whether that means chasing a receivable, delaying a purchase, or lining up a short-term credit facility.

By the end of this article, you’ll understand what a forecast actually contains, how timing and confidence change everything about its usefulness, and how to read one so it informs real decisions.

 

What is a cash flow forecast?

A cash flow forecast estimates how much cash your business expects to receive and spend over a future period. It maps your opening balance, layers in expected inflows and outflows, and produces a projected closing balance for each week or month you’re looking at. That closing balance rolls forward as the next period’s opening balance.

The word “expected” is doing real work in that definition. A forecast is a living document built on assumptions about when customers pay, when bills come due, and what you plan to spend. Those assumptions need regular updating, which is where most forecasts either become useful or become fiction.

Cash flow forecast vs. budget vs. cash flow statement

These three tools answer different questions, and confusing them creates problems.

Tool	The question it answers
Budget	What do we plan to earn and spend this year?
Cash flow statement	What actually happened to our cash last period?
Cash flow forecast	What do we expect to happen to our cash next?

A budget is a plan you set at the start of a period. A cash flow statement is a historical record, usually generated from your accounting data. A forecast sits between the two: it’s an updated expectation, revised as reality shifts. You might budget $10,000 in monthly revenue, report $9,200 on your cash flow statement, and forecast $8,500 for next month because your largest client just extended their payment terms. Three tools, three different lenses on the same business. If you’re still building your annual plan, the ProfitBooks guide to business budgeting covers that process separately.

This is also why a profitable business can still hit a cash flow problem: profit is recorded when a sale is earned, but cash only moves when the money actually arrives. If those two events are weeks apart, the P&L can look healthy while the bank account runs dry. Profit and cash flow are not the same thing, and the forecast is where that gap becomes visible.

 

Why small businesses need a cash flow forecast

Skip the generic “cash is king” framing. The practical reason is simpler: a forecast turns vague financial anxiety into specific, answerable questions.

Can you make payroll if two invoices pay late? Should you commit to that equipment lease in Q3, or wait? Is the seasonal dip you’re expecting going to require a credit line? A forecast gives you the structure to work through those questions with numbers instead of gut feeling. In practice it helps you spot potential shortages early, prepare for major upcoming payments, understand whether customer payment delays could cause problems, plan spending more carefully, decide whether growth plans are affordable, and prepare for slower periods.

It also won’t save you from every problem. A forecast built on bad assumptions is just organized optimism. The value comes from updating it regularly and being honest about what you don’t know. The biggest benefit isn’t predicting every number perfectly. It’s giving yourself more time to respond when something doesn’t go according to plan.

How far ahead should you forecast? The 3-horizon model

Most guides default to “create a 12-month forecast.” That’s fine as general advice, but it ignores something important: the forecast period should match the decision you’re trying to make.

Horizon 1: the next 4 weeks (immediate cash)

Horizon 1 (next 4 weeks) is about immediate survival. Can you cover payroll? Are supplier payments going to stack up? Is there a week where your balance dips dangerously low? Weekly buckets, high detail. The main question: do I have enough cash to comfortably meet my upcoming commitments?

Horizon 2: the next 3 months (operating stability)

Horizon 2 (next 3 months) is about operating stability. Will receivables timing hold? Are expenses trending upward? Is a slow season approaching? Monthly buckets, moderate detail. The main question: is my business likely to remain financially comfortable over the next few months?

Horizon 3: the next 6 to 12 months (growth planning)

Horizon 3 (6 to 12 months) is about growth decisions. Can you afford to hire? Will you need external financing? What happens if revenue grows 20% slower than you hope? Monthly buckets, broader assumptions. The main question: can my business afford the decisions I’m planning to make?

You don’t need three separate spreadsheets. One forecast with tighter detail in the near term and looser projections further out works well. Most practitioner guidance recommends either a weekly 13-week view for businesses under cash pressure or a 12-month rolling view for more stable operations. The choice depends on volatility and what decisions are on the table. Your forecast period should match the decision you’re trying to make.

 

What you need before building your forecast

The first week of building a forecast is mostly gathering inputs, not building models. Four things matter.

1. Your actual starting cash balance

Your actual opening cash. Not your expected revenue, not your available credit line. The real number in your bank account. If your books haven’t been reconciled recently, start there. Stale records produce a starting number you can’t trust, and every row after it inherits the error.

2. Expected cash inflows

Your expected customer payments, mapped to when cash will realistically arrive: customer payments, cash sales, recurring revenue, confirmed deposits, and other business income. If you invoice on net-30 terms and your average customer pays on day 42, use day 42. Modeling invoice dates instead of collection dates is the single most common reason forecasts look healthy while bank balances drop. Don’t focus only on when you make a sale. Focus on when you expect to receive the money.

3. Expected cash outflows

Your expected expenses: payroll, suppliers, rent, subscriptions, taxes, loan payments, insurance, inventory. The less glamorous the line item, the more likely it gets forgotten. Quarterly tax payments and annual insurance renewals create outflow spikes that monthly averages completely miss.

4. Expected payment dates

And payment timing for all of the above. Timing is everything: a customer might owe you $10,000, but if the payment arrives next month and payroll is due this week, that $10,000 doesn’t solve today’s cash problem. A business might close $50,000 in sales this month and collect $20,000 of it. That $30,000 gap is the entire reason forecasting exists.

The core logic of a cash flow forecast

Rather than walking through a step-by-step build (ProfitBooks has template resources for that), here’s what matters conceptually. Every forecast follows the same underlying logic:

That ending cash becomes the next period’s opening cash. Repeat. Simple arithmetic. The hard part is everything that feeds into it.

Confidence changes everything

Most forecasts treat every future dollar as equally real. That’s a mistake. An invoice you’ve already sent to a long-standing client who pays reliably is not the same as revenue you’re hoping to close from a prospect you met last week.

Confidence level	What it looks like
🟢 High	Invoice issued, reliable payer, confirmed contract
🟡 Medium	Expected recurring sale, timing uncertain
🔴 Low	Potential new client, unconfirmed project

The practical takeaway: don’t build your survival plan around low-confidence cash. Keep those numbers visible in your forecast so you can see the upside, but make sure your essential commitments (payroll, rent, debt service) are covered by high-confidence inflows alone. When I’ve seen businesses get into trouble, it’s almost always because they were mentally spending money that hadn’t been confirmed yet.

Timing is the mechanism, not totals

This is where forecasting diverges sharply from budgeting. A budget might tell you that revenue will exceed expenses by $5,000 this month. The forecast might tell you that on the 8th, your balance drops to $1,200 because payroll clears before your largest customer payment arrives on the 19th.

That mid-month low point matters more than the month-end total. If you only check where the forecast ends, you can miss a two-week window where you literally cannot cover obligations. Practitioners call this “finding the trough,” and it’s one of the most underused pieces of a forecast.

 

How to create a cash flow forecast step by step

The core logic above tells you what a forecast is. Here’s how to actually build one, in nine practical steps you can run for the next four weeks and then extend.

Step 1: Start with your actual available cash

Begin with the real opening cash position, the money actually available in your bank account, not your expected revenue or your credit line. Start from reliable information, and reconcile your records first if they’re behind. If the starting number is wrong, everything downstream is wrong.

Step 2: List the cash you expect to receive

Add your expected customer payments, using realistic payment dates, along with confirmed deposits and predictable recurring income. Don’t fill your forecast with sales you hope will happen. Start with money you have a realistic reason to expect.

Step 3: Rate how certain your expected inflows are

Use the forecast confidence scale from the previous section. Mark each expected inflow as 🟢 high (invoice issued, confirmed payment, reliable recurring payment), 🟡 medium (expected recurring sale, timing uncertain), or 🔴 low (potential new customer, unconfirmed project, possible future sale). The key rule: don’t build your essential payment plan around low-confidence cash.

Step 4: List every significant cash payment you expect to make

Cover fixed expenses, variable expenses, one-time expenses, and irregular payments. The expenses businesses forget are often the ones that cause the biggest surprises, so be deliberate about the payments that don’t show up every month.

Step 5: Map when the money will actually move

A cash flow forecast is about timing, not just totals. Place each inflow and outflow in the week it will actually move. Consider a simple scenario:

On paper the month is fine, but the business may temporarily experience a cash shortage in Weeks 1 and 2, before the customer payment arrives in Week 3. That timing gap is exactly why profit and cash flow are not the same thing.

Step 6: Calculate your projected cash position

For each week or month, apply the simple calculation: opening cash, plus expected inflows, minus expected outflows, equals projected ending cash. That ending cash becomes the next period’s opening cash. Repeat the calculation across every period in your forecast.

Step 7: Find your lowest cash point

Don’t only look at the amount of cash you expect to have at the end of the month. Instead ask: when does my cash balance reach its lowest point? A business might end the month with healthy cash but still experience a dangerous shortage halfway through. That mid-period low, the trough, is where cash crises actually happen.

Step 8: Decide what you would do if cash drops too low

A forecast is only useful when it drives a decision. If your low point looks risky, your options include following up on customer payments, delaying non-essential spending, adjusting planned purchases, negotiating payment timing where appropriate, and arranging financing before an emergency rather than during one.

Step 9: Update your forecast as things change

Update the forecast whenever customers pay earlier or later, expenses change, new projects are confirmed, sales expectations shift, or unexpected costs appear. The goal isn’t to create a perfect forecast once. The goal is to keep improving your view as new information becomes available.

 

Cash flow forecast example

A small consulting firm starts March with $25,000 in the bank.

Item	Amount	Timing
Payroll	-$12,000	Week 1
Contractor payments	-$6,000	Week 1
Rent and software	-$4,000	Week 1
Customer payment (Project A)	+$18,000	Week 3
New project deposit	+$5,000	Week 4

Month-end projection: $26,000. Looks fine.

But look at the timing. After Week 1, the balance is $3,000. For nearly two weeks, the business is running on fumes. If the Week 3 customer payment slips by even five days, the firm can’t cover a surprise expense or an early supplier invoice.

That’s the insight a totals-only view hides. A forecast becomes useful when you look at when money moves, not just how much money moves.

 

How to read your forecast

Building the forecast is half the work. Reading it is the other half. Ask these five questions, every time you review it:

A forecast that doesn’t change a decision is just a spreadsheet exercise. The whole point is to connect projected numbers to real actions: chasing a receivable earlier, delaying a non-critical purchase, or starting a financing conversation before you’re desperate.

 

Common forecasting mistakes

Forecasting sales instead of cash collections. Revenue recognized on your income statement and cash in your bank account are different events, sometimes weeks apart.

Forgetting irregular expenses. Annual insurance, quarterly taxes, equipment maintenance. They don’t show up every month, so they get left out of the model until they hit.

Assuming every customer pays on time. Practitioner sources consistently flag this as the primary reason forecasts diverge from actuals. If your average collection runs past terms, model the actual behavior.

Only checking month-end balances. The mid-period trough is where cash crises live.

Never updating. A forecast built in January and never revised is useless by March. The recommendation across most guidance is to refresh monthly at minimum, or every two to three months for stable businesses.

Starting with inaccurate books. If your opening balance is wrong, every projection downstream is wrong. This is where bank reconciliation stops being a chore and starts being a prerequisite.

How accurate does a forecast need to be?

Not perfectly. A forecast is a tool for visibility, not prophecy. It needs to be realistic enough to flag genuine risks, updated frequently enough to reflect current conditions, and honest about which numbers are solid and which are speculative.

The goal is better decisions made earlier. If your forecast gives you two extra weeks to respond to a cash shortfall, it’s done its job, even if the specific numbers were off by 15%. Don’t spend hours trying to make every number perfect while ignoring the bigger picture. A simple forecast you update regularly is often more useful than a complex model you never touch again.

 

Cash flow forecast vs cash flow projection

You’ll see both terms used, and in everyday business conversation they’re generally used interchangeably to mean the same thing: an estimate of the cash you expect to move in and out over a future period. Some people reserve “projection” for longer-range or scenario-based estimates and “forecast” for the near-term rolling view, but that distinction isn’t standardized and isn’t worth overthinking. Whichever word you use, the discipline is the same: map expected inflows and outflows to when the money actually moves, rate your confidence, and update as reality changes.

 

Spreadsheet vs. accounting software

A spreadsheet works when your transaction volume is low, your business model is straightforward, and you’re comfortable maintaining the file manually. Plenty of businesses run perfectly good forecasts in Google Sheets. In short, a spreadsheet may be enough if your business is relatively simple, transactions are limited, you can maintain it regularly, and you understand your financial data.

The friction increases as financial activity gets more complex. When receivables and payables need active monitoring, when multiple people touch the finances, when bank data changes daily, manual updates start falling behind. Accounting software may help once transactions are increasing, you manage many invoices, customer payment timing matters, you need better visibility of receivables and expenses, or updating spreadsheets manually is becoming difficult. That’s the point where accounting software becomes less of a convenience and more of a reliability issue. The right approach depends on where your business sits on that spectrum.

 

How ProfitBooks can help you maintain better cash flow visibility

A forecast is only as good as the data behind it. The most common reason forecasts drift into fiction isn’t a flawed model, it’s stale or scattered financial records. ProfitBooks keeps that underlying information current, so the numbers you forecast from reflect where your business actually stands. The workflow looks like this:

ProfitBooks isn’t a crystal ball, and no tool removes the judgment a forecast requires. What it does is keep the inputs, your cash position, receivables, and payables, accurate and in one place, so you can spend your time on the decision rather than on chasing down the numbers. If you want to try it, ProfitBooks offers a free Startup plan.

 

Where practitioners disagree

There’s an ongoing split on whether small businesses should forecast using the direct method (projecting actual cash receipts and payments) or the indirect method (starting from net income and adjusting for non-cash items). Most small-business guidance, including sources like Fit Small Business and the SBA, defaults to the direct method because it maps more intuitively to how owners think about money. FP&A practitioners sometimes argue the indirect method catches accrual-timing issues the direct method misses. I’d side with direct for most small businesses. If you’re not sure what “adjusting for depreciation and changes in working capital” means, the indirect method will create more confusion than clarity.

 

Frequently asked questions

 

What to do next

Start with the next four weeks. Use your actual bank balance, not your accounting software’s revenue figure. List what’s coming in, list what’s going out, and note when each payment is expected to move. Find the lowest point. Ask yourself what you’d do if that low point dropped another 20%.

That’s a forecast. It doesn’t need to be elaborate. It needs to be current, honest about what’s uncertain, and connected to a decision you’re actually facing. Build the habit with a short horizon first. Complexity can come later, once the practice is already part of how you run the business.

A cash flow forecast isn’t about predicting the future perfectly. It’s about understanding what could happen early enough to make better decisions. Keep three principles in mind: focus on timing, be realistic about confidence, and update your forecast as reality changes. Start simple. Look at the cash you have today, the money you realistically expect to receive, and the payments you know are coming. Once you can see those three things clearly, you’re already in a much better position to manage your business cash flow.