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

I want to run a report showing any expenses that have gone through the bank that does not have a customer allocated to it - is there such a report?

Please help!  I want to run a report showing any expenses that have gone through the bank that does not have a customer allocated to it - is there such a report?  Basically I want to capture any outgoings that I have missed allocating a customer against.

 

TIA

4 REPLIES 4
Mark_R
Moderator

I want to run a report showing any expenses that have gone through the bank that does not have a customer allocated to it - is there such a report?

I've got you covered, @JAC10.

 

You can run and customise the Transaction Detail by Account report to show transactions aren't allocated to a customer. Here's how:

 

  1. Sign in to your QuickBooks Online (QBO) account.
  2. Click Reports from the left menu.
  3. Search for the Transaction Detail by Account report.
  4. On the report, click Customise.
  5. Go to the Filter section and select Expense from the Transaction Type drop-down.
  6. Click Run report.
  7. Once done, open each transaction that doesn't have an allocated name. Then, select the vendor or customer from the transaction window.

1.PNG

I'm adding this article to learn more about customising reports in QBO: Customise reports.

 

You might also want to memorise some reports in QBO. This allows you to save your current customisation settings on the report.

 

Please know that I'm just a reply away if you need any further assistance running reports. Wishing you all the best, @JAC10.

JAC10
Level 1

I want to run a report showing any expenses that have gone through the bank that does not have a customer allocated to it - is there such a report?

Thanks Mark, but that is not it as that report does not show the Customer/Project name just the name of the company the expense is from.  We have various expenses that I assign to a customer/project and I want to run a report on the expenses that we have to ensure every expense has a customer/project allocated.  For what I can see this report ensures that every expense has the name of the company we purchased the item from NOT the customer it relates to.

 

Is there such a report and if so, please advise.

 

Many thanks

 

JAC10
Level 1

I want to run a report showing any expenses that have gone through the bank that does not have a customer allocated to it - is there such a report?

  POSTING AGAIN IN THE HOPE THAT SOMEONE KNOWS THE ANSWER :)

 

Thanks Mark, but that is not it as that report does not show the Customer/Project namejust the name of the company the expense is from.  We have various expenses that I assign to a customer/project and I want to run a report on the expenses that we have to ensure every expense has a customer/project allocated.  For what I can see this report ensures that every expense has the name of the company we purchased the item from NOT the customer it relates to.

 

Is there such a report and if so, please advise.

 

Many thanks

Ashleigh1
QuickBooks Team

I want to run a report showing any expenses that have gone through the bank that does not have a customer allocated to it - is there such a report?

Hello JAC10, thanks for coming back to us, so it is not possible to get a report to do this in quickbooks, the closest report would be the one Mark has mentioned. You can leave it as feedback from the main cog wheel >feedback, this gets sent straight to the developers. 

Need to get in touch?

Contact us