Pro free for 30 days.No card.Start free →

Cash flow forecasting for a small business: a simple step-by-step guide

Profit is not cash. Learn how to build a simple 13-week or 12-month cash flow forecast, set a minimum cash level, spot shortfalls weeks ahead, and keep the forecast useful with a short weekly and monthly review.

By WorkBOS Content Desk6 min read
Stack of silver coins resting on a spread of banknotes (Photo by stevepb on Pixabay)
Photo: stevepb / Pixabay

Profit and cash are not the same thing. A business can show a profit on paper and still run out of money to pay rent or payroll, simply because customers pay later than suppliers need to be paid. A cash flow forecast is the tool that shows that gap before it happens.

This guide walks through how to build a simple forecast for a small business, how to read it, and what to do when it shows trouble. You do not need special software to start; a spreadsheet and an hour will do. This is general information, not professional financial advice.

What a cash flow forecast is (and is not)

A cash flow forecast is a projection of the amount and timing of money coming in and going out over a set period. Extension guidance from Oklahoma State University describes a cash flow plan as a recorded projection of all cash inflows and outflows, and says it helps you spot problems in meeting obligations and see when cash is available to invest.

It is not a profit and loss statement. It only counts cash that actually moves, on the day it moves.

Forecast vs budget vs statement

  • Cash flow statement: looks back at what happened.
  • Forecast: looks forward at when money will arrive and leave.
  • Budget: sets spending and income targets (see building a simple budget).

SCORE, the SBA-backed mentoring network, recommends preparing a cash flow statement at each month-end and a forecast projecting the next month, quarter or year, using customer payment patterns, sales projections and expected expenses.

Before you start: gather your numbers

You need four things:

  1. Your opening cash balance across all business bank accounts.
  2. Past sales and collection patterns: how long customers typically take to pay.
  3. Fixed obligations: rent, payroll, loan payments, insurance, software, taxes.
  4. Planned or likely changes: a new hire, a big purchase, a seasonal swing.

If you keep the books on a cash method, the SBA notes that it shows cash flow clearly, while accrual can give a more immediate snapshot of the business. Either way, a forecast is about when cash moves, so base it on payment dates, not invoice dates.

How to build a simple 13-week or 12-month forecast

Pick a horizon. A weekly view for the next 13 weeks suits businesses with tight cash; a monthly view for 12 months suits steadier ones. Many owners keep both.

Step 1: List cash coming in

  • Customer payments (by expected payment date)
  • Deposits and advance payments
  • Loan proceeds or owner contributions
  • Other receipts (refunds, interest)

Step 2: List cash going out

  • Payroll and contractor pay
  • Rent and utilities
  • Supplier bills (by due date)
  • Loan repayments
  • Taxes (see estimated taxes)
  • Insurance, software, subscriptions
  • One-off purchases

Step 3: Calculate the running balance

For each period:

Opening balance + cash in − cash out = closing balance

The closing balance becomes the next period's opening balance.

Step 4: Set a minimum cash level

Pick a floor, a balance below which you would be uncomfortable. Oklahoma State's guidance describes a minimum desired balance and borrowing to cover a gap when the balance falls below it. SCORE suggests building savings to cover roughly three to six months of expenses, starting small and increasing over time.

An example

| | Week 1 | Week 2 | Week 3 | Week 4 | |---|---|---|---|---| | Opening cash | $8,000 | $6,500 | $3,200 | $4,700 | | Customer payments | $2,000 | $1,500 | $6,000 | $1,000 | | Payroll | (3,000) | | | (3,000) | | Rent | | (3,500) | | | | Supplier bills | (500) | (1,300) | (4,500) | (1,200) | | Closing cash | $6,500 | $3,200 | $4,700 | $1,500 |

The business looks fine on average, but week four leaves only $1,500. If your minimum is $3,000, you now know three weeks ahead that you need to collect faster, delay a purchase or arrange credit.

Make the forecast realistic

  • Use payment behavior, not hope. If a client who is invoiced on Net 30 usually pays on day 45, forecast day 45.
  • Be careful with catch-all categories. Oklahoma State warns that vague lines such as "Supplies" make estimates less accurate.
  • Include irregular costs. Annual insurance, taxes, equipment repairs and licenses should be spread or entered in the right month.
  • Run three versions. A base case, a cautious case (sales down, payments slower) and a good case. Plan around the cautious one.
  • Check your assumptions against last year. Fill in last year's actuals first as a reasonableness check, as the Oklahoma State guidance suggests.

Review and update on a schedule

A forecast is only useful if it stays current.

  1. Weekly (10 minutes): replace forecast numbers with actuals and add the next week.
  2. Monthly (30 minutes): compare forecast to actual, find the biggest differences, and adjust your assumptions. The U.S. Chamber of Commerce likewise advises monthly or quarterly reviews that compare actual results with planned figures and look for the cause of each big gap.
  3. Before big decisions: test a hire, purchase or expansion by adding it to the forecast first. See our cost-benefit check.

The SBA also advises confirming you can still cover operating expenses before paying cash for assets, and assigning someone to manage available cash, accounts receivable and accounts payable.

What to do when the forecast shows a shortfall

  • Speed up money in: invoice sooner, shorten terms, ask for deposits, follow up on late invoices (see getting paid faster).
  • Slow money out: negotiate payment dates with suppliers, spread purchases, pause non-essential spending.
  • Arrange a buffer: SCORE suggests setting up a business line of credit while your finances are healthy, and using it only when needed.
  • Adjust growth plans: SCORE notes that rapid growth, such as hiring for a new contract, can strain cash when customers pay on long terms.

Common mistakes

  • Forecasting sales, not receipts. A sale in March may be cash in May.
  • Forgetting taxes and owner pay. These are real outflows.
  • Never comparing forecast with actuals. Without feedback, errors repeat.
  • Making it too complicated. A one-page sheet you update beats a perfect model you never open.
  • Ignoring slow-paying customers. One large late invoice can wipe out a month.
  • Waiting until you are short. Lenders and suppliers are easier to deal with before a crisis.

How WorkBOS can help

WorkBOS does not predict your cash for you, and a forecast still needs your judgment. What it does is keep the inputs in one place: invoicing shows what customers owe and what is overdue, project budgets versus actuals show cost trends, and the CRM pipeline lists deals that may turn into invoices. Automations can send reminders about overdue invoices, with AI agents acting only after a person approves. Compare plans on the pricing page, and see the docs for set-up steps.

Frequently asked questions

Q: How far ahead should a small business forecast? A: Many use 13 weeks for tight cash management and 12 months for planning. Start with whichever you will actually update.

Q: Is a cash flow forecast the same as a budget? A: No. A budget sets targets for income and spending. A forecast predicts when cash will actually arrive and leave, which depends on payment timing.

Q: Do I need accounting software? A: Not to begin. A spreadsheet works, and accounting software can later pull in invoice and bill data automatically.

Q: What if my income is very uneven? A: Use the cautious scenario, keep a larger cash reserve, and forecast by week so you can see the low points.

Q: How much cash should I keep in reserve? A: SCORE suggests roughly three to six months of expenses, built up gradually. The right amount depends on your business and risk.

Sources are linked in the text above: U.S. Small Business Administration, Oklahoma State University Extension, SCORE.

Run it all from one place

Projects, clients, finance, people and AI employees in one system. Start free, no card needed.

Start free →