13 Week Cash Flow Forecast From Your QuickBooks Export
You closed a good month. Revenue was up and margin held. Then payroll hit, and you were refreshing the bank app on a Thursday morning. A 13 week cash flow forecast is a weekly, direct-method schedule of the cash you expect to collect and pay over the next 91 days. It is built from receivables, payables, and recurring commitments rather than from accrual profit, and it answers the one question your income statement cannot: on which specific Friday do you run out of money?
That gap is not a bookkeeping failure. It is a reporting-model failure, and it takes about two hours to fix.
Key Takeaways
- It is a direct-method model, so it cannot be built from the QuickBooks Statement of Cash Flows, which Intuit documents as accrual-basis only. Build it from four exports instead: A/R aging detail, A/P aging detail, the recurring template list, and a trailing 24-month P&L.
- Thirteen weeks is one fiscal quarter (13 x 7 = 91 days), long enough to expose a payroll-and-tax collision and short enough that receivable timing stays predictable.
- The median small business holds only 27 cash buffer days, per the JPMorgan Chase Institute, so a single 30-day slip in collections becomes a solvency event.
Why Generic Cash Flow Advice Fails Owner-Operators
Most cash flow content is written for treasurers with an FP&A team. You have a bookkeeper, QuickBooks Online, and a Tuesday. That advice skips the only step that matters to you: where each row of the model actually comes from inside the books you already keep.
The Direct-Versus-Indirect Trap
Here is the error that kills most DIY models. Owners open the Statement of Cash Flows in QuickBooks, see the words “cash flow,” and start there. But that report is an indirect-method reconciliation that starts at net income and adjusts backward, and Intuit’s documentation states it runs in accrual basis only. Your 13 week cash flow forecast is the opposite animal. It is direct-method, so you start from invoices and bills, not from profit. Pull these four exports.
| Export | Where it lives in QBO | What it feeds |
|---|---|---|
| A/R aging detail | Who owes you | Receipts, weeks 1 to 8 |
| A/P aging detail | What you owe | Disbursements, weeks 1 to 6 |
| Recurring template list | Recurring transactions | Fixed disbursements, weeks 1 to 13 |
| Profit and Loss, trailing 24 months | Business overview | New-business receipts, weeks 6 to 13 |
The recurring transaction list is the export nobody mentions, yet it is the one that makes weeks 7 through 13 credible. Rent, insurance, debt service, and software renewals all live there.
Want Your Own Cliff Mapped Before It Arrives?
Build It in Five Moves
Convert A/R aging into dated receipts by assuming behavior, not terms. Apply a collection probability and a timing lag to each bucket, then drop the dollars into a specific week.
| A/R bucket | Typical treatment | Week landed |
|---|---|---|
| Current | High probability, on terms | Invoice date + terms |
| 1 to 30 days | High probability, one-week slip | Terms + 1 week |
| 31 to 60 days | Moderate; requires a call | Terms + 3 weeks |
| 61 to 90 days | Low without escalation | Terms + 6 weeks, or excluded |
| 90+ days | Exclude entirely | None |
Then layer disbursements in three tiers: committed and dated (payroll, taxes, rent, debt service), committed but flexible (open A/P you can time within terms), and variable (materials and ad spend, driven off the trailing P&L). Mark estimated tax payments and any three-payroll month in red first. Run the weekly roll-forward where closing cash becomes next week’s opening cash. Finally, set a cadence: every Monday, re-export the agings, replace last week’s forecast with actuals, add a new week 13, and review which line missed and by how much. Fifteen minutes a week is what converts a spreadsheet into a management system.
Three Ways the Model Breaks
Booking revenue instead of cash, because an invoice is not a deposit. Netting inside a week, which hides the Wednesday you were actually short. And abandoning it after week three, which lets the forecast decay into a stale document within a month.
Frequently Asked Questions
Why 13 weeks instead of six months? Thirteen weeks spans 91 days, close enough to a fiscal quarter to stay comparable to reporting and legible to lenders. Six months is too far out for receivable timing to stay reliable, and anything shorter hides the payroll-and-tax collisions that cause most cash crises.
How often should I update it? Weekly, on the same day, replacing the closed week with actuals and adding a new week at the far end. A forecast updated only monthly is a historical document, not a decision tool.
Satisfaction Guaranteed
✓
I stand behind my work. Start with a free Books Health Check at zero obligation, and if we work together and you are not satisfied with the value, I will make it right. No long-term contracts, no pressure.
Get a Straight Read on Your Numbers
A free 30-minute Books Health Check. No pitch, no obligation. You leave with a Custom Financial Roadmap and a straight read on what your books actually need.