How to Create a Simple Cash Flow Forecast for Your Small Business

A cash flow forecast is exactly what it sounds like: an estimate of how much cash will come into and leave your business over a future period. The value isn't precision — it's early warning. A forecast that's 80% accurate gives you weeks of runway to act on a potential cash shortage that would otherwise hit you as a surprise.

Most small business owners skip forecasting because it sounds complex. The version we'll build here takes about 30 minutes to set up and 15 minutes a month to maintain.

What You're Building

A cash flow forecast has three inputs per time period (week or month):

1. Cash in: Money you expect to receive — client payments, recurring revenue, other income
2. Cash out: Money you expect to pay — rent, payroll, suppliers, subscriptions, taxes, loan payments
3. Net cash flow: Cash in minus cash out

Add net cash flow to your opening balance and you get your closing balance. The closing balance of one period becomes the opening balance of the next. A negative closing balance means you've run out of money — now you know in advance instead of when the payment fails.

Step 1: List Your Expected Cash Inflows

Go through your unpaid invoices and expected income for the next 1–3 months. For each one, estimate when it will actually land in your bank account:

• Outstanding invoices: when are they due? Add a buffer for clients who typically pay late.
• Recurring retainers or subscriptions: when do they bill?
• Upcoming project payments: when do you expect to invoice, and when will payment arrive?
• Any other expected income: refunds, asset sales, loan proceeds, owner investment

Be conservative — if a client has a history of paying late, forecast the later date.

Step 2: List Your Expected Cash Outflows

Go through your known upcoming expenses:

• Fixed recurring costs: rent, loan payments, insurance premiums — exact amounts and due dates are known
• Payroll: if you have employees or contractors paid on a regular schedule
• Tax payments: quarterly estimated taxes, VAT or sales tax remittances, any known annual obligations
• Variable costs: supplies, services, software you expect to purchase
• One-time upcoming costs: equipment, events, anything you're planning to spend on

Your bank statement from the past three months is a good reference for what you typically spend — most expenses recur.

Step 3: Build the Forecast

A simple monthly structure:

                   July      August    September
Opening balance  $12,400   $14,800   $8,200
Cash in           $28,000   $18,500   $24,000
Cash out         −$25,600  −$25,100  −$24,800
Net cash flow      $2,400   −$6,600    −$800
Closing balance  $14,800    $8,200    $7,400

This forecast shows that August is a tight month — revenue dips while expenses stay roughly flat. Knowing this in July gives you time to: chase outstanding invoices for early payment, defer non-essential expenses from August to September, or draw on a credit line if needed. None of these options are available if you discover the crunch in August when it's already happening.

Step 4: Update It Monthly (or Weekly)

At the start of each month:

• Replace estimates with actuals for the month just completed
• Roll the forecast forward one month
• Note where the forecast was significantly wrong and adjust your assumptions

A 15-minute monthly refresh keeps the forecast useful. Without it, the numbers go stale and the forecast loses its value.

What to Look For in Your Forecast

Negative closing balance: A cash crunch is coming — act now.

Consistently low balance: Not technically negative, but dangerously thin. Any unexpected expense could push you negative. Build the reserve.

Large receivable-dependent months: If a single month depends heavily on one large payment coming through, flag the risk. What happens if it's a month late?

Seasonal patterns: Do certain months reliably look worse? Plan cash reserve accumulation accordingly.

The Bottom Line

A cash flow forecast is one of the highest-value financial tools a small business owner can maintain, and it doesn't require sophisticated software — a spreadsheet with three rows is enough to start. The goal isn't accuracy to the dollar; it's visibility far enough in advance to have options. For the full guide to managing cash flow, see our hub: Cash Flow Management for Small Businesses.