Cash Flow Forecasting with QuickBooks: What's Missing & How to Fix It

A board member asks a simple question: What happens to cash if the company hires two more people next quarter? It's the kind of question every CFO and business owner needs to answer with confidence, and answering it well starts with the same place most finance teams already trust, which is QuickBooks. As a trusted accounting tool, QuickBooks is where the numbers live, clean, current, and reconciled. That foundation is exactly what makes real forecasting possible in the first place.

Turning that foundation into a forward-looking answer is where a connected three-way forecast comes in. This blog looks at how QuickBooks' native forecasting tool works, and how connecting Fathom builds on that same data to help finance teams and business owners plan several moves ahead with more confidence.

What QuickBooks brings to cash flow forecasting

A strong foundation with clean, connected data

Good forecasting starts with good data, and that's exactly where QuickBooks does its best work:

• ‍Reliable bookkeeping: Transactions are recorded, categorised, and reconciled in one place.
  ‍
• ‍An accurate transaction history: Every invoice, bill, and payment feeds a single source of truth.
  ‍
• ‍Dependable reporting on what's already happened: Profit and loss, balance sheet, and cash flow reports are ready whenever they're needed.

Without that foundation, nothing built on top of it, in QuickBooks or anywhere else, would be worth trusting.

What the native forecasting tool does well

QuickBooks Online Advanced includes a native forecasting tool, and it's a genuinely useful starting point:

• Analyses historical financial data to project future cash flow and profit trends.
  ‍
• Draws directly on existing transaction data, so there's no separate setup or data migration involved.
  ‍
• Gives a quick, near-term read on where cash is heading, based on the same clean data QuickBooks already keeps in order.

Turning historical data into forward-looking decisions

Trend lines to modelled assumptions

A trend-based projection assumes tomorrow looks broadly like yesterday, which holds up reasonably well for a stable, steady-state business. Where a growing business gets more value is in modelling a specific decision rather than extending a line drawn from history.  

Examples of the kind of assumptions worth modelling directly:

• A new hire, and its effect on payroll and cash over the following months
  ‍
• Price increases and how quickly it flows through to the bottom line
  ‍
• Change in payment terms with a key customer or supplier
  ‍
• New piece of equipment, financed or purchased outright

That's less about what QuickBooks' native forecast is missing, and more about the next layer a growing finance function typically wants to add on top of it.

From one projection to several, side by side

A CFO preparing for a board meeting, or an owner deciding whether to make an offer to a new hire, usually wants to compare more than one possible future, not just one:

• What happens if revenue holds steady
  ‍
• What happens if it dips for a quarter
  ‍
• What happens if a major customer pays 30 days late instead of 15
  ‍
• What happens if two scenarios are blended, a modest dip alongside a planned hire

Building several modelled scenarios side by side, rather than working from a single projection, is what turns a forecast into an actual decision-making tool.

What Fathom's three-way forecasting adds on top of your QuickBooks data

Connecting the P&L, balance sheet, and cash flow

A cash flow forecast built in isolation can show that cash is tightening, without fully explaining why. The real driver often lives elsewhere:

• Drop in margin, visible in the profit and loss statement
  ‍
• Build-up of inventory, sitting on the balance sheet
  ‍
• Financing decision, such as a new loan or repayment schedule

Three-way forecasting connects all three statements, so a change in one flows through to the others automatically. That same connected data also feeds Fathom's financial analysis software, for digging into the drivers behind a margin or cash movement before it shows up in the forecast.  

Together, that's what makes a forecast trustworthy enough to bring to a board or a lender: the numbers are internally consistent, not three separate stories.

Planning further ahead, with more range

Layered on top of QuickBooks' near-term trend view, a connected three-way forecast is built to extend much further out, with the flexibility to update as circumstances change:

• ‍Plan up to five years ahead: Rather than a single near-term projection.
  ‍
• ‍Revisit the horizon as needed: A longer-range view doesn't mean losing sight of the near term, it sits alongside it.

Rolling forecasts that stay current with your QuickBooks data

A forecast that's accurate on the day it's built and stale a month later isn't much use:

• Automatic daily updates keep the forecast in step with actual QuickBooks Online results.
  ‍
• Manual updates can be triggered at any time, whenever fresh numbers are needed.
  ‍
• No rebuilding from scratch. The forecast updates in place rather than starting over each time.

For a full walkthrough of the connection, the QuickBooks Online import guide in the Help Centre covers the setup step by step.

Scenario planning: Preparing for more than one version of the future

