cancel
Showing results for 
Search instead for 
Did you mean: 
Tiffiny Taylor Krugh
Level 4

Project Report

I'm looking for a report that will show me expenses that are not assigned to a project.

Solved
Best answer June 09, 2020

Best Answers
MirriamM
Moderator

Project Report

Thanks for joining the thread, @ericmehlum.

 

I know the importance of having the report you need. As of this time, it's still unavailable in QuickBooks Online (QBO). 

 

When adding transactions to a Project, it won't affect your accounts or how they're categorized. Since you only tag them to help track specific project income and expenses.

 

To learn more about how Project feature works, check these articles:

While we continue to make your experience with us even better, I recommend visiting our QuickBooks Online Blog to get the recent news, information about the latest features, and updates. 

 

I'm only a couple of clicks away if you need further assistance in managing your account. It's always a pleasure to help. Have a great day!

View solution in original post

15 Comments 15
JonpriL
Moderator

Project Report

Hello @Tiffiny Taylor Krugh,

 

At this time, there isn't an option to list or pull up a report that'll show all your expenses that are not assigned to a project.

 

That being said, you'll want to consider manually reviewing your expenses to check if a project is selected on the Payee field.

 

I've got you this helpful article in case you need some ideas about how you can handle your vendor transactions: How do I?

 

Fill me in if you have further questions. I'm always around if you need any help.

Tiffiny Taylor Krugh
Level 4

Project Report

I was hoping that a P&L Detail report could help, & while it does show the project name associated with an income item is received, the expenses & COGS sections just list the vendor name & nothing more.

 

If anyone has any ideas on reports I can use I would appreciate it & I certainly hope QB creates one.

ericmehlum
Level 1

Project Report

Any luck with this request?  I am experiencing the same issue...

Project is associated with income, but not with COGS or expenses.  Perhaps there are outside vendors to help?

MirriamM
Moderator

Project Report

Thanks for joining the thread, @ericmehlum.

 

I know the importance of having the report you need. As of this time, it's still unavailable in QuickBooks Online (QBO). 

 

When adding transactions to a Project, it won't affect your accounts or how they're categorized. Since you only tag them to help track specific project income and expenses.

 

To learn more about how Project feature works, check these articles:

While we continue to make your experience with us even better, I recommend visiting our QuickBooks Online Blog to get the recent news, information about the latest features, and updates. 

 

I'm only a couple of clicks away if you need further assistance in managing your account. It's always a pleasure to help. Have a great day!

View solution in original post

khbwarr
Level 1

Project Report

Is there a way to run a detailed report on expenses associated with a given report? The project profitability report is helpful, but I would like to get to the transaction details as well. 

Thank you.

RenjolynC
QuickBooks Team

Project Report

Thanks for joining this thread, khbwarr.

 

You can run the Transaction List by Vendor. This is a separate report that will display transactions grouped by vendor. You can customize also customize it by following these steps:

 

  1. Go to Reports on the left panel.
  2. Scroll down until you see Expenses and vendors.
  3. Select Transaction List by Vendor.
  4. Choose the Report period and click the Customize button.
  5. Click Filter, and select Expense from the Transaction Type drop-down list and then choose the vendor name you want t view.
  6. Hit the Run report button.

You also have the option to export the report to Excel and manually edit the details. Just click the icon next to Print and choose Export to Excel.

 

I've got these articles for reference:

 

I'll be around if you need more help with QuickBooks. Take care and stay safe.

khbwarr
Level 1

Project Report

Thanks. This does not work for what I am trying as the Project Transactions are all connected to a Donor (or Customer). 

 

I ended up running a P&L and filtering for the Donor (customer) the Projects are associated with.

 

Thorhaug
Level 1

Project Report

One thing that seems to work for me is if you take one of your project expense reports, then go to CustomizeFilter > check the Customer box and pick Not Specified from the drop-down menu > Run report. This has given me a list of expenses I have not assigned to any project. Hope this helps

J and J
Level 1

Project Report

I thought there was an Expenses not Assigned report previously in Quickbooks. I know it'd not available now. But I'm not finding any real substitute, which ironically seems to be in my findings, contractors in the contractor version. 

 

Any helpful feedback would be great. 

 

Thanks

J&J 

RCV
QuickBooks Team
QuickBooks Team

Project Report

 We always strive to provide the best experience with the product, 

 

I know how beneficial it is to your business to list or pull up a report that'll show all your expenses that are not assigned to a project. What we can do is manually reviewing your expenses to check if a project is selected on the Payee field.

 

We can also run the Transaction List by Vendor report to show the expense transactions. Just customize it by following these steps below: 

 

  1. Go to Reports on the left menu. 
  2. Enter the Transaction List by Vendor in the report search field. 
  3. Choose the Report period and click the Customize button.
  4. Tap Filter, and select Expense from the Transaction Type drop-down list. Then, choose the vendor name you want t view.
  5. Hit the Run report button.

We can also export the report to Excel and manually edit the details. Just click the icon next to Print and choose Export to Excel. For more details about modifying your reports, check out the Customize reports page. From there, you'll see related articles about creating and managing reports.

 

Feel free to visit these blogs for any upcoming QuickBooks updates and enhancements:

 

The Community will always have your back if you need anything else in running your business in QBO. Assistance is just one post away. You have a good one. 

Tiffiny Taylor Krugh
Level 4

Project Report

Thank you but I don't see how the report you suggested allows me to view expenses that are not assigned to a project.

 

DivinaMercy_N
QuickBooks Team

Project Report

Thanks for getting back to us, @Tiffiny Taylor Krugh.

 

At this time, the option to run a report showing expenses not assigned to projects is unavailable. You might want  to send feedback directly to our product engineers. This way, we'll know your ideas and suggestions. To do so, click the Gear/Setting icon and select Feedback.

 

In the meantime, you can check out the Run reports in QuickBooks Online page, for more info on each report and what goes into them. 

 

To learn more about the latest product updates in QuickBooks Online, please visit our QuickBooks Blog. This page provides details for product recent improvements, news, and product enhancements. 

 

Please let me know if I can be of additional assistance or should you have any follow up questions. I’ll be here to help. Have a good one. 

baypoint-paulhood
Level 1

Project Report

Hi Tiffany,

 

I am looking for a similar response to your question.  Have you any solution or alternative work around to find the information you require?

evansolcamp
Level 1

Project Report

I was just able to find this report by the following:

Profit & Loss by Customer, Adjust your date range & run report

Go to the right side where you see a column called "Not Specified"

Scroll to the bottom of the screen to the total at the bottom of the "Not Specified" column (this will be the Net Income in Not Specified) and double click on that total

Report displays showing all income & expenses that are not assigned to a Job/Project 

You can customize and delete columns you don't need to make it fit on one page 

 

evansolcamp
Level 1

Project Report

I was just able to find this report by the following:

Profit & Loss by Customer, Adjust your date range & run report

Go to the right side where you see a column called "Not Specified"

Scroll to the bottom of the screen to the total at the bottom of the "Not Specified" column (this will be the Net Income in Not Specified) and double click on that total

Report displays showing all income & expenses that are not assigned to a Job/Project 

You can customize and delete columns you don't need to make it fit on one page 

Sign in for the best experience
Ask questions, get answers, and join our large community of QuickBooks users.
Sign In / Sign Up

Need to get in touch?

Contact us