💷 Build a Cash Flow Forecast in 7 Easy Steps

Many small business owners avoid building a cash flow forecast. They believe it is a job for an accountant, or that it needs complex software. This belief is wrong, and it is an expensive one. Businesses do not usually fail because they are unprofitable. They fail because the cash runs out before a bill is due, or before payroll needs to go out.

A cash flow forecast is simply a plan for your money. It answers one question: will you have enough cash in the bank on the days you need it? This post gives you a plain-language, repeatable framework. Follow these seven steps, and you will have your first cash flow forecast built before the end of the week 😊

The first decision is how far ahead, and in what size steps, you want to look.

There are two common choices:

A good rule of thumb: the tighter the cash, the shorter the time period should be. If you are unsure, start with a 13-week rolling forecast. This gives you a full quarter of visibility, broken into weekly steps small enough to spot a problem early.

Before you can forecast forward, you need a true starting point. This means the actual balance sitting in your bank account today, not the profit figure shown on your accounting software.

Profit and cash are not the same thing. A business can show a healthy profit on paper while the bank account is nearly empty, because profit includes invoices that have not yet been paid. Your forecast must start from the real number: what is in the bank right now.

This single figure anchors everything that follows. Every other number in the forecast builds on top of it.

Now list the cash you expect to come in, period by period.

Be realistic about timing. Use the date you expect to actually receive payment, not the date you raise the invoice. A customer who takes 30 days to pay does not put cash in your account on the invoice date. It arrives a month later, and your forecast should reflect that.

Include:

A simple example, using a two-week window:

Next, list every cash outflow across the same time buckets you used for inflows.

Split these into two groups:

Do not forget the outflows that are easy to overlook because they do not happen every week: tax payments, VAT, and loan repayments. These are often the ones that catch a business owner by surprise, because they arrive as a large lump sum rather than a steady weekly cost.

With inflows and outflows both mapped, you can now calculate your net cash position for each period. The formula is simple:

Opening balance + inflows − outflows = closing balance

The closing balance for one period becomes the opening balance for the next. Roll this forward, period by period, across your whole forecast.

This is the step where the forecast earns its keep. A single week where outflows are higher than inflows is not usually a problem. But if you see the closing balance turning negative in week 6, you now have five weeks of warning to act, instead of finding out on the day payroll bounces.

A forecast built on one single set of assumptions is fragile. Think of it like a bridge. Engineers do not design a bridge to hold exactly the expected traffic. They build in a safety margin, so the bridge still stands if the load is heavier than planned.

Your forecast needs the same safety margin. Build two extra columns alongside your main forecast:

Run the numbers for the worst case. If your worst-case scenario still leaves you with enough cash to cover the essentials, you know your buffer is strong enough. If it does not, you have found a weakness before it became a real crisis.

A cash flow forecast is not a report you build once and file away. It is a habit, similar to checking the weather before a long drive. Conditions change, so you check again.

Each week, compare what actually happened against what you forecast. Where the two differ, ask why. Did a customer pay later than expected? Did a cost come in higher than planned? Use these differences to sharpen your assumptions for the weeks ahead.

A simple weekly review checklist:

A cash flow forecast does not need a finance degree. It needs seven steps, a spreadsheet, and thirty honest minutes.

Block time in your diary this week. Open a blank spreadsheet, pull your real bank balance, and work through the seven steps in order. Do not aim for a perfect forecast on the first attempt. Aim for a first draft, then improve it every week using Step 7.

TLDR: A cash flow forecast is a simple seven-step plan, built in a spreadsheet, that shows whether your business will have enough cash in the bank on the days it needs it.