How to Create a Cash Flow Forecast (Step-by-Step)

You landed a $40,000 contract, invoiced it, and celebrated a record month on paper. Then payroll hit on the 15th, a supplier deposit came due, and your business checking account showed $1,900. The contract was real, the profit was real — but the cash wasn't there yet because the client pays on net-45 terms. This gap between profit and cash is exactly why profitable businesses still bounce payments and miss payroll.

A cash flow forecast fixes that blind spot. It maps the timing of every dollar so you can see a shortfall three or six weeks before it lands — while you still have room to chase an invoice, delay a purchase, or draw on a line of credit. This guide walks through building one step by step, with a working example you can copy into a spreadsheet today.

What a Cash Flow Forecast Actually Is

A cash flow forecast is a forward-looking schedule of the cash you expect to receive and spend over a set period, usually laid out week by week or month by month. It answers one blunt question: Will I have enough money in the bank to cover what's due?

Cash Flow vs. Profit

Profit is an accounting concept — revenue earned minus expenses incurred, regardless of when money changes hands. Cash flow is literal: what's in the account. You can be highly profitable and still insolvent if your customers pay slowly while your bills arrive quickly. That timing mismatch is the number one reason healthy-looking businesses hit a wall.

Rule of thumb: A profit-and-loss statement tells you if the business model works. A cash flow forecast tells you if you'll survive next month.

Step 1: Choose Your Time Horizon

Pick a window that matches how fast your situation changes. The most common formats are:

• 13-week rolling forecast — the small-business standard. One full quarter of weekly detail gives you enough runway to act on problems.
• 12-month monthly forecast — better for annual budgeting, hiring plans, and loan applications.
• Daily forecast — only if your margins are razor-thin or you're managing a cash crunch right now.

Weekly is the sweet spot for most owners. Monthly hides the mid-month gaps where payroll and rent cluster.

Step 2: Start With Your Opening Cash Balance

Open your business bank account and record the actual cleared balance today. Not the balance including uncashed checks or pending deposits — the real, spendable number. This is your starting point for week one. Every week after that, your opening balance is simply the prior week's closing balance.

Step 3: Project Cash Coming In

List every source of money you expect and, critically, when it will actually land. Base this on payment terms and your customers' real behavior, not your invoice date.

• Customer invoice payments (adjust for typical late-payment patterns)
• Cash and card sales
• Loan drawdowns or owner capital injections
• Tax refunds, grants, or interest

Be Honest About Timing

If a client is on net-30 terms but historically pays in 45 days, forecast 45. Optimistic timing is the fastest way to make a forecast useless.

Step 4: Project Cash Going Out

Now list every payment, grouped so nothing slips through:

• Fixed costs — rent, loan repayments, software subscriptions, insurance
• Variable costs — inventory, materials, shipping, contractor fees
• Payroll and payroll taxes — usually your largest and least flexible outflow
• Owner draws, tax set-asides, and one-off purchases

Assume outflows happen on their due date. Vendors rarely wait; plan as if they won't.

Step 5: Calculate Net Cash Flow and Closing Balance

For each period the math is simple:

1. Opening balance
2. Plus total cash in
3. Minus total cash out
4. Equals closing balance (which becomes next period's opening balance)

A Worked Example

Here's a simplified four-week forecast for a small design studio starting with $8,000 in the bank:

Notice week 2: cash drops to $4,100 because a big payroll run lands before a large client payment arrives in week 3. The forecast flags that dip in advance — giving the owner time to nudge the week-3 client to pay early, or delay a discretionary purchase. Without the forecast, week 2 would have been a nasty surprise.

Step 6: Stress-Test With Scenarios

A single forecast is a best guess. Build two more:

• Conservative case — assume your two biggest customers pay 30 days late.
• Downside case — assume a 20% drop in sales for a quarter.

If the downside case runs your balance negative, you know exactly how much of a cash buffer or credit line you need before it happens.

Step 7: Update It Every Week

A forecast is only useful if it's current. Each week, replace your estimates with actual figures, roll the window forward one week, and compare forecast to reality. Over a month or two you'll learn where your estimates drift — usually optimistic on collections — and your accuracy will climb fast. Keeping clean books makes this painless; if your records are messy, tightening up your Bookkeeping & Accounting is the first step. For deeper cash discipline, pair this with the tactics in our Cash Flow Management resources.

Frequently Asked Questions

How far ahead should a cash flow forecast look?

Thirteen weeks is the practical standard for small businesses — long enough to see problems coming, short enough to forecast with reasonable accuracy. Add a rolling 12-month view for planning and financing conversations.

What's the difference between a cash flow forecast and a budget?

A budget sets targets for revenue and spending over a period. A cash flow forecast tracks the timing of actual money movement so you know whether you can pay your bills each week. You need both, but the forecast is what keeps you solvent.

Do I need special software to build one?

No. A spreadsheet handles it perfectly for most businesses. Accounting tools can automate the data, but the logic — opening balance, in, out, closing — is identical either way.

What if my income is unpredictable?

Forecast conservatively: assume lower income and on-time expenses. Build a larger cash buffer and update weekly. Irregular income is exactly the situation where a forecast helps most, because it reveals the lean weeks in advance.

How often should I update the forecast?

Weekly for a 13-week forecast. Replace estimates with actuals, roll forward one week, and note where reality differed from your projection.

The Bottom Line

A cash flow forecast turns the scariest question in business — "will the account cover what's due?" — into something you can answer with confidence weeks ahead of time. Start with today's real bank balance, layer in honest timing for what's coming in and going out, and update it every week. It takes an hour to build and a few minutes to maintain, and it's the single most effective tool for making sure a profitable business never runs out of cash.

Disclaimer: This article is for general informational and educational purposes only and does not constitute financial, tax, or accounting advice. Consult a qualified professional about your specific situation.