Forecasting should give you clarity—but too often, it just gives you a false sense of security. A spreadsheet with perfect rows, tidy formulas—and zero connection to reality. I’ve made the same mistake—Excel can produce whatever numbers you want. 

It’s not really a forecast. It’s a budget remix with new dates. 

The Problem: Forecasts Become Fiction

Most business forecasts start with good intentions.

But somewhere between “assumptions” and “projections,” they become wishful thinking:

• Sales growth is pulled from last year’s top line with some random growth number
• Expenses are simply spread evenly month to month
• Inventory, labor, and overhead aren’t recalculated monthly
• Cash flow is assumed—or worse, plugged, not modeled

Before you know it, your forecast isn’t telling you what’s likely to happen— It’s telling you what you hope will happen.

And hope is not a cash management strategy. 

If this sounds familiar, you’re not alone. Most leaders don’t mean to build fictional forecasts—they’re just using outdated tools. Fortunately, there’s a better way.

Rolling Forecasts: Your Antidote to Fiction

What I recommend based on my work with business turnarounds — and what we implement with clients—is a rolling 13-week forecast. It’s short-term enough to be actionable and long-term enough to expose red flags.

Here’s why it works:

• Forces weekly discipline and real-time updates
• Tracks actuals vs. forecast each week
• Reveals trends before they become crises
• Improves cash decision-making (timing payables, hiring, CAPEX)
• Builds CFO-level thinking into the day-to-day

It stops the “rearview mirror” reporting mindset and pulls the team into forward-looking leadership.

Three Forecasting Questions I Ask Every Client

1. Where does your forecast come from? Is it a thoughtful, operations-informed plan—or a top-down target retrofitted into Excel?
2. What assumptions have changed? The best forecasts evolve. Your pricing, customer base, labor costs, and lead times are always shifting. If your forecast doesn’t change, it’s not honest.
3. What’s your buffer? I always include a line for “cushion” or “surprises.” Because they’re coming—might as well plan for them. 

What Goes in a Real Forecast?

Every rolling 13-week forecast we build includes:

Forecast Element	Why It Matters
Cash In	Receivables, credit card sales, transfers, and loan draws
Cash Out	Payroll, vendor payments, rent, taxes, operations
Net Cash Flow	Weekly inflow – outflow
Cumulative Cash	Rolling balance—your oxygen meter
Key Drivers	Inventory buys, project starts, tax deadlines
Risks & Assumptions	Timing gaps, major customers, vendor pressures

Forecasting Is a Leadership Tool

A good forecast isn’t just for finance. It drives better decisions across the business:

• When to hire—or pause
• When to take on debt—or pay it down
• When to buy inventory—or wait
• How aggressive to be in collections

And most importantly— It brings focus. It replaces uncertainty with visibility. It turns the fog into a manageable path forward.

Tying It Together: The 13-Week Forecast + The 2HYBP

In a perfect world, your 13-week cash forecast ties directly into your broader financial forecast—giving you both daily visibility and longer-term strategy.

That’s where the Second Half-Year Business Plan (2HYBP) comes in.

Every July, we work with clients to true-up the budget, evaluate actual performance from the first half, and re-forecast the rest of the year with fresh, reality-based assumptions.

It’s not just a financial update—it’s a leadership reset.

Think of the 2HYBP as your mid-year recalibration tool: Forecast meets operations. Strategy meets execution.

We’ll go deeper on this in next month’s post, “Halftime”—but if you’re not taking the opportunity to rethink your second half, now’s the time to start.

Bottom Line:

Your forecast shouldn’t be a best-case spreadsheet that “makes the math work.”  It should be a reality check. Because when you plan from what’s real, not what’s ideal, you lead better.

Want help building your own 13-week forecast or launching your 2HYBP? Let’s talk. I help leaders turn numbers into clarity.