cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Everything you need to know about banking in QuickBooks Online - Discover more
kaadblue
Level 1

Why ara some of my customers appearing in services in my P&L report

In my P&L report, some customers UI have set up are all groups in services while others are separated out. How can I get them all separate ?
1 REPLY 1
Rea_M
Moderator

Why ara some of my customers appearing in services in my P&L report

Let's customise the P&L report, @kaadblue. This way, you'll be able to separate your customers based on their groups.

 

There are variety of P&L reports available in QuickBooks Online (QBO). In case you're opening the Profit and Loss by Customer, it'll display all the list of your customers regardless if they're belong to a group or not. It'll provide your income, expenses, and net income by all your customers in a certain period.

 

Here's how to customise the P&L report separate your customers based on their groups.

  1. Go to the Reports menu.
  2. Select the type of Profit and Loss report you want to pull up in the Business overview section.
  3. Click the Customise button.
  4. Set the Report period and Accounting method in the General section.
  5. Go to the Filter section to select the group of customers and other details you want.
  6. Click Run report.

I've attached screenshots below for your reference.

6.PNG7.PNG

 

Once done, you can memorise the said report to save the current customisation settings. For the detailed steps, kindly refer to this article: Memorise reports in QuickBooks Online. It also contains steps on how to export the report to an Excel file.

 

Additionally, grouping your products and services into categories will keep your account organised. To learn more about the process, you can check out this article: Group your products and services into different categories.

 

Please let me know if you have other concerns. I'm just around to help.

Need to get in touch?

Contact us