Cash flow projections built in QuickBooks Online carry something a spreadsheet built from scratch never will: an audit trail back to real transactions. That single property is why bank-ready cash flow projections start in your accounting system rather than in a blank workbook.
When a lender reviews your cash flow projections, they’re running one test above all others: is this a considered view of the business, or is it a wish? A forecast whose historical base ties directly to your general ledger answers that question before anyone asks it. A forecast typed into Excel with no visible lineage invites every follow-up question in the book.
This guide covers what lenders actually assess, how to build cash flow projections from your QBO data, and the six mistakes that get otherwise reasonable applications declined.
QuickBooks Online features and plan tiers change regularly. The method below is deliberately platform-stable — it works with reports available across plans. Confirm current feature availability in your own subscription before relying on any specific tool.
What Banks Assess in Your Cash Flow Projections
Credit assessment is less mysterious than it appears. Five questions, in roughly this order:
| What they’re testing | What satisfies it |
|---|---|
| Can you service the debt? | Projected cash flow covering principal and interest with visible headroom, in every month, not on average |
| Is the forecast credible? | Growth assumptions consistent with your actual trailing performance, and stated openly rather than buried in a formula |
| Does it tie to real data? | A historical base pulled straight from QBO, reconciling to the statements you’ve submitted |
| What happens if you’re wrong? | A downside scenario, modelled deliberately, that still services the debt |
| Is this business well run? | Timely, reconciled books and a forecast that someone clearly maintains rather than produced for this application |
That last row is the one applicants underestimate. Lenders read the quality of your submission as evidence about the business, independent of its contents. A projection assembled the week it was requested looks like exactly that.
Building Cash Flow Projections: A Four-Week Sequence
Week 1 · Get the QBO data trustworthy
→ Reconcile every bank and credit card account through the most recent complete month
→ Clean up miscoded transactions, particularly anything sitting in Uncategorized
→ Confirm the chart of accounts separates fixed from variable costs meaningfully
→ Export 24–36 months of profit and loss, by month
→ Export the AR and AP aging summaries
Week 2 · Find the patterns in your own history
→ Calculate monthly revenue growth across the trailing period, and its variability
→ Establish each month’s share of annual revenue if there’s any seasonality
→ Derive your real collection timing from the AR aging, not from your stated terms
→ Separate genuinely fixed costs from those that scale with revenue
→ Identify irregular outflows: tax instalments, insurance, annual renewals
Week 3 · Build the twelve-month projection
→ Project revenue from your historical rate, adjusted for anything you can evidence
→ Apply variable costs as a percentage of revenue; carry fixed costs forward
→ Convert revenue to cash using your actual collection lag — this is the step that matters
→ Layer in debt service, including the facility you’re applying for
→ Add tax remittances and instalments on their real due dates
→ Carry closing cash forward as the next month’s opening balance
Week 4 · Scenarios, assumptions, and the package
→ Model base, upside, and a downside with revenue 20–25% below plan
→ Confirm debt service holds in the downside — this is the number they’ll test
→ Write the assumptions on their own page, in plain language, with sources
→ Include the trailing actuals alongside the forecast so the join is visible
→ Note the QBO reports each figure came from
A one-page assumptions summary does more for an application than another twenty rows of detail.
Applying for financing this quarter?
Book a free 30-minute discovery call. We’re QuickBooks Online Advanced Certified ProAdvisors — we’ll look at your file and tell you what a lender would make of it.
Six Cash Flow Projection Mistakes That Sink Applications
a defensible base
the downside gets read first
to submission-ready package
Why QBO-Based Cash Flow Projections Land Better
- ✓The base is verifiable. Historical figures trace to reconciled transactions rather than to a founder’s recollection.
- ✓It’s updatable. When the lender asks for a refresh two months later — and they will — it takes an afternoon rather than a rebuild.
- ✓Maintained books are themselves a signal. A clean, current QBO file tells the lender something about management before they read a single projected figure.
- ✓Post-close reporting becomes trivial. Covenant reporting and lender updates run off the same structure, which matters for the next facility as much as this one.
All of which depends on the file being current. Cash flow projections built on books that close on day 25 inherit that staleness — which is why close discipline underpins everything here. For businesses with a pronounced seasonal curve, pair this with a seasonal cash flow forecast, since an annual view hides intra-year troughs a lender will find anyway.
Want the projection built properly the first time?
We work inside your existing QuickBooks Online file — no migration, no lengthy onboarding. We’ll build the model, the scenarios, and the assumptions page your lender will actually read.
Before You Submit
✓ Check every one of these
- Trailing figures reconcile exactly to your submitted financial statements
- Revenue is converted to cash using real collection timing
- Debt service on the requested facility is included
- The downside scenario still covers debt service
- Tax instalments and GST/HST remittances appear on their real dates
- Assumptions are on one page, in plain language
- Closing cash never goes negative in any scenario
- Someone other than the author has reviewed it
Frequently Asked Questions
The Bottom Line
Lenders decline applications for weak cash flow projections far more often than for weak businesses. This is the part of the process you control completely.
- ✓If your QBO file isn’t reconciled: start there, not with the forecast
- ✓If you’re forecasting revenue rather than cash: that single fix changes the picture most
- ✓If you’re submitting one scenario: add the downside before they ask for it
Give your lender something they can believe
Book a free 30-minute discovery call. As QuickBooks Online Advanced Certified ProAdvisors, we’ll review your file and build cash flow projections that stand up to credit review.