Here’s where a 13-week cash flow forecast shines: There’s a moment every CEO has lived through. Your sales pipeline is finally lined up, revenue is trending and growth actually feels possible. Then someone flags the bank account status and your mood shifts from confident to concerned.
Welcome to the mid-market paradox: you can have strong margins, a healthy backlog, and rising demand… and still feel like cash is evaporating faster than you can generate it.
Listen, here’s what I wish many companies realized ahead of time: growth eats cash. And most CEOs are not operating without the one tool that actually tells them whether they have enough oxygen to sustain it. Forget the KPI dashboard (though we like those too), forget the P&L, get your hands on a 13-week cash flow forecast.
What is a 13-Week Cash Flow Forecast?
A 13-week cash flow forecast is a rolling, weekly projection of cash inflows and cash outflows over the upcoming 90 days or quarter.
A 13-week cash flow forecast highlights what’s about to happen to your bank balance based on real operational behavior.
Think of it as your tactical map for liquidity. A model that pulls data from AR, AP, payroll, inventory purchasing, project schedules, and financing commitments, then shows you how each move impacts cash over the next 90 days.
Why 13 weeks? Because it’s long enough to see danger ahead and short enough to act on it.
Monthly reporting, while important is only a reflection of where you were, not where you’re headed. Annual budgets are outdated by February. But weekly projections force you to live in reality. This is where your budget process from September can work in tandem with your cash flow forecast.
Do We Have Enough Cash?
Whether you articulate it or not, this is the question behind nearly every leadership decision.
- Can we hire a controller?
- Should we add another manufacturing shift?
- Can we place the larger inventory buy to support Q2 demand?
- Can we accelerate the ecommerce re-platform?
- If we buy that new piece of equipment, how much strain on cash will that cause?
When CEOs don’t have a 13-week view, they default to intuition. Intuition works until it doesn’t.
The Hidden Drains of Cash Flow
If you’ve ever wondered why your profit and your cash balance seem to speak different languages, you’re not alone. The biggest cash surprises come from places that don’t show up on your income statement.
You see it all the time in manufacturing and wholesale distribution:
Inventory spikes because demand forecasting isn’t tight. Projects run long, labor overruns accumulate, and no one tells finance until the next costing review.
One of our clients had a moment like this last year. Revenue was up by 19, but their bank balance was falling. A 13-week forecast made the issue obvious: sales had increased so quickly that working capital ballooned. Inventory purchases were outpacing customer payments by six weeks.
Cash hides in the balance sheet. The forecast exposes exactly where. You need both to really get a handle on your financial position.
Related Read: The big 3 financial reports you need each month
5 Things that Make a Good 13-Week Cash Flow Forecast
A lot of companies have something they think is a 13-week forecast, but here are five of the non-negotiables to double-check your forecasting setup:
- Clear, consistent categories for every cash movement
- Assumptions that are actually tied to operational behavior
- Weekly updates with actuals vs projections
- Scenario planning that models the uncomfortable cases, not just the best-case dreams
- A source-of-truth data pipeline that prevents manual errors
This is where tools like Amalgam and a solid outsourced CFO add real horsepower. Pulling data from NetSuite, banks, payroll providers, and sales systems automatically combined with the strategic oversight to steer you in a cash-positive direction.
7 Steps to Create a 13-Week Cash Forecast
Step 1: Start With Actual Cash, Not Accruals
- Your forecast should start with actual cash on hand by bank account. Not AR balances. Not “expected receipts.” Cash that exists today.
- Pull this directly from your bank feeds, not a reconciled report that’s already outdated.
CFO Tip: you’re running NetSuite, don’t rely on the GL alone for these purposes. Bank data gives you truth faster than your close process ever will.
Step 2: Map Expected Cash Inflows by Timing
Break inflows down into:
- Customer receipts (based on real payment behavior, not terms)
- Subscription or recurring revenue
- Refunds, rebates, or credits
- Other one-off inflows
Use historical payment patterns to adjust expectations. If a customer pays in 52 days, calling them Net 30 doesn’t change reality.
This is where automated tools like Amalgam earn their keep: pulling AR aging, bank deposits, and historical trends into one view.
Step 3: Forecast Outflows Ruthlessly
Cash outflows include:
- Payroll and payroll taxes
- Rent and fixed overhead
- AP by vendor and due date
- Debt service
- Inventory purchases and freight
- CapEx and one-time payments
CFO Tip: Do not smooth expenses. “Lumpy” cash is real cash.
If you “average” payroll or inventory, you’ll miss the exact week cash gets tight which defeats the point of the model.
Step 4: Build Weekly, Rolling Updates
A 13-week forecast should roll weekly:
- Drop the completed week
- Add a new week at the end
- Refresh assumptions based on what actually happened
Progress over perfection. The forecast improves because reality keeps correcting it.
Step 5: Pressure-Test Scenarios
Once the base forecast is stable, start asking questions:
- What happens if collections slip by 10 days?
- What if we delay a vendor payment?
- What if we accelerate inventory buys?
- What if revenue underperforms plan for 30 days?
Scenario modeling turns the forecast from a report into a decision tool. Here’s where, with the right prompts AI can really shine.
Step 6: Use the Forecast in Leadership Conversations
If the forecast lives only in finance, it will die there. Use it wisely to drive decision-making (otherwise what’s the point, really?):
- Weekly leadership meetings
- Lender and covenant discussions
- Hiring and investment decisions
- Board updates
At expandCFO, this is why we pair NetSuite data with Amalgam, to keep the forecast dynamic, current, and credible enough for executives to trust.
Step 7: Treat Cash as a Strategy, Not a Safety Net
The goal here is to control timing so growth doesn’t create risk.
When cash visibility improves, confidence follows and decisions get faster. Check out our examples below.
How to Use the Cash Flow Forecast to Make Smarter Decisions
Think of the 13-week cash flow forecast as a leadership tool.
Once you see your liquidity over the next 90 days, decisions become sharper.
- You know exactly how fast you can hire without getting ahead of cash.
- You negotiate vendor terms with confidence because you understand your cash conversion cycle
- Capital investments are based on reality
- The sales team definitively knows what the business can and cannot support.
- You anticipate shortfalls early enough to secure financing instead of scrambling.
Lenders love companies that run a 13-week model. So do boards. So do COOs. Cash clarity increases your credibility and your finance ops.
The Weekly Rhythm: The Most Underrated Value Driver
The model itself is only half the benefit. The cadence is where the discipline is built.
Every week you compare what you thought would happen to what actually happened. That simple ritual forces accountability across the entire business. Your AR collections cadence improves, AP becomes strategic instead of reactive, inventory purchasing tightens, project managers become aware of how delays impact cash.
The Gaps that a Cash Flow Forecast Can Expose
Weekly check-ins with your cash forecast can uncover:
- Pricing inefficiencies.
- Inventory practices that are draining liquidity (see below example).
- Revenue plugs
- Internal process breakdowns
Common cash flow forecast issues
Most mid-market companies try to build a 13-week forecast and give up after three to five cycles. Not because they don’t care about cash, but because they run into these forecast issues:
No one owns the model
Stale Data
No cross-department visibility
Excel breaks
Irregular reporting cadence
Assumptions drift
It’s why an external team, especially one that lives in NetSuite and uses automation tools, can maintain the rigor that internal teams can’t sustain.
What the First 90 Days Look Like with expandCFO
When we drive a 13-week model, this includes:
- Integrating NetSuite, bank feeds, and operational data
- Building a forecasting engine tailored to your business model
- Mapping your GL, purchasing cycles, collection patterns, payroll timing, and fixed obligations
- Drafting your first 13-week forecast with assumptions clearly documented
- Identifying red flags and opportunities you likely haven’t seen before
- Walking the CEO and leadership team through the next 90 days of cash reality
It’s not uncommon for companies to uncover significant opportunities to free up cash simply by tightening working capital. The forecast often pays for itself long before the quarter ends.
Client Case Example
Running through the first 90 days with a new clients we uncovered 2,500 units in backlog. Demand was strong. Cash felt tight month to month.
Almost all their cash is received when they ship. And they were shipping under 400 units a month. At that rate, it would take 7 months to clear the backlog, without a single new order coming in. Yikes, am I right?!
And of course their fixed costs (payroll, overhead) were still burning up cash in the background. Plus you can imagine how that affects your customer relations.
Here are 3 takeaways we gained from running the 13-week forecast:
- Backlog = Cash trap. If you’re sitting on finished goods or partially kitted product, you’re sitting on cash that hasn’t cleared your bank account yet.
- Calculate your throughput ROI. Sometimes the best investment isn’t more marketing, it’s more capacity. Run the math: hiring one more technician or production team could unlock hundreds of thousands in cash.
- Short-term boost, long-term gain. A temporary staffing ramp or operational push to clear backlog might feel expensive… but stretch it over 7 months of fixed costs, missed sales, and frustrated customers, and it’s likely the cheaper option.
Expand your cash visibility
Consider predictable cash flow to be a prerequisite for growth to ensure your company’s stability. CEOs need clarity, control, and a model that shows precisely what the next 90 days will require.
The 13-week cash flow forecast is that model. It gives leaders the visibility to make bold moves without gambling the company.
If you want to know what your next 13 weeks look like using your actual data, we can show you. Most CEOs discover more opportunity than risk once the numbers finally come into focus. Learn more about our outsourced CFO services.
