A cash flow forecast helps you see whether money will arrive before bills are due. This practical monthly template shows how to track opening cash, expected income, fixed and variable expenses, tax reserves, owner draws, one-off costs, closing cash, and runway so you can make spending and hiring decisions with fewer surprises.
Overview
A small business cash flow forecast is a forward-looking schedule of cash entering and leaving the business. It is different from a profit and loss statement: a profitable business can still face a cash shortfall if customers pay late, a large bill is due early, or cash is tied up in stock and work in progress.
The simplest useful forecast is organized by month, with each month showing:
- Opening cash balance: the cash available at the start of the month.
- Expected cash income: customer payments, deposits, loans, grants, or other receipts expected to reach the bank account.
- Cash expenses: operating costs, payroll, taxes, debt payments, owner draws, and purchases paid during the month.
- Net cash movement: expected income minus expected expenses.
- Closing cash balance: opening cash plus net cash movement.
Use cash received and cash paid, not simply the date an invoice or bill was issued. A sales invoice dated in one month belongs in the forecast month when you reasonably expect the customer payment to arrive. For invoice design and payment follow-up fields, see this small business invoice template guide.
A forecast is a decision tool, not a promise. Its value comes from making assumptions visible and updating them as new information arrives.
How to estimate
Build the forecast in a spreadsheet with one row for each income or expense category and one column for each month. A 12-month view is useful for planning, while a shorter rolling view can provide more detail for immediate bills and collections.
Copy-ready monthly cash flow template
Category Month 1 Month 2 Month 3 Month 4 Opening cash balance [input] [prior] [prior] [prior] Cash income Customer payments [input] [input] [input] [input] Deposits or retainers [input] [input] [input] [input] Other cash income [input] [input] [input] [input] Total cash income =SUM(...) =SUM(...) =SUM(...) =SUM(...) Cash expenses Payroll and contractor payments [input] [input] [input] [input] Rent, software, and utilities [input] [input] [input] [input] Materials, stock, or delivery [input] [input] [input] [input] Marketing and sales costs [input] [input] [input] [input] Tax reserve or tax payment [input] [input] [input] [input] Loan or finance payments [input] [input] [input] [input] Owner draw [input] [input] [input] [input] One-off purchases [input] [input] [input] [input] Other cash expenses [input] [input] [input] [input] Total cash expenses =SUM(...) =SUM(...) =SUM(...) =SUM(...) Net cash movement =income-expenses Closing cash balance =opening+net movement Low-cash alert =IF(closing<minimum,"Review","OK")
In a spreadsheet, the opening balance for each month should link to the previous month’s closing balance. The closing balance formula is:
Closing cash = Opening cash + Total cash income − Total cash expenses
Set a minimum cash threshold that reflects your operating needs rather than choosing an arbitrary target. The alert can flag any month in which projected closing cash falls below that threshold. If you want to test whether a new employee is affordable, add the expected payment dates and full employment cost to the forecast. The related payroll cost calculator guide can help you identify the categories to consider.
Use payment timing, not sales timing
For each expected receipt, record the likely payment month. Separate confirmed, probable, and uncertain income if your spreadsheet allows it. A conservative version can include only signed work or invoices with a realistic collection date. A planning version can include likely sales, but label those assumptions so they are not mistaken for committed cash.
For expenses, use the date money leaves the account. Include annual or irregular costs in the month they are likely to be paid. If a yearly renewal is easy to overlook, add a note or a separate assumptions tab rather than spreading it across months unless you are deliberately budgeting for a monthly reserve.
Inputs and assumptions
A forecast is only as useful as the inputs behind it. Keep an assumptions list beside the main schedule and record the reason for each estimate.
- Opening bank balance: use the cash actually available for business payments. Keep restricted funds or money reserved for specific obligations identifiable.
- Customer receipts: list the customer, invoice or project, expected amount, and expected payment date where practical.
- Fixed expenses: include recurring payroll, rent, subscriptions, insurance, utilities, and finance payments.
- Variable expenses: estimate materials, transaction charges, shipping, contractors, commissions, and other costs that change with sales.
- Tax reserve: record money set aside for expected tax obligations separately from ordinary operating cash. Treatment varies by business structure and location, so confirm the appropriate categories with your accountant or bookkeeping process.
- Owner draws: include planned withdrawals even when they are discretionary. Leaving them out can make available cash look higher than it really is.
- One-off costs: add equipment, deposits, professional fees, annual renewals, repairs, and planned purchases in the month of payment.
- Minimum cash threshold: define the balance below which you would delay spending, accelerate collections, arrange funding, or revise the plan.
Use separate cases when an important assumption is uncertain. A base case might use expected customer payments; a cautious case might delay some receipts and include a larger expense buffer; an upside case might include additional signed work. Avoid disguising uncertainty by combining all cases into one number.
For broader operational planning, connect the forecast to your quarterly goals and owners using a business planning template. This makes it easier to compare planned activity with the cash required to deliver it.
Worked examples
Assume a service business begins Month 1 with $18,000 in cash. It expects $12,000 in customer payments and $2,000 in deposits. Its planned cash expenses are $7,000 for payroll and contractors, $1,500 for recurring overhead, $1,200 for tax reserves, $1,000 for an owner draw, and $800 for a one-off equipment purchase.
The calculation is:
- Total cash income = $12,000 + $2,000 = $14,000
- Total cash expenses = $7,000 + $1,500 + $1,200 + $1,000 + $800 = $11,500
- Net cash movement = $14,000 − $11,500 = $2,500
- Closing cash balance = $18,000 + $2,500 = $20,500
If Month 2 starts with $20,500 but a major customer payment is delayed by one month, remove that receipt from Month 2 and place it in Month 3. The business may still be profitable overall, but the forecast could reveal that Month 2 falls below its minimum cash threshold. That warning creates time to follow up on the invoice, postpone a nonessential purchase, adjust the owner draw, or review funding options.
You can estimate cash runway with:
Runway in months = Available cash ÷ Average monthly net cash outflow
Use this cautiously. If income is irregular, an average can hide a near-term bill. The month-by-month closing balance is more useful for immediate decisions, while runway provides a simple summary for longer-range planning.
When to recalculate
Update the forecast at least monthly, and consider a weekly review when cash is tight, income is uneven, or several large payments are approaching. During each review:
- Replace last month’s estimates with actual bank receipts and payments.
- Move unpaid invoices to their revised expected payment dates.
- Remove assumptions that are no longer relevant.
- Add new commitments, renewals, tax payments, hires, purchases, or owner withdrawals.
- Compare the latest closing balance with the minimum cash threshold.
- Run a cautious case before approving a large recurring cost or expansion.
Recalculate whenever pricing, payment terms, payroll, rent, loan payments, tax arrangements, supplier costs, or customer timing changes. Keep a dated copy of major forecast versions so you can understand why the result changed. If a low-cash alert appears, act on the earliest month affected rather than waiting for the balance to reach zero.
A well-maintained business cash flow spreadsheet does not need to be complicated. It needs clear dates, realistic assumptions, and a regular review habit. Start with the next three months, make every major receipt and payment visible, then extend the forecast as your records improve.