Skip to main content
T
ThL5
March 5, 2024
Question

Annual report comparisons - why does it add up all the years, when I try to run look at 5 years of historical profit & loss reports? I don't want an aggregate of the 5 years as the last column.

  • March 5, 2024
  • 2 replies
  • 0 views
Original commenter did not share additional details

2 replies

S
Sherrie_F
March 5, 2024

Hello there, @ThL5. 

 

Let me assist you with this and make everything clear about the report that you're trying to pull up.

 

In QuickBooks Online (QBO), running the report without the totals isn't possible.

 

Please know that our developers are working towards improving our product for the benefit of its users. With this, I'd suggest sending feedback to our engineering team so they can consider adding this feature in future updates.

 

Here's how:

 

  1. Log in with your QuickBooks Online (QBO) account.
  2. On the Gear icon, click Feedback.
  3. Enter your product comments and suggestions, then select Next to submit.

 

Alternatively, you can export the report that you want to accomplish into Excel.

 

Lastly, I've added a resource that you can browse through for you to be able to save a report with its current customization settings: Memorize reports in QuickBooks Online.

 

Should you need any other queries pulling up a report or anything else about QuickBooks, let us know by dropping a comment below. We're always here to assist you 24/7. Stay safe.

T
ThL5Author
March 6, 2024

But I don't want a total column on the right hand side - I don't care about seeing the sum of the 5 years, and there doesn't seem to be any way of getting rid of the far right column.

 

Even your example has the right hand column adding up the prior years.

Unless you are doing a year to date, adding the totals are unnecessary; 5 years of total are unnecessary unless specific to a sale of a business or something unusual.

 

Change this!

MsNorthPND18
MsNorthPND18
March 6, 2024

I understand that you find the total column of your QuickBooks Online (QBO) transaction report unnecessary.

 

The report cannot be generated without the totals column. However, you can export the transaction report to an Excel file and provide feedback. This will allow you to review the report in a different format and provide any necessary comments.

 

Here's how to submit feedback for QuickBooks Online:

  1. Select Settings, then Feedback.
  2. Enter your comments or product suggestions. Then select Next to subit feedback.

 

To know more about modifying and managing the accounting method in your QuickBooks Online:

 

Please let me know if you have more questions about annual report comparisons in your profit and loss reports. I'll be glad to assist. Keep safe.

R
RishBR
March 7, 2024

Hi @ThL5,

 

Rishika here from Better Reports!

I think our app, Better Reports, can easily show this. I have attached a screenshot below that shows the sample report showing the year-wise Profit and Loss Statement. The report also has an option to include or exclude the grand total column at the right.

Also, there are other built-in reports available like “Balance sheet”, “Profit and Loss by Vendor”, “Profit & Loss by Account”, etc. We can create custom reports as well, based on your business requirements. 
 
It is also possible to filter the report for a specific period and schedule the reports to be sent automatically to your email or Google Drive at a regular cadence.

What do you think?

    T
    ThL5Author
    March 19, 2024

    I understand that you have a solution but QuickBooks should have it built in.  Sorry, I can't pay for a solution in my situation.

    I
    Irene R
    March 19, 2024

    Hello there, ThL5.

     

    I truly understand the importance of personalizing your Profit and Loss report in accordance with your wants and business needs using QuickBooks Online. I'm here to share information with you on this matter.

     

    It is QuickBooks Online (QBO) by design to have the total amount or columns in the Profit and Loss Report or any report in the software.

     

    Alternatively, we can export the report from your QBO to Excel. From there, you can manually remove the total amount, columns, or any necessary details you want to attach to your Profit and Loss Report. 

     

    Here's how you can export the report: 

     

    1. Go to Reports, then look for the one you want to export.
    2. At the top right of the report, click on the Export icon, then select Export to Excel.
    3. Then save the file, like your Downloads or Desktop folders, where it is easy to find.

     

    Once you've downloaded and noticed missing data in the report, know that the file is currently in protected view. You have to click on Enable Editing to view the full report.

     

    In addition, learn how to get the most out of your reports by personalizing them in your QBO: Customize reports in QuickBooks Online. 

     

    Let me know if you have further inquiries about modifying your Profit and Loss Report in QBO. I'll be sure to answer them as soon as possible.

    Terms & ConditionsAccessibility statement