Cash Flow Forecast: How to Build a 12-Month Rolling Forecast, Step by Step

Cash Flow Forecast How-To: Five Steps to See the Gap Three Months Early

A cash crunch is never bad luck—it’s a calculation nobody ran early enough. Here’s how to build a cash flow forecast: one sheet laid out month by month—write down opening cash, place inflows by when customers actually pay, lay out every outflow, then derive closing cash month after month, until the gap surfaces as a negative number three months before it hits. Update it at each month-end and it rolls a full 12 months ahead.

You may know this picture: Chen, a construction-materials owner doing RM30M a year, wins a big contract in March and pays his supplier RM800K upfront—then the client says payment comes 90 days after sign-off. By June the account holds RM120K against RM650K of payroll and supplier bills due at month-end. Let’s build the sheet, step by step, so June’s hole shows up back in March—where you can still do something about it.

The Belief That Quietly Kills Owners: “I’ll Know When Cash Gets Tight”

Plenty of owners think the bank balance is enough—when cash really starts running low, they’ll feel it, and they’ll sort it out then.

Here’s the flaw: it forces you to discover the gap only at the moment it lands. By the time you “feel” it, payroll is due next week and the supplier is calling today. Your only moves left are high-interest borrowing, begging a customer to pay early, or cutting orders. Every one of those is expensive.

But a cash crunch is never a natural disaster, and it’s not a sign that you’re a poor operator. It’s a number you can calculate in advance. Every time you win a contract, pay for materials, or collect a payment, the timing of that money is knowable. And if the timing is knowable, you can lay it out on a single sheet—and the gap reveals itself early, on its own.

Put differently: you didn’t get unlucky and hit a cash crunch. There was simply never a sheet on the desk that shows it coming three months out. That sheet is what we mean by calculating before you commit—before you take a contract, you run how its money will flow in and out over the next 12 months.

How to Build a Cash Flow Forecast: Five Steps, One Sheet

The heart of a cash flow forecast is a single table laid out month by month. Across the top: the next 12 months. Down the side: five things—opening cash, inflows, outflows, net cash flow, and closing cash. Let’s build it one step at a time.

Step 1: Write Down Your Opening Cash

The easiest step. Open your banking app, add up the cash across every account today, and that number is the “opening cash” for month one. Count only cash you can actually use—fixed deposits, security bonds, and receivables not yet collected don’t count.

Say Chen has RM500K across his accounts today. His opening cash for July is RM500K.

Step 2: Lay Out Inflows by When You Collect, Not When You Invoice

This is where most owners get the whole sheet wrong. Many people treat the month they raise the invoice as the month the money arrives—a serious error. A cash flow forecast must place inflows in the month the customer’s money actually lands in your account.

Chen raises a RM1M invoice in July with 90-day terms, so that RM1M does not belong in July—it belongs in October. Same logic across the board:

• Retail collected on the spot → inflow in the same month
• A customer on 30-day terms → inflow the following month
• Construction released 90 days after sign-off → inflow three months later
• A deposit-based business → deposit in the month it’s taken, balance in the delivery month

Place every expected future inflow over the next 12 months into the month it truly arrives. Get this step right and your forecast actually means something.

Side note: to have a consultant check your inflow timing and find which month your own gap is hiding in, start with the free AI profit diagnosis — a real consultant, 30-45 minutes, no hard selling.

Step 3: Lay Out Every Outflow

Outflows are easier than inflows, because most of them are fixed and predictable:

Fixed monthly outflows (example):
Payroll + EPF/SOCSO   = RM180K/month
Rent & utilities      = RM40K/month
Supplier purchases    = varies with orders won
Loan / hire-purchase  = RM30K/month

