Key Takeaway: Choose a forecast horizon that reaches the decisions you need to make, and use enough detail to expose payment-day shortfalls. Start from reconciled available cash, preserve a dated forecast before entering actuals, and assign an owner and deadline to each material cash decision.
This article is part of our guide to cash flow forecasting and financial planning.
A profitable business can still struggle to cover Friday payroll when customer receipts arrive the following week. A cash forecast maps receipts and payments to the dates cash is expected to move. This guide helps you choose the time horizon, update schedule, review process and responsibilities that fit your business.
Choose the horizon around the decision
A horizon is how far ahead the model looks. Its time intervals are a separate choice: daily, weekly or monthly. A company may need a detailed short-term forecast and a broader annual view at the same time. The examples below are planning choices, not mandatory reporting periods.
| Decision or pressure | Useful starting view | Review trigger |
|---|---|---|
| Payroll or supplier payments are at risk in the next few weeks | Daily detail for the immediate cash window, supported by a rolling 13-week weekly view | A receipt slips, a bank hold appears or the cash buffer is breached |
| Stable operations with recurring receipts and payments | A rolling 12-month monthly forecast, with detail around large payment dates | Actual cash materially differs from plan or a major commitment changes |
| Seasonal inventory, annual renewals or concentrated collections | A monthly view covering the next full seasonal cycle, plus weekly detail through the cash trough | Orders, purchase commitments or expected collections change |
| A new location, equipment purchase or financing decision | A project forecast through funding, launch and the expected recovery period, linked to the operating forecast | A deposit, milestone, hiring date or funding condition changes |
Weekly detail is useful when the timing of collections and disbursements is tight. A longer monthly view helps reveal taxes, renewals and seasonal needs outside the next quarter. SCORE’s cash-flow management presentation discusses rolling analysis, a 13-week view where appropriate and comparing forecasts with actual results. Adapt the cadence to your payment risk.
For a week-by-week starting layout, see our 13-week cash-flow forecast guide and example grid. Keep a longer view when the next material decision falls beyond those 13 weeks.
Define the cash covered by the forecast
List the included bank accounts and entities, the opening date and whether the main output is total cash or cash available for operations. Reconcile the starting point to bank and accounting records. Investigate uncleared payments, deposits in transit and holds; a bank’s displayed balance is not automatically cash available to spend.
Separate legal or contractual restrictions from management earmarks. Client trust funds, restricted grant money or other funds the business cannot use for general bills should not inflate operating liquidity. A management tax reserve is an allocation of cash; it is not automatically a separate expense or legal restriction. Present total cash and the operating amount clearly enough to reconcile them.
Illustrative opening-cash bridge
Assume the included bank balances total $60,000. They include $9,000 that is legally restricted, and $6,000 of issued payments have not yet cleared. There are no other reconciling items:
- Bank balances: $60,000.
- Less issued payments already committed: $6,000.
- Reconciled cash after those payments: $54,000.
- Less restricted cash: $9,000.
- Opening cash available for the operating forecast: $45,000.
Because this example deducts the $6,000 in the opening bridge, do not deduct the same payments again in future operating outflows. A model starting from unadjusted bank balances could instead show them on their expected clearing dates, but it must reconcile to the same position.
A 13-week cash flow forecast applies this same definition at weekly intervals, which is why the opening balance must be reconciled before the first week is built.
Forecast cash movements, not just revenue and expenses
The basic relationships are net cash flow = receipts minus payments and ending cash = opening cash plus net cash flow. Ending cash becomes the next period’s opening cash. A forecast is forward-looking; it is not the same as historical cash reporting.
Use expected collection dates for customers, supported by invoice terms and actual payment behavior. A billed sale is not a receipt until collected. Track known supplier due dates, payroll funding, tax payments, debt service and capital purchases. Loan proceeds and owner contributions are cash inflows, but they are not sales revenue. Loan principal and owner distributions affect cash without necessarily being income-statement expenses.
Use one treatment for each movement:
- Internal transfers: Eliminate transfers between accounts included in the total-cash forecast. Show them separately in account-level or available-cash views where needed.
- Credit cards: In a bank-cash forecast, the card repayment is an outflow. Do not also treat each card purchase as a bank payment; retain the purchases in the expense and card-liability records.
- Payroll: Model the actual funding arrangement. If a provider debits a combined amount for net wages and tax remittances, do not also deduct separate remittances it pays from those same funds.
- Tax reserves: Moving money to another included account is an internal transfer. Payment to the tax authority is an external outflow. Coordinate any separate operating-availability view so it does not count the same tax twice.
- Multiple entities: Preserve each entity’s ability to meet its own obligations. A combined presentation does not make another entity’s cash legally available or eliminate the need for proper intercompany records.
Preserve the forecast before comparing actuals
Save a dated baseline with its assumptions before the period begins. At the review, put actual receipts and payments in separate columns or a separate version. Explain material differences, then roll the live forecast forward. Keep the original forecast so that the later comparison remains meaningful.
Continuing the illustrative operating-cash example, suppose opening available cash is $45,000:
| Item | Original forecast | Actual | Actual minus forecast |
|---|---|---|---|
| Opening available cash | $45,000 | $45,000 | $0 |
| Customer receipts | $30,000 | $22,000 | −$8,000 |
| Payments | $40,000 | $43,000 | +$3,000 |
| Net cash flow | −$10,000 | −$21,000 | −$11,000 |
| Ending available cash | $35,000 | $24,000 | −$11,000 |
The positive $3,000 payment variance means more cash paid out, so it reduces ending cash. The $8,000 receipt shortfall plus the $3,000 extra payment explains the $11,000 ending-cash shortfall. Investigate whether each difference is timing, a permanent amount change or an omitted item. Move a late receipt to its revised date once; do not leave it in both periods.
Also inspect the low point inside the period. If the forecast $40,000 of payments all clear Monday and the $30,000 receipt arrives Friday, available cash falls from $45,000 to $5,000 before ending at $35,000. A positive week-end balance does not show that every payment-day requirement or operating buffer is met.
Turn scenarios into specific actions
Keep base, downside and upside assumptions separate. Change an identified driver, such as a major customer’s payment date, instead of applying an unexplained percentage to every line. Label financing that is proposed separately from funding that is approved and available; include conditions and expected timing.
For example, management might select a $30,000 operating buffer for this hypothetical business after reviewing its obligations. Actual ending cash of $24,000 is $6,000 below that buffer. That should trigger a named review, not an automatic assumption that borrowing or withholding a required payment is the right response.
A useful action log records the condition, responsible person, decision deadline and result. A collection manager might confirm a delayed customer receipt before the next payroll run. An owner might defer an uncommitted equipment purchase before paying its deposit. A finance lead might check a lender’s availability conditions before including a draw. Required tax, wage and contractual obligations remain part of the decision.
Working capital is not the same as available cash
Net working capital is current assets minus current liabilities. It can include receivables, inventory and other current items as well as cash. A positive number does not mean that amount is in the bank or immediately spendable. The SBA financial glossary describes the underlying current-asset, current-liability and working-capital concepts.
Operating working capital is a narrower management measure whose definition should be stated—for example, operating receivables plus inventory minus operating payables, with specified additional items. It often excludes cash and financing debt. Do not use an undefined operating measure interchangeably with balance-sheet net working capital or the cash available for payroll.
Assign preparation, review and decision responsibilities
Specify who updates bank and invoice information, who confirms receipt assumptions, who reviews the model, and who approves spending or financing. A forecast prepared by one person can still be reviewed by another. Agree on an update deadline and an escalation rule for changes that cannot wait for the normal meeting.
The work can be shared by an owner, bookkeeper, accountant or outsourced CFO. Capabilities depend on skills and the engagement. Bookkeepers and accountants may provide interpretation and planning; a CFO title does not automatically guarantee a particular forecast, funding outcome or review process.
Before engaging outside support, define the model, included accounts and entities, update frequency, assumptions log, variance review, meeting schedule, recommendations and decision authority. Confirm fees and the work outside scope. For help planning that process, contact CPA Firm South Florida with your current records and the decisions the forecast must support.
Frequently asked questions
Should I overwrite last week’s forecast with actual results?
Preserve the dated forecast first. Enter actuals in separate columns or a separate version, calculate the differences, and then update future periods. Overwriting the only forecast destroys the baseline needed to evaluate accuracy.
Is a positive month-end forecast enough to approve spending?
No. Check the lowest projected balance within the month, required payments, restricted funds and the operating buffer. Cash can fall short before a large receipt arrives even if the ending balance is positive.
Does a transfer to a tax-reserve account reduce total business cash?
A transfer between included business bank accounts does not reduce total cash. It changes where cash is held and what management regards as available. The later payment to a tax authority is the external cash outflow; avoid counting both as expenses or as two reductions of total cash.
Must a CFO provide all forecast interpretation?
No. An owner, bookkeeper, accountant or CFO may contribute analysis within their skills and agreed responsibilities. Define who prepares, reviews and approves decisions in the actual engagement rather than assigning capabilities solely by job title.