cancel
Showing results for 
Search instead for 
Did you mean: 
finance-techcore
Level 2

Can quickbooks report cash flows using a "direct" method? To all CFOs !!! If it it can't - how do you guys see the info related to direct cash flows?

 
11 Comments 11
RaymondJayO
Moderator

Can quickbooks report cash flows using a "direct" method? To all CFOs !!! If it it can't - how do you guys see the info related to direct cash flows?

I'll provide the steps on how to prepare a Statement of Cash Flows using a direct method, @finance-techcore

 

Yes, we have a cash flow statement template that's ready for customization when using the direct method. We'll need to manually prepare it since QuickBooks Online (QBO) runs the said report on an accrual basis.

 

First, let's gather and take note of all your cash amounts received and paid by your company. These will serve as your reference when filling out the spreadsheet below. Here are the examples: 

  • Cash collected from customers
  • Cash received from interest and/or dividends
  • Payments to employees
  • Payments to suppliers
  • Cash paid for interest and tax payments

 

Second, let's download the cash flow statement template to manually prepare your report using the direct method. You can also run Profit & Loss and Balance Sheet on a cash basis for your other data references. From there, enter the applicable values in their respective cells. The total amounts will auto-populate based on the embedded formulas. You'll also get a sample cash flow statement to help guide you through the process, as seen in the screenshot below. 

 

To learn more about the process above, check out this article: A Guide To Cash Flow Statements With Template (Direct Vs. Indirect Method)

 

Also, I recommend turning on the Cash Flow Dashboard Widget to get a clearer picture of money coming in and going out over the last 12 months. Just go to the Settings (gear) icon at the upper right and select QuickBooks Labs. Then, enable this feature and click Done. After that, you'll see this on the Dashboard menu. Here's what it looks like: 

 

I'm here anytime you have other concerns. Take care always, @finance-techcore

finance-techcore
Level 2

Can quickbooks report cash flows using a "direct" method? To all CFOs !!! If it it can't - how do you guys see the info related to direct cash flows?

Hi there!  

thanks for the template. 

 

Can QB do this for me automatically?  You have supplied me with a template but how do I get the info? For instance "cash received from customers" - where do I get this information?  

FritzF
Moderator

Can quickbooks report cash flows using a "direct" method? To all CFOs !!! If it it can't - how do you guys see the info related to direct cash flows?

Thanks for getting back to us, @finance-techcore.

 

Currently, the option to automatically let QuickBooks Online (QBO) pull up the cash flow statement template for you is not yet available. You need to download it manually and fill or enter the applicable values, as mentioned by my colleague above. Also, you can use the  Profit & Loss and Balance Sheet on a cash basis reports for your reference.

 

I can see how having this option would be helpful for you and your business. Rest assured that I'll pass along your suggestion to our Product Developers. They're always looking for ideas to consider on how to improve QBO.

 

In the meantime, I recommend visiting our Blog site. This is where we share recent happenings and future developments, such as updates to newly added features.

 

Just in case, I'll add these articles for future reference:

 

 

Reach out to me in the comment section below if you have any other issues or concerns. I'm more than willing to assist. Have a good one!

finance-techcore
Level 2

Can quickbooks report cash flows using a "direct" method? To all CFOs !!! If it it can't - how do you guys see the info related to direct cash flows?

Hi  - I am sure you know that:

cash basis PL & BS doesn't work (still puts in JE s and non-cash items)
XERO (competitor) already has it

Question - template asks me to input this info - so WHERE DO I GET IT? 

 

Cash Sales
Collections from Customer Credit Accounts
Loan or Other Cash Injection
Interest Income
Income Tax Refund
Misc. Cash Receipts
TOTAL CASH RECEIPTS
 
LESS: CASH PAYMENTS
COST OF GOODS SOLD:
Direct Product/Service Costs
Charies_M
Moderator

Can quickbooks report cash flows using a "direct" method? To all CFOs !!! If it it can't - how do you guys see the info related to direct cash flows?

Thanks for getting back to us, finance-techcore.

 

Allow me to share additional insight about managing Statement of Cash Flow in QuickBooks Online (QBO).

 

The information on QBO reports depends on the chosen type of industry when you set up your company file. That said, the downloaded template for cash flow statement should be customized to include necessary types of cash flow activities that is applicable to your business type.

 

To make sure everything is accurate, I recommend working with your accountant or any knowledgeable financial specialist in filling up the downloaded Cash Low Statement template. They can provide expert advice on how to deal this type of situation.

 

You can also find an accountant by clicking on this link: Find an accountant.

 

We are finding more ways to improve the report options for our customers convenience. While we do, I encourage you to visit our QuickBooks Blog where we post the most recent feature updates of the product.

 

If there's anything I can help you with, feel free to drop me a reply below. Hope you have a good one.

finance-techcore
Level 2

Can quickbooks report cash flows using a "direct" method? To all CFOs !!! If it it can't - how do you guys see the info related to direct cash flows?

HI  - so disappointing.  

 

can't you just admin that QB has no ability to provide a DIRECT cash flow statement?  and that there is not way to get this information anywhere? 

 

If you are working on it  - great.  Can you please give my contact to your dev team?  I would like to know when you guys will have it...(all CFOs want to know that)   Once again you competitors already have it - please don't be left behind!!!!   We want to QB to continue succeeding but you have to move fowward. 

mexicain
Level 1

Can quickbooks report cash flows using a "direct" method? To all CFOs !!! If it it can't - how do you guys see the info related to direct cash flows?

I am also frustrated about the Direct Cash Flow report not available.  It would be so simple for QB to do it.

 

I am under a program called Profit First where I need to have the Direct Cash Flow Statement.  Too highly time-consuming.  Please advise when the report will be ready.

IamjuViel
QuickBooks Team

Can quickbooks report cash flows using a "direct" method? To all CFOs !!! If it it can't - how do you guys see the info related to direct cash flows?

Hello, @mexicain.

 

I understand the importance of having the ability to run a Direct Cash Flow report. Your business cash flow is the amount of money moving in and out of your business and bank account. Currently, QuickBooks Online offers different reports and projections to get a clear look at your current and future businesses' finances. You can generate and customize these reports to suit your business needs.

 

Also, you follow the information shared by my colleague above,  RaymondJayO.

 

Get back to us here if you have further questions or concerns. You can reach out to the Community at any time. Take care and have a great day! 

 

mexicain
Level 1

Can quickbooks report cash flows using a "direct" method? To all CFOs !!! If it it can't - how do you guys see the info related to direct cash flows?

Thanks for your reply!

I use Quickbooks Enterprise.

I need to dig in into advance reporting but the work I would do could be done by someone in QB only once and all the customers can benefit from ti.

Sometimes I don't understand big companies (including Salesforce) that can easily focus on quick-hit type of deals that can make everyone's life better and

 happier.

jmeghnani
Level 1

Can quickbooks report cash flows using a "direct" method? To all CFOs !!! If it it can't - how do you guys see the info related to direct cash flows?

Hi

Any update on whether QB has been able to resolve the issue of generating cash flow based on direct method??

 

Thank you

MaryLandT
Moderator

Can quickbooks report cash flows using a "direct" method? To all CFOs !!! If it it can't - how do you guys see the info related to direct cash flows?

We haven't received an update about the availability of the direct method when using cash flow for QuickBooks Online International, jmeghnani.

 

For now, you can run and manually customise your report. I've added this link to learn more about the outflow of your business: How to prepare and analyze a statement of cash flows.

 

Stay in touch if you need additional information by commenting below. I'm always right here to help you.