SUMMER SAVINGS 90% OFF QuickBooks for 3 months* Ends June 27

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Work smarter and get more done with advanced tools that save you time. Discover QuickBooks Online Advanced.
windyl0u
Level 2

How can I exclude specific accounts from my Profit and Loss in Desktop?

I'm on Pro Plus and I want to create a memorized P&L that excludes New Install Income and the COGS for those items. The only option I see is to choose multiple accounts and go through and select every single one outside of those 2. Who comes up with this stuff? Regardless, anytime I create a new account, I'll have to remember to go select it in that report, which is just crazy to me. This is so basic, I don't see why it can't be done. If I'm missing something, please let me know. 

3 Comments 3
Carneil_C
QuickBooks Team

How can I exclude specific accounts from my Profit and Loss in Desktop?

I can help you memorize your Profit & Loss report in QuickBooks Desktop (QBDT) so you won't have to go through the customization process again, windyl0u.

 

In QBDT, we have a feature that allows you to memorize your reports, enabling you to use the same settings of the customized report for future use. In your case, you'll need to exclude "New Install Income" and the COGS for your items, and then manually select the accounts you wish to include in the report. Once you’re done, click OK to save the changes.

 

 

From the Report window, select Memorize from the upper panel then enter a new name for it. 

 

 

This reference can help you if you want to access your memorized report: Create, access and modify memorized reports. It also includes fixes if you encounter errors when memorizing them.

 

In addition, you can now print financial reports with gridlines to be able to read them clearly. This article provides detailed process: Print reports with grid lines in QuickBooks Desktop.

 

The Community is still open to other concerns about reports in QBDT. Just add your reply below and we'll circle back to help you, windyl0u.

windyl0u
Level 2

How can I exclude specific accounts from my Profit and Loss in Desktop?

I don't know why I still act surprised when QB 'Support' goes on a long drawn out attempt to answer a question that they clearly have not READ. So, again, I'm looking for a report that I can memorize and I won't need to recreate it anytime I make a change, like adding a new account. Having to change the report constantly defeats the purpose of a 'memorized' report. 

Rea_M
Moderator

How can I exclude specific accounts from my Profit and Loss in Desktop?

To make changes to a memorized report, you'll need to memorize it again to add and save the updated data, windyl0u.

 

When you memorize a report in QuickBooks, it saves only the current settings and customizations. Any new accounts won’t be automatically included, so you’ll need to memorize the report again to overwrite the data.

 

 

For more insight, please see this article: Create, access and modify memorized reports.

 

Additionally, would you like to understand your company's financial behavior by incorporating reports from different QuickBooks Desktop (QBDT) files? If so, I recommend checking out this article: Combine reports from multiple company files.

 

Please let us know in the comments if there's anything else you need or concerns about memorizing reports in QuickBooks Desktop. We're always ready to help you out.

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.

Need to get in touch?

Contact us