Created with Sketch.Learn about PPP and Loan Forgiveness, stay informed with the latest changes.
Created with Sketch.Need help with 1099's or other Year End topics? Visit our Year End Resources page.
Created with Sketch.New to QuickBooks or using a new product? Visit our Get Started resource page to help you get going.
Created with Sketch.Need to make changes to your account? Visit the Account Manager Portal.
Showing results for 
Search instead for 
Did you mean: 
Level 1

P&L reporting with filters

Filtering by clients

1. I choose all

2. I exclude two - (check their box)

3. Pull P&L - THEN it excludes basically all expenses!


If taking the filter off PL behavior is normal


Please help!

1 Comment
Content Leader

P&L reporting with filters

Help has arrived, @Beat.


I can help to clarify why the P&L is acting as you've explained. When Customizing a Profit and Loss and filtering it to customers, it will only display transactions assigned specifically to those individuals. This means only Billable Expenses assigned to the selected customers will display in the report as you've described it. Since most expenses aren't appearing after filtering this way, they haven't been created as Billable. You'll have a few options for reporting your P&L in this way:


1. Profit and Loss by Customer Report

  1. From QuickBooks Online, navigate to the Reports tab.
  2. In the search bar, type Profit and select Profit and Loss by Customer.
  3. This report sorts customers into columns, displaying their income for each of the Profit categories.

Please note, the expenses still won't be displayed per customer unless they're assigned in a Billable transaction. However, the total expenses (as compared to the regular P&L for the same date range) will remain the same in the Total Expenses section. Here's a screenshot displaying how the P&L by Customer reports:


2. Profit and Loss Detail sorted by customer

  1. Follow the steps above to search for the Profit and Loss Detail report.
  2. This statement displays each transaction in all included income categories.
  3. You can sort each of these transaction groups by customer by clicking the Sort dropdown (▼) and selecting Name.

This method also groups the fully listed expenses by Vendor in the bottom half of the statement. The image here shows what the report looks like:


3. Assign customers to those expenses and make them Billable

  1. If you haven't already, enable Billable Expenses by clicking the Gear icon (⚙) Account and Settings > Expenses tab > Check the box to Make expenses and items billable.
  2. On the unfiltered P&L report, click on each expense category to open it and select a transaction to review it.
  3. Make sure there is a name assigned under the Customer column of each Check, Expense, and Bill that you review.

This information is available from our guide on Entering Billable Expenses as well for your convenience. I'm including a brief video demonstration as well:


The methods above enable you to have your P&L sorted by customer while including necessary expenses. In addition to all of these resources, we also offer a guide on customizing your Profit and Loss that's worth checking out. Please let me know if you have any additional questions or concerns. Thanks for coming to the Community, wishing you continued success.

Sign in for the best experience
Ask questions, get answers, and join our large community of QuickBooks users.
Sign In / Sign Up

Need to get in touch?

Contact us