To forecast cash flow, start with your reconciled bank balance today, add the cash you realistically expect to collect in each future week or month, subtract the cash you expect to pay out on the exact dates it leaves your account, and carry the running balance forward period by period. The result is a dated map of when your account will be flush and when it will run thin, built from arithmetic simple enough to keep in a spreadsheet.
The goal is not perfect prediction; it is lead time. A forecast that flags a shortfall eight weeks out gives you eight weeks to accelerate collections, renegotiate a payment date, or arrange financing on your terms. The same shortfall discovered when payroll fails to clear gives you nothing but a scramble. This guide covers what to measure, what time horizon to use, how to estimate inflows and outflows on the right dates, how to assemble a rolling forecast, and how to act on the gaps it reveals.
Key takeaways
- A cash flow forecast tracks cash movement, not profit; a profitable business can still run out of cash when collections lag behind expenses.
- The core formula is simple: opening balance + expected inflows − expected outflows = closing balance, carried forward each period.
- A 13-week rolling forecast in weekly buckets is the standard operational tool; a 12-month monthly view supports planning decisions.
- Forecast inflows by when cash actually lands, not by invoice terms, and weight uncertain pipeline revenue by its real close rate.
- Automatic fixed drafts (financing, leases) and lumpy periodic bills (quarterly taxes, annual insurance) are the outflows that most often break a forecast.
- Update the forecast weekly with actuals and review projected-vs-actual variance to make each future forecast more accurate.
- The main payoff is lead time: seeing a shortfall weeks ahead lets you accelerate collections, smooth payments, or arrange financing calmly rather than in a crisis.
What a Cash Flow Forecast Actually Measures
A cash flow forecast tracks cash, not profit, and confusing the two is the single most common reason a profitable business misses payroll. Profit is booked when you earn revenue and incur an expense; cash moves only when money changes hands. Invoice a customer $20,000 in March and collect it in May, and the sale counts as March revenue while the cash lands in May. Your forecast follows the cash, on the day it moves.
Every forecast is built from three parts:
- Opening balance — the reconciled cash you hold at the start of the period.
- Cash inflows — customer collections, card deposits, loan proceeds, tax refunds, and owner contributions.
- Cash outflows — payroll, rent, inventory, supplier and loan payments, taxes, software, and everything else going out.
Add inflows to the opening balance, subtract outflows, and you get the closing balance, which becomes the next period's opening balance. Chained across many periods, that arithmetic is your forecast. The skill is not the math; it is estimating each inflow and outflow honestly and placing it on the correct date.
Choosing Your Time Horizon and Granularity
Two decisions shape a forecast before you type a single number: how far out you project, and in what size of time buckets. They pull against each other. Short buckets over a short horizon give operational precision; long buckets over a long horizon give strategic direction. Most small businesses run both, side by side.
The 13-week rolling forecast in weekly buckets is the workhorse. Thirteen weeks is roughly one quarter, long enough to see a seasonal dip forming, short enough that estimates stay grounded in what you actually know. Weekly buckets are precise enough to catch the specific week payroll and rent collide. "Rolling" means that each week you drop the week that just closed and add a fresh week at the far end, so a full quarter of visibility always sits ahead of you.
A 12-month forecast in monthly buckets sits alongside it for planning: hiring, equipment, tax set-asides, and financing timing. Match granularity to the decision. You do not need daily buckets to decide whether to hire in Q3, and you cannot decide whether Friday's payroll clears from a monthly average.
Estimating Your Cash Inflows
Inflows are harder to forecast than outflows because they depend on other people paying you. The task is to estimate not just how much you will collect but when it will actually land in the account. Start from recurring revenue and your sales pipeline, then apply what you know about how your customers really pay, not how your terms say they should.
If invoices average 40 days to pay despite Net 30 terms, forecast the cash on day 40. If a slice of receivables always pays late or never arrives, discount for it. Break inflows into categories so you can reason about each one's timing and reliability separately.
| Inflow source | Example monthly amount | Timing assumption | Reliability |
|---|---|---|---|
| Recurring contracts (auto-pay) | $45,000 (for example) | 1st of month | High |
| Invoiced clients (Net 30) | $60,000 (for example) | ~40 days after invoice | Medium |
| Point-of-sale / card sales | $25,000 (for example) | 2-3 day deposit lag | High |
| New-business pipeline | $18,000 (for example) | Weighted by close probability | Low |
Weight the low-reliability line. If your pipeline holds $18,000 of prospective work but, for example, one deal in three historically closes, forecasting $6,000 is more honest than $18,000. Overstated inflows are how a forecast lies to the person who built it.
Mapping Your Cash Outflows
Outflows are more predictable, which makes them the backbone of a reliable forecast. Sort them into fixed costs that recur on a schedule and variable costs that move with sales, then place each on the exact date it clears. A cost labeled "monthly" still lands on a specific day, and that day is what decides whether a given week is tight.
| Outflow category | Type | Example amount | When it hits |
|---|---|---|---|
| Payroll | Semi-fixed | $38,000 (for example) | Every other Friday |
| Rent | Fixed | $7,500/mo (for example) | 1st of month |
| Inventory / COGS | Variable | ~35% of sales (for example) | On supplier terms |
| Loan / financing payments | Fixed | $4,200/mo (for example) | Fixed draft date |
| Estimated taxes | Periodic | $9,000/qtr (for example) | Quarterly due dates |
| Software & utilities | Fixed | $2,100/mo (for example) | Various days |
Two categories quietly wreck forecasts. The first is lumpy quarterly and annual bills, estimated taxes, insurance renewals, license fees, that feel invisible for eleven months and then land all at once; put each on the calendar the day you learn its date. The second is any payment drafted automatically on a fixed day. Financing payments and equipment leases clear whether or not the cash is there, so they belong in the forecast at full weight on their exact draft date.
Building the Rolling Forecast, Step by Step
With inflows and outflows mapped, assembling the forecast is mechanical. Work in a spreadsheet with one column per week.
- Enter the opening balance. Use your real, reconciled bank balance, not the accounting-software figure, which may still carry uncleared items.
- Lay out the inflows. Drop each expected collection into the week you truly expect the money, using your timing assumptions rather than invoice dates.
- Lay out the outflows. Place every payment in the week it will clear, including fixed auto-drafts and the lumpy periodic bills.
- Calculate each week's net. Inflows minus outflows for that week.
- Carry the balance forward. Opening balance plus net equals closing balance; that closing figure is next week's opening. Repeat across all 13 weeks.
- Read the low points. Scan the closing-balance row for the smallest and any negative numbers. Those weeks are your risk.
Then keep it alive. Each week, replace that week's estimates with what actually happened, roll a fresh week onto the end, and correct the assumptions that missed. The gap between projected and actual, your forecast variance, is the feedback that makes next month's numbers sharper.
Running Scenarios and Closing Gaps
A single forecast is a guess about one future. Scenarios admit that several are possible. Build three from the same structure: a base case on realistic assumptions, a downside case where large customers pay 30 days later and sales soften, and an upside case where collections land on time and the pipeline converts. Comparing them shows how much cushion you truly hold and which assumption you are most exposed to.
When a forecast shows a gap, a week where the closing balance dips too low or turns negative, you have lead time and options, in rough order of preference:
- Accelerate inflows. Invoice the day work ships, offer a small early-payment discount, take deposits up front, or tighten collections on overdue accounts.
- Delay or smooth outflows. Negotiate longer supplier terms, align payment dates with collection dates, or defer non-urgent purchases.
- Build a reserve in good weeks. Surplus weeks fund the tight ones, and a forecast tells you exactly how much to hold back.
- Arrange financing before the gap, not during it. A line of credit or working-capital advance is far easier to secure when your forecast shows the need in advance than when you are already short.
That last point is the strongest case for forecasting at all. Financing arranged calmly, weeks ahead, is a different animal from financing scrambled for after a payment has failed. If a temporary gap points toward outside capital, working-capital products for small businesses commonly start around a $10,000 minimum, some are available to owners with FICO scores of 500 and up, and funding is often completed in roughly 24 to 48 hours once approved. If existing advance payments are the pressure, an MCA-relief or reverse-consolidation structure helps only by lowering the daily or weekly payment amount to free up cash; it does not pay off or buy out the underlying balance. No outcome is ever guaranteed. Your forecast is what tells you which lever you need, and when.
Frequently asked questions
What is the difference between a cash flow forecast and a budget?
A budget sets targets for revenue and expenses over a period, usually a year, and answers what you plan to earn and spend. A cash flow forecast answers a different question: when cash will actually be in the account. A budget can show a healthy annual profit while a forecast reveals that in week six there is not enough cash to cover payroll because a large customer pays late. Use the budget to set goals and the forecast to manage liquidity day to day. They work together, but they are not interchangeable.
How far out should a small business forecast cash flow?
Most small businesses run two horizons at once. A 13-week rolling forecast in weekly buckets handles operational decisions, precise enough to catch the specific week rent and payroll collide and short enough that estimates stay realistic. A 12-month forecast in monthly buckets supports planning decisions like hiring, equipment, and tax set-asides. Rolling the 13-week view forward each week, dropping the completed week and adding a new one at the end, keeps a full quarter of visibility in front of you at all times.
How often should I update my cash flow forecast?
Weekly is the practical standard for the 13-week view. Each week, replace that week's estimated figures with what actually happened, add a fresh week onto the far end, and adjust any assumptions that proved wrong. A forecast built once and left alone drifts out of date within a month and quietly stops being trustworthy. Reviewing the variance, the gap between what you projected and what occurred, is also how your estimates get sharper over time.
What are the most common cash flow forecasting mistakes?
Four recur most often. First, forecasting inflows on invoice terms rather than on when customers actually pay, which overstates near-term cash. Second, counting full pipeline revenue instead of weighting it by close probability. Third, forgetting lumpy periodic bills, quarterly estimated taxes, annual insurance, license renewals, that land all at once after months of silence. Fourth, treating the forecast as a one-time document instead of a living one updated with real results each week.
How do I forecast cash flow for a brand-new business with no history?
Without historical data, build the forecast bottom-up from assumptions you can defend, then test them hard. Estimate units or clients per month from realistic market research, not hope; map every known fixed cost, since those you can pin down exactly; and be conservative on both the timing and the volume of inflows. Because your assumptions are unproven, run a downside scenario and hold a larger cash cushion than an established business would. Then update rapidly: as real sales and payment data arrive, replace assumptions with actuals every week.
What should I do when my forecast shows a cash shortfall?
The value of spotting a gap early is the range of options it buys you. Work them roughly in this order: accelerate inflows by invoicing sooner, taking deposits, or tightening collections; smooth outflows by negotiating longer supplier terms or deferring non-urgent spending; draw on a reserve built during surplus weeks; and, if needed, arrange financing before the shortfall arrives rather than after. Securing a line of credit or working-capital funding is far easier when your forecast shows the need weeks ahead than when a payment has already failed.
