If your P&L says you made money and your bank account disagrees, QuickBooks Online will tell you why. Most owners never open the report. It takes about five minutes.
This is the shortcut version of building a cash bridge by hand. If you want to understand why profit and cash separate in the first place, read why a profitable company runs out of cash first. This article is just how to run the report and read it.
Run It Month Over Month
In QuickBooks Online, go to Reports and open Statement of Cash Flows.
Three settings before you read anything:
Set the date range to the last six to twelve months. One month tells you nothing. The pattern is the whole point.
Set “Display columns by” to Months. This is the step people skip, and without it the report is nearly useless. You want each month as its own column so you can scan across.
Then hit Run report.
What the Report Is Doing
It starts with net income and works backward to your actual change in cash. Every line between those two numbers is something that moved cash without moving profit, or moved profit without moving cash.
QuickBooks groups those lines into three sections. Read them in order.
Operating Activities
Net income at the top, then the working capital adjustments.
- Accounts receivable. If AR went up, cash went down. That’s work you did and billed but haven’t collected. Growing companies live here.
- Accounts payable. If AP went down, you paid vendors faster than you took on new bills. Cash out. If AP went up, you effectively borrowed from your supply house that month.
- Inventory. Parts on trucks and in the warehouse. Cash out, even though none of it has hit the P&L yet.
- Depreciation. Added back, because it’s an expense that never cost you cash this month.
- Deferred revenue. Membership money collected for visits you haven’t performed. Cash in now, obligation later.
Investing Activities
Trucks, equipment, and buildings. Big, lumpy, and completely invisible on the P&L in the month you write the check.
Financing Activities
Two lines that account for more “where did it go” conversations than everything above combined.
- Loan principal. Each note shows the principal you paid down. Your P&L only shows the interest. A fleet of financed trucks can pull $60K or $80K a month straight out of the bank with almost nothing to show for it on the income statement.
- Owner distributions. Money you took out. Not an expense, not on the P&L, absolutely gone from the account.
Seeing those side by side, month by month, usually answers the question on the spot. And it tends to be one line doing most of the damage, not six. Fix that one first.
When the Report Lies to You
This report is only as good as the balance sheet underneath it. Two failure modes to check before you trust what you see.
Nothing is reconciled. If bank and credit card accounts aren’t reconciled through last month, and loan balances don’t tie to the actual amortization schedules, the adjustment lines are noise. Fix that first. It’s a bookkeeping problem wearing a cash problem costume.
Purchases are landing in the wrong place. I’ll be looking at a company’s books and gross profit is sitting at 35%, which makes no sense for residential service. It should be closer to or above 50%. So I start asking questions, and it turns out they bought five or ten trucks, stocked them, maybe added a warehouse, and every dollar of it went straight into cost of goods sold. Some of that belongs on the balance sheet as inventory and fixed assets.
When that happens, your gross margin is wrong, your EBITDA is wrong, and the cash flow statement can’t show you an inventory build that was never recorded as inventory.
A workaround for truck stock
If you’re not ready to run real inventory counts, don’t. Nobody in a $5 million shop is doing weekly truck counts, and the ones who claim they are usually aren’t.
Do this instead. Figure out an average per truck, say $4,000 for one size and $7,000 for another, and carry that total on the balance sheet as inventory. Review it every three to six months and true it up.
It isn’t perfect, and you do need to watch for parts walking off, because an average hides leakage by design. But it gets your gross profit close to honest and puts the truck stock where the cash flow statement can see it. That’s a much better position than a 35% gross margin you can’t explain.
This Report vs. Your 13-Week Forecast
They answer different questions and you need both.
The Statement of Cash Flows is backward-looking. It tells you where the money went last month, and it’s built off accrual accounting.
A 13-week cash flow forecast is forward-looking and built off bank clearance dates. It tells you which week you get tight.
Use this report on the 10th when the books close, to understand the month. Use the forecast every Monday, to make a decision.
Take It One Step Further
John Wilson runs Wilson Companies in the Midwest, on his way past $100 million. When I was on Owned and Operated with him, he described the change that fixed this for them. Their monthly leadership meeting used to walk the P&L down to EBITDA and stop. They realized that wasn’t enough, so they kept going all the way down to cash. Trucks at $80K a month. A building at $50K a month. A $300K inventory buy spread across a few months.
What that exercise showed them was blunt. On paper they were a 17% business. In actual free cash they were at 2%. The full conversation is here: Growth Is Eating Your Cash.
So they reset the target. They set breakeven at 25% EBITDA specifically so free cash would land at 8% to 10%, and worked it for about a year. EBITDA now runs in the low-to-mid 20s every month and the business throws off cash.
That’s the whole point of this report. EBITDA is a scoreboard. Cash is the game.
If you want the full picture on why profitable home service companies stay broke, start with the owner’s guide to cash flow.
Questions Owners Ask
Where is the Statement of Cash Flows in QuickBooks Online?
Reports, then Statement of Cash Flows. Before you read it, set the date range to the last six to twelve months and set “Display columns by” to Months. A single month of this report tells you almost nothing.
Why doesn’t my QuickBooks cash flow statement match my bank account?
Usually because the balance sheet underneath it isn’t clean. If bank and credit card accounts aren’t reconciled through last month, or loan balances don’t tie to the amortization schedules, every adjustment line is a guess. Reconcile first, then read the report.
Does the QuickBooks cash flow statement show loan principal payments?
Yes, under Financing Activities. That’s the main reason to run it. Your P&L shows only the interest, so a fleet of financed trucks can pull tens of thousands a month out of the bank with almost nothing showing up on the income statement.
Should I use the cash flow statement or a 13-week forecast?
Both, for different jobs. The Statement of Cash Flows is backward-looking and tells you where last month went. A 13-week forecast is forward-looking and tells you which week gets tight. Read the report when the books close. Update the forecast every Monday.
