August 16, 2026

How to Create a Cash Flow Forecast

A business can be profitable on paper and still run out of cash — a big invoice that hasn't been paid yet doesn't cover this week's payroll. A cash flow forecast is the tool that catches that gap before it becomes a real problem, and it's a different exercise from a budget even though the two get confused constantly.

Cash flow vs. budget — the actual difference

A budget compares revenue and expenses for a period, on paper. A cash flow forecast tracks real cash moving in and out and the resulting balance, timing included. A $10,000 invoice due in 30 days is real revenue for a budget the moment it's sent — it's not real cash until it's actually paid. That gap is exactly what sinks businesses that look healthy on a budget.

What a real forecast needs

  • Starting cash balance — what's actually in the account right now, not what's owed to you.
  • Cash in — money genuinely expected to arrive in the period, not total sales booked.
  • Cash out, broken into real categories — operating expenses, payroll, and everything else, since payroll timing in particular is where forecasts go wrong.
  • Net cash flow and ending balance — cash in minus cash out, added to (or subtracted from) the starting balance.

Chain forecasts forward

One period's ending balance becomes the next period's starting balance. Doing this every month (or every week, for a business with tight margins) turns a single snapshot into an actual forward view — enough warning to act on a cash shortfall weeks before it happens instead of discovering it the day payroll is due.

Use the template instead of building this from scratch

The Cash Flow Forecast Template has this structure already built — starting balance, cash in and out, and net cash flow all calculate automatically. Open it in FLYNT Sheets and plug in your real numbers, or pair it with the Small Business Budget Template for the fuller picture: what you're spending against what you're actually collecting.