Running out of cash is one of the most common reasons small businesses fail, even when they’re profitable on paper. A cash flow forecast gives you a forward-looking view of when money will actually hit your bank account and when it will leave, so you can spot shortfalls before they become emergencies.

Building a forecast doesn’t require an accounting degree, but it does require discipline and honest assumptions. Here’s a practical, step-by-step approach you can start using this week.

Why Cash Flow Forecasting Matters

A profit and loss statement tells you whether your business is making money over a period. It says nothing about timing. You might close a large sale in January but not collect payment until March, while rent, payroll, and supplier invoices are due every month in between. A cash flow forecast bridges that gap by mapping out actual cash movements week by week or month by month.

Forecasting also gives you lead time. If you can see a cash crunch coming six weeks out, you have options: delay a purchase, negotiate payment terms, or draw on a line of credit. If you only discover the shortfall the day payroll is due, your options shrink dramatically.

Gather Your Historical Data

Start with at least 12 months of bank statements and, if available, your accounting software’s cash reports. You’re looking for patterns: which months are typically strong, which are slow, and how long it actually takes customers to pay versus your stated terms.

Pull together these inputs before you start projecting forward:

1. Historical revenue by month, broken out by product or service line if possible
2. Average days sales outstanding (how long invoices actually take to get paid)
3. Recurring fixed costs: rent, insurance, loan payments, subscriptions
4. Variable costs tied to sales volume: materials, commissions, shipping
5. Known one-time items: tax payments, equipment purchases, seasonal inventory buys

Build the Forecast Structure

Most small businesses do well with a rolling monthly forecast covering 12 to 13 months, though businesses with tight margins or seasonal swings often move to a weekly format (more on that in a related approach called a 13-week forecast). Structure your spreadsheet with three sections: beginning cash balance, cash inflows, and cash outflows, ending in a calculated closing balance that rolls into the next period.

Line Item	Jan	Feb	Mar
Beginning Cash	$12,000	$9,400	$14,200
Cash Inflows	$28,000	$31,500	$26,000
Cash Outflows	$30,600	$26,700	$29,800
Ending Cash	$9,400	$14,200	$10,400

The ending cash balance for one month becomes the beginning balance for the next. This simple chain is what reveals whether you’re building a cushion or slowly draining one.

Project Inflows Realistically

Don’t just spread annual revenue evenly across 12 months. Base your inflow projections on actual collection patterns, not invoice dates. If a customer segment typically pays 45 days after invoicing, reflect that lag in your forecast rather than assuming payment arrives the moment you bill.

For recurring revenue businesses, project based on your subscriber or contract base plus expected churn and new signups. For project-based businesses, map each pipeline deal to an expected close date and payment date separately, since these are rarely the same.

Project Outflows With Equal Care

Outflows are usually easier to predict than inflows because many are contractual and fixed. Still, don’t overlook irregular expenses like quarterly tax estimates, annual insurance renewals, or equipment maintenance. A common mistake is forecasting only the “usual” monthly bills and getting blindsided by a predictable but infrequent expense.

• List every recurring outflow with its exact due date, not just the month
• Add a line for irregular but known expenses (taxes, renewals, bonuses)
• Include a contingency buffer of 5% to 10% of outflows for unplanned costs

Stress-Test Your Assumptions

Once you have a baseline forecast, build two variations: a conservative case where sales come in 15% to 20% lower and collections slow down, and an optimistic case where growth accelerates. Reviewing all three side by side shows you the range of outcomes and helps you decide how large a cash cushion or credit line you actually need.

Update It Regularly

A forecast is only useful if you keep it current. Compare actual results to your projections every month and adjust future months based on what you learn. Businesses that review their forecast monthly catch cash flow problems an average of one to two months earlier than those that only look at cash flow reactively.

Frequently Asked Questions

How far ahead should a small business forecast cash flow?

Most businesses should maintain a rolling 12-month forecast for strategic planning, supplemented by a more detailed weekly or 13-week forecast when cash is tight or growth is fast.

What’s the difference between a cash flow forecast and a budget?

A budget is a planned target for revenue and expenses over a period. A cash flow forecast tracks the actual timing of cash moving in and out, which can differ significantly from budgeted figures due to payment timing.

How accurate should my forecast be?

Aim for directional accuracy rather than perfection. A forecast that correctly identifies you’ll be tight on cash in March, even if the exact number is off by 10%, is far more valuable than no forecast at all.

What tools can I use to build a cash flow forecast?

A spreadsheet works fine for most small businesses starting out. As complexity grows, dedicated cash flow software that connects to your accounting system can automate data pulls and reduce manual errors.

Final Thoughts

Cash flow forecasting turns financial uncertainty into a manageable, visible process. Start simple, base your projections on real historical patterns rather than hopeful assumptions, and revisit the forecast often enough that it stays a living tool rather than a one-time exercise. The businesses that survive tight periods are usually the ones that saw them coming.