Skip to main content
October 26, 2021
Question

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?

  • October 26, 2021
  • 1 reply
  • 0 views

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

1 reply

October 26, 2021

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.

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.

JAC10Author
October 27, 2021

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

 

JAC10Author
November 1, 2021

  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