Put receipts in the month you expect payment
Start with the bank balance available at the beginning of the forecast. List incoming payments by expected receipt date, not the invoice date or the date an order was placed. Keep uncertain sales separate from confirmed orders. For platform sales, check settlement timing, fees, refunds and any holdbacks against your actual provider terms.
Holiday activity is a timely reason to review this: QuickBooks’ 2026 U.S. holiday shopping survey examines planned seasonal spending with small businesses. That research supplies context, not a forecast of demand for your business.
A profitable month can still need funding
Consider this fictional cash schedule in USD. It ignores tax and borrowing to keep the timing example clear; add them where relevant to your own business.
| Cash movement | November | December |
|---|---|---|
| Opening cash | 4,000 | 1,500 |
| Customer receipts | 6,000 | 10,000 |
| Stock payments | 5,000 | 2,000 |
| Payroll, rent and other payments | 3,500 | 4,000 |
| Closing cash | 1,500 | 5,500 |
The rule is opening cash plus receipts minus payments. December begins with November’s closing balance. Sales and profit need separate records; this schedule shows whether the payment timing fits the cash available.
Run a delayed-receipts scenario
Now move USD 2,000 of expected November receipts into December. November closes at minus USD 500, rather than USD 1,500. December still closes at USD 5,500 if everything else stays the same. The final balance hides the earlier shortfall.
A negative forecast is a warning that the plan needs a change; it does not mean an overdraft is available. Check proposed actions with the people involved. You might agree a different stock-delivery schedule, revise a purchase or confirm customer payment dates. Record only arrangements that have actually been agreed.
Review the tightest weeks separately
A monthly forecast can conceal a payment due before the month’s main receipts arrive. When the buffer is small, list the dates of payroll, rent, supplier instalments and expected settlements for the relevant weeks. Do not assume that a positive month-end balance makes every day affordable.
- Which payments are committed, and which are optional?
- Which receipts have written confirmation?
- What would happen if the largest receipt arrived two weeks late?
- Who will update the forecast when a date changes?
Make it a short weekly routine
Use the cash-flow tool to build your base case, export it, then keep a clearly labelled delayed-payment scenario. Once a week, replace estimates with actual receipts and payments and explain material changes. Keep a dated copy so you can see which assumptions were unreliable.
If unpaid invoices are the source of uncertainty, follow the invoice follow-up workflow. For the difference between a cash forecast and an income result, read cash flow versus profit.
Build your cash-flow forecast using your own information. Review the result before exporting or sharing.
Build your cash-flow forecast →