Quickbooky

Accounting News

Cash Flow & Forecasting

QuickBooks Cash Flow Planner Skips Manual Entries and Card Transactions

QuickBooks Online's cash flow planner excludes manual entries, card and trust account activity, and multi-currency files, and here is what it counts.

COMMUNITY ISSUESQUICKBOOKY

Questions keep arriving from QuickBooks Online users about the cash flow planner. The forecast looks nothing like their books, users report, and whole categories of spending seem to be missing. The accepted answer on the subject, published by Intuit, confirms the gaps are deliberate. The tool was never designed to mirror your ledger, and knowing where it looks, and where it refuses to look, explains almost every discrepancy.

A forecast built from bank history

The planner is an interactive tool that projects the money moving in and out of your business. It studies the transaction history of your connected bank accounts, then forecasts recurring income and expenses from those patterns. You can layer hypothetical events on top, a loan, a hire, a large purchase, and watch the projected balance react. Intuit frames the tool around timing: when to save, when to spend, when to borrow, and when to shift money between accounts. First-time users see a short setup prompt before any projection appears.

Why does the forecast ignore some transactions?

The model draws only on accounts connected through the bank feed. Categorized and uncategorized transactions both count. Everything outside that stream is invisible to the projection. Manual entries top the exclusion list. If you typed a transaction into QuickBooks by hand, the planner will not factor it in. Users who run partly manual books see the largest gaps for that reason alone. The chart reflects the feed, not the file.

Credit cards and trust accounts stay out

Two further exclusions catch people off guard. Credit card transactions never appear, so card-based spending is absent from the outlook entirely. Trust account activity is excluded too, which matters to firms that hold client funds. The tool also counts only movements of actual money. Entries that record no cash movement, depreciation for instance, do not register on the chart at all.

Multi-currency files are left out entirely

Companies with multi-currency turned on cannot use the planner at all. The exclusion applies to the whole company file, not merely to foreign-denominated accounts. Firms that invoice across borders have to build their forecasts elsewhere. Intuit lists this as a flat limitation, and no workaround appears in the answer.

Does editing events in the planner change your books?

No. The planner works as a scratchpad. You can add, delete, and adjust future events to test scenarios, and none of it posts to your accounts. That sandbox design is the feature Intuit emphasizes most: model a decision here, then commit to it in the real ledger if the numbers hold. One caution applies. Because the model reads only feed history, a scenario that leans on unconnected accounts is guesswork dressed as a projection.

The time window is not what the label suggests

You reach the planner through the Reports area, under Financial Planning. A month filter then controls the window, and it sits beneath the today’s cash balance figure, easy to miss on a first visit.

Its labels are misleading. Select 24 months and you see the last nine, the current month, and the next fourteen. Select 12 months and the future view collapses to two months, while nine months of history remain on display. Six months keeps three months back and two forward. Three months shows one month on either side of today. One month shows the current month alone. Longer views buy future runway; shorter ones mostly trim history.

Disconnect a bank account and its history vanishes

The feed dependency cuts both ways. Disconnect a bank account and its data stops displaying on the chart. The forecast recalibrates around whatever connections remain. Anyone troubleshooting a thin or empty chart should check the connection list first, before assuming the tool itself is broken. We would rank this check as step one in any diagnosis, since it explains the symptom in one move.

A directional instrument, not a mirror

Read the planner as a directional instrument rather than a second set of books. Its line is a connected-accounts projection with a sandbox on top. If card spending, manual entries, or trust activity dominate your cash picture, the chart will understate reality by that much. Know the exclusions and the forecast becomes genuinely useful for timing decisions. Ignore them and it will keep disagreeing with your ledger, for reasons that have nothing to do with errors.

← Back to Community Issues