Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Connect with and learn from others in the QuickBooks Community.
Join nowI'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.
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:
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.
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!
Hello there, @1_.
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!
@katherinejoyceOThanks for the information--can you please advise on how to do this in the desktop version? Your instructions for QBO don't quite seem to fit for QBD. Thank you!
Hi there, skssf.
Thank you for visiting the QuickBooks Community. I'll ensure you can run the report that you need in QuickBooks Desktop and achieve your goal smoothly.
I suggest running and customizing the Transaction Detail by Account report in QuickBooks Desktop. This way, it will show all transactions with their associated projects or view a list of all your expenses assigned to a specific Project/Customer.
Here's how:
Once done, you can open this article to see extra details on how you can customize different reports in QBDT: Customize reports in QuickBooks Desktop.
Lastly, you may refer to this article to view information on how to memorize reports in QuickBooks so the same settings of the customized report are available for future use: Create, access and modify memorized reports.
I'm always here to help if you have any other concerns or questions. Just tag my name in the comment section and I'll get back to you as soon as I can, skssf. Have a great day!
Hi @ChristieAnn -- Thanks for the rapid response. I think either I'm asking for something incorrectly, or this didn't quite work for me. In my business, I purchase a lot of items that either get reimbursed by my clients, or are COGS for projects for my clients. I'd like a report that allows me to review all transactions to see all transactions grouped by customer/job, including those that have no customer/job (e.g. expenses incorrectly unassigned as well as expenses that are for my business--not for a customer/job).
The closest I've gotten is essentially what you recommended, but with the Total By set to customer. In that case, I get a list of transactions in a category called "No name" but it does not include all transactions (e.g. credit card expenses for internal purchases). Can you advise on how to do this? Thanks!
Hi @ChristieAnn -- Thanks for the rapid response. I think either I'm asking for something incorrectly, or this didn't quite work for me. In my business, I purchase a lot of items that either get reimbursed by my clients, or are COGS for projects for my clients. I'd like a report that allows me to review all transactions to see all transactions grouped by customer/job, including those that have no customer/job (e.g. expenses incorrectly unassigned as well as expenses that are for my business--not for a customer/job). The closest I've gotten is essentially what you recommended, but with the Total By set to customer. In that case, I get a list of transactions in a category called "No name" but it does not include all transactions (e.g. credit card expenses for internal purchases). Can you advise on how to do this? Thanks!
Hi @ChristieAnn -- Thanks for the rapid response. I think either I'm asking for something incorrectly, or this didn't quite work for me. In my business, I purchase a lot of items that either get reimbursed by my clients, or are COGS for projects for my clients. I'd like a report that allows me to review all transactions to see all transactions grouped by customer/job, including those that have no customer/job (e.g. expenses incorrectly unassigned as well as expenses that are for my business--not for a customer/job). The closest I've gotten is essentially what you recommended, but with the Total By set to customer. In that case, I get a list of transactions in a category called "No name" but it does not include all transactions (e.g. credit card expenses for internal purchases). Can you advise on how to do this? Thanks!
Hi there,
I appreciate you getting back to us here in the Community. I can clarify things about how the report works in QuickBooks Desktop.
The transactions that reflect on the report will depend on what you choose on the Total By dropdown. Only expenses linked to jobs will show if you filter by Customer.
I recommend you toggle and play around with the options under the Total By drop-down. Aside from it, review the filters and ensure all are correct.
Here's how:
If you need to show the other transactions from a different Total By, export your report to Excel (see screenshot below). This way, you can combine your QuickBooks data manually.
There are different ways to assign expenses to jobs in the Desktop version. I've attached an article you can visit to get a complete job cost picture and assign expenses correctly in QuickBooks: Track job costs in QuickBooks Desktop.
Let us know if you have additional questions about running reports or generating data. We'll be more than happy to lend a hand in this space. Take care.
@AlcaeusFThanks for the response. If I'm understanding you correctly, there's no way to see a list of transactions that are not assigned to a job/customer, correct? Thanks!
It's nice to see you again, @skssf. I'm here to help share insights about the reports you want to pull up in QuickBooks Desktop.
Yes, there isn't a direct way to see a list of transactions assigned for your job/customer. As mentioned by my colleague, the transactions that reflect in the Transaction Detail by Account report will depend on how you filter them. For now, you can utilize the Excel button and manually edit the transactions to add to one report.
Here's how:
Then, export the other details to add up to the Excel file. For complete information about exporting files, see this article: Export reports as Excel workbooks in QuickBooks Desktop.
I've added these links about entering multiple jobs and pulling up reports in QuickBooks Desktop (QBDT) for reference:
Keep in touch if you have any further concerns about running reports. I'm always here to assist you always. Have a good day ahead.
@JoesemMThanks for the response. My experience is that there is no option to have a customer/job column in the report--it can only be indicated by totalling by customer. And if I total by customer, then unassigned transactions get removed from the report. So...it seems that even using Excel, one cannot get a report of unassigned transactions in QBD, no?
Yes, it doesn't possible, @skssf. Let me impart information to help improve your experience.
I recognize how beneficial to generate a report for unassigned transactions for your business. I recommend sending this idea directly to our Product Developer team so they can take a look and might consider this as part of the future enhancements.
Please know that the QuickBooks Product Development team keeps searching for ways to improve user experience by promoting helpful and efficient features to streamline processes that suit your company's necessities.
You can follow the instructions below to submit a product request within the program:
I’m adding this reference to learn more about the report group available in QuickBooks Desktop and how the program generates them: Understand reports.
Please feel welcome to add a reply if you have any other concerns or questions about QuickBooks reports. I’m always here to help. Take care always!
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.