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

Can I run reports by category to determine profitability, eg sales by category and expensese by category?

 
Solved
Best answer February 28, 2020

Accepted Solutions
Ashleigh1
QuickBooks Team

Can I run reports by category to determine profitability, eg sales by category and expensese by category?

Hello Macdonaldviv, 

 

Welcome to the Community page, 

 

There is not a report that will show this, as the way QuickBooks works it runs reports separately.

 

You can run the report Sales by Product/Service Detail Report and you can customize the report so it shows the information you need. Once the report is open if you click in the little cog wheel top right of the report >show more>tick product/service> then click customize top right>filter> tick - Distribution Account and Product/Service> click run report 

 

For the expense you can run the report Transaction List by Date Report or Transaction Detail by Account Report and again you can customize these to show that you need so the little cog and customize. 

View solution in original post

3 REPLIES 3
JessT
Moderator

Can I run reports by category to determine profitability, eg sales by category and expensese by category?

Let's create the report you need, macdonaldviv.

 

We can use the Transaction List by Account report because it already has balances per account. We can add the Debit and Credit columns to it to show the total incoming and outgoing value. The final output will look like a profit and loss report for each account or similar to T-Accounts.

  1. Go to Reports.
  2. Search for Transaction Detail by Account and click it from the result.
  3. Click the small Gear icon on the report page.
    gear icon.PNG
  4. Place a checkmark in the Debit and Credit checkboxes.
  5. Click Run Report.

You can also check on Memorise to save this customisation. This will be saved to your list of Custom Reports.

 

If you need more help to get other data in QuickBooks, please don't hesitate to comment below.

macdonaldviv
Level 1

Can I run reports by category to determine profitability, eg sales by category and expensese by category?

Thank you for your reply - but this does not answer my question.
I want to run a report where I can group products and expenses by category.
For example - we have several rental properties and have spent differing amounts of money on these properties over the year. I want to know how profitable each unit is.
Name = Garden Cottage shows as a "product" with a monthly "sales price" set against it.  When I enter expenses I am not offered the same list of categories as available in Product AND I cannot see how to run a report that includes Category - either expense or product.
 
Ashleigh1
QuickBooks Team

Can I run reports by category to determine profitability, eg sales by category and expensese by category?

Hello Macdonaldviv, 

 

Welcome to the Community page, 

 

There is not a report that will show this, as the way QuickBooks works it runs reports separately.

 

You can run the report Sales by Product/Service Detail Report and you can customize the report so it shows the information you need. Once the report is open if you click in the little cog wheel top right of the report >show more>tick product/service> then click customize top right>filter> tick - Distribution Account and Product/Service> click run report 

 

For the expense you can run the report Transaction List by Date Report or Transaction Detail by Account Report and again you can customize these to show that you need so the little cog and customize. 

Need to get in touch?

Contact us