Skip to main content

SUMMER SAVINGS 90% OFF QuickBooks for 3 months* Ends 8/27

Buy now
Switch to QuickBooks and 70% off for 3 Months
November 2, 2020
Question

Expense report for transactions without an associated project

  • November 2, 2020
  • 40 replies
  • 96 views

I need to run a report to capture expenses entered for which I may have missed adding a project. Is there a way to do this?

40 replies

IamjuViel
Level 8
November 2, 2020

Greetings, @eknelsongroup.

 

You can generate and customize your Transactions List by Vendor report. This way, you can see a list of transactions grouped by vendors for a specific date range. I can guide you on how to do it.

  1. Go to the Reports menu. 
  2. Scroll down to the Expenses and Vendors section.
  3. Double-click on the Transaction List by Vendor report. 
  4. Click the Customize button.
  5. Set the report Date Range.
  6. Expand the Filter section.
  7. From the Transaction Type drop-down, select bills, expense, checks, time and etc.
  8. Click the Run Report button.

Once completed, you can open each expense transaction manually and assigned it to a specific Project. You can save the customization you've created for future use.

 

Visit us here again if you have other questions about generating expense reports in QuickBooks. I'm just a few clicks away.

IamjuViel
Level 8
November 4, 2020

Helping our customers achieve their goal is my priority, @eknelsongroup.

 

Were you able to generate an expense report in your account using the steps I've shared above? 

 

Know that the Community and I are always here to address your concerns. Wishing you continued success!

January 30, 2021

What I am trying to capture is transactions NOT associated with a project, though. 


Is there someone at Intuit Quickbooks who can actually read the original question and answer it?  The above answers sound like bot answers and do not address the question.  The question is:  How can a Quickbooks user see an expense report with the customer/project assigned to each expense?  We need to identify any expenses that DO NOT have a customer/project assigned.  The Expense Transactions report should simply have a Customer/Project column.  Please log this as a high priority feature with your product development team.

 

March 7, 2021

Was this ever actually solved? Those answer above still don't help. Lol.

 

I can't find a way to sort expenses by project at all. 

MJoy_D
QuickBooks Team
March 7, 2021

Thank you for posting here in the Community, @Flipped Out investments.

 

I can provide additional information on how to sort expenses by project. 

 

You can generate a Project profitability report in QuickBooks Online (QBO) to view all the expense accounts under that project and then customize it to only have the expense accounts.

 

Let me show you how:

  1. Go to the Projects menu and then select the Project that you're trying to run a report. 
  2. Select the View link on the Project profitability under the Project Reports tab.
  3. Pick the Customize button and go to the Filter section, tick the Distribution Account box and select All Expenses Accounts.
  4. Choose Run report.

 

You can refer to the following article for more information about this: Track income, costs, and profitability by project.

 

Here's an article for more information on how to customize a report: Customize Reports In QuickBooks Online.

 

Let me know if there's anything that you need in generating the report that you need. I'm always here ready to answer them for you. Take care and have a great day ahead!

March 7, 2021

Yes, I've seen this report and is useful but not really the answer to the question. I need to see if they are expenses entered and categorized but no project added to the expense. In essence I need to do the search you described but for all expenses not attached to a project. 

November 11, 2022

Dear QB,

We are still waiting for a solution.  It has been two years and eight days.

Sincerely,

Patience

March 19, 2023

I don't think QB has any intention of producing high level accounting software. On that note, anyone know of any other accounting software for a small construction business? I have spent tens of hours to no avail.