What Is a 13-Week Rolling Cash Flow Forecast?
A 13-week cash flow forecast is a week-by-week projection of every dollar coming into and going out of your business bank account for the next 90 days. It differs from three common planning tools that many small business owners confuse it with:
- Annual budget — too high-level, monthly granularity misses weekly timing mismatches
- P&L / Income statement — records revenue when earned, not when collected
- Cash flow statement (historical) — looks backward, not forward
- Balance sheet — snapshot of assets/liabilities, not a timing tool
- Week-by-week projection of actual bank account movements
- Cash in only counts when it actually lands in your account
- Cash out only counts when it actually leaves your account
- A living document — updated every week, always looking 13 weeks forward
- The tool that gives you lead time to prevent crises
The Core Insight: Profit ≠ Cash Flow
The most dangerous phrase in small business finance is: "We're profitable — why don't we have any money?"
A business can be profitable on paper and simultaneously run out of cash. Here's how:
- You complete a $120,000 construction project in April — you've earned that revenue. Your P&L shows it.
- But your contract is Net-60, so the $120,000 hits your bank account in June.
- Meanwhile, April and May payroll, rent, fuel, materials, and insurance are all due now.
- A profitable business is now unable to make payroll — not because it's failing, but because of timing.
The 13-week forecast solves this by tracking cash timing, not accounting recognition. You see the June cash arrival in Week 9 — and the April payroll gap in Week 2 — with six weeks to address it before it hits.
The 13-Week Forecast Template
Below is the structure of a standard 13-week rolling cash flow forecast. Customize the line items to match your business — not every category applies to every business type.
| Category / Line Item | Wk 1 | Wk 2 | Wk 3 | Wk 4 | Wk 5 | Wk 6 | Wk 7 | Wk 8 | Wk 9 | Wk 10 | Wk 11 | Wk 12 | Wk 13 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| OPENING BALANCE | |||||||||||||
| Beginning Cash Balance | $12,400 | [W1 end] | [W2 end] | ← rolls forward automatically | |||||||||
| CASH INFLOWS (when cash actually hits your account) | |||||||||||||
| Cash sales / POS receipts | $4,200 | $4,500 | … | ||||||||||
| AR collections — Net-30 invoices | $18,000 | $9,500 | … | ||||||||||
| AR collections — Net-60 invoices | — | $12,000 | … | ||||||||||
| Progress billings (construction) | — | — | … | ||||||||||
| Loan draws / MCA advance | — | — | … | ||||||||||
| Tax refunds / owner investments | — | — | … | ||||||||||
| TOTAL INFLOWS | $22,200 | $26,000 | … | ||||||||||
| CASH OUTFLOWS (when cash actually leaves your account) | |||||||||||||
| Payroll (net) | $8,400 | — | … | ||||||||||
| Payroll taxes (employer) | $720 | — | … | ||||||||||
| Rent / mortgage | $3,500 | — | … | ||||||||||
| MCA / loan repayment (daily ACH) | $875 | $875 | … | ||||||||||
| Vendor / supplier payments | $2,100 | $4,800 | … | ||||||||||
| Utilities | — | $620 | … | ||||||||||
| Insurance premiums | — | — | … | ||||||||||
| Credit card settlements | $1,200 | $1,200 | … | ||||||||||
| Owner draw | $2,500 | $2,500 | … | ||||||||||
| Quarterly estimated tax | — | — | … | ||||||||||
| Other | $300 | $150 | … | ||||||||||
| TOTAL OUTFLOWS | $19,595 | $10,145 | … | ||||||||||
| NET CASH FLOW (Week) | +$2,605 | +$15,855 | … | ||||||||||
| ENDING CASH BALANCE | $15,005 | $30,860 | ← scan for negatives | ||||||||||
Example numbers for illustration only. Your actual line items will vary by business type and payment terms.
How to Build Yours: 6 Steps
-
1
Gather your inputs
Pull 90 days of bank statements (to understand actual timing of past deposits and payments), your AR aging report (outstanding invoices by age), your AP schedule (what's owed and when), and your payroll calendar (exact pay dates for the next 13 weeks). This takes 20–40 minutes and is the only genuinely tedious part.
-
2
Set up your columns: Week 1 through Week 13
Use Excel or Google Sheets. Create a column for each of the next 13 weeks, with dates. The first column is the current week. Add a "Week 0" column for your current bank balance — this is your starting balance. Every weekly ending balance is: prior balance + this week's net cash flow.
-
3
Project inflows — when cash actually hits your account
List every source of incoming cash in the week it will actually arrive in your account — not when you earn it. Your invoice terms determine timing: Net-30 invoice sent today hits Week 5. Net-60 hits Week 9. Cash sales are immediate. Credit card settlements typically arrive 2 business days after the sale. If you're unsure, look at your last 90 days of bank statements and identify the average lag between a sale and when the deposit shows up.
-
4
Project outflows — when cash actually leaves your account
Map every payment to the week it will clear. Payroll: use your exact scheduled pay dates (if biweekly, mark every other week). Rent: usually the 1st — find which week that falls in. MCA repayment: daily ACH — multiply your daily holdback by 5 for a weekly amount. Quarterly estimated taxes: April 15, June 16, September 15, January 15 — mark the week of each date. Annual premiums: find the exact renewal dates in your insurance policies.
-
5
Calculate net cash and running balance — scan for negative weeks
For each week: Net = Total Inflows − Total Outflows. Running Balance = Prior Week Ending Balance + This Week Net. Scan the running balance row. Any negative number (or a number uncomfortably close to zero) is a cash gap — a week where your business cannot cover obligations. Highlight these weeks in red. They are your action items.
-
6
Act on gaps — with enough lead time to fix them
The forecast only has value if you use it to act. For each cash gap you identified: determine the cause (payroll bunching, slow AR, seasonal dip, large annual payment), choose the right tool (accelerate AR collection, defer a discretionary payment, draw on a line of credit, apply for an MCA), and act now — before the gap arrives. An MCA takes 1–3 business days. An SBA loan takes 30–90 days. A gap in Week 3 leaves no time for a bank loan.
7 Common Cash Flow Forecasting Mistakes
Confusing revenue with cash
Recording revenue when it's billed, not when it's collected. If you're on Net-30, money billed today doesn't hit the forecast until Week 5.
Forgetting quarterly tax payments
Quarterly estimated taxes are due 4x per year and can be $5,000–$20,000+. Missing them in the forecast creates a devastating surprise cash gap.
Ignoring collection rate history
Not all invoices get paid on time — or at all. Apply your historical collection rate (e.g., 80% paid within 45 days) to AR projections, not 100%.
Not updating the model weekly
A one-time forecast becomes a fiction by Week 3. The value is in the weekly rolling update — actuals in, new Week 14 added, projections revised.
Over-optimistic sales projections
Always run a "base case" and a "downside case" (20–30% below base). If the downside creates a gap, plan for it — even if you think it won't happen.
Omitting owner draws
Owner draws are cash out of the business. If you take a weekly draw, it belongs in the outflow section — otherwise the forecast doesn't match reality.
Building it once and filing it
The forecast that sits in a file is worthless. The forecast you open every Monday morning and update for 30 minutes is the one that saves the business.
How to Use Your Forecast With Lenders
A well-maintained 13-week cash flow forecast is one of the most powerful documents you can bring to a lender meeting. Here's how to use it:
When Applying for an SBA 7(a) Loan
SBA lenders require a 2–3 year financial projection as part of the loan package. A 13-week forecast doesn't replace this, but including it alongside your annual projections signals that you actively manage cash — not just accrual accounting. It also demonstrates that you understand the difference between profit and cash, which many SBA lenders find reassuring in first-time borrowers.
When Applying for an MCA
MCA underwriting is bank-deposit-based — underwriters look at 3–6 months of bank statements. But bringing a 13-week cash flow forecast to an MCA discussion serves a different purpose: it shows exactly where in your cash cycle you need the advance (Week 3 payroll gap, Week 7 material purchase) and exactly how the MCA holdback fits into your projected inflows. This builds confidence in the ISO and occasionally enables better advance amounts or factor rates for sophisticated applicants.
When Negotiating a Business Line of Credit
Banks that offer business lines of credit want to see that you can manage draws and repayments responsibly. A 13-week forecast that clearly shows your seasonal peak needs (Oct–Dec retail; spring construction) and your repayment capacity (strong summer months) makes the case for a larger line at lower rates.
Frequently Asked Questions
- What is a 13-week cash flow forecast?
- A 13-week cash flow forecast is a week-by-week projection of all cash inflows and outflows for the next 90 days. It's the gold standard used by accountants, CFOs, turnaround advisors, and lenders because 90 days gives enough forward visibility to identify and fix cash gaps before they become crises. It's called "rolling" because you update it every week, dropping the most recently completed week and adding a new Week 13 — keeping your planning window constant.
- What is the difference between cash flow and profit?
- Profit is an accounting concept: revenue minus expenses as recorded by your accountant. Cash flow is what actually moves through your bank account. A profitable business can run out of cash if customers pay slowly (slow AR), inventory is high, or large payments cluster in the same week. Cash flow forecasting tracks the actual timing of money movement — not when it's earned or recognized, but when it physically moves.
- How far in advance should I forecast cash flow?
- The 13-week (90-day) window is the minimum for operational usefulness. Most lenders want at least 12 months for loan applications, and SBA lenders want 2–3 years. However, beyond 13 weeks, forecast accuracy decreases significantly for most small businesses. A practical approach: maintain a detailed 13-week rolling forecast for operations, and build a higher-level monthly forecast for 12–24 months for lender presentations.
- What is the difference between a cash flow forecast and a cash flow statement?
- A cash flow statement (part of your financial statements prepared by your accountant) looks backward — it reports cash movements that already happened in a prior accounting period. A cash flow forecast looks forward — projecting cash movements that will happen in the future. Both are useful; only the forward forecast can help you prevent cash crises.
- What tools do small businesses use to build cash flow forecasts?
- Most small businesses use Google Sheets or Microsoft Excel — they're free (or included with most plans), flexible, and familiar. QuickBooks and Xero both have cash flow projection features built in, but they require clean, up-to-date bookkeeping to generate useful forecasts. For businesses with complex operations, specialized tools like Float, Pulse, or Dryrun layer onto QuickBooks/Xero. For most small businesses starting their first cash flow forecast, a well-structured Google Sheet works perfectly.