cancel
Showing results for 
Search instead for 
Did you mean: 
david-hall
Level 2

Has anyone had problems with the format of the Statement of Cash Flows? The total appears to be correct but the individual line items are not?

For example, the profit does not agree to the profit and loss statement: it excludes Other External Services, and then these are shown as a non-cash outflow further down the report, even though they are direct bank expenses.

It also shows cash flows from Non Current Liabilities as Operating cash flows instead of Financing Cash Flows.
7 Comments
JonpriL
Moderator

Has anyone had problems with the format of the Statement of Cash Flows? The total appears to be correct but the individual line items are not?

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.

  1. On your report, click Customise.
  2. Under Report period, select one from the list.
  3. Click Run report.

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
Level 2

Has anyone had problems with the format of the Statement of Cash Flows? The total appears to be correct but the individual line items are not?

Many thanks - I'll check out the articles you suggested

nirez
Level 1

Has anyone had problems with the format of the Statement of Cash Flows? The total appears to be correct but the individual line items are not?

@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?

 

Thanks

Kass_B - Product Champion
Content Creator

Has anyone had problems with the format of the Statement of Cash Flows? The total appears to be correct but the individual line items are not?

Hi nirez,

 

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:

 

  1. Select the Settings icon (top right), then Chart of Accounts.
  2. Locate the account and from the dropdown arrow on the right select Edit. 
  3. Change the Detail Type and Save and Close.

 

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.

 

-Kass

 

 

 

jwalterCFO
Level 1

Has anyone had problems with the format of the Statement of Cash Flows? The total appears to be correct but the individual line items are not?

"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?

MaryJoyD
QuickBooks Team

Has anyone had problems with the format of the Statement of Cash Flows? The total appears to be correct but the individual line items are not?

Hello, @jwalterCFO.

 

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!

david-hall
Level 2

Has anyone had problems with the format of the Statement of Cash Flows? The total appears to be correct but the individual line items are not?

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.