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

macdonaldviv · ‎February 27, 2020

Ashleigh1 · ‎February 28, 2020

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

JessT · ‎February 28, 2020

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.

Go to Reports.
Search for Transaction Detail by Account and click it from the result.
Click the small Gear icon on the report page.
Place a checkmark in the Debit and Credit checkboxes.
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 · ‎February 28, 2020

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 · ‎February 28, 2020

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.

Topics

Training

Community

Resources

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