The restaurant owner — I'll call him Marcus — had been in business for four years. His Sugar Land location was consistently busy. His accountant told him he was profitable. And yet, every month, Marcus found himself stressing about making payroll, wondering why his credit card balance kept climbing, and feeling like he was running faster just to stay in place.
When he came to us, the first thing he said was: "My P&L says I'm making money. My bank account says something different. One of them is lying."
Neither was lying. Both were telling partial truths. The problem was timing — and a 13-week cash flow forecast made it visible in a way that nothing else had.
The Problem: Profitable on Paper, Broke in Practice
The P&L statement is an accrual-basis document. It recognizes revenue when it's earned and expenses when they're incurred — regardless of when cash actually moves. A restaurant like Marcus's might record $40,000 in catering revenue in March, but if that invoice is net-30, the cash doesn't arrive until April. Meanwhile, the food cost, labor, and supplies that supported that catering event were paid in March.
This timing mismatch is the source of the "profitable but cash-strapped" paradox that I see in small businesses across Houston every week. It's especially pronounced in:
- Restaurants and food-service businesses with large catering or event components
- Service businesses that invoice on completion (contractors, consultants)
- Seasonal businesses with high Q4 revenue but year-round expenses
- Any business carrying significant inventory or equipment loans
The P&L is not wrong. But looking at it alone is like navigating a city using only an elevation map. You know the terrain, but not where the traffic is.
What Is a 13-Week Cash Flow Forecast?
A 13-week cash flow forecast is exactly what it sounds like: a week-by-week projection of every dollar expected to come in and every dollar expected to go out over the next quarter. The 13-week (roughly 90-day) window is the standard used by turnaround advisors, lenders, and CFOs for one simple reason: it's long enough to be meaningful but short enough to be accurate.
Unlike a P&L, which reports history, or an annual budget, which projects far into an uncertain future, the 13-week model lives in the near term where you can actually act on what it shows you. Every week, you update it — rolling it forward one week — so it's always reflecting your current reality, not a projection made six months ago.
How We Built the Model for This Client
We started with three inputs, all of which Marcus already had in some form:
- Opening cash balance. We pulled the actual bank balance as of the first Monday of the model. This is your starting point — not an estimate, not an average. The actual number.
- Projected cash inflows by week. We categorized revenue by type: dine-in (collected daily, deposited same-week), catering invoices (net-30, collected based on actual due dates), delivery platform payouts (weekly on Tuesday), and private event deposits (collected 50% upfront, 50% on event day). For each category, we projected the actual collection week — not the week revenue was earned.
- Projected cash outflows by week. This included every recurring obligation: weekly payroll, vendor payments (food and beverage on net-15 terms), rent (1st of month), insurance (15th of month), loan payments (automated on the 20th), utilities (estimated by month, allocated to the billing week), and quarterly tax deposits. We also mapped in non-recurring items: a walk-in cooler repair, a planned equipment purchase, and an annual insurance renewal.
The model itself was a simple spreadsheet — thirteen columns (one per week), with rows for each cash inflow and outflow category. The bottom two rows were the ones that mattered: net weekly cash flow, and ending cash balance. When ending cash balance went negative, we had found the problem.
Seeing profit but not cash? Let's build your model.
We'll construct a 13-week cash flow forecast for your business and walk you through exactly what it's showing — week by week, dollar by dollar.
What the Numbers Revealed
Three things jumped out of Marcus's model immediately:
Week 6 was a crisis. The model showed ending cash dropping to negative $8,200 in week six. The cause: a large catering invoice ($22,000) was due to be collected that week, but the customer had a history of paying 10 days late. Meanwhile, payroll, rent, and a quarterly loan payment all landed in that same week. The model made the crunch visible three weeks before it happened.
Delivery platform payouts were masking a receivables problem. Marcus had been mentally combining his dine-in revenue (immediate cash) with his catering receivables (30-day lag) when estimating cash position. The model separated them clearly. His catering segment — which was growing rapidly and felt like a success story — was actually a source of cash drag because collection was slow.
The equipment purchase timing was wrong. Marcus had planned to buy a new commercial dishwasher in week seven. The model showed that would take ending cash to negative $31,000. Moving it to week eleven — after the catering receivables cleared — kept the business solvent through the whole quarter.
The Three Changes That Turned It Around
Armed with the model, Marcus made three targeted decisions:
1. Tightened catering payment terms. He changed his catering invoices from net-30 to 50% deposit, 50% due on delivery. This required some negotiation with regular clients, but most agreed. The immediate effect: cash arrived with the event instead of 30 days after it. His catering segment went from cash-negative to cash-positive in the model within two weeks of implementing the change.
2. Created a payroll buffer account. He opened a separate savings account and moved a fixed amount into it every week from his operating account — essentially pre-funding payroll. This removed the weekly anxiety about whether the operating account would clear payroll. The model helped us calculate the right buffer size based on his payroll pattern.
3. Deferred the equipment purchase and negotiated vendor terms. The dishwasher moved to week eleven. He also called his two largest food vendors and negotiated net-21 payment terms (up from net-15), buying three additional days of float each cycle. Small, but compounding.
Three months later, Marcus's bank balance had grown by over $30,000 — not because revenue went up, but because the timing of cash flows was finally managed intentionally.
Why Most Small Businesses Don't Do This (and Pay the Price)
The 13-week forecast sounds technical, but the concept is simple. The barrier isn't complexity — it's the assumption that looking at the bank account every day is the same thing. It isn't. The bank balance tells you where you are; the forecast tells you where you're going.
"Managing cash from the bank balance is like driving by looking in the rearview mirror. The 13-week forecast puts a windshield in front of you." — Darshi Kasotia, CPA
The other barrier is time. Building the first model takes real effort — usually 4–6 hours of focused work to gather the data and structure it correctly. But maintaining it weekly takes 30–45 minutes once it's built. Most business owners who do it once and experience a cash crisis they saw coming — and avoided — never stop.
How to Build Your Own 13-Week Forecast
If you want to start on your own, here is the framework:
- Get your actual bank balance as of Monday morning. This is row one, column one.
- List every expected cash inflow for the next 13 weeks. Use actual invoices, booking schedules, and historical patterns. Separate by collection timing, not revenue timing.
- List every cash outflow. Include payroll dates, vendor payment terms, loan due dates, tax deposits, rent, insurance, subscriptions, and any known non-recurring items.
- Build the weekly columns. Net cash flow each week is total inflows minus total outflows. Ending cash each week is prior week's ending cash plus that week's net flow.
- Look for weeks where ending cash goes negative or uncomfortably low. Those are your action weeks. What can you accelerate (collect faster), defer (pay later), or eliminate?
- Update weekly. Replace projections with actuals and roll the model forward one week. The model is only as good as the data going into it.
When You Need a CFO-Level View of Your Cash
The 13-week forecast is a tool, not a strategy. For businesses going through a period of rapid growth, a difficult season, or a major capital decision — lease, equipment, expansion — the forecast needs to be paired with someone who can interpret what it's showing and advise on the options.
That's where outsourced CFO support comes in. For most Houston small businesses, a full-time CFO is not an appropriate hire. But a CFO-level brain on your numbers — reviewing the forecast monthly, flagging decisions, stress-testing assumptions — is something most growing businesses eventually need and can now access without the overhead.
If you're consistently profitable but never quite sure where the cash is going, the 13-week forecast is the most powerful single tool I know of to answer that question. Start there.
