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

reports

Does anyone know if I can run a 3 year comparison for profit & Loss report?

 

5 Comments 5
ShyMae
QuickBooks Team

reports

You'll be happy to know you can run a three-year comparison for Profit & Loss report, haggertysrides.


Please know that the Profit and Loss Comparison report can only compare two years at a time.

As a workaround, you can use the Profit and Loss by Month report to compare your income and expenses for up to three periods. This report presents a detailed overview of your business performance during a specific timeframe, giving you a better understanding of how your business is doing.

I'm here to walk you through how to generate this:

 

  1. From the left navigation panel, select Reports
  2. Look for the Profit and Loss by Month.
  3. From the Report Period column, choose All Dates
  4. In the Display column by, set this to Years
  5. Click Run report.

    Report Sample 1.jpg

    Report Sample 2.jpg

 

If you wish to have a printed version, click the Print icon, and if you want to send the report via email, click the Email icon. 

image (3).png

 

Moreover, you can customize your reports in QuickBooks and memorized them. This feature saves you time from doing the customization process again. 

 

You can reach out again if you require additional help or clarification regarding the Profit and Loss Report. I'm always here to help you. Best wishes!

nightwatchjess
Level 2

reports

I am the admin of the company and tried to follow the instructions listed.

 

The report period column briefly shows then disappears so I cannot edit it.

nightwatchjess
Level 2

reports

Disregard - turns out it scrolled down and I didn't see that I could scroll up to find the menu.

Ncc2024
Level 1

reports

I am also trying to run a 3-yr comparison based on a 12 month period (not calendar or fiscal year). I have done this in the past, but now the "Display Columns By" dropdown does not include an option for "Years".  I see Calendar Years or Fiscal Years, but not simply Years. Is this function still available?

SheandL
QuickBooks Team

reports

The ability to choose years in Display column by is not available in this report, Ncc2024. At the same time, I'm to share some steps on how you can still compare your records using this report. 

 

The Profit and Loss Comparison report shows the current year-to-date figures of your business by default. To view this report according to your preference, you can use the Compare another period  dropdown to customize it. I'll be here to guide you on how.

 

  1.  Go to Reports.
  2. In the search field, write Profit and Loss Comparison, or locate it using the Standard tab.
  3. Edit the length of time you want to view in the Report period. Select the start and end dates in the date field.
  4. From the Compare another period dropdown, select and modify the Previous year checkbox. You can also choose the Previous Period checkbox.
  5. In the same dropdown, click the $ change or % change checkboxes. This way, they will be included.
  6. Choose between Cash or Accrual in the Accounting method.
  7. Once done, click Run report.

 

For reference, check out this article: Run a Profit and Loss Comparison Report in QuickBooks Online and Online Accountant.

 

Additionally, you can read this article to learn more ways to personalize a report in QBO: Common custom reports in QuickBooks Online.

 

If you have further questions about the functions in this report, I'll be right in the corner to always offer my assistance. Just click the reply button if you have one. 

Need to get in touch?

Contact us