cancel
Showing results for 
Search instead for 
Did you mean: 
treasurer-onerap
Level 2

How can I exclude some income/expense accounts from my Profit and Loss report?

I saw another answer in Help suggesting that I can click Customize and there should be a Filters section where I can choose Distribution Accounts, but when I click Customize there's only two sections available, General and Rows/Columns, and neither of those has any option for filtering by distribution account.
16 Comments 16
MirriamM
Moderator

How can I exclude some income/expense accounts from my Profit and Loss report?

Welcome aboard to the Community forum, @treasurer-onerap.

 

If you want to see specific accounts on the report, you're able to filter them manually using the Customize option in QuickBooks Online (QBO).

 

Here's how:

  1. In the left menu, click Reports.
  2. Under Business overview, select Profit and Loss.
  3. Tap Customize.
  4. Go to the Filter section, select Distribution Account.
  5. Choose an account that you wanted to display on your report.
  6. Click Run report.

From there, the data will show only the specific accounts you've chosen.

 

If you're still unable to see the Filter section, let's try performing some basic troubleshooting steps to fix the problem. Sometimes cache stored up in the system can cause unexpected behavior in the product.

 

You can start by opening a private (incognito) window. Using a safe browser and accessing the program from there can usually fix the issue.

 

Check out these keyboard shortcuts:

  • Command + Shift + N (Safari)
  • Ctrl+ Shift + N (Google Chrome)
  • Ctrl + Shift + P (Mozilla Firefox) 

Once done, pull up the report again by following the steps above.

 

To learn more about customizing your Profit and Loss report, see this article: Customize reports in QuickBooks Online.

 

You’re more than welcome to visit the Community whenever you need further assistance. I'm here to lend you a hand. Have a good day!

treasurer-onerap
Level 2

How can I exclude some income/expense accounts from my Profit and Loss report?

There is no Filter section under Customize in my P&L report. I've tried in the desktop app, in the browser, and in a private browsing window in the browser. I've attached a screenshot of what shows up when I click Customize on a P&L report.

Rose-A
Moderator

How can I exclude some income/expense accounts from my Profit and Loss report?

I'd be happy to help keep the process of customizing a report easy and simple. , treasurer-onerap.

 

To be able to customize and filter the Profit and Loss report, as an initial step, you might want to ensure that you're logged in as the Master Admin of the account.

 

If you're added as a user in QuickBooks Online, the access and options may vary from one user at a company to another. The system determines what information it displays by each user’s access rights.

 

You can reach out to the owner of the account or the Master Admin and ask to review your access. Here’s how:

 

  1. Click the Gear icon and select Manage Users.
  2. Highlight the user's name, click Edit.
  3. Under Edit user settings, go to User type.
  4. Make sure to select the correct option to view and customize the Profit and Loss report.
  5. Hit Save.

However, if you're still unable to filter the report, I'd suggest deleting and adding yourself again. Once done, go back and filter the report.

 

 

I recommend memorizing the report to save its current customization settings. It serves as your record and helps you quickly access it for future use.

 

Please get back to me if you continue to get the same results so I can look further into this. I'll be here to keep helping.

treasurer-onerap
Level 2

How can I exclude some income/expense accounts from my Profit and Loss report?

I am logged in as the Master Admin account and the only user on the account, so I don't believe this is a user permissions issue, and I don't think I can "remove and re-add" myself.

 

I continue to see the same lack of a "Filters" section on the Customize section of P&L.

 

I suspect that the problem is that I'm on the Simple Start plan and that I have to pay Intuit more money in order to get access to necessary features.

Adrian_A
Moderator

How can I exclude some income/expense accounts from my Profit and Loss report?

I appreciate you for getting back to us, treasurer-onerap.

 

You're correct. The Filter option on the Customize button isn't available in the QuickBooks Online Simple Start version.

 

If you want to upgrade your subscription, you may check these references:

 

Upgrade your QuickBooks Online subscription

Update billing, payment, and subscription info in QuickBooks Online

 

I'm just around if ever you need help. Keep safe always!

bertcox1
Level 1

How can I exclude some income/expense accounts from my Profit and Loss report?

I must say this is maddening. Why not be able to simply customize your P&L. for a sole prop like myself I have business expenses coming from a personal credit card and checking account. if I want a window into what my business is doing I should be able to easily customize what is showing in my P&L. This is so basic....

IOWALSH
Level 1

How can I exclude some income/expense accounts from my Profit and Loss report?

Hi, Which versions of quickbooks online is this available in? Essentials? Plus? Thanks

Giovann_G
Moderator

How can I exclude some income/expense accounts from my Profit and Loss report?

Yes, it's available in Essential, Plus, and Advance subscription, IOWALSH.

 

The option to filter the Profit & Loss (P&L) report to exclude specific income/expense accounts or other accounts is unavailable in QuickBooks Online (QBO) Simple Start.

 

