I appreciate the steps you've taken to elaborate your concern, @david-hall.
Let's utilize the reporting period when pulling up your Statement of Cash Flows report to identify why you have incorrect report data.
From there, you can open your Transaction List report and investigate every details of your transaction. To add, you can consider comparing your reports from one to the other to check if they have the same data.
But know that your report's data are always dependent on what information you've entered into your account. With this, I've added this helpful article that you can read to learn more about the filters and data of your reports: Targets vs. Sources Overview.
Lastly, I've also added our Help Articles page for QuickBooks Online in case you need some related articles for your future tasks.
If there's anything else that I can help you with, please let me know in the comment section down below. I'll be always around ready to help.
@david-hall I have the same issue. It also happens when the account detail type is Sundry, Staff Costs and Other External Services among others. Like you, the profit on my balance sheet and profit and loss reconcile, so I believe the data is fine. When I changed the account detail type in the chart of accounts, the profit for the year now correctly shows in the cash flow statement.
@JonpriL is there some sort of setting within the statement of cash flows that is inadvertently excluding certain types of accounts? Or is there a reason that these types of accounts are shown differently?
The Statement of Cash Flow report groups a small section of accounts with certain detail types under 'non-cash income and expenses', like the aforementioned expense accounts above (Other external services, Sundry and Staff costs). We also see this on other detail types Expenses > Other current operating charge, Expenses > External Services and Expenses > Project studies, surveys, assessments. This also includes a small selection of Income accounts: Income > Operating Grants, Income > Own work capitalised and Income > Other current operating income.
To work around this, as you've identified you would need to edit the account detail types to another type that will show as preferred on the report:
While this has been passed on as feedback to the product enhancement team for these detail types to be included in a future update, I would please encourage you to use the Feedback option in-product to submit this as well. To do so, go to the Settings icon and select Feedback. We value all insights from our customers and want to ensure we are working towards the best customer experience possible when using QuickBooks Online.
"It also shows cash flows from Non Current Liabilities as Operating cash flows instead of Financing Cash"
Yes, that's my frustration too. GAAP requires current portion of LT liabilities to be in the Financing Section... So why does QBO put "Other Current Liabilities" "Loan Payable" in the Operating Section of the Statement of Cashflows?
Intuit needs to have their accounting team look at this, probably?
To further check on this report, I suggest reaching out to our Customer Support. They can get into your account in a secure environment and help you in arranging these accounts in the report.
You can do it by going to the Help icon at the top right of your QuickBooks Online (QBO) account. See this article for detailed guidance: Contact the QuickBooks Online Customer Support team.
I'm always here if you have any other concerns. Have a great rest of the day!
I love how Intuit are improving the product
But... if you are pursuing the CPA market you really need to go all in and have CPA advisors helping you with the report formats and ensuring they are correct.
Either you're in the CPA market or you're not.