Finance

How to Fix Cash Flow Unpredictability for Good

Revenue is up, you're profitable on paper, and payroll still feels like a coin flip. Here's the discipline that turns cash from a mystery into a number you can see coming.

Revenue is up. You closed more work this year than last, the pipeline looks healthy, and on paper you're profitable. So why does Thursday still feel like a coin flip before payroll clears?

That gap — a growing business that still can't predict its own bank balance — is one of the most common reasons owners call us. It says nothing about whether you're good with money. Cash and profit are two different things, and nobody built you a tool that tracks the one that actually pays the bills.

This is a fixable problem, and the fix is a specific discipline rather than a better feeling about your numbers: a rolling 13-week cash flow forecast, maintained weekly, that tells you what your bank account will look like six to ten weeks before it happens. Below is how the unpredictability actually works, the forecast that ends it, and why a static spreadsheet you update "when you get to it" almost always breaks.

Why a growing, profitable business still can't predict its cash

Your profit and loss statement can say you had a great month while your checking account quietly slides toward zero. Both are telling the truth. They're just measuring different things.

Profit is what you earned. Cash is when the money actually moves. A P&L records the sale the day you invoice it. Your bank account only moves on the day the customer pays, which might be 45 days later, if they pay on time at all. Grow fast enough and that timing gap widens instead of closing, because every new job means you're fronting materials, labor, and overhead months before the cash comes back.

When owners tell us "I don't really know my numbers," this is usually what's underneath it. Three specific things drive the unpredictability:

  • AR timing. You did the work in March, invoiced it in April, and the money shows up in June. Your P&L booked it in March. Your cash reality is June. Multiply that across every open invoice and you've lost the thread on when money lands.
  • Margin leaks. A job priced at 30% margin that actually ran at 12% doesn't announce itself. It just quietly consumes cash you thought you'd keep. Without someone watching job-level margin, the leak shows up as a mystery shortfall three months later.
  • Seasonality. Most owner-operated businesses have a rhythm: a slow first quarter, a summer crunch, a year-end rush. If you're not forecasting into those swings, the slow stretch always arrives as a surprise, even though it arrives every single year.

All three are timing problems. Margins can look fine while each one drains the account. And a backward-looking report, which is what a standard P&L or a bookkeeper's monthly close is, can't warn you about timing. It tells you what already happened. By the time it shows a problem, the problem is your problem.

The discipline that fixes it: a rolling 13-week forecast

A 13-week cash flow forecast is a week-by-week projection of the cash you expect to collect and the cash you expect to pay out over the next quarter. The math is not complicated:

Opening cash + expected collections − expected disbursements = ending cash. For each of the next 13 weeks.

The important word is cash. This runs on when money actually moves, not on accrual accounting. Accruals tell you what you earned; the 13-week tells you what you'll have in the bank on a Tuesday in week seven. It's the same tool used in corporate turnarounds and private-equity finance, scaled down to a business doing $500k to $10M in revenue. Thirteen weeks is the sweet spot: far enough out to give you room to act, close enough in that the numbers are still credible.

Built once and left alone, it's a static snapshot that's wrong by next Friday. Built weekly and rolled forward, it becomes an early-warning system. Here's how it comes together:

  • Start from this week's actual cash balance. Real number, from the bank, not the accounting software's guess.
  • Lay out expected collections by week, and tag each one by how likely and how soon it'll actually land. A signed customer paying on terms is not the same as a maybe.
  • Lay out expected disbursements: payroll, vendors, taxes, debt service, owner draws. The predictable outflows are easy; the point is to stop the unpredictable ones from ambushing you.
  • Net it to an ending balance for each of the 13 weeks. Now you can see the low point coming.
  • Roll it forward every week and check the variance. Where did actual cash differ from what you forecast, and why? That question, asked weekly, is what makes the forecast smarter over time.

The variance review is the part most people skip, and it's the part that matters most. A forecast you never check against reality never gets more accurate. A forecast you reconcile every week tightens up fast. The near weeks get very reliable within a month or two, and you start trusting it enough to make decisions on it.

A forecast shows the shortfall. These levers close it.

Seeing a cash dip in week eight is only useful if you do something about it in week two. The forecast buys you the runway; these moves use it:

  • Speed up AR. Chase invoices by age and dollar size, not alphabetically or whenever someone remembers. The oldest, biggest invoices are where your cash is stuck.
  • Early-payment incentives. A small discount, say 1–2% for payment inside 10 days, can pull cash forward when a specific week looks tight. Run the math before you offer it, but it's a real lever.
  • Deposit-forward billing. On project work, collect a deposit up front so you're not financing the whole job out of your own pocket for two months.
  • Bridge financing when the math works. Factoring or a line of credit to cover a known slow-pay gap is a legitimate tool, as long as you've priced the cost and it's cheaper than the alternative.

