cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Want an expert to help you set up your QuickBooks Online? Find out how: Click here

Reply to message

View discussion in a popup

Replying to:
RaymondJayO
Moderator

Reply to message

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