To take advance of this feature, you can upgrade your subscription to Essential, Plus, or Advance so you can personalize your report to display the information you require.

 

Here how:

 

  1. Log in to your QBO account as admin.
  2. Go to the Gear icon, then Accounts and Settings.
  3. Select the Billing & Subscription.
  4. In the QuickBooks Online section, click Upgrade.
  5. Choose the plan that suits your need, then Upgrade.
  6. Confirm your payment information and hit Save.

 

For more details about our Plan & Pricing, please visit this page: quickbooks.intuit.com/pricing/

 

Once done upgrading your subscription, you can follow these easy steps to customize your P&L report:

 

  1. Go to the Reports menu, then search for Profit and Loss report.
  2. Click the Customize button.
  3. Enter the correct reporting period.
  4. Select Filter.
  5. Check the Distribution Account box and choose the accounts you want to view in this report.
  6. Once done, hit Run report.

 

Check out this article for more details: Customize reports in QBO.

 

In addition, you can also memorize your report to save the settings of the customized report for future use. This way, you won't have to go through the customization process again.

 

You can always count on me if you have further questions in running reports in QBO. I'm here to help you out.

Safety signal vest
Level 1

How can I exclude some income/expense accounts from my Profit and Loss report?

I have this same issue. I am going to try setting up a project for my personal transactions and assign/split transaction and assign to either the business or project.  I will then filter report to see if the results are accurate.  

alternatively, I could just delete all the persons stuff which I’m sure may present it’s own set of challenges.


@bertcox1 wrote:

I must say this is maddening. Why not be able to simply customize your P&L. for a sole prop like myself I have business expenses coming from a personal credit card and checking account. if I want a window into what my business is doing I should be able to easily customize what is showing in my P&L. This is so basic....



@bertcox1 wrote:

I must say this is maddening. Why not be able to simply customize your P&L. for a sole prop like myself I have business expenses coming from a personal credit card and checking account. if I want a window into what my business is doing I should be able to easily customize what is showing in my P&L. This is so basic....




 


 

other98
Level 2

How can I exclude some income/expense accounts from my Profit and Loss report?

I'm having the same issue, and I see that it's because we're not paying Quickbooks enough money to have a basic feature like being able to create a P&L for specific accounts. Absurd.

Jackie Fromm1
Level 1

How can I exclude some income/expense accounts from my Profit and Loss report?

These suggestions will not work if you do not have QB Essentials or higher.  You do not have same tools if using QB Simple Start.  

asrobin4
Level 1

How can I exclude some income/expense accounts from my Profit and Loss report?

I have a situation that I have been trying to fix for a while and I cannot figure out how to display only our companies employees net income only.  My P&L report shows not only employees gross income but also the taxes paid on that income.  So, essentially, I am reporting the state and federal taxes twice on one report.  How to I exclude the state and federal taxes from the employees payroll reporting on the P&L?  Any help you can give me would be greatly appreciated.  I am not an accountant and work for a small non-profit.  I am self taught and I think I've gotten as far as I can go by myself.  

Thank You So Much!

Amy Robinson

First United Methodist Church of Coweta, OK  

CharleneMaeF
QuickBooks Team

How can I exclude some income/expense accounts from my Profit and Loss report?

Let's customize the report, Amy.

 

The Profit and Loss report will display all your income, expenses, and net income. Let's uncheck the payroll expense accounts to exclude the state and federal taxes. 

 

Here's how:

 

  1. On the left panel, click Reports.
  2. Click the Profit and Loss by Client report under Business overview.
  3. Change the Report period, and click the Customize button.
  4. Select the Distribution Account drop-down menu under Filter.
  5. Uncheck all payroll expense-related accounts.
  6. Click the Run report button.

 

For more details about personalizing the details, please see this article: Customize reports in QuickBooks Online.

 

I've also added an article that'll help you save the current customized settings: Memorize Reports.

 

I'm only a few clicks away if you need more help running and customizing reports. It's always my pleasure to assist you. Keep safe always!

user04773
Level 3

How can I exclude some income/expense accounts from my Profit and Loss report?

As of today Oct 2022, it is $300 per year EXTRA in order to simply filter the accounts that show in the P&L report.  I'm absolutely positive that cost will go up in 3 months.  What absolutely ridiculous piece of garbage this company is. I wish I had never started using your junk over priced product. 

mafrif
Level 2

How can I exclude some income/expense accounts from my Profit and Loss report?

Another bait and switch by quickbooks.  So infuriating.  Your guide says the only difference between simple start and essentials is tracking billable hours by customer, did you just forget to list anything that users would actually care about......

KLHM1
Level 2

How can I exclude some income/expense accounts from my Profit and Loss report?

mafrif that is exactly what it is. So many basic features missing from the basic product.

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us