A 13-week cash flow forecast is a rolling weekly projection of every dollar entering and leaving your operating bank account over the next 90 days. For service business owners doing $1M–$20M in annual revenue, this model stops the “profitable but broke” syndrome where positive EBITDA on the P&L fails to translate into enough cash to make payroll, pay quarterly taxes, or fund growth. Unlike monthly budgets that average out timing, a 13-week cash flow model exposes the specific weeks when cash runs short—before you feel the crunch.
The mechanics start with your actual bank balance on a specific Friday. From there, you layer in weekly cash inflows: client payments pulled from your accounts receivable aging, retainer deposits, project milestone receipts, and any financing draws. Then you subtract weekly cash outflows: payroll hitting on the 1st and 15th, contractor payments, rent, software subscriptions, marketing spend, owner draws, quarterly IRS estimates, debt service, and capital expenditures. The ending balance each week becomes the starting point for the next. Update it every Monday morning with actuals, roll the forecast forward one week, and you maintain a live view of your cash position across the entire quarter.
Service businesses face unique cash flow management challenges that make weekly forecasting essential. You carry heavy payroll costs—often 40–60% of revenue—but bill clients after work is complete, typically on Net 30 or Net 60 terms. In practice, collections stretch to 38–42 days. A $60,000 project billed 40% upfront, 40% mid-project, and 20% on delivery scatters receipts across six or eight weeks. Retainers provide baseline stability, but project work creates spikes. Seasonal cash flow patterns hit hard: slower December payments, January B2B renewals, front-loaded hiring for new contracts. Without a weekly cash forecast, these patterns remain invisible until the bank account screams.
The numbers anchor this discipline. A healthy service business maintains 60% gross margin (delivery costs under 40% of revenue), caps sales and marketing at 15%, and holds G&A to 15%. That leaves 10–15% net margin and supports a cash buffer of 1–2 months of operating expenses—roughly $200K–$500K for a $5M firm. The 13-week forecast takes 24–48 hours per month to maintain once built, with weekly updates consuming 30–60 minutes. Accuracy targets 80–90% per week; the goal is direction and low-point visibility, not perfection. A $4M marketing agency using this model might see in Week 7 that payroll and a quarterly tax payment will exceed projected receipts by $120,000. With visibility, they accelerate collections, slow hiring, and avoid the liquidity crisis entirely.
Cash flow projections at this level transform strategic decision making. Before signing a new office lease in May, you run it through the forecast. Before adding two sales reps in June, you see the cash impact in Weeks 9–13. Before committing to a $20,000/month ad spend increase, you confirm the floor holds. The forecast links to pricing decisions, hiring cadence, owner compensation, debt reduction, and exit readiness. Acquirers and banks routinely ask to see 13-week cash flow forecasts during diligence because consistent positive net cash flow and stable margins improve buyer confidence and valuation multiples. Once the 13-week cash flow forecast is in place, every growth decision can be tested against cash before it hits the bank.
Key Takeaways
- A 13-week cash flow forecast shows every dollar expected in and out of your operating account over the next 90 days, updated weekly, so you stop the “profitable but broke” cycle common in service businesses doing $1M–$20M.
- Build the model in a simple spreadsheet with 13 weekly columns, starting from your actual Friday bank balance—not your accounting software’s book balance.
- Use the forecast to test real decisions before they hit cash: hiring, ad spend changes, price increases, and lease signings only proceed if cash stays above your floor.
- Benchmark your rows against 60% gross margin, 15% sales and marketing, and 15% G&A to diagnose whether cash strain is timing or structural.
- Connect short-term cash visibility to long-term goals like scaling, improving exit multiples, and knowing exactly when the business can safely reinvest.
What a 13-Week Cash Flow Forecast Really Does for a Service Business
You can grow revenue 30% and still miss payroll if you don’t control cash timing. Many businesses fail not from lack of sales but from misaligned cash moves between when work gets delivered and when payment arrives.
Service businesses carry heavy people costs and bill after work is done. A product company has inventory as a buffer. You have accounts receivable—promises to pay that don’t cover payroll until they convert to actual cash. This makes payment timing more dangerous than in businesses with physical goods.
The 13-week forecast shows, by week, when cash will run short or pile up. It gives you time to act: accelerate collections, delay a hire, negotiate extended terms with a vendor, or adjust owner draws. Without it, you’re reacting to the bank balance instead of managing it.
Why 13 weeks? One full quarter is long enough to plan hires, adjust spend, and renegotiate terms. It’s close enough to stay accurate—receipts and payments beyond 90 days carry too much uncertainty to model weekly. And it aligns with the strategic planning horizon most $1M–$20M service businesses actually operate on.
Tie this back to benchmarks: if gross margin is below 60% or G&A exceeds 15%, the 13-week view will show constant pressure on cash even when revenue looks stable. The forecast doesn’t just reveal timing problems—it surfaces structural issues you might otherwise mistake for bad luck.
Step 1: Choose the Right Scope for Your 13-Week Model
The model should only cover operating companies. Personal accounts, side ventures, investment entities, and retirement accounts don’t belong in this forecast. You’re tracking the business units that generate and consume operating cash.
Specify your scope clearly:
- Single LLC agency: One model, one bank account, straightforward
- Main agency + separate media-buying entity: Two tabs or consolidated view showing intercompany transfers
- Three clinic locations under one parent: Roll up into a summary tab with location-level detail underneath
- Management company + operating company structure: Track where cash actually sits and flows between entities
- Holding company with multiple service businesses: Each business gets its own 13-week view, with a master consolidation
For multi-entity service businesses, build individual forecasts first, then create a summary tab that pulls ending balances and highlights consolidated cash position. The goal is seeing exactly how much cash the entire operation has available—not just what each legal entity shows in isolation.
If you’re a service business doing $1M–$20M with 8–150 employees, this level of scope is usually enough. You don’t need enterprise treasury software. You need clarity on which accounts to track and which to ignore.
Step 2: Build a Simple 13-Week Cash Flow Template
The layout is straightforward: rows down the page, 13 weekly columns across.
Row Category | Week of Apr 6 | Week of Apr 13 | … | Week of Jul 5 |
|---|---|---|---|---|
Beginning Cash | $285,000 | $320,000 | … | … |
Cash Inflows | ||||
Client Invoices Due | $150,000 | $175,000 | … | … |
Retainers | $30,000 | $30,000 | … | … |
Project Milestones | $0 | $40,000 | … | … |
Total Inflows | $180,000 | $245,000 | … | … |
Cash Outflows | ||||
Payroll | $95,000 | $95,000 | … | … |
Contractors | $25,000 | $30,000 | … | … |
Rent | $0 | $12,000 | … | … |
Software/SaaS | $8,000 | $3,000 | … | … |
Marketing Spend | $12,000 | $15,000 | … | … |
Owner Draws | $0 | $10,000 | … | … |
Taxes | $0 | $0 | … | … |
Loan Payments | $5,000 | $0 | … | … |
Total Outflows | $145,000 | $165,000 | … | … |
Net Cash Flow | $35,000 | $80,000 | … | … |
Ending Cash | $320,000 | $400,000 | … | … |
Start with actual cash in the main operating account as of a specific Friday. Not the book balance from your accounting software—the real number on the bank statement. Book balance includes checks written but not cashed, deposits in transit, and reconciling items that don’t reflect available cash. |
A well-built Google Sheet or Excel file handles this for a $5M firm. You don’t need specialized forecasting software to build accurate cash flow forecasting. You need discipline and 30 minutes per week.
Step 3: Gather the Right Data (and Ignore the Noise)
Collect data from cash-basis sources only:
- A/R aging report: Shows what’s due over the next 8–12 weeks by invoice and client
- Signed contracts: Revenue that’s committed but not yet invoiced
- Renewal calendar: Upcoming retainer renewals, annual contract anniversaries
- Payroll reports: Exact amounts and dates for next several pay periods
- Recurring bills: Rent, software, insurance—amounts and draft dates
- Tax calendar: Quarterly IRS estimates, annual filings, state payments
- Debt service schedule: Loan repayments, credit facilities draws and payments
Do not copy from the P&L. The P&L follows accrual accounting—it records revenue when earned and expenses when incurred, regardless of when cash actually moves. Your 13-week forecast only cares about when dollars hit or leave the bank.
Tighten collection assumptions based on historical data. If invoices are Net 30 but clients actually pay in 38–42 days on average, model the reality. Pull 3–6 months of payment history and build a simple collections schedule by week based on actual client behavior, not contract terms.
Data quality drives forecast accuracy. Garbage assumptions produce garbage projections. Spend the time upfront to collect data properly.
Step 4: Forecast Cash Inflows Week by Week
Break forecasted revenue into expected receipts by week using contract terms and average days-to-collect.
Example: A $60,000 project with 40/40/20 billing:
- Week 1: $24,000 upfront payment received at contract signing
- Week 5: $24,000 mid-project milestone (assuming Net 30, actually pays Week 6-7)
- Week 10: $12,000 on delivery (assuming Net 30, actually pays Week 11-12)
Project cash inflows don’t match project billing. They match when clients actually pay.
Retainers provide baseline cash inflow—predictable monthly or quarterly receipts that cover a portion of fixed costs. Project work creates spikes. The 13-week model shows exactly how these patterns interact with outflows week by week.
Adjust for seasonality:
- December: Slower B2B collections as clients close books
- January: Spike from Q1 renewals and annual contracts
- Summer months: Vacation-related delays in approvals and payments
- Q4: Potential rush as clients spend remaining budgets
Conservative assumptions protect you. Better to project cash inflows at 90% of expected and be pleasantly surprised than to project 100% and miss payroll. When forecasting future cash flows, pessimism is your friend.
Step 5: Forecast Cash Outflows Without Missing the “Landmines”
Recurring weekly and biweekly costs form the baseline:
- Payroll (typically 1st and 15th, or biweekly)
- Contractor payments
- Marketing and ad spend
- Software subscriptions
- Utilities
- Insurance drafts
But the “landmines” ambush your cash position. These are large, infrequent payments that coincide with regular expenses:
Landmine Type | Typical Amount | Frequency | Danger |
|---|---|---|---|
Quarterly IRS estimates | $50K–$150K | 4x/year | Hits with payroll |
Annual insurance renewal | $30K–$80K | 1x/year | Often Q1 |
Annual software renewals | $20K–$50K | 1x/year | Various dates |
License renewals | $5K–$25K | 1x/year | Easy to forget |
Vendor prepayments | Variable | As needed | Unplanned |
Example: A $90,000 quarterly tax bill and a $40,000 annual software renewal land in the same week as $95,000 payroll. That’s $225,000 in cash outflows in a single week. Without the forecast, you discover this when the bank balance plummets. |
Group outflows into three blocks mirroring your benchmarks:
- Cost of Delivery (COGS): Payroll for delivery staff, contractors, direct project costs
- Sales & Marketing: Ad spend, sales team payroll, marketing tools
- G&A: Rent, admin staff, software, insurance, professional services
Align due dates with actual payment behavior. If you habitually pay a Net 30 vendor on day 40, model day 40—not day 30. The goal is predicting when cash actually moves, not when it’s theoretically due.
Step 6: Tie It Together – Net Change and Ending Cash Balance
The math is simple:
- Net cash flow = Total Inflows – Total Outflows
- Ending Balance = Prior Week Ending + Net Cash Flow
Week-by-week example:
Week | Beginning | Inflows | Outflows | Net Change | Ending |
|---|---|---|---|---|---|
Week 4 | $380,000 | $165,000 | $140,000 | +$25,000 | $405,000 |
Week 5 | $405,000 | $120,000 | $195,000 | -$75,000 | $330,000 |
Week 6 | $330,000 | $210,000 | $150,000 | +$60,000 | $390,000 |
The swing from surplus to deficit and back shows exactly why weekly granularity matters. A monthly view would average these swings and hide the $330,000 low point. |
The only number that matters to survival is the lowest projected cash balance over the 13 weeks. Find it. Protect it. That’s your potential cash shortfalls warning—the week where negative cash flow risk is highest.
Step 7: Turn the Forecast into Weekly Operating Rhythm
The forecast dies without a weekly update. Build it into your operating rhythm:
Monday morning ritual (30–60 minutes):
- Replace last week’s estimates with actual performance
- Roll the forecast forward one week (drop Week 1, add Week 14)
- Review variances—if actuals were off by more than 10–15%, revisit assumptions
- Flag upcoming tight weeks for discussion
- Update any new contracts, hires, or commitments
Attendees:
- Owner/CEO (always)
- Finance lead or bookkeeper (to input actuals)
- Operations or sales leader (for larger firms with 30+ employees)
What to discuss:
- Upcoming weeks where ending balance drops near the floor
- Collections priorities—which invoices to chase this week
- Hiring decisions pending—does cash support it?
- Owner draws—timing adjustments if needed
Set one or two simple operating rules based on the model. Example: “No new full-time hires unless we stay above $250,000 cash in every week of the forecast.” These rules transform the forecast from a reporting tool into a decision-making guardrail for working capital efficiency.
How to Use the 13-Week Forecast to Make Real Decisions
The forecast earns its value when you test decisions against it before committing.
Scenario 1: Adding two hires You want to add a project manager in Week 5 ($8,500/month fully loaded) and a sales rep in Week 8 ($9,000/month). Run it through the model. The combined impact drops your Week 9–13 ending balances by $45,000–$60,000. If that pushes any week below your $200,000 floor, you delay one hire to Week 10 or accelerate a collection to offset.
Scenario 2: Increasing ad spend Marketing wants to add $20,000/month to paid campaigns starting Week 3. You model it across 10 weeks. Cash stays above floor through Week 8, then dips below in Week 9 when a quarterly tax payment hits. Decision: approve the spend but delay the campaign start to Week 5, after the tax payment clears.
Scenario 3: Pulling forward a price increase You planned to raise retainer rates in Q3, but the forecast shows persistent pressure in Weeks 6–10. Model the impact of moving the increase to next month—extra cash from existing clients hits earlier, smoothing the rough weeks. The forecast makes the case for acting now instead of waiting.
Nothing leaves the “idea” stage until it’s run through the 13-week forecast and proven cash-safe. That’s how finance teams and finance leaders at scaling businesses prevent expensive mistakes.
Diagnosing Structural Problems from Your 13-Week Forecast
Recurring weekly cash strain—even with stable sales revenue—points to structural margin issues, not just timing.
If cash is always tight and delivery costs consume more than 40% of revenue, you have a gross margin problem. The 13-week forecast makes this visible because you can see the COGS rows eating into inflows week after week.
Example: A $250,000 revenue month with $170,000 going to payroll and contractors for delivery. That’s 68% in delivery costs, leaving 32% gross margin. Even perfect collections timing won’t fix that—there simply isn’t enough cash left to cover overhead, owner pay, and growth investment.
Use the forecast rows to back into rough percentages:
- Sum your delivery costs (production payroll, contractors, direct project costs) and divide by total revenue
- Sum sales and marketing outflows and divide by revenue
- Sum G&A outflows and divide by revenue
If gross margin is below 60%, or S&M exceeds 15%, or G&A exceeds 15%, the forecast reveals chronic strain that no amount of cash management strategies will solve, and it often points back to weaknesses in strategic budget planning and execution.
When the 13-week model shows structural problems, revisit pricing, staffing mix, or service design. The forecast diagnosed the issue—now you fix it.
Common Mistakes Owners Make with 13-Week Cash Forecasts
- Starting from the P&L instead of bank balance: Accrual numbers don’t show cash timing. Start with actual cash in the bank.
- Overestimating collection speed: Assuming Net 30 means 30 days when historical analysis shows 40+ days. Use real payment behavior from historical data.
- Ignoring taxes: Quarterly estimates, payroll taxes, and annual filings hit hard. Many businesses fail to model these properly.
- Modeling by month instead of week: Monthly views hide the mid-month cash low points where payroll and supplier payments collide.
- Letting it go stale: A forecast from three weeks ago is worse than no forecast—it creates false confidence. Manual processes must be weekly.
- Overcomplicating with dozens of minor lines: 47 expense categories make the model unusable. Group into meaningful blocks that drive decisions.
- Optimistic scenario planning only: Model what happens if collections slow 10% or a big client delays payment. Multiple scenarios reveal true risk.
An 80% accurate forecast updated weekly beats a “perfect” one that nobody maintains. Improve forecast accuracy over time by tracking variances and adjusting assumptions—but never let perfection prevent progress.
When to Bring in a Fractional CFO to Own the 13-Week Model
Tipping points where choosing the right fractional CFO services and outside support makes sense:
- Revenue between $3M and $20M
- More than 20–30 employees
- Multiple locations or entities that may include real estate-focused operations needing specialized cash forecasting
- Founder can no longer personally track cash
- Planning for exit, acquisition, or major financing
Bookkeepers focus on recording transactions. Tax CPAs focus on compliance and minimizing liability. Neither typically builds decision-ready 13-week cash flow models. Their work is essential—but it’s backward-looking. The forecast is forward-looking and often benefits from fractional CFO support.
A fractional CFO uses the 13-week forecast alongside a 12–18 month model to plan growth, debt repayments, owner compensation, and exit timing. They connect short-term cash visibility to long-term strategic decision making.
Example: A $6M consulting firm operated in weekly cash panic—checking the bank balance daily, delaying vendor payments, nervous before every payroll. A fractional CFO built the 13-week model, identified chronic collection delays, negotiated shorter payment terms with two key clients, and restructured contractor payments. Within three months, the firm had a 6–9 month clear runway and stopped the reactive cycle.
The 13-week model exists whether you manage it yourself or bring in support. At mid sized businesses scale, outside expertise—especially from specialized fractional CFO firms used by high-growth startups—often pays for itself in avoided mistakes and operational efficiency.
Strategic Payoff: From Surviving Payroll to Planning an Exit
Short-term cash visibility connects directly to long-term goals. Consistent positive weekly cash and stable margins improve buyer confidence and business valuation.
When you can show an acquirer or lender a 13-week cash flow statement with predictable patterns, no surprise shortfalls, and maintained floors—you demonstrate financial discipline. This translates to higher multiples at exit. Buyers pay more for businesses with proven cash flow management because they carry less risk.
Banks and private equity firms routinely request 13-week cash forecasts during diligence, refinancing, or credit facilities discussions. Having the model ready—maintained weekly, accurate to 80–90%—signals that your company’s financial health is under control. It’s the difference between “we think we have enough cash” and “here’s exactly where we stand every week for the next quarter.”
The ultimate strategic payoff: knowing exactly when the business can safely reinvest versus distribute to owners. The 13-week forecast shows whether you can fund that expansion, hire that team, or open that second location without creating financial distress. It transforms growth from a gamble into a calculated move backed by future cash positions visibility.
Get a Scale-Ready Assessment
Your P&L is hiding growth. Let us find it.
I take 15 assessments per month. If you’re a service business doing $1M–$20M and you want to know exactly where your numbers sit—book now.
