cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Level 1

Expense report for transactions without an associated project

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?

7 Comments
Highlighted
QuickBooks Team

Expense report for transactions without an associated project

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.

Highlighted
QuickBooks Team

Expense report for transactions without an associated project

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!

Highlighted
Level 1

Expense report for transactions without an associated project

No. I followed those steps and there is no filter for "project." 

 

I am looking to identify transactions that have NOT been associated with a project. Even a list of all transactions that also shows the associated project would work. 

 

This answer does not seem to help me. 

Highlighted
QuickBooks Team

Expense report for transactions without an associated project

I can help you in running that report, eknelsongroup.

 

You can pull up and customize the Transaction List by Customer report to view all the transactions (income and expenses), grouped by project or customer. Here's how to do it:

 

  1. Select Reports from the sidebar menu.
  2. Go to the Sales and customers section.
  3. Choose Transaction List by Customer.
  4. Click the Customize button, then set the desired reporting date.
  5. Under the Rows/Columns section, click the Change columns link and then tick the Customer checkbox.
  6. Go to the Filter section.
  7. From the Customer drop-down menu, select All if you want to view all the transactions linked to your customers and projects. This way, you'll be able to track and compare the transactions entered into a project.
  8. If you want just want a list of all transactions associated with a project, you can select the project name from the Customer drop-down menu.
  9. Click Run report.

Once those filters are applied, you'll be able to see the transactions you’ve entered in QuickBooks and the projects that go with them in the Customer column. Take a look at my screenshot below:

Transaction_List_By_Customer2.PNG

 

I'd recommend memorizing this report to save its current customization settings. Additionally, here's an article that you can read to ensure that you'll get the most out of QuickBooks Online's reporting capabilities: Customize reports.

 

Fill me in if you have any other concerns or further questions about transaction reports. I'll always have your back.

Highlighted
Level 1

Expense report for transactions without an associated project

I need a list of all posting transactions and their associated project (or lack thereof). A list 'by project' will exclude transactions that are not assigned to a project. I am trying to capture exactly those transactions. I ran what you suggested, just in case that report would be useful to me in the future, but only ONE project has transactions displayed, and I had not added any additional filters. Are projects broken in reports?? 

Highlighted
Moderator

Expense report for transactions without an associated project

Hi there, @eknelsongroup.

 

Thanks for following up on this thread. I'll provide some additional information regarding this issue.

 

We can run the Transaction Detail by Account and filter the Customer associated with the Project. Doing so will show all the transactions link to the Project. 

 

Here's how to run the report:

  1. In the left menu, click Reports.
  2. Go to the Reports tab and type in Transaction Detail by Account in the search field.
  3. Tap the Customize button. 
  4. Set the Reporting period.
  5. In the Filter section, put a checkmark on the Customer box and select the customers assigned to a project.
  6. Hit Run report.

In case you'd want to save this report for future use, you have the option to save the current customization settings by memorizing the report. Check this link for more information.

 

Moreover, if you want to have a Project report, we have the report available for you in the Project page, these are the following:

  • Project profitability
  • Time cost by employee or vendor
  • Unbilled time and expense

If you need further assistance in managing your account, I'm only a couple of clicks away. Have a great day!

Highlighted
Level 1

Expense report for transactions without an associated project

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

Need to get in touch?

Contact us