QuickBooks Cash Flow Statement: Run the Statement of Cash Flows, Fix the Report, Tie It Out

How to run the statement of cash flows in QuickBooks

In QuickBooks Online, go to Reports, then Standard reports, and search for Statement of Cash Flows. It also sits under the Business Overview group. In QuickBooks Desktop the path is Reports, then Company & Financial, then Statement of Cash Flows. Set the reporting period and the report returns a single total column by default. Use Customize to split that total into interim columns: months, quarters, classes, locations or customers. Splitting by month is what most controllers want, because a quarterly total hides the month where collections stalled.

One setting is not a setting at all. The statement of cash flows runs on accrual basis only, and QuickBooks will not let you switch it to cash. That is correct behavior rather than a bug: the indirect method starts from accrual net income and reverses the accruals back out, so a cash-basis version of the reconciliation would be circular. It does mean that if your P&L is being read on a cash basis and your cash flow statement is not, the two documents will disagree about net income and somebody will ask why. Pick accrual for the whole pack, label it, and stay consistent. Our guide to the QuickBooks cash flow statement walks the report screen by screen, and the companion reports are covered on the QuickBooks financial statements hub.

Export from the report header to PDF or XLSX. The XLSX keeps the section subtotals, which matters if the export feeds a reporting pack downstream rather than getting emailed as is.

Why is my QuickBooks cash flow statement wrong?

Because QuickBooks assigns every account to operating, investing or financing based on the account type you picked when the chart of accounts was built, and account type is a much cruder signal than the classification a statement of cash flows actually requires. Four failures show up over and over. A revolving line of credit set up as an Other Current Liability lands in the operating section, when borrowings and repayments on a line belong in financing. A vehicle loan entered as a current liability does the same thing. Depreciation, the single largest non-cash add-back in most small company statements, is often missing entirely because QuickBooks builds the reconciliation from balance sheet movement and the expense account itself carries no balance to move. And an owner draw account classified as an equity account may or may not appear where a reader expects it.

There is a second class of problem that has nothing to do with classification. If bank accounts are not reconciled through the period end, the change in cash at the bottom of the statement is a number nobody should rely on, and every section above it inherits the error. Duplicate deposits created by accepting a bank feed match that already existed will inflate operating cash. Transactions dated outside the period, or backdated into a closed month, will move cash between columns. A statement of cash flows is the most sensitive of the three statements to bad underlying data, because it is entirely constructed from differences between two balance sheets.

The tell that something is wrong is simple, and you can check it in fifteen seconds. Take the ending cash on the statement of cash flows and compare it to the cash and cash equivalents line on your QuickBooks balance sheet at the same date. They must be identical. If they are not, stop and find the reason before the pack leaves your desk. AIStatements runs that tie automatically and refuses to present a statement that does not close.

Direct method or indirect method, and which one QuickBooks gives you

QuickBooks gives you the indirect method. It starts at net income, adds back non-cash items like depreciation and amortization, adjusts for movement in working capital accounts (receivables, payables, inventory, accrued liabilities, deferred revenue) and arrives at cash from operations. The direct method instead lists actual cash receipts from customers and cash paid to suppliers, employees and lenders. QuickBooks has no direct method report, and no customization produces one, which is a genuine complaint you will find in Intuit community threads going back years.

For US GAAP purposes, FASB permits either method and encourages the direct method, but the overwhelming majority of US private companies file indirect, partly because the direct method requires a supplementary reconciliation anyway. A lender or a surety reading your statements expects indirect and will not question it. If you specifically need a direct-method presentation, it has to be built from cash account activity rather than from the report QuickBooks hands you. We cover the mechanics and when each one is worth the effort in direct vs indirect cash flow method.

The practical takeaway for most finance teams: keep the indirect statement as the formal document, and run a separate cash-in, cash-out view for internal management. They answer different questions and neither replaces the other.

What AIStatements does with your QuickBooks data

Connect QuickBooks or drop in the export. AIStatements reads the same ledger QuickBooks reads, then rebuilds the statement of cash flows rather than reprinting it. Every account is classified into operating, investing or financing based on what the account actually is, not the type dropdown someone chose during setup, so a line of credit lands in financing and equipment purchases land in investing. Depreciation and amortization are picked up as explicit non-cash add-backs. Working capital movement is broken out line by line, so you can see whether cash was consumed by receivables, by inventory or by paying down payables faster than usual. The statement is then tied against the movement in cash on the balance sheet before you are shown anything.

The numbers are deterministic, computed from your ledger. The AI writes the commentary on top of them and cites the figures it refers to, which is the part that turns a cash flow statement into something a board can act on: cash from operations was positive but only because payables stretched by eighteen days, or free cash flow turned negative in May when the equipment purchase closed. You get monthly columns, a full statement pack alongside the QuickBooks profit and loss statement and balance sheet, and PDF plus XLSX export. Firms running many client files get the same output per client, white-labelled, through the accounting firm plan. The generic version of the report, from any CSV, is at the cash flow statement generator.

Two honest limits. We integrate with QuickBooks and are not affiliated with Intuit. And AIStatements formats and analyzes your data: it is not accounting, audit or tax advice, it is not a CPA, and it does not guarantee GAAP compliance. Have a licensed professional review anything you file or submit to a lender.

Common questions