QUICK ANSWER
The fastest reliable way to forecast cash flow is a 13-week rolling forecast: start with today’s bank balance, list every expected cash inflow and outflow week by week for the next quarter, and track the running balance to spot the week it dips lowest. Update it every Monday against actuals — the forecast gets sharper each week you do. A spreadsheet is genuinely enough for most businesses under about $1 million in revenue; QuickBooks Online’s cash flow planner, Float, or Fathom make sense once you have multiple accounts, credit lines, or an owner who will not open Excel.
Key Takeaways
- 13 weeks is the sweet spot — long enough to see a crunch coming, short enough that the numbers stay honest.
- Forecast cash, not profit — a profitable month can still leave you unable to make payroll if receivables land late.
- Date inflows when cash arrives — an invoice with net-30 terms sent today is a week-6 inflow, not a week-1 inflow.
- The minimum-balance week is the whole point — every decision (hiring, equipment, draws) should be checked against it.
Why Cash Flow Forecasting Beats Watching Your Bank Balance
A bank balance tells you where you are; a forecast tells you where you will be the Friday payroll hits the same week as quarterly estimated taxes and your liability insurance renewal. That collision is findable eight weeks out — which is enough time to chase receivables, delay a purchase, or draw on a line of credit calmly instead of at emergency pricing. Cash problems remain a leading killer of otherwise healthy small businesses precisely because profit and cash timing diverge: you book revenue in March, buy inventory in April, and collect in May.
How to Build a 13-Week Cash Flow Forecast
1. Start with real, available cash
Row one is today’s combined balance across operating accounts, minus outstanding checks and pending charges that have not cleared. Do not include your credit line — that is a backstop, not cash.
2. Map inflows to the week the money actually lands
Work from three sources: open invoices (use each client’s real payment behavior — the customer who always pays net-30 invoices on day 45 goes in at day 45), recurring revenue like retainers or subscriptions, and a conservative estimate of new sales. If card processing takes two business days to settle, reflect that. Optimism here is the number-one forecast killer; when unsure, push an inflow a week later.
3. Map outflows — including the irregular ones
Weekly and monthly items are easy: payroll, rent, software, loan payments, utilities, typical supplier runs. The forecast earns its keep on the lumpy items owners forget: quarterly estimated taxes (September 15 is inside any summer 13-week window), annual insurance premiums, sales tax remittances, W-2 season costs, and owner draws. Go through last year’s bank statements once to build the list of irregular hits and their months.
4. Compute the running balance and find the low week
Each week: opening cash + inflows − outflows = closing cash, which opens the next week. Scan the closing-cash row for the minimum. If it is below your safety floor — one payroll cycle plus rent is a sensible floor for most service businesses — you now have weeks of runway to fix it: invoice sooner, offer a 2% discount for early payment, shift a supplier to net-45, or schedule the equipment purchase after the crunch.
5. Update weekly against actuals
Every Monday, replace last week’s forecast with what actually happened, note the variance, and add week 14. Fifteen minutes, honestly. After six or eight cycles your collection assumptions stop being guesses — and the forecast becomes the document your banker most wants to see when you ask for a credit line.
Forecasting Tools Compared
| Tool | Cost (2026) | Data Entry | Scenarios | Best For |
|---|---|---|---|---|
| Spreadsheet (Excel/Sheets) | Free | Manual, weekly | Copy the tab | Businesses under ~$1M revenue |
| QuickBooks Online cash flow planner | Included from ~$38/mo | Auto from bank feeds | Basic what-ifs | Existing QBO users |
| Float | ~$59/mo | Syncs QBO/Xero | Strong, visual | Agencies, project businesses |
| Fathom | ~$50/mo | Syncs QBO/Xero | Reporting + 3-way forecasts | Advisor-led companies |
Recommended Resources
Bookkeeping Workbook For Dummies — a forecast is only as good as the books feeding it; this workbook drills the reconciliation habits that keep your inputs trustworthy.
Accounting All-in-One For Dummies — explains the cash-versus-accrual distinction that trips up first-time forecasters, with worked examples.
Frequently Asked Questions
How accurate does a small business cash flow forecast need to be?
Less accurate than most owners assume — the forecast’s job is to change your decisions, not to predict the future to the dollar. A useful benchmark: within 10% on total weekly outflows and within one week on major inflow timing for the first four weeks of the window. Weeks 5 through 13 can be considerably rougher; they exist to flag structural problems (a tax payment stacking on payroll, a seasonal dip) rather than exact balances, and they get refined every Monday as they roll closer. Two asymmetries are worth building in deliberately. First, bias inflows late and outflows early — the failure mode that hurts is a surprise shortfall, not a surprise surplus. Second, spend your accuracy effort on the few large items: for most small businesses, payroll, rent, taxes, and the top three customers’ payments determine 80% of the picture, so nailing those matters far more than agonizing over the software subscriptions line. If your actuals diverge more than about 20% from forecast for three straight weeks, that is not a forecasting failure — it is the forecast telling you your collections process or sales pipeline assumptions need attention, which is exactly the early warning you built it for.