Your business has been busy. Customers are placing orders, invoices are going out, and sales are looking better than they did a few months ago. You might even be considering hiring someone or investing in new equipment.
Then you look at your bank balance and wonder whether there's enough money to cover next month's expenses.
It's an uncomfortable position, especially when the business appears to be performing well. The problem often isn't a complete lack of income. It's that money doesn't always arrive when you need it, while rent, wages, supplier bills, and other financial commitments still have to be paid on time.
This is where a cash flow forecast becomes valuable. Rather than relying on today's bank balance or assuming that strong sales will cover everything, a cash flow forecast helps you estimate how much money your business will have available in the weeks and months ahead.
You don't need to be an accountant or financial analyst to prepare one. With accurate records, realistic assumptions, and a straightforward calculation, you can build a forecast that gives you a clearer picture of your business's financial future.
What Is a Cash Flow Forecast?
A cash flow forecast is an estimate of the money expected to enter and leave your business over a future period. It brings together anticipated customer payments, operating expenses, loan repayments, major purchases, and other cash movements to show how your available cash balance might change.
For example, suppose your business has $8,000 in the bank today. You expect customers to pay you $12,000 next month, but you also have $15,000 in expenses and other payments coming due.
Based on those estimates, your projected closing cash balance would be:
$8,000 + $12,000 − $15,000 = $5,000
If everything happens as expected, you'll finish the month with approximately $5,000 in cash.
But what if a customer delays a $4,000 payment until the following month? Suddenly, your projected closing balance drops to $1,000. Nothing necessarily changed about the value of the work you completed, but the timing of the payment changed how much cash you expect to have.
A forecast helps you recognize these possibilities before they turn into urgent financial problems.
Cash Flow Forecast vs. Cash Flow Statement
Although the names sound similar, these two financial tools serve different purposes.
A cash flow statement reports money that has already moved into and out of a business during a particular period. A cash flow forecast estimates what is expected to happen in the future.
Your historical records help you understand what happened. Your forecast uses that information, alongside known commitments and reasonable assumptions, to prepare for what may happen next.
It's also important not to confuse cash flow with profit. A business can recognize revenue from a sale before the customer pays, while some payments, such as loan principal repayments, reduce cash without being ordinary operating expenses in the profit calculation.
For a deeper explanation of that distinction, see Cash Flow vs. Profit: Why a Profitable Business Can Run Out of Money.
Why Does a Small Business Need a Cash Flow Forecast?
A cash flow forecast can be useful even when your business is small, profitable, or growing steadily. Its purpose isn't simply to predict whether you'll run out of money. It's to help you make decisions with a clearer understanding of your upcoming financial commitments.
Imagine that you're planning to buy a new piece of equipment. Your current bank balance suggests you can afford it, but you also have a substantial supplier payment and several invoices that customers haven't settled. Without looking ahead, you might make the purchase only to discover that there isn't enough cash left to cover everything else.
A forecast helps you consider the purchase alongside other expected transactions rather than evaluating it in isolation.
A well-maintained forecast can help you:
Identify periods when your available cash may be unusually low.
Plan for payroll, rent, supplier payments, and other recurring obligations.
Estimate when outstanding customer invoices are likely to be paid.
Prepare for seasonal changes in sales or expenses.
Evaluate whether major purchases can be made without disrupting operations.
Understand when additional financing or cash reserves might be needed.
Make more informed decisions about spending, growth, and payment arrangements.
You don't need to predict every future transaction perfectly. A useful forecast gives you enough visibility to make decisions before a potential shortage becomes a crisis.
How Far Ahead Should You Forecast Cash Flow?
There isn't one forecasting period that's appropriate for every business. The right timeframe depends on your payment cycles, operating costs, business activities, and how quickly your cash position can change.
For many small businesses, a monthly forecast covering the next six to twelve months is a practical starting point. It gives you a broader view of upcoming expenses, seasonal patterns, and periods when cash requirements may be higher than usual.
Businesses with tighter cash balances or significant short-term obligations may benefit from a weekly forecast.
| Forecast period | When it may be useful |
|---|---|
| 4 to 6 weeks | Managing immediate payment obligations and short-term cash concerns |
| 13 weeks | Monitoring cash availability across approximately one quarter |
| 6 months | Planning upcoming expenses, customer payments, and operating needs |
| 12 months | Reviewing seasonal patterns, major purchases, and longer-term financial plans |
You can also use more than one timeframe. For example, a business might maintain a rolling 13-week forecast for its immediate cash needs alongside a monthly twelve-month forecast for broader planning.
If you're preparing your first forecast, however, there's no need to make the process unnecessarily complicated. Start with a timeframe that fits your business, then expand it once you understand the information you need.
How to Prepare a Cash Flow Forecast: Step by Step
A basic cash flow forecast is built around three pieces of information: the cash you have available at the beginning of the period, the money you expect to receive, and the money you expect to pay out.
From there, you calculate how those movements affect your closing balance and carry that balance into the next period.
Let's work through the process.
Step 1: Determine Your Opening Cash Balance
Start by identifying how much cash your business has available at the beginning of the forecast period.
For a simple forecast, this may be the current balance of your business bank account, adjusted for any outstanding transactions or restrictions that affect what is genuinely available to spend.
If you operate multiple business accounts, you may need to consider balances across those accounts while making sure transfers between them aren't counted as new incoming cash.
You should also distinguish cash available for general operations from money reserved for specific obligations. For example, a business may have collected sales tax that will need to be remitted later. That money may be present in the bank account, but it shouldn't automatically be treated as available for discretionary spending.
Suppose your business begins the month with $8,000 in cash.
Your forecast starts with:
Opening cash balance = $8,000
That amount provides the starting point for calculating the effect of upcoming receipts and payments.
Step 2: Estimate When Money Will Come In
Next, list the money you reasonably expect to receive during the forecast period.
This may include payments from existing customer invoices, anticipated sales collected immediately, subscription payments, grants, loan proceeds, owner contributions, or other expected cash receipts.
The most important detail is when you expect the money to arrive, not simply when the sale takes place.
Suppose you send a customer a $3,000 invoice on the last day of January with payment terms of 30 days. If you expect the customer to pay in February, that $3,000 belongs in February's expected cash receipts, not January's.
But payment terms don't always reflect actual customer behaviour. If that customer consistently takes 45 days to pay, assuming payment will arrive exactly 30 days after invoicing may make your forecast overly optimistic.
When estimating receipts, consider:
Outstanding invoices and their expected payment dates.
Historical customer payment patterns.
Sales that are likely to be collected immediately.
Recurring customer payments and subscriptions.
Seasonal changes in demand.
Expected deposits, advances, or other contractual payments.
Financing or other cash receipts that are reasonably expected.
For uncertain sales, use assumptions you can explain. A confirmed customer payment due next week should not automatically be treated with the same level of confidence as a potential sale to someone who hasn't yet agreed to buy.
Step 3: Estimate Your Upcoming Cash Payments
Once you've estimated incoming cash, list the payments your business expects to make during the same period.
Start with regular commitments such as rent, wages, utilities, software subscriptions, insurance, and supplier payments. Then consider less frequent expenses, including equipment purchases, annual renewals, tax payments, loan repayments, and inventory orders.
It's particularly important to account for expenses that aren't paid every month. If your business pays $2,400 for an annual insurance policy in September, your cash flow forecast should generally show the $2,400 payment in September, rather than spreading it evenly across twelve months simply because the coverage lasts a year.
Common cash outflows include:
| Payment type | Examples |
|---|---|
| Operating expenses | Rent, utilities, subscriptions, advertising, and supplies |
| Employees and contractors | Wages, contractor payments, and related obligations |
| Inventory and materials | Supplier payments and stock purchases |
| Taxes | Applicable income tax, sales tax, and payroll-related payments |
| Financing | Loan principal and interest payments |
| Capital purchases | Equipment, vehicles, computers, and other assets |
| Owner payments | Owner withdrawals or distributions, where applicable |
Remember that a cash flow forecast records actual expected cash movements. A loan principal repayment, for example, reduces available cash even though the principal portion is not normally treated as an ordinary expense on the income statement.
Similarly, the purchase of a long-term business asset may have a substantial immediate cash impact even when its accounting cost is recognized over a longer period.
Step 4: Organize Your Forecast Into Periods
With your expected receipts and payments identified, organize them according to your chosen forecasting period.
For a monthly forecast, create a column for each month. For a weekly forecast, create a column for each week. Then organize your opening balance, incoming payments, outgoing payments, and projected closing balance into clearly labelled rows.
A simple monthly forecast might look like this:
| Forecast item | Month 1 | Month 2 | Month 3 |
|---|---|---|---|
| Opening cash balance | $5,000 | $6,500 | $5,300 |
| Expected cash receipts | $8,000 | $7,500 | $9,000 |
| Expected cash payments | $6,500 | $8,700 | $7,200 |
| Net cash flow | +$1,500 | −$1,200 | +$1,800 |
| Closing cash balance | $6,500 | $5,300 | $7,100 |
If your business has more complicated finances, you can add separate rows for customer payments, financing, payroll, inventory, tax payments, and other categories.
The goal is to make the forecast detailed enough to be useful without creating a system that's difficult to maintain.
Step 5: Calculate Your Net Cash Flow and Closing Balance
Once the expected figures have been entered, calculate the net cash movement for each period.
The first formula is:
Net cash flow = Total cash inflows − Total cash outflows
The second formula calculates how much cash is expected to remain:
Closing cash balance = Opening cash balance + Net cash flow
The closing balance from one period then becomes the opening balance for the next period, assuming the forecast covers the same cash accounts and no adjustments are required.
If your business starts with $8,000, expects $12,500 in cash receipts, and plans to pay $10,400 during the month, the calculation would be:
Net cash flow = $12,500 − $10,400 = $2,100
Closing cash balance = $8,000 + $2,100 = $10,100
You would then carry the $10,100 closing balance into the next month's opening balance.
This calculation is the foundation of a simple cash flow forecast. Once you understand it, you can extend the process across several months or weeks.
Step 6: Review Your Results and Identify Potential Shortages
After calculating the closing balance for each period, look for months or weeks when cash is expected to become unusually low.
A positive closing balance doesn't automatically mean your business has plenty of money available. If your forecast shows that you'll end a month with $1,000 but have $8,000 in payments due during the first few days of the following month, you may still have a cash flow problem.
You should also consider how much of your forecast depends on payments arriving exactly when expected.
A cash flow forecast is particularly useful when it highlights the difference between what your business can comfortably afford and what it could afford only if every customer pays on time.
A Practical Three-Month Cash Flow Forecast Example
Let's look at a more complete example showing how cash flow forecasting can influence real business decisions.
Meet Aisha, a Small Business Owner
Aisha operates a small custom packaging business. She supplies printed boxes, labels, and packaging materials to independent retailers and online sellers.
Her business has been receiving a steady stream of customer orders, but payments don't always arrive immediately. Some customers pay deposits when ordering, while others pay after delivery. Meanwhile, Aisha has to purchase materials, cover everyday operating expenses, and occasionally invest in equipment.
She wants to know whether she can comfortably meet her financial obligations over the next three months.
Her opening cash balance is $8,000.
Based on outstanding invoices, expected customer payments, supplier commitments, and planned expenses, she prepares the following forecast.
Aisha's Three-Month Cash Flow Forecast
All amounts are illustrative and expressed in dollars.
| Cash flow item | Month 1 | Month 2 | Month 3 |
|---|---|---|---|
| Opening cash balance | $8,000 | $10,100 | $1,200 |
| Expected cash receipts | $12,500 | $6,100 | $16,000 |
| Expected cash payments | ($10,400) | ($15,000) | ($9,300) |
| Net cash flow | +$2,100 | −$8,900 | +$6,700 |
| Closing cash balance | $10,100 | $1,200 | $7,900 |
The numbers reveal something that wouldn't necessarily be obvious from Aisha's sales figures alone.
Month 1: Cash Increases
Aisha begins with $8,000 and expects to collect $12,500 from customers. After paying $10,400 in business expenses and other cash obligations, she's projected to finish the month with $10,100.
Her cash position appears relatively comfortable, but that doesn't mean she can spend the additional money without considering the months ahead.
Month 2: Cash Becomes Tight
In Month 2, Aisha expects to receive only $6,100 while paying out $15,000. The unusually high payments include a planned equipment purchase alongside her normal operating and supplier costs.
Her net cash flow for that month is negative $8,900, which reduces her projected closing balance to just $1,200.
This doesn't necessarily mean her business is unprofitable. It means the timing of expected receipts and payments will substantially reduce the cash available to her.
Although she technically finishes the month with a positive projected balance, she may have very little room for delayed customer payments, unexpected expenses, or other changes.
Month 3: Cash Recovers
Aisha expects customer payments to increase to $16,000 in Month 3, while outgoing payments fall to $9,300.
This creates positive net cash flow of $6,700 and raises her projected closing balance to $7,900.
Without a forecast, she might look at her first month's strong bank balance and assume the business can comfortably afford additional spending. The forecast shows that Month 2 is much more vulnerable than Month 1 or Month 3.
That information gives her an opportunity to reconsider the timing of her equipment purchase, review expected customer payments, or arrange additional liquidity before cash becomes tight.
What Happens If a Customer Pays Late?
A useful forecast shouldn't assume that everything will happen exactly as planned.
Suppose Aisha expects to collect $4,500 from a customer during Month 2, but the customer informs her that payment will be delayed until Month 3.
Nothing has necessarily changed about the amount the customer owes. However, the delay significantly changes when the business will have access to that money.
Let's compare the original forecast with the delayed-payment scenario.
| Forecast item | Original Month 2 | Delayed-payment Month 2 |
|---|---|---|
| Opening cash balance | $10,100 | $10,100 |
| Expected cash receipts | $6,100 | $1,600 |
| Expected cash payments | ($15,000) | ($15,000) |
| Projected closing balance | $1,200 | −$3,300 |
Instead of finishing Month 2 with $1,200, Aisha now faces a projected cash shortfall of $3,300.
A negative forecast balance doesn't mean her bank account can necessarily operate below zero. It indicates that, under those assumptions, her expected cash resources aren't sufficient to cover all scheduled payments without another source of funds or a change in timing.
If the delayed $4,500 arrives during Month 3 and everything else happens as originally forecast, the projected Month 3 closing balance returns to $7,900. But that eventual recovery doesn't solve the immediate problem in Month 2.
This is the distinction that makes cash flow forecasting so useful. A business can expect enough money over a three-month period and still be unable to make a payment when it's due.
What Could Aisha Do About the Shortfall?
Because Aisha identified the possible shortage in advance, she has time to consider several options.
She might follow up with the customer about the outstanding payment, review whether the equipment purchase can be postponed, or discuss appropriate payment arrangements with a supplier. If the business regularly experiences similar timing gaps, she may also need to consider a suitable cash reserve or financing arrangement.
Each option has consequences. Delaying equipment could affect production, extending supplier payments may not be acceptable under existing terms, and borrowing introduces additional costs and obligations.
The purpose of the forecast isn't to suggest that every shortfall has an easy solution. It's to give Aisha enough warning to evaluate her choices before the business is forced into a rushed decision.
How to Make Your Cash Flow Forecast More Accurate
A cash flow forecast is based on estimates, so it will rarely match reality perfectly. That's normal. What matters is using reasonable assumptions, updating them as new information becomes available, and learning from the differences between what you expected and what actually happened.
Use Customer Payment History, Not Just Invoice Terms
If your invoices are due within 30 days but customers typically pay after 45 days, your forecast should reflect that pattern.
Using the invoice due date without considering actual payment behaviour can cause you to overestimate how much cash will be available.
The same principle applies to recurring customers. A history of consistent payments may support a more confident estimate than a potential sale to a customer who hasn't yet committed.
Account for Seasonal Changes
Some businesses earn more during particular months or seasons. A retailer might experience higher sales during holiday periods, while a landscaping business could see substantial changes in revenue and operating costs throughout the year.
Using the same expected sales figure every month may produce an unrealistic forecast.
Historical records can help you identify seasonal patterns, although you should also consider changes in pricing, customer demand, and business activity that may make the coming year different.
Include Irregular and One-Time Payments
Annual insurance premiums, equipment replacements, tax remittances, software renewals, inventory purchases, and loan repayments can create significant movements in cash.
These payments are easy to overlook when you're focused on everyday operating expenses.
Review your financial records and upcoming commitments to identify amounts that might not appear in a typical month.
Be Consistent When Handling Sales Taxes
If you collect sales taxes or similar amounts on behalf of tax authorities, make sure your forecast accounts for those receipts and subsequent remittances consistently.
For example, if customer receipts are forecast including sales tax, your outgoing cash estimates should also account for expected tax remittances at the appropriate time. Avoid mixing figures that include sales tax with others that exclude it without understanding the effect on your projected cash balance.
The applicable treatment depends on your jurisdiction, tax obligations, and accounting records.
Keep Confirmed and Uncertain Receipts Distinct
A signed contract or approved invoice doesn't always guarantee the payment will arrive on a particular day. Similarly, a promising sales conversation isn't the same as an agreed customer order.
Consider distinguishing confirmed or highly probable cash receipts from those that remain uncertain. This helps you understand how much of your projected balance depends on expectations that may change.
For major decisions, it may be useful to prepare a forecast that excludes uncertain receipts altogether.
How to Prepare Best-Case and Worst-Case Cash Flow Scenarios
A single forecast shows one possible outcome based on your current assumptions. But because customer payments, sales, and expenses can change, it's often useful to consider more than one scenario.
You don't need to build a complicated financial model to do this. Start with your normal forecast, then adjust a few of the assumptions most likely to affect your business.
| Scenario | Assumptions |
|---|---|
| Best case | Customers pay promptly, expected sales are strong, and major costs remain under control |
| Base case | Sales, payment timing, and expenses follow your most reasonable current estimates |
| Worst case | Some customer payments are delayed, sales are weaker, or unexpected costs arise |
For example, Aisha's base forecast assumes that customers will pay $6,100 during Month 2. Her more cautious scenario could account for the possibility that the $4,500 customer payment is delayed.
By comparing the results, she can see how sensitive her business is to that particular payment. If one delayed invoice creates a large funding gap, she may need stronger cash reserves or a more cautious approach to spending.
Scenario planning doesn't mean constantly expecting the worst. It means recognizing where your finances are vulnerable and making decisions with those risks in mind.
How Often Should You Update a Cash Flow Forecast?
A forecast becomes less useful when it's prepared once and never reviewed again.
Customer payment dates change, new expenses arise, and some expected sales never happen. As these changes occur, your original estimates gradually become less reliable.
For many small businesses, reviewing a monthly forecast at least once a month is a reasonable starting point. If your cash position is tight, your transactions are changing rapidly, or your business has significant upcoming commitments, weekly updates may be more appropriate.
A rolling forecast can be particularly useful. Instead of allowing your forecast period to shrink as time passes, you add another period whenever one is completed. For example, a rolling 13-week forecast continues looking approximately 13 weeks ahead as each week ends.
Compare Forecasted Cash Flow With Actual Results
One of the best ways to improve forecasting is to compare what you expected with what actually happened.
Suppose you forecast customer receipts of $12,000 for a month, but your business collected only $9,500. Rather than simply changing the number, investigate the reason for the $2,500 difference.
Were customers late? Did sales decline? Was a payment expected in the wrong month? Or did the business fail to collect an amount that was already overdue?
The answer can help you prepare more realistic forecasts in future periods.
| Forecast item | Expected | Actual | Difference |
|---|---|---|---|
| Customer receipts | $12,000 | $9,500 | −$2,500 |
| Cash payments | $8,000 | $8,700 | +$700 spent |
| Net cash flow | +$4,000 | +$800 | −$3,200 |
In this example, the business expected its available cash to increase by $4,000, but the actual increase was only $800.
That difference matters. If the owner had already committed to spending the expected $4,000 increase, the business might now have less flexibility than anticipated.
Regular comparisons help you identify forecasting mistakes, improve your assumptions, and respond more quickly when financial conditions change.
Can You Prepare a Cash Flow Forecast Without Historical Records?
Yes. A new business may not have previous sales figures, customer payment history, or several months of operating expenses to use as a starting point.
In that situation, you'll need to rely more heavily on business plans, supplier quotations, confirmed contracts, expected customer demand, and realistic operating cost estimates.
For example, a new online retailer might estimate incoming cash based on expected order volumes and average purchase values. Outgoing cash might include website costs, inventory purchases, shipping materials, advertising, and payment processing fees.
Because the assumptions are less certain, it is particularly important to document them and revisit them frequently.
As real sales and expenses begin to occur, replace your initial estimates with actual information. Over time, your forecasts should become more useful because they'll be informed by the business's own operating experience.
If you're still establishing your recordkeeping system, Bookkeeping for Beginners: A Practical Guide to Managing Business Finances can help you understand how to organize the financial information that supports your forecast.
Should You Use a Spreadsheet or Financial Software?
You don't necessarily need specialized forecasting software to build a useful cash flow projection. A well-designed spreadsheet can be sufficient for a small business with relatively straightforward finances.
At minimum, your forecasting tool should allow you to record opening cash balances, expected receipts, anticipated payments, and closing balances for each period. It should also make it easy to update estimates and compare projected figures with actual results.
Spreadsheets offer flexibility, but they require careful maintenance. Incorrect formulas, missing transactions, and outdated assumptions can make a forecast misleading.
Financial software may help organize transaction records and reduce some manual work, depending on the features available. However, no tool can reliably predict every customer payment or unexpected expense without appropriate information and human review.
For businesses managing larger transaction volumes, multiple bank accounts, inventory, or complicated financing arrangements, additional reporting tools or professional accounting support may be worthwhile.
The best system is one that produces understandable information and is practical enough to update regularly.
Common Cash Flow Forecasting Mistakes to Avoid
Even a carefully prepared forecast can become misleading if it relies on unrealistic assumptions or leaves out important cash movements.
1. Recording Sales Instead of Expected Payments
A sale doesn't always result in immediate cash. If customers pay on credit, record the cash receipt in the period when payment is realistically expected.
2. Forgetting Large or Irregular Expenses
Annual renewals, tax payments, equipment purchases, and seasonal inventory orders can significantly affect available cash. Include them in the periods when payment is expected.
3. Assuming Every Customer Will Pay on Time
Use actual customer payment patterns where available. Consider alternative scenarios when your forecast depends heavily on one or two large invoices.
4. Confusing Profit With Available Cash
Profit and cash flow measure different things. A profitable business may still face payment difficulties when money arrives later than its obligations fall due.
5. Ignoring Cash Shortages Within a Month
A positive month-end balance doesn't guarantee that every payment due during the month can be covered. Use shorter forecasting periods when cash timing is important.
6. Treating Borrowed Money as Sales Revenue
Loan proceeds may increase available cash, but they aren't ordinary sales revenue. Record financing separately and include the expected repayment obligations.
7. Preparing the Forecast Once and Forgetting It
A forecast needs regular review. As customer payments, expenses, and business plans change, update your projections so they continue to reflect your best available information.
Use Your Forecast to Make Better Business Decisions
A cash flow forecast is most valuable when you use it to make decisions, not simply when you finish filling in the numbers.
Perhaps you're considering hiring another employee, expanding your product range, investing in equipment, or accepting a large order that requires significant spending before the customer pays. A forecast can help you evaluate how those decisions may affect the money available to operate your business.
It can also help you identify when you need to improve payment collection. If unpaid customer invoices are creating pressure on your cash balance, reviewing How to Follow Up on Unpaid Invoices Without Losing Clients may be a useful next step.
The forecast won't tell you exactly what to do in every situation. Instead, it helps you see the financial consequences of different choices before you commit to them.
That's an important advantage for any business owner making decisions with limited time and resources.
Plan for the Cash You Will Need, Not Just the Sales You Expect
It's encouraging to see sales growing and customers showing interest in your business. But a strong sales pipeline doesn't always mean you'll have enough money available to cover your next round of expenses.
A cash flow forecast brings those two sides of the business together. It helps you look beyond current sales figures and bank balances to understand when money is expected to arrive, when payments must be made, and where financial pressure might develop.
Start with a realistic opening balance, estimate your expected cash receipts and payments, and calculate the closing balance for each period. Then review the results, test important assumptions, and update the forecast as circumstances change.
You don't need a perfect prediction of the future. You need enough visibility to recognize potential problems early and make better decisions while you still have options.
