A monthly cash flow forecast gives a small business a practical view of what may be available for bills, payroll, taxes, and planned spending. This guide provides a repeatable cash flow forecast template, explains the assumptions behind it, and shows how to compare best-, base-, and worst-case scenarios without confusing cash movement with accounting profit.
Overview
A cash flow forecast estimates when money is expected to enter and leave the business. Unlike a profit and loss statement, which records revenue and expenses according to accounting rules, a forecast focuses on the timing of actual cash receipts and payments. That timing is what determines whether the business can meet its obligations next week or next month.
A useful monthly small business cash flow forecast template should answer four questions:
- How much cash is available at the start of the period?
- Which customer payments are likely to arrive, and when?
- Which bills, payroll costs, taxes, and one-time expenses must be paid?
- What will the expected closing balance be under different scenarios?
The basic calculation is:
Closing cash = opening cash + total cash inflows - total cash outflows
For a more useful rolling forecast, prepare the calculation by week within the month or by month across several months. Weekly detail can reveal a short-term gap that a monthly total would hide. A monthly view is often easier for planning larger decisions such as hiring, purchasing equipment, or delaying a discretionary expense.
This forecast is a planning tool, not a substitute for bookkeeping, tax advice, or financial statements. Its value comes from using consistent assumptions, recording actual results, and updating it regularly.
How to estimate
Start with a spreadsheet containing one column for each week or month in the forecast period. Add a separate column for notes so each estimate can be traced to an invoice, contract, bill, payroll schedule, or management decision.
Use the following spreadsheet-ready structure:
| Forecast line | Period 1 | Period 2 | Period 3 | Notes |
|---|---|---|---|---|
| Opening cash balance | Prior period closing balance | |||
| Customer payments | Invoice, customer, expected payment date | |||
| Other cash receipts | Refunds, financing, grants, or owner funds if applicable | |||
| Total cash inflows | Customer payments plus other receipts | |||
| Supplier and operating bills | Use payment dates, not only invoice dates | |||
| Payroll and related costs | Include the full expected cash payment | |||
| Taxes and statutory payments | Use applicable schedules and confirmed assumptions | |||
| One-time expenses | Equipment, repairs, deposits, or planned purchases | |||
| Total cash outflows | Sum of all expected payments | |||
| Net cash movement | Inflows minus outflows | |||
| Closing cash balance | Opening cash plus net movement |
For each customer invoice, estimate the date cash will actually arrive rather than automatically using the invoice date. Separate invoices that are contracted and due from sales that are merely possible. This distinction makes the forecast more useful for decisions where a shortfall would be costly.
Next, list recurring outflows such as rent, subscriptions, loan payments, utilities, supplier bills, payroll, and tax-related payments. Add one-time items separately so they can be tested or moved without changing the recurring operating picture.
Finally, calculate a cash runway measure. A simple reference calculation is:
Cash runway in periods = available cash ÷ average recurring net cash outflow per period
This measure should be treated as an estimate. It can be misleading when revenue is seasonal, large invoices are due soon, or a major payment is missing from the average. The forecasted closing balance by period is usually more actionable than a single runway number.
Inputs and assumptions
Good forecasts make uncertainty visible instead of hiding it inside one precise-looking total. Label each input as confirmed, probable, or uncertain. A confirmed input might be a bank balance or scheduled payroll payment. A probable input might be a customer invoice with a history of timely payment. An uncertain input might be a prospective sale or an invoice with a disputed amount.
Opening cash
Use the reconciled bank and cash balance at the beginning of the forecast period. If there are funds that cannot be used for ordinary operating expenses, identify them separately rather than treating all cash as available.
Receivables and payment timing
List expected receipts by customer or invoice where practical. Record the expected amount, due date, likely payment date, and confidence level. If customers regularly pay later than their stated terms, reflect that pattern as an assumption and document it for review.
Operating costs
Include the cash amount and expected payment date for suppliers, software, rent, insurance, contractors, debt service, and other operating costs. Check for annual or irregular bills that may be absent from a normal monthly budget.
Payroll and taxes
Use the applicable payroll schedule and include the full cash requirement relevant to the business. Tax timing and employer obligations vary by location, entity type, and circumstance, so confirm these assumptions with the responsible finance professional or official guidance before relying on them.
Scenario rules
Create three versions without changing the underlying structure:
- Base case: contracted receipts arrive near the expected dates, routine costs remain stable, and planned expenses occur.
- Best case: selected receipts arrive earlier or additional likely work converts, while discretionary spending is controlled.
- Worst case: selected receipts are delayed, expected sales are excluded, and essential costs remain payable.
Keep the worst case plausible rather than extreme. The goal is to identify a manageable warning point, not to predict every possible disruption.
Worked examples
Assume a business begins the month with $18,000 in available cash. It expects $12,000 in customer payments, $2,000 in other receipts, and $15,000 in operating bills, payroll, and taxes. It also plans a $4,000 equipment purchase.
The base-case calculation is:
$18,000 + $14,000 - $19,000 = $13,000 closing cash
Now test payment timing. If $5,000 of the customer receipts moves into the following month, the current-period closing balance becomes $8,000. The total expected revenue has not changed, but the cash position has. That difference may affect whether the equipment purchase should proceed now or be delayed.
For a simple scenario table, record the assumptions beside the result:
| Scenario | Key assumption | Closing cash | Decision signal |
|---|---|---|---|
| Best | Receipts arrive as planned and discretionary purchase is delayed | Higher than base case | Review whether the purchase can be funded safely |
| Base | Expected receipts and scheduled outflows occur | Calculated forecast balance | Use for ordinary planning |
| Worst | Selected receipts are delayed while essential bills remain due | Lower than base case | Prepare collection, spending, or financing actions |
After the month closes, replace estimates with actual bank movements and compare each major line. Note whether a variance came from a changed amount, a changed payment date, a missed item, or an incorrect assumption. This turns the forecast into a learning system rather than a static business cash flow spreadsheet.
When to recalculate
Update the forecast at least once each month, then roll the completed period out and add a new future period. Recalculate sooner when a large invoice is issued, a customer payment is delayed, payroll changes, a tax or statutory payment is due, or a planned purchase is approved.
Use a short weekly review when cash is tight, receipts are concentrated among a few customers, or the business is making a significant hiring or purchasing decision. Review the following checklist:
- Reconcile the opening balance to the relevant bank and cash records.
- Mark receipts as collected, delayed, reduced, or cancelled.
- Confirm upcoming payroll, supplier, tax, debt, and subscription payments.
- Remove completed items and add newly known commitments.
- Compare base, best, and worst cases against the minimum cash buffer the business wants to maintain.
- Record one action for any period that shows a likely shortfall.
Refresh payment-timing assumptions, tax and payroll inputs, and scenario rules when the business changes location, staffing, pricing, billing terms, or operating model. If the forecast is connected to cloud productivity tools or workflow software, automate reminders for overdue invoices and review tasks, but keep an owner responsible for validating the numbers.
For related process work, see the automated invoice approval workflow guide and the workflow automation ROI guide. The forecast should remain the central decision record: update it with actuals, investigate variances, and use the next closing balance to guide spending decisions.