cancel
Showing results for 
Search instead for 
Did you mean: 
miner_tom
Level 2

Reports combine expenses from 2 accounts. Need separate expense info.

Hi to the community,

I am certainly not an expert with quick books and am starting to use the "reports". This should be simple.

 

I have two accounts. Both have the same expense, in my case "Fuel" (we are a flight school). When doing the "Profit and Loss" report, the numbers seem to reflect numbers that combine both of the accounts. So, for example, account #1 and account #2 both have expenses for Fuel. 

 

All that I wish to do is to determine how much Fuel was purchased in each separate account. I did look at the "filter" options in the "Customize" area for reports but I still kept getting combined results.

 

Thank You

Tom

Solved
Best answer July 07, 2020

Best Answers
MarsStephanieL
QuickBooks Team

Reports combine expenses from 2 accounts. Need separate expense info.

Welcome to the Community, @miner_tom.

 

I'd be glad to help you customize a report so that you can see the details on the two expense account in QuickBooks. 

 

You can run a separate report since you need specific details. I recommend running and customizing the Transaction Detail by Account report. I'll guide you through the steps:

 

  1. From the left pane, go to the Reports menu.
  2. Enter Transaction Detail by Account in the search box.
  3. Click on the Customize button.
  4. Edit the Report period.
  5. In the Filter section, tick the box for Distribution Account.
  6. Select the drop-down icon to choose the two expense accounts only. You can do that by ticking the boxes for each account name. (I added a screenshot for additional guide).


     
  7. Verify the details then select the Run Report button.

 

You can check out the screenshot below to see the comparison before and after customizing the report for your reference.

 

 

Once done, you can save your customization so that you can easily run a report with the template you've setup, it's called memorize report in QuickBooks. Here's an article that can help you through the steps: Run reports in QuickBooks Online. This article also contains a series of topics on how to manage reports such as running payroll reports, aging transaction reports and many more.

 

I'll be here if you have any concerns or questions just let me know in the comment section below. Stay safe and have a wonderful day ahead.

View solution in original post

3 Comments 3
MarsStephanieL
QuickBooks Team

Reports combine expenses from 2 accounts. Need separate expense info.

Welcome to the Community, @miner_tom.

 

I'd be glad to help you customize a report so that you can see the details on the two expense account in QuickBooks. 

 

You can run a separate report since you need specific details. I recommend running and customizing the Transaction Detail by Account report. I'll guide you through the steps:

 

  1. From the left pane, go to the Reports menu.
  2. Enter Transaction Detail by Account in the search box.
  3. Click on the Customize button.
  4. Edit the Report period.
  5. In the Filter section, tick the box for Distribution Account.
  6. Select the drop-down icon to choose the two expense accounts only. You can do that by ticking the boxes for each account name. (I added a screenshot for additional guide).


     
  7. Verify the details then select the Run Report button.

 

You can check out the screenshot below to see the comparison before and after customizing the report for your reference.

 

 

Once done, you can save your customization so that you can easily run a report with the template you've setup, it's called memorize report in QuickBooks. Here's an article that can help you through the steps: Run reports in QuickBooks Online. This article also contains a series of topics on how to manage reports such as running payroll reports, aging transaction reports and many more.

 

I'll be here if you have any concerns or questions just let me know in the comment section below. Stay safe and have a wonderful day ahead.

heymamatrey
Level 1

Reports combine expenses from 2 accounts. Need separate expense info.

I am not presented with an option called TRANSACTION DETAIL BY REPORT. Where do I find this?

 

JamesAndrewM
QuickBooks Team

Reports combine expenses from 2 accounts. Need separate expense info.

Welcome to the QuickBooks Community forum. I understand you want to pull up the Transaction Detail Report. I'll share information that could help you.

 

QuickBooks Online offers a range of financial reports that provide insights into various aspects of your business. While many reports are accessible to all users, some are only available to specific subscriptions. Your current subscription could be the reason you can't find the Transaction Detail Report. Refer to this article for more details: Reports included in your QuickBooks Online subscription.

 

However, if you are subscribed to QBO Essentials or Plus and still can't find the report, you can perform basic troubleshooting steps to see if it is a browser issue. Sometimes your search engine's cache and cookies become corrupted, causing problems when accessing websites or opening files. To begin, open your QBO account in an incognito window. It will prevent the browser history from being saved. Please refer to the following keyboard shortcuts based on your browser type:

 

  • Google Chrome: Ctrl + Shift + N
  • Mozilla Firefox: Ctrl + Shift + P
  • Microsoft Edge: Ctrl + Shift + P
  • Safari: Command + Shift + N

 

If the private browsing session works, clear the browser's cache so the system can restart. This task is also possible in other supported, up-to-date browsers. Clearing the cache will reboot the system, allowing you to work with clearing the stocked cache and cookies causing the issues.

 

I'm adding these articles you can use in the future:

 

 

If you have more questions about reports in QuickBooks Online, post them here in the forum. I'll be sure to answer them in any way possible. Have a great day ahead!

Need to get in touch?

Contact us