Monthly Small Business Cash Flow Forecast Template: Track Runway, Bills, and Scenarios
cash flowfinancial templatessmall business financerunway planningforecasting

Monthly Small Business Cash Flow Forecast Template: Track Runway, Bills, and Scenarios

WWorkflowApp Editorial Team
2026-11-20
6 min read

Build a rolling monthly cash flow forecast with opening cash, payment timing, bills, scenarios, and a practical reconciliation checklist.

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 linePeriod 1Period 2Period 3Notes
Opening cash balancePrior period closing balance
Customer paymentsInvoice, customer, expected payment date
Other cash receiptsRefunds, financing, grants, or owner funds if applicable
Total cash inflowsCustomer payments plus other receipts
Supplier and operating billsUse payment dates, not only invoice dates
Payroll and related costsInclude the full expected cash payment
Taxes and statutory paymentsUse applicable schedules and confirmed assumptions
One-time expensesEquipment, repairs, deposits, or planned purchases
Total cash outflowsSum of all expected payments
Net cash movementInflows minus outflows
Closing cash balanceOpening 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:

ScenarioKey assumptionClosing cashDecision signal
BestReceipts arrive as planned and discretionary purchase is delayedHigher than base caseReview whether the purchase can be funded safely
BaseExpected receipts and scheduled outflows occurCalculated forecast balanceUse for ordinary planning
WorstSelected receipts are delayed while essential bills remain dueLower than base casePrepare 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:

  1. Reconcile the opening balance to the relevant bank and cash records.
  2. Mark receipts as collected, delayed, reduced, or cancelled.
  3. Confirm upcoming payroll, supplier, tax, debt, and subscription payments.
  4. Remove completed items and add newly known commitments.
  5. Compare base, best, and worst cases against the minimum cash buffer the business wants to maintain.
  6. 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.

Related Topics

#cash flow#financial templates#small business finance#runway planning#forecasting
W

WorkflowApp Editorial Team

Business Productivity Editors

Senior editor and content strategist. Writing about technology, design, and the future of digital media. Follow along for deep dives into the industry's moving parts.