A business can be profitable on paper and still run short of cash.
The reason is simple: sales, expenses, invoices, and cash do not always move at the same time. You may make a sale today but collect the money next month. You may also need to pay payroll, rent, suppliers, taxes, or inventory before that cash arrives.
A cash flow forecast helps you estimate when money is expected to come into and leave your business so you can identify potential cash shortages before they happen.
In this guide, you will learn how to calculate and interpret cash flow, build a 12-month forecast, and use two free Excel templates designed for small businesses.
Table of Contents
- What Is a Cash Flow Forecast?
- Cash Flow Forecast vs. Monthly Cash Flow Tracking
- Free Cash Flow Templates for Small Business
- How to Calculate Cash Flow
- How to Build a 12-Month Cash Flow Forecast
- 12-Month Cash Flow Forecast Example
- How to Interpret Your Cash Flow Forecast
- How to Use Conservative, Base and Optimistic Scenarios
- Common Cash Flow Forecasting Mistakes
- Cash Flow vs. Profit
- A Simple Monthly Cash Flow Review
- Download the Free Excel Cash Flow Templates
- Frequently Asked Questions
What Is a Cash Flow Forecast?
A cash flow forecast is an estimate of the money you expect to receive and pay during a future period.
It focuses on cash timing, not only on sales or accounting expenses.
For example, imagine your business makes a $5,000 credit sale in March, but the customer will not pay until May.
For your cash flow forecast, that $5,000 should normally appear as a May cash inflow, because May is when you expect the money to reach your business.
A forecast usually considers:
- beginning cash balance;
- expected cash inflows;
- expected cash outflows;
- net cash flow;
- ending cash balance;
- upcoming taxes, debt payments, purchases, or investments.
The objective is not to predict the future perfectly. It is to identify periods when your business may have enough cash, limited cash, or a potential deficit.
Cash Flow Forecast vs. Monthly Cash Flow Tracking
These two concepts are related, but they answer different questions.
Monthly cash flow tracking asks:
What cash actually came in and went out?
Cash flow forecasting asks:
What cash do I expect to come in and go out over the next few months?
If you want to reconcile what already happened, you need a monthly cash flow spreadsheet. If you want to determine whether you may have enough cash to cover future payments, you need a cash flow forecast.
For many small businesses, using both provides a more complete view: actual results help improve future forecasts.
Free Cash Flow Templates for Small Business
This guide includes two Excel files with different purposes.
1. 12-Month Cash Flow Forecast Template
Use this template when you want to plan cash availability over the next 12 months.
The workbook lets you estimate:
- collected sales;
- collections from credit sales;
- other operating income;
- owner contributions;
- loan proceeds;
- inventory and purchasing payments;
- payroll;
- rent;
- utilities;
- marketing;
- logistics;
- taxes;
- maintenance;
- fees and interest;
- debt payments;
- capital expenditures;
- other cash inflows and outflows.
It automatically calculates Total Cash Inflows, Total Cash Outflows, Net Cash Flow, Beginning Cash Balance, Ending Cash Balance, Difference vs. Minimum Reserve, and Monthly Status.
The workbook can classify each month as:
- Adequate: projected cash is at or above your minimum reserve.
- Below Reserve: projected cash remains positive but falls below the safety level you defined.
- Deficit: projected ending cash is negative.
It also includes Conservative, Base, and Optimistic annual scenarios to help you evaluate how changes in operating inflows and selected variable costs could affect your cash position.
2. Monthly Cash Flow Spreadsheet
Use the monthly spreadsheet when your objective is to record actual cash received and paid.
It includes:
- transaction date;
- description;
- category;
- inflow or outflow;
- payment method;
- amount;
- reference;
- notes.
The spreadsheet automatically calculates your monthly cash inflows, cash outflows, net cash flow, and ending cash balance.
Which Template Should You Use?
Use the Monthly Cash Flow Spreadsheet if you want to understand what already happened.
Use the 12-Month Cash Flow Forecast if you want to anticipate what may happen.
A practical workflow is:
- Record actual cash activity during the month.
- Review the results at month-end.
- Compare actual results with your forecast.
- Update the remaining months using better information.
If you first need to organize business income and expenses rather than cash timing, use our Small Business Income and Expense Spreadsheet.
How to Calculate Cash Flow
The basic calculation is:
Net Cash Flow = Cash Inflows − Cash Outflows
Then:
Ending Cash Balance = Beginning Cash Balance + Net Cash Flow
For example:
- Beginning Cash Balance: $4,000
- Cash Inflows: $12,850
- Cash Outflows: $12,130
Net Cash Flow:
$12,850 − $12,130 = $720
Ending Cash Balance:
$4,000 + $720 = $4,720
The business generated cash during the month, but that does not automatically mean its liquidity position is comfortable.
If the business wants to maintain a minimum cash reserve of $5,000, the projected ending balance of $4,720 would still be $280 below its desired reserve.
That additional comparison makes the forecast more useful for decision-making.
How to Build a 12-Month Cash Flow Forecast
A useful forecast should reflect when cash is expected to move, not simply when sales or expenses are recorded.
1. Start With Your Beginning Cash Balance
Enter the cash you expect to have available at the beginning of the forecast.
This may include money available in business bank accounts and cash that can actually be used for operations.
Avoid using sales, accounts receivable, or inventory as if they were available cash.
2. Estimate When You Will Collect Sales
Estimate cash receipts month by month.
For cash sales, timing may be relatively straightforward. For credit sales, focus on the month when customers are expected to pay.
For example:
- March sale: $8,000
- Expected collection: May
The forecast should normally include that $8,000 in May, not March.
3. Add Other Expected Cash Inflows
Your business may also receive cash from:
- additional operating income;
- owner contributions;
- loans;
- other non-sales sources.
Keep these separate from sales. A bank loan improves your cash position when received, but it is not operating revenue and creates future repayment obligations.
4. Forecast Cash Outflows
Estimate when you expect to make payments for:
- inventory and supplies;
- payroll;
- rent;
- utilities;
- marketing;
- logistics;
- taxes;
- maintenance;
- bank fees and interest;
- debt;
- equipment and other investments.
Again, timing matters. If a supplier invoice is received in April but will be paid in May, the forecast should normally reflect the cash outflow in May.
5. Calculate Monthly Net Cash Flow
For every month:
Cash Inflows − Cash Outflows = Net Cash Flow
A positive value means the month generates cash. A negative value means the month uses cash.
A negative month is not automatically a crisis. A business may deliberately use cash for inventory, equipment, taxes, expansion, or other planned expenses. The key question is whether enough cash remains afterward.
6. Calculate the Ending Cash Balance
Add net cash flow to the beginning cash balance.
The ending cash balance of one month becomes the beginning balance of the next month. This creates a continuous 12-month view of liquidity.
7. Set a Minimum Cash Reserve
A minimum cash reserve gives you an additional reference point.
Suppose you want to maintain at least $5,000 in available cash.
- Ending Cash Balance: $7,500 → Adequate
- Ending Cash Balance: $4,200 → Below Reserve
- Ending Cash Balance: -$1,000 → Deficit
This makes it easier to identify cash pressure before the balance reaches zero.
12-Month Cash Flow Forecast Example
Consider a small retail business beginning the year with a Beginning Cash Balance of $4,000.
In January, it forecasts:
- Collected Sales: $11,000
- Collections from Credit Sales: $1,600
- Other Operating Income: $250
Total Cash Inflows: $12,850
Expected January cash payments include:
- Inventory / Purchases: $5,600
- Payroll: $3,200
- Rent: $1,500
- Utilities: $450
- Marketing: $350
- Logistics: $500
- Maintenance: $150
- Fees & Interest: $180
- Other Cash Outflows: $200
Total Cash Outflows: $12,130
Net Cash Flow: $720
Ending Cash Balance: $4,720
If the business has selected a minimum reserve of $5,000, January would be classified as Below Reserve.
The business still has positive cash, but the forecast is signaling that its liquidity margin is smaller than desired. That is more actionable than simply knowing that January produced positive cash flow.
How to Interpret Your Cash Flow Forecast
Do not evaluate the forecast only by asking whether net cash flow is positive. Look at the entire cash position.
Adequate
An Adequate month means the projected ending cash balance is equal to or greater than your minimum reserve.
This suggests that the business remains above the cash safety level you selected. It does not mean every financial indicator is healthy, but immediate liquidity pressure is lower.
Below Reserve
A Below Reserve month means the ending cash balance remains positive, but cash falls below your selected minimum reserve.
This is an early warning. Consider reviewing:
- customer collection dates;
- supplier payment terms;
- inventory purchases;
- discretionary spending;
- timing of investments;
- upcoming taxes;
- financing requirements.
Deficit
A Deficit means projected ending cash is negative.
If the forecast is realistic, the business may not have enough cash to cover all expected payments during that period.
Possible responses include:
- accelerating collections;
- postponing non-essential purchases;
- renegotiating payment terms;
- reducing discretionary expenses;
- adjusting inventory purchases;
- changing the timing of investments;
- evaluating financing before the shortage occurs.
The purpose of forecasting is to identify these situations early enough to have options.
How to Use Conservative, Base and Optimistic Scenarios
A single forecast is useful, but business conditions rarely develop exactly as expected.
Scenario analysis helps you test how sensitive your cash position is to changes in assumptions.
Base Scenario
The Base scenario represents your current forecast. It should reflect what you currently consider the most reasonable assumptions.
Conservative Scenario
A Conservative scenario can model weaker operating cash inflows or different variable-cost assumptions.
Its purpose is to answer:
What happens to our cash position if operating performance is weaker than expected?
Optimistic Scenario
An Optimistic scenario evaluates stronger operating performance while recognizing that some variable costs may also increase.
It can help answer:
If sales and collections improve, how much additional cash could the business generate?
The free 12-month workbook includes all three scenarios as an annual sensitivity analysis. The monthly Base forecast should still remain your primary planning reference.
Common Cash Flow Forecasting Mistakes
Forecasting Sales Instead of Cash Collections
A sale does not create cash until the customer pays. If your business sells on credit, use expected collection dates.
Ignoring Irregular Payments
Taxes, annual subscriptions, equipment purchases, bonuses, maintenance, and debt payments can create large cash outflows. Include them in the month when payment is expected.
Treating Loans as Sales
Loans increase cash but are not sales revenue. Keep financing inflows separate so you can understand how much cash is being generated by operations.
Forgetting the Beginning Cash Balance
Net cash flow tells you what happened during the month. Ending cash balance tells you what you actually expect to have available. Both matter.
Assuming Positive Cash Flow Means There Is No Risk
A month may generate positive net cash flow but still finish below the minimum cash reserve. That is why reviewing the ending balance is essential.
Never Updating the Forecast
A forecast made once and ignored quickly loses value.
Update it when:
- customer payment timing changes;
- sales expectations change;
- major purchases are approved;
- tax obligations change;
- financing is obtained;
- inventory plans change;
- actual results differ materially from assumptions.
Cash Flow vs. Profit: What Is the Difference?
Profit and cash flow measure different things.
Profit is based on revenue and expenses recognized during a period.
Cash flow focuses on money actually received and paid.
For example, a business can make a profitable credit sale today without receiving the cash immediately. It can therefore report profit while still experiencing cash pressure.
The opposite can also happen. Receiving a loan increases cash, but the loan itself does not create profit.
For this reason, a cash flow forecast does not replace your income statement or accounting records. It complements them by focusing specifically on liquidity.
A Simple Monthly Cash Flow Review
At the end of each month:
- Compare actual cash inflows with your forecast.
- Compare actual cash outflows with your forecast.
- Identify the largest differences.
- Replace the completed month with actual results when appropriate.
- Update expected collections and payments for future months.
- Review the lowest projected cash balance.
- Check whether any month is Below Reserve or in Deficit.
- Adjust decisions before the cash problem occurs.
The objective is not forecasting precision for its own sake. The objective is better timing and better decisions.
Download the Free Excel Cash Flow Templates
Free 12-Month Cash Flow Forecast Template
Use this workbook to forecast monthly cash inflows and outflows, calculate ending balances, define a minimum cash reserve, identify potential deficits, and compare three annual scenarios.
Free Monthly Cash Flow Spreadsheet
Use this workbook to record actual cash received and paid during the month and calculate your current cash position.
If you want to organize income and expenses before moving into cash flow planning, start with the free Small Business Income and Expense Spreadsheet.
Frequently Asked Questions
What is a cash flow forecast?
A cash flow forecast estimates future cash inflows, cash outflows, and cash balances over a selected period. It helps a business anticipate whether enough cash may be available to cover upcoming payments.
How far ahead should a small business forecast cash flow?
The appropriate period depends on the business. A 12-month forecast is useful for medium-term planning, while a shorter weekly or monthly view may be more appropriate when cash conditions change quickly.
What is the difference between a cash flow forecast and a cash flow statement?
A cash flow forecast looks forward and uses estimates. A cash flow statement reports cash flows from a completed period using actual financial information.
What should be included in a cash flow forecast?
At minimum, include:
- beginning cash;
- expected cash receipts;
- expected cash payments;
- net cash flow;
- ending cash balance.
You can also include a minimum cash reserve, financing, investments, taxes, and scenario assumptions when they are relevant to your business.
What happens if my cash flow forecast is negative?
A negative projected ending cash balance indicates a potential cash shortage. Review collection timing, inventory purchases, expenses, taxes, investments, payment terms, and financing options before the projected shortage occurs.
Is cash flow the same as profit?
No. Profit measures the financial result of revenue and expenses. Cash flow measures the movement and availability of cash. A profitable business can still experience a cash shortage if money is collected later than payments are due.
How often should I update my cash flow forecast?
Review it at least monthly for ongoing planning. Businesses with tight liquidity, rapid growth, seasonal demand, or frequent cash movements may benefit from updating it more often.
Discover more from
Subscribe to get the latest posts sent to your email.
