Skip to main content
July 28, 2022
Question

I need a report that shows all transactions without a project code

  • July 28, 2022
  • 1 reply
  • 0 views

I'm looking to find any transactions that were NOT assigned to a project. Orphan transactions. You can run a general ledger report which has a column for "project/Customer" but even if a transaction is logged to a project, it won't show in that column. There doesn't seem to be any report that will allow you to show all transactions with the projects they are assigned to. Only reports on a single project which won't allow you to see any transactions with no project assigned.

1 reply

katherinejoyceO
July 28, 2022

I'm pleased to guide you in pulling up a report that shows all transactions without a project code, @1_.

 

In QuickBooks, we have a lot of built-in reports that you can customize to display the data based on your business needs. I'd recommend generating Transaction Detail by Account and customize it to get the data the you need. 

 

Here's how:

 

  1. Go to the Reports menu, then go to the For my accountant section.
  2. Double-click on the Transaction Detail by Account report.
  3. Click the Customize button, then set the Date Range of the report.
  4. From the Rows/Columns section, click the Group by drop-down indicator.
  5. Select a Customer, then in the Filter section, mark the Distribution Account tick box.
  6. Select All Expense Accounts.
  7. Click the Run Report button. 

 

From there, you can view a list of your expense transactions grouped by Project/Customer. You can change the name of the report to match the information it displays. 

 

You can also group the transactions by Vendor to show all the expense transactions that were not billed to your projects shown as a blank entry under the Customer column.

 

For future reference, you'll want to save the customization so you can quickly find it when you need it again. Additionally, check out these articles to learn more about personalizing the built-in reports in QuickBooks to match your business needs: 

 

 

Comment down below if you have other questions or concerns with your reports. I'm always here to help.

 

 

 

 

 

1_53_2Author
July 29, 2022

Wow, that's insane. I've called several times to get answers on this but this actually worked. It's a bit round about but it does work and will save me so much money. I really appreciate this!

July 29, 2022

Hello there, @1_53_2.

We appreciate you for letting us know how the steps went. We couldn't do it without your cooperation.

I'm glad that we're able to provide you the report you need to manage your transactions in QuickBooks Online (QBO).

If there's anything else that you need or if you have any other concerns or questions, please feel free to post here anytime. Thanks for being the best part of QuickBooks, and have a lovely day!