cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Level 1

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

 
3 REPLIES 3
Highlighted
QuickBooks Team

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.

Highlighted
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.
 
Highlighted
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 as the way quickbooks works it runs report separetly

 

You can run the report Sales by Product/Service Detail Report and you can customize the report so it shows the information you need so 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.