cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Can I generate a report which will show total sales for each of the past 5 years?

 
1 Comment
Moderator

Re: Can I generate a report which will show total sales for each of the past 5 years?

You can definitely generate that report, phyllis4.

 

Let's customize the Profit and Loss by Month report by filtering the transactions to show five years worth of data. Then, regroup them by years instead of by months. 

 

Here's how:

  1. Go to Reports.
  2. Search for Profit and Loss by Month.
  3. Click on the Customize button.
  4. In the Report period, choose the date range (example: 01/01/2013-12/30/2018).
  5. In the Rows/Columns section, select Years from the Columns drop-down. 
  6. In the Filter section, select All Income Accounts from the Distribution Account drop-down. 1.PNG
  7. Click on Run report.

Don't forget to save this customization. It will be easier for you to pull it up again from the Custom reports tab. 

 

Gay SC.JPG

You'll also find more ways on how to customize reports in this reference: Customize your financial reports

 

I'm happy that I was able to provide the steps to help you get the report you need. We're here if you've got more questions.