Plus lumpy outflows (critical—don't miss these!):
SST payment           = every two months
CP204 income tax       = instalments
Year-end bonus        = once, in December
Annual insurance      = once, in one month

The reason most cash flow forecasts miss is that owners leave out these lumpy, irregular outflows: tax, bonuses, annual fees, equipment. You don’t see them most of the time, and then the month arrives and they land like a punch. Every one of them goes into the sheet.

Step 4: Derive Closing Cash for Each Month

With the first three steps in place, step four is pure arithmetic. The formula for each month is:

Closing Cash = Opening Cash + Inflows − Outflows

And: this month's Closing Cash = next month's Opening Cash

Roll it forward month by month and all 12 months of closing cash fall out. Here are three months of Chen’s example laid out:

              July        Aug         Sep
Opening cash  500K        420K        180K
+ Inflows     300K        200K        150K
− Outflows    380K        440K        650K
─────────────────────────────────────────
Closing cash  420K        180K       −320K  ⚠️

See it? By the end of September, closing cash is negative RM320K. That’s the exact hole Chen ran into—except now he’s seeing it back in July.

Step 5: Spot the Gap Three Months Early and Act Now

The negative cell is your cash gap. The moment a month turns negative on the sheet, you’ve just bought yourself several months of reaction time instead of panicking at month-end. Seeing that September will be RM320K short, in July you can already: renegotiate supplier terms, ask the customer to release payment earlier, line up a standby overdraft facility, or simply re-pace which contracts you take.

Update it at the end of every month—drop the month that’s passed, add a new twelfth month—and the sheet becomes rolling: always looking 12 months ahead. That, in full, is the point of a 12-month rolling cash flow forecast.

Three Things an Owner Can Do This Week

No software to buy, no consultant to hire—one spreadsheet, starting this week:

1. Open a sheet, lay 12 months across the top, and enter your opening cash from Step 1. Get the skeleton up first, then fill it in.
2. Drop in your known inflows by the month they actually arrive. Go through your contracts and invoices, read the terms on each, and place them in the right month—remembering it’s the collection month, not the invoice month.
3. Lay out every outflow, especially the lumpy ones: tax, bonuses, annual fees. Finish this step and the negatives will surface on their own.

Building this sheet into a system—and learning to read the gap three months out—is exactly what we walk owners through hands-on in our working capital optimization service and the Budget Management (3+1)-Day Program. For why the gap deserves a full 90 days of warning—and the system behind it—read cash flow prediction: the early-warning method.

FAQ

How do you build a cash flow forecast? What are the basic steps?

Build a cash flow forecast as a table laid out month by month, working through five steps. First, write down opening cash (the usable cash in your accounts today). Second, lay out inflows by the month the customer actually pays you, not the month you raise the invoice. Third, lay out every outflow—payroll, materials, rent, plus lumpy items like tax, bonuses, and annual fees. Fourth, derive each month with “Closing Cash = Opening Cash + Inflows − Outflows,” carrying one month’s closing cash into the next month’s opening cash. Fifth, look for any month where closing cash turns negative—that’s your cash gap. Update it at each month-end so it rolls forward a full 12 months.

How is a cash flow forecast different from a P&L?

A P&L measures how much you earn and records on an accrual basis—revenue is booked when the invoice is raised, whether or not the money has arrived. A cash flow forecast measures when money actually moves in and out of the account, recorded by when cash truly lands. A profitable contract where the customer pays in 90 days while the supplier wants paying today looks fine on the P&L but produces a gap on the cash flow forecast. You need both, but the one that lets you sleep at night is the cash flow forecast.

Why build a 12-month rolling cash flow forecast instead of a one-off annual one?

Rolling means that at each month-end you drop the month that has passed and add a new twelfth month, so the forecast always looks a full year ahead. A one-off forecast you build and forget drifts out of step with reality within two or three months, because actual collections and actual spending change. Rolling updates keep a live 12-month map of your cash in hand, so a gap in any month surfaces at least several months early instead of arriving by surprise.

A Cash Crunch Isn’t Luck—It’s What Never Got Calculated in Advance

Chen now builds this sheet and runs every contract through it before he commits. The next time a big order came in, he saw at a glance that month four would be short, negotiated staged payments with the customer in advance, and never touched that 1 AM payroll panic again. A cash crunch is never a disaster that befalls you—it’s the absence of a sheet that would have calculated it for you in advance.

To find out which month over the next 12 your business will run short, and how to fill it before it happens, book a strategy call with us, or sign up for the Budget Management (3+1)-Day Program and we’ll build the sheet on your own numbers.

Book a Cash Flow Strategy Call

Explore Working Capital Optimization