What you need to know
- A cash flow forecast estimates when money will enter and leave the business; it is not the same as a profit forecast.
- A rolling 13-week view is detailed enough for near-term decisions and short enough to update every week.
- Use realistic payment dates, not invoice dates, and separate committed payments from estimates.
- Test a base case, a downside case, and specific management actions before a shortfall becomes urgent.
What is a small-business cash flow forecast?
A cash flow forecast is a time-based estimate of cash receipts, cash payments, and the resulting bank balance. It answers a practical question: will the business have enough available cash to meet payroll, suppliers, tax, debt, and other obligations when they fall due?
Profit and cash are related but different. A profitable sale may not create cash until the customer pays, while loan proceeds increase cash without being revenue. That timing difference is why a business can report profit and still face a cash shortage.
Choose a useful forecasting window
For day-to-day management, start with a rolling 13-week forecast. Use one column per week, begin with the actual opening bank balance, and replace estimates with actual figures as each week closes. Add a new week at the end so the horizon remains constant.
A monthly 12-month view is useful for strategy and seasonality, but it can hide a shortfall inside a month. Many small businesses benefit from both: a weekly model for liquidity and a monthly model for planning.
- Use a daily view temporarily when cash is extremely tight.
- Use weekly columns for operational control.
- Use monthly columns for hiring, investment, financing, and seasonal planning.
Forecast cash coming in
List receipts by the date cash is reasonably expected, not the date an invoice is issued. Separate cash sales, card settlements, customer payments, subscriptions, tax refunds, grants, asset sales, and financing. Use actual customer payment behavior where possible.
Avoid treating the sales pipeline as guaranteed cash. Apply probability only when it is supported by experience, and keep uncommitted opportunities in a separate scenario. If one customer represents a large share of receipts, show that payment on its own line so a delay is visible.
Forecast cash going out
Record the date and amount of payroll, rent, supplier invoices, inventory purchases, software, insurance, loan payments, owner withdrawals, tax, and planned capital spending. Include annual or quarterly payments that are easy to forget.
Mark payments as committed, controllable, or uncertain. The distinction makes the forecast actionable. Rent may be committed, while a marketing campaign may be rescheduled. Never hide overdue obligations; show them on the earliest realistic payment date.
- Reconcile recurring payments against recent bank statements.
- Confirm tax dates with the relevant authority or adviser.
- Show loan principal and interest clearly where the distinction matters.
- Add a small contingency rather than assuming every estimate will be exact.
Calculate the closing cash position
For each week, calculate opening cash plus receipts minus payments. The result becomes the next week's opening balance. Keep restricted funds separate if they cannot be used for ordinary expenses.
Set a minimum cash threshold that reflects payroll, essential suppliers, debt commitments, and operating risk. A positive balance is not necessarily comfortable if it leaves no margin for a delayed payment or unexpected repair.
Run scenarios and decide early
Build a base case using the best current information, then test a downside case such as a major customer paying two weeks late, sales falling, or inventory costs rising. A third scenario can show the effect of a specific action rather than an optimistic wish.
If a shortfall appears, act while options remain. Possible responses include collecting receivables earlier, changing deposit terms, reducing discretionary spending, negotiating supplier timing, adjusting inventory purchases, or arranging finance. Each action has costs and consequences, so document the owner and deadline.
Maintain the forecast as a management tool
Update the forecast at the same time each week. Compare forecast receipts and payments with actual transactions and note the cause of major differences. Repeated misses may reveal weak sales assumptions, slow invoicing, inaccurate payment dates, or costs that are not being captured.
The model does not need to be complex. It needs to be complete enough to support decisions, easy enough to update, and connected to bank data, receivables, payables, payroll, tax, and the sales outlook.
Frequently asked questions
How often should a small business update its cash flow forecast?
Update a 13-week forecast every week and more frequently during a cash squeeze. Replace the completed period with actual results and add a new period at the end.
Should unpaid invoices count as cash?
No. Forecast the receipt on the realistic payment date. Keep receivables visible, but do not treat an invoice as available cash before it is paid.
What is the difference between cash flow and profit?
Profit measures revenue and expenses under accounting rules. Cash flow measures when money actually enters or leaves the business. Timing, credit terms, loan movements, and asset purchases can make them differ substantially.