13 week cash flow forecast
💡Introduction : If you’ve ever stared at a profitable P&L and a stressed-out bank balance in the same week, you already understand why founders need a 13-week cash flow forecast. Profit is an opinion; cash is a fact. This guide walks through what a 13-week forecast is, why it works better than monthly budgeting, how to build one in an afternoon, and the discipline that turns it into a weapon for growth instead of a Tuesday chore.
🔍 Table of Contents
📊 What a 13-Week Cash Flow Forecast Actually Is
A 13-week cash flow forecast is a rolling weekly projection of every dollar in and every dollar out of your business for the next quarter. Unlike a monthly budget, it operates on the only timeframe that matters when cash is tight: the next payroll, the next loan payment, the next vendor due date. It uses the direct method — you forecast actual receipts and actual disbursements, not adjusted earnings.
📈 Explore the 10 Financial KPIs Every $3M+ Business Should Track
⏳ Why 13 Weeks (Not 8, Not 26)
Thirteen weeks is one full quarter. Long enough to see the next big tax payment, the next debt service date, and seasonality patterns. Short enough that the numbers stay credible — anyone forecasting cash to the dollar 26 weeks out is guessing. Thirteen is the sweet spot finance has used since the 1970s, and it’s the standard turnaround consultants and lenders expect to see.
💰 What Goes In — Inflows
Customer collections — by customer, by week, based on AR aging and historical pay behavior (not invoice date)
- Other receipts — refunds, deposits, interest, asset sales
- Financing inflows — line draws, new debt, equity raises (only when committed, not hoped for)
💸 What Goes In — Outflows
- Payroll & related taxes — by pay date, including 941 deposits
- AP disbursements — by vendor, by week, based on actual payment terms
- Recurring fixed costs — rent, software, insurance, utilities
- Variable costs — COGS, freight, marketing
- Debt service — principal + interest by due date
- Tax payments — sales tax, state estimates, federal estimates
- Owner draws / distributions
🛠️ How to Build It in an Afternoon
- Pull a YTD detailed P&L by week from your accounting system.
- Open a 13-week template (Excel, Sheets, or a tool like Float, Jirav, or Cashflowtool).
- Lay out the weekly cash inflow and outflow rows for the next 13 weeks.
- Populate Week 1 from real data — known receipts, known disbursements.
- Populate Weeks 2–13 from contractual obligations + historical timing.
- Reconcile the model to your current bank balance.
- Review weekly. The first 4 weeks will be sharp; weeks 8–13 will be directional.
📈 The Variance Discipline That Drives Behavior
A forecast you don’t review is just a spreadsheet. The discipline that makes the 13-week forecast actually work is the weekly variance review: every Monday, you compare last week’s forecast to last week’s actuals and explain every line that missed by more than 5%. Within four weeks, your forecast accuracy doubles, and within eight weeks the team starts thinking in cash, not just revenue.
⚠️ The 6 Most Common Founder Mistakes
- Forecasting on invoice date, not pay date — the #1 reason founders miss collections by 2–3 weeks.
- Ignoring 941 payroll tax deposits — they hit semi-weekly and routinely surprise people.
- Treating committed line draws as actual cash — they’re optionality, not income.
- Skipping the variance review — without it, the forecast decays in 30 days.
- Building it once and forgetting it — it’s rolling. Drop the oldest week and add a new Week 13 every Monday.
- Doing it in isolation — sales should see the receipts forecast; ops should see the disbursements forecast.
❓ Frequently Asked Questions
How is a 13-week cash flow forecast different from a budget?
A budget is annual, monthly, and accrual-based. A 13-week forecast is quarterly, weekly, and cash-based. Budgets answer “is this profitable?” Forecasts answer “will I make payroll Friday?”How long does it take to build a 13-week cash flow forecast?
The first one takes 4–8 hours if your accounting is clean, longer if AR/AP records are messy. Once built, the weekly maintenance is 30–60 minutes.
What software do I need?
Excel or Google Sheets work fine for $3M–$15M businesses. Above $15M, dedicated tools like Float, Jirav, or Cashflowtool save real time.
Should I share the forecast with my team?
Selectively. Senior leadership should see it. Mid-level managers benefit from seeing the slice that affects their work — collections, AP timing, hiring. Not everyone needs the full model.