cancel
Showing results for 
Search instead for 
Did you mean: 
titan321214
Level 1

Quickbooks Desktop Pro 2017 Statement of Cash Flows showing multiple columns by year

Hello,

 

Is it possible to create a Statement of Cash Flows in Quickbooks Desktop Pro 2017 that shows multiple years and has a column for each year? For example, if the report were set to show the years 2018 to 2020, it would have a three columns. One each for 2018, 2019, and 2020. 

 

I can do this with the P&L and Balance Sheet in Quickbooks and would like to do it with the Statement of Cash Flows.

 

Solved
Best answer August 09, 2020

Best Answers
RenjolynC
QuickBooks Team

Quickbooks Desktop Pro 2017 Statement of Cash Flows showing multiple columns by year

Hi, titan321214.

 

I appreciate your time reaching out to us here. Running a year comparison for the Statement of Cash Flows report is unavailable. You'll want to use the custom date to get each year's data. Then, export the report to Excel and manually combine them on a spreadsheet.

 

Here's how:

 

  1. Go to Reports > Company & Financial > Statement of Cash Flows
  2. Select Custom from the Date drop-down and select the From and To date.
  3. Click the Excel drop-down list and choose Create New Worksheet.
  4. Select Create a comma separated values (.csv) file and click Export. Save the file on the your Desktop, so you can find it easily.

Repeat the same process for the other years. Then open the Excel files, copy and paste the data on one spreadsheet. 

 

I'm also adding this article for reference: Export reports as Excel workbooks in QuickBooks Desktop.

 

Please don't hesitate to leave a comment below if you have any other questions for QuickBooks. Take care and stay safe.

View solution in original post

4 Comments 4
RenjolynC
QuickBooks Team

Quickbooks Desktop Pro 2017 Statement of Cash Flows showing multiple columns by year

Hi, titan321214.

 

I appreciate your time reaching out to us here. Running a year comparison for the Statement of Cash Flows report is unavailable. You'll want to use the custom date to get each year's data. Then, export the report to Excel and manually combine them on a spreadsheet.

 

Here's how:

 

  1. Go to Reports > Company & Financial > Statement of Cash Flows
  2. Select Custom from the Date drop-down and select the From and To date.
  3. Click the Excel drop-down list and choose Create New Worksheet.
  4. Select Create a comma separated values (.csv) file and click Export. Save the file on the your Desktop, so you can find it easily.

Repeat the same process for the other years. Then open the Excel files, copy and paste the data on one spreadsheet. 

 

I'm also adding this article for reference: Export reports as Excel workbooks in QuickBooks Desktop.

 

Please don't hesitate to leave a comment below if you have any other questions for QuickBooks. Take care and stay safe.

View solution in original post

g22815
Level 1

Quickbooks Desktop Pro 2017 Statement of Cash Flows showing multiple columns by year

RenjolynC,

 

I appreciate you providing this explanation, but I don't understand why this functionality is not available. It is available for the Balance Sheet and Income Statements. The method you explained works, but it looks inconsistent. If there is any way to request this functionality be added, I'd like to do so.

g22815
Level 1

Quickbooks Desktop Pro 2017 Statement of Cash Flows showing multiple columns by year

RenjolynC,

 

I appreciate you providing this explanation, but I don't understand why this functionality is not available. It is available for the Balance Sheet and Income Statements. The method you explained works, but it looks inconsistent. If there is any way to request this functionality be added, I'd like to do so.

LieraMarie_A
QuickBooks Team

Quickbooks Desktop Pro 2017 Statement of Cash Flows showing multiple columns by year

Thanks for getting in touch, @g22815.

 

Being able to run the Statement of Cash Flows report displaying columns by year would be handy as you're able to compare the business cash position each year. Rest assured that I'll relay this message to our team in concern here on my end and add your vote for this one.

 

You can also share your thoughts and ideas through your account. Our product development team reviews all the feedback we receive to ensure we’re meeting the needs of our customers. 

 

  1. Go to the Help menu.
  2. Choose Send Feedback Online and select Product Suggestion.
    Capture.PNG
  3. Click the Product Area drop-down menu and select Reports.
  4. Enter your comments or product suggestions.
  5. Select Send Feedback.

 

You can check out this article to see the complete list of available reports for your QuickBooks Desktop: Understand reports.

 

If you have any other questions, just let me know and I'll be happy to help. Thanks again for reaching us and have a good day!

Sign in for the best experience
Ask questions, get answers, and join our large community of QuickBooks users.
Sign In / Sign Up

Need to get in touch?

Contact us