Get 50% OFF QuickBooks for 3 months*

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
billr1
Level 3

Problem with report customization

I am trying to customize a report that contains income and expenses for a given year. I am looking to run the report for only certain customers. To do this I go into the report and click Customize, then Filter, then check Customers, then check the customers I want to include. I then click Run Report. The report shows income from those customers but doesn't show all the expenses, in fact only a few out of hundreds. What is the problem?
1 Comment 1
EduardA
QuickBooks Team

Problem with report customization

Hello there, @billr1. When you filter the Profit and Loss report by specific customers, QuickBooks only shows income transactions linked to those customers as well as expenses that have those customers explicitly assigned in the Customer/Project field.

 

Most expense transactions (such as bills and checks) are typically recorded with a vendor, not a customer. Unless you've specifically assigned a customer to each expense—usually for job costing or project tracking—those expenses won't appear when you filter by customer.

 

To fix this, open a few of the expense transactions that aren't showing. Do they have the customer name filled in the Customer/Project field, or are they only linked to a vendor?

 

If the Customer/Project field doesn't appear on the transactions you opened, follow these steps:

 

  1. Within the expense transaction, click the Gear icon for either the Category or Item details.
  2. Enable the Customer/Project column.
  3. Select the specific customer, then click Save and close.

 

If you need to see all expenses regardless of customer assignment, you'll want to re-run the report without the customer filter. You can then identify the expenses that may not have a customer assigned to them.

 

Should you have any other concerns, feel free to leave a message in the thread.

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

Need to get in touch?

Contact us