Which levers matter depends on your business. A contractor carrying long jobs lives and dies on deposit terms and retainage. A services firm on monthly retainers cares more about collection speed. An e-commerce operator is managing inventory cash cycles that neither of the other two think about. There's no generic answer. The forecast tells you which lever to pull, and when.

Why the spreadsheet breaks (and what "real-time" actually means)

Almost every owner we meet has, at some point, built a version of this in Excel. It usually works for about three weeks.

Building the forecast once is easy. Maintaining it every week, on top of running the business, is where it falls apart. The spreadsheet goes stale, you stop trusting it, and you're back to checking the bank balance and hoping. A forecast you don't trust is worse than no forecast, because it gives you false confidence right up until it doesn't.

The difference between a static spreadsheet and a real-time forecast is where the numbers come from. A real-time forecast is connected. It pulls actual bank balances, open invoices, and scheduled payments straight from the systems that already hold them, instead of waiting for someone to key it all in by hand. Your opening balance is always today's real number. Your AR is always the current aging. The forecast updates itself as reality changes, which means it's never three weeks out of date at the exact moment you need it.

This is the piece a lot of fractional CFO work misses. Plenty of advisors will hand you a beautifully built spreadsheet and wish you luck maintaining it. We'd rather build the back office that runs without you: the connected systems and the weekly operating rhythm that keep the forecast alive whether or not you have time to touch it. The forecast is the strategy; the operational plumbing that feeds it is what makes the strategy stick. For owner-operated businesses those two things are one job, and we treat them that way.

What it looks like when it's running

Done right, you stop building the forecast and start reading it. Every Monday you get a one-page view: your beginning balance, projected inflows and outflows for the week, your ending balance, your 13-week runway, one flag if something looks off, and one recommended action. That's it. Five minutes, and you know where cash stands for the next quarter.

The 13-week also connects up to your annual budget. The budget is the plan you set in January; the 13-week is the rolling reality underneath it. When actuals drift from the plan (and they always do), the forecast shows you exactly which week the drift hits your cash, so the budget becomes a live tool instead of a document you filed and forgot.

To be clear about scope: this is finance and operations work, not accounting. We don't do your taxes or touch attest work. You keep your accountant for all of that. What we do is give you a forward-looking view of cash your bookkeeper's monthly close was never designed to provide. It's the kind of forward-looking discipline that separates a fractional CFO for an owner-operated business from a records-keeper, and it sits at the center of the broader fractional CFO services we run. If you want the full mechanics of how the forecast is built, we go deep on it in our 13-week cash flow guide.

Start by finding where the cash actually goes

You can't forecast cash you don't understand yet. That's why we start every relationship with a free QuickBooks grade. We grade your file in five areas, and two of them go straight at this. Data hygiene checks whether your receivables and payables agings match who really owes you and what you really owe. Balance sheet integrity shows whether the cash in the books is the cash in the bank. No catch, and you don't switch accountants. If cash has been a mystery despite a growing top line, that's the fastest way to see why, and to see whether a rolling forecast would end the guesswork for good.

Frequently asked questions

Why can I be profitable and still short on cash?

Profit measures what you earned; cash measures when the money actually moves. Your P&L books a sale the day you invoice it, but your bank account only changes when the customer pays, often weeks later. That timing gap is what makes a profitable business run short.

Why 13 weeks and not a 12-month budget?

A 12-month budget is for planning; the 13-week is for timing and survival. Thirteen weeks is far enough out to give you room to act on a shortfall and close enough in that the numbers are still credible. You want both, because they answer different questions.

Isn't cash flow forecasting my bookkeeper's job?

Bookkeeping records what already happened. Forecasting cash is forward-looking work, closer to what a fractional CFO does. Your bookkeeper's monthly close was never designed to tell you what your bank balance will be six weeks from now.

How accurate is a 13-week cash flow forecast?

The near weeks are highly accurate; later weeks less so. Accuracy improves quickly over the first few months as you reconcile forecast against actuals each week and tighten your assumptions. That weekly variance review is what makes the forecast trustworthy.

Why does building this in a spreadsheet usually fail?

Building the forecast once is easy. Maintaining it every week on top of running the business is where it breaks. The spreadsheet goes stale and you stop trusting it. A forecast connected to your bank and invoicing systems stays current without manual re-keying, which is what keeps it useful.

Does Walden do my taxes as part of this?

No. This is finance and operations work, not accounting. We don't do tax, attest, or compliance work. You keep your accountant for all of that. We give you the forward-looking view of cash that a monthly close doesn't provide.

How do I know where my cash is actually going?

Start with a free QuickBooks grade. We grade your file in five areas, including whether your receivables and payables agings are accurate and whether the balance sheet ties to the bank. It's the fastest way to see why cash feels unpredictable and whether a rolling forecast would fix it.

Read on Walden →