Skip to main content
T
titan321214
August 10, 2020
Solved

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

  • August 10, 2020
  • 1 reply
  • 0 views

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.

 

    Best answer by RenjolynC

    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.

    1 reply

    RenjolynC
    RenjolynCAnswer
    August 10, 2020

    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.

    G
    g22815
    April 6, 2021

    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.

    Terms & ConditionsAccessibility statement