How to Forecast Cash Flow for a Small Business (Step by Step)

Most small business owners check their bank balance and assume that is their cash position. It works until it does not. One slow month, one big bill arriving early, and suddenly you are scrambling to cover payroll.

A cash flow forecast changes that. It shows you where your money is going before it gets there, so you can act early instead of reacting late. Here is exactly how to build one.

Why Cash Flow Forecasting Matters More Than Your P&L

Profit is what you earn. Cash is what you have. Those two numbers are almost never the same, and the gap between them is where businesses fail.

A restaurant in its second year can show a healthy profit margin and still run out of money because customers pay with credit cards that settle in 3 days, suppliers want payment in 15, rent is due on the 1st, and a slow January wiped out the buffer.

A cash flow forecast for a small business gives you a month-by-month view of that gap. You see not just whether you will be profitable, but whether you will have enough cash to cover your obligations when they are actually due. If you are still building that foundation, what cash flow actually means and why it matters is worth reading first.

What You Need Before You Start

You do not need accounting software or a finance background. You need three things: your current bank balance, a list of expected income for each of the next 6 months, and a list of fixed and variable expenses per month.

If you have been running for at least a few months, pull your last 3 bank statements. Your actuals are the best baseline for estimates. Do not guess when you have real numbers to work from.

How to Build a Cash Flow Forecast: Step by Step

Step 1: Set Your Opening Balance

Start with the cash you have right now. If your bank account shows $18,500 today, that is your opening balance for month one. This number anchors everything. Every projection flows from here.

Step 2: Project Your Income Month by Month

List every source of income for each month. Be specific and be conservative.

For a service business billing $20,000 per month: if you typically collect 80% in the same month and 20% the following month, your cash inflow in January is not $20,000. It is $16,000 plus 20% of December's invoices.

If you are projecting a new product launch in month 3, be conservative. Use 60 to 70% of your target number the first time you forecast it. You can adjust upward once you have real data.

Step 3: List Every Expense

Split your expenses into fixed and variable. Fixed costs stay the same every month regardless of revenue. Variable costs move with your sales volume.

A small retail business might have fixed monthly costs like this: rent at $3,200, payroll at $11,500, software subscriptions at $480, and loan repayment at $1,100. Variable costs might include inventory at roughly 35% of revenue and marketing spend between $800 and $1,500 depending on the month.

Do not forget annual or quarterly expenses. Insurance renewal in March, quarterly tax payments in April and June, equipment servicing in September. These irregular spikes destroy forecasts that only think in monthly averages.

Step 4: Calculate Net Cash Flow

For each month: net cash flow equals total income minus total expenses. Add that result to the prior month's closing balance and you get the new closing balance. That closing balance becomes the next month's opening balance.

A simple 3-month example: you start January with $18,500. Income comes in at $22,000, expenses total $19,800, net is +$2,200, and your closing balance is $20,700. In February, income drops to $18,000 but expenses hold at $21,300. Net is -$3,300 and you close at $17,400. In March, income recovers to $24,500 and you close at $22,100.

February looks rough in isolation. But because you forecasted it in January, you have 4 weeks to act before the shortfall arrives.

Step 5: Spot the Danger Zones

Look for months where your closing balance drops below a threshold you are comfortable with. For most small businesses, that is 1 to 2 months of operating expenses held as a reserve.

If your monthly expenses average $19,000, you want at least $19,000 to $38,000 as a floor. Any month where your projected balance dips below that is a warning flag, not a crisis. You have time to respond.

A Real Example: Acme Coffee Co.

Acme Coffee has $22,000 in the bank. Monthly revenue averages $28,000. Fixed costs are $18,500, variable costs add another $7,000 to $9,000 depending on foot traffic.

Without a forecast, the owner sees $22,000 and feels comfortable. With a forecast, she sees that January and February are typically slow months (revenue down about 30%), and that a $4,200 equipment lease payment hits in February. Her projected closing balance in February would be $6,800 — dangerously close to zero.

She has 6 weeks to act. She pre-sells a catering contract, negotiates a 2-month deferral on the lease, and enters February with $14,000 instead.

The forecast did not prevent the slow month. It gave her time to solve it before it became a crisis.

You can build this exact kind of forecast using FlowCast in under 5 minutes. Enter your numbers in a 4-step wizard and it generates the full 6-month projection automatically, including a visual chart and a cash runway indicator that shows how many months until your balance hits zero.

How Often Should You Update Your Forecast?

Update it monthly. At the start of each month, replace last month's estimates with actuals and push your projections forward by one month. This takes 15 to 20 minutes once you have the template built. Over time you get better at estimating and the forecast gets more accurate.

Common Mistakes to Avoid

Using revenue instead of cash. An invoice sent is not cash received. If a client has 30-day payment terms, their payment belongs in next month's inflows, not this month's.

Forgetting irregular expenses. Map out the full year and note every quarterly, semi-annual, or annual payment before you start monthly projections. One forgotten insurance renewal can wreck an otherwise solid forecast.

Being too optimistic. Cut your income estimates by 10 to 15% as a sanity check. If the forecast still looks healthy, great. If it turns negative under conservative numbers, you needed to know that before it happened in real life.

Building it once and leaving it. A forecast from 3 months ago is nearly useless. The whole point is visibility into what is coming next. Keep it current.

Start Your Cash Flow Forecast Today

A cash flow forecast for your small business does not require an accountant or a finance degree. It requires honest numbers and a consistent habit.

Start with your opening balance, estimate 6 months of income, list your expenses, and run the math. If you are weighing a manual spreadsheet against a dedicated free cash flow calculator, that guide covers both approaches. If you want to compare Float, Pulse, and free alternatives side by side, the best free cash flow tools guide breaks down the options. If you want to skip the setup entirely, FlowCast does all of this for you. It is free, takes under 5 minutes to set up, and no account is required to start.