A cash flow forecast spreadsheet gives a small business a forward view of available cash, expected collections, and upcoming payments. This guide explains how to build a practical model in Excel or Google Sheets, organize a 13-week, monthly, or rolling-12-month forecast, test collection delays, and use a minimum cash threshold to decide when action is needed.
Overview
Profit and cash are related, but they are not the same. A sale may be recorded before the customer pays, while a large supplier invoice, payroll run, tax payment, or equipment purchase can reduce the bank balance before the expense has a visible effect on monthly profit. A cash flow forecast spreadsheet focuses on the timing of those movements.
The basic calculation is straightforward:
Ending cash = starting cash + cash inflows − cash outflows
The value comes from making each part of the calculation visible and repeatable. Instead of asking whether the business is profitable in general, you can ask whether enough cash is expected to be available on a specific future date.
A useful cash flow spreadsheet normally includes an assumptions or inputs sheet, a forecast sheet, an actuals-versus-forecast comparison, and a summary area. The forecast can be organized by week or month, depending on how quickly cash conditions change. A 13-week cash flow forecast is useful for near-term liquidity management. A monthly forecast supports budgeting and management reviews. A rolling-12-month forecast provides a longer planning view and can connect to a broader financial model spreadsheet.
Keep the model simple enough to update regularly. A detailed forecast that nobody maintains is less useful than a smaller model with reliable assumptions and current actuals.
What to track
Start by creating one column for each forecast period. Use weekly columns for a short-term 13-week model or monthly columns for a longer planning horizon. Add rows for the following categories.
Starting and ending cash
- Starting cash: Enter the opening bank balance for the first period. For later periods, link starting cash to the previous period's ending cash.
- Minimum cash threshold: Set the balance below which management action is required. This is a planning limit, not a universal accounting rule.
- Ending cash: Calculate starting cash plus total inflows minus total outflows.
- Available headroom: Subtract the minimum cash threshold from ending cash to show how much room remains.
Expected cash inflows
- Customer receipts from invoices already issued
- Expected receipts from new sales
- Deposits, retainers, or upfront payments
- Owner contributions or other equity funding
- Loan proceeds, credit facility draws, or other financing
- Refunds, grants, asset sales, or other one-time receipts
Separate confirmed or highly probable receipts from uncertain opportunities. A signed customer contract and an unqualified sales pipeline should not be treated as equally dependable. You can use separate rows such as “committed receipts” and “possible receipts,” then exclude possible receipts from a conservative base case.
Expected cash outflows
- Payroll, contractor payments, and related payroll costs
- Supplier and inventory payments
- Rent, software, insurance, utilities, and other recurring expenses
- Taxes, loan repayments, and interest
- Equipment purchases and other capital spending
- Owner distributions or drawings
- One-time legal, repair, launch, or restructuring costs
Record payments in the period they are expected to leave the bank account. If an invoice is received in one month but paid in the next, the forecast should reflect the payment date rather than simply copying the expense from an income statement.
Useful supporting fields
Add a notes column or supporting assumptions table for payment dates, customer terms, confidence levels, and responsible owners. For accounts receivable, an aging schedule can help you estimate which invoices are likely to be collected and when. See the Accounts Receivable Aging Spreadsheet Template for a related structure.
A practical spreadsheet layout might include rows for starting cash, committed receipts, uncertain receipts, total inflows, payroll, suppliers, recurring overhead, taxes, financing, one-time payments, total outflows, net cash movement, ending cash, and headroom above the minimum threshold.
Cadence and checkpoints
Choose a forecast format based on the decision you need to make rather than trying to build one model for every purpose.
| Format | Best use | Typical update rhythm |
|---|---|---|
| 13-week weekly forecast | Near-term liquidity, payment timing, and funding decisions | Weekly |
| Monthly forecast | Budget management, hiring plans, and operating reviews | Monthly |
| Rolling 12-month forecast | Longer-term planning, investment, and scenario analysis | Monthly or quarterly |
At each update, follow the same sequence:
- Replace the prior period's forecast with actual bank activity and confirmed transactions.
- Compare actual receipts and payments with what the spreadsheet expected.
- Move each remaining forecast period forward by one week or month.
- Update customer collection dates, supplier payment dates, payroll changes, and one-time items.
- Review the lowest projected cash balance and the date on which it occurs.
- Record an explanation for material changes instead of overwriting assumptions without a note.
Use clear labels for actual, forecast, and revised forecast. Conditional formatting can highlight ending cash below the minimum threshold, overdue assumptions, or unusually large changes. Keep formulas protected where appropriate, but make input cells visually distinct so the model is easy to maintain in both Excel and Google Sheets.
How to interpret changes
A lower projected ending balance does not automatically mean the business is in trouble. First identify whether the change comes from timing, volume, or a new commitment.
- Timing change: A customer payment moved from this week to next week, or a supplier payment was brought forward.
- Volume change: Sales receipts are lower, payroll is higher, or operating costs have changed.
- New commitment: A lease, loan repayment, equipment purchase, or recurring contract was added.
- Forecast error: The original assumption was too optimistic or a transaction was omitted.
Compare projected cash movement with actual cash movement for each completed period. A simple variance calculation is:
Cash variance = actual cash movement − forecast cash movement
Review the largest variances by category. If receipts are repeatedly late, adjust the collection pattern rather than treating each delay as an isolated surprise. If payroll or supplier payments consistently exceed the forecast, update the underlying assumptions and investigate the operational cause.
Test at least three views when the cash balance is tight: a base case, a downside case, and a response case. In the downside case, delay selected customer receipts, reduce expected new sales, or bring forward known payments. In the response case, show practical actions such as collecting overdue invoices, rescheduling discretionary spending, reducing planned purchases, or arranging financing. Do not count a possible funding source as available cash until its timing and conditions are sufficiently clear.
For a more complete management view, pair the cash flow forecast with a small business KPI dashboard and a sales forecast. This helps distinguish a temporary collection issue from a broader change in demand, margin, or operating performance.
When to revisit
Revisit a 13-week forecast at least weekly, especially when the business has narrow cash headroom, uneven customer payments, or frequent supplier commitments. Update a monthly or rolling-12-month forecast at least monthly, with a deeper review each quarter.
Refresh the model whenever a recurring data point changes, including a new customer contract, pricing change, hiring decision, loan, lease, tax obligation, supplier term, or planned capital purchase. Also update it after a material collection delay, an unexpected payment, or a significant change in the sales pipeline.
Before a lender, owner, or management review, check that the opening cash balance agrees with the relevant bank records, formulas extend through every forecast period, and actuals are not mixed with estimates. A spreadsheet audit checklist can help identify broken links, formula errors, and reporting mistakes.
To put the model into use today, create the period columns, enter the current opening cash balance, list committed receipts and payments, set a defensible minimum cash threshold, and calculate ending cash. Then add notes for uncertain items and schedule the next update. Over time, the forecast becomes more useful because its assumptions are tested against actual results rather than left unchanged.