This is where a connected, driver-based forecast really earns its keep alongside QuickBooks' trend-based view. Instead of one projection, it's possible to build and compare several, each based on a different assumption:

• Seasonal dip in revenue and what it does to the cash position over the following quarter
  ‍
• New hiring, modelled against both a best case and a slower ramp-up
  ‍
• A piece of equipment financed rather than purchased outright
  ‍
• A key customer paying consistently late instead of on terms
  ‍
• Opening a second location, and how long it takes to reach breakeven

None of these are hypothetical for a growing business, as they're the exact questions a board, a lender, or a management team asks on a fairly regular basis. Having more than one modelled scenario ready is what propels a finance team from reporting on the business to actively steering it.

How Fathom connects to your QuickBooks data

QuickBooks stays exactly as a system of record for daily bookkeeping, transactions, and reconciliation. Fathom connects on top of it, pulling that data through to add a forecasting and scenario-planning layer alongside it:

• ‍Native integration with QuickBooks Online: Supported in most regions, importing the Chart of Accounts and transaction history automatically, along with automatic detection of cash-basis or accrual accounting
  ‍
• ‍QuickBooks Desktop support: Connects through the Fathom Desktop Connector, covering versions from the current year across Pro, Premier, Simple Start, and Enterprise editions
  ‍
• ‍Automatic updates: For QuickBooks Online companies, automatic daily updates or a manual update can be triggered at any time, so the connected data doesn't go stale
  ‍
• ‍A one-way connection: Fathom reads data from QuickBooks. It never writes back. QuickBooks data stays exactly as it was, which matters for any CFO weighing up whether to connect a second system to their books
  ‍
• ‍Single sign-on support: It's possible to log into Fathom directly using existing Intuit credentials

Setting up the connection itself takes a few minutes through the Fathom and QuickBooks integration page, with step-by-step guides available for both QuickBooks Online and QuickBooks Desktop in the Help Centre.

What this looks like in practice

For the CFO or finance executive

A connected three-way forecast changes what's possible in a board meeting or a lender conversation:

• ‍Walk in with options, not one number: Two or three modelled scenarios, built on the same QuickBooks data, show how a decision plays out across the full financial picture.
  ‍
• Package it for the board: Modelled scenarios can be turned into board-ready reports with Fathom's management reporting software, rather than rebuilt in a separate document.
  ‍
• ‍Add the narrative automatically: Commentary Writer generates AI-powered commentary on those reports, so the story behind the numbers doesn't need to be written from scratch each time.

That's the difference between reporting on the business and actively planning for it, and it's a meaningful step up for a finance team looking to grow its strategic role.

For the SME owner

For an owner without a finance team behind them, the value is simpler:

• ‍Know before deciding: See whether there's enough cash to make a decision before making it, without building a forecasting model from scratch in a spreadsheet.
  ‍
• ‍Bring in an existing budget: A QuickBooks Online budget can be imported directly into Fathom as a starting point.
  ‍
• ‍Build one from the forecast: A Fathom forecast can be saved as the new budget going forward, so the two systems reinforce each other rather than duplicating work.

Getting started with three-way forecasting from your QuickBooks data

QuickBooks keeps the books clean and current. Layering a connected three-way forecast on top of that same data gives a finance team or business owner the range to plan several moves ahead, model more than one future, and walk into a board meeting or a lender conversation with a plan built on real numbers rather than a spreadsheet built overnight.

Try Fathom today

Ready to see what your QuickBooks data can do with the right forecasting layer on top?  Explore Fathom's QuickBooks integration here.

Or you can start your 14-day free trial with no credit card required and speak to our team.

Frequently asked questions (FAQs)

1. ‍Does QuickBooks Online have a cash flow forecasting tool?
   
   ‍Yes, on the Advanced plan. It's a trend-based forecast built from historical financial data, projecting a single scenario without a connected balance sheet.
   ‍
2. ‍What's the difference between a cash flow forecast and a three-way forecast?
   
   ‍A cash flow forecast on its own projects cash movements in isolation. A three-way forecast connects the profit and loss statement, balance sheet, and cash flow together, so a change in one flows through to the others, giving a more complete and internally consistent picture.
   ‍
3. ‍Can Fathom forecast from QuickBooks Desktop as well as QuickBooks Online?
   
   ‍Yes. Fathom connects to QuickBooks Desktop through the Fathom Desktop Connector, supporting the current versions across Pro, Premier, Simple Start, and Enterprise editions.
   ‍
4. ‍Is there an extra cost to connect Fathom to QuickBooks?
   
   ‍No. Fathom charges per company connection rather than charging separately for the QuickBooks integration itself.