Question

Expense report for transactions without an associated project

40 replies
219 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?

QuickBooks Online

IamjuViel

Level 8

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.

Go to the Reports menu.
Scroll down to the Expenses and Vendors section.
Double-click on the Transaction List by Vendor report.
Click the Customize button.
Set the report Date Range.
Expand the Filter section.
From the Transaction Type drop-down, select bills, expense, checks, time and etc.
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

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!

E

eknelsongroupAuthor

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.

F

Flipped Out investments

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

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:

Go to the Projects menu and then select the Project that you're trying to run a report.
Select the View link on the Project profitability under the Project Reports tab.
Pick the Customize button and go to the Filter section, tick the Distribution Account box and select All Expenses Accounts.
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!

H

Hhowie

Hello there, @sdtld.

I understand how beneficial it is for you and your business to be able to easily view an expense by project report. QuickBooks has a lot of built-in reports that you can customize to display the data your business needs. That being said, let me walk you through in generating and customizing the Transaction Detail by Account report.

Go to the Reports menu.
Scroll down to the For my accountant section.
Double-click on the Transaction Detail by Account report.
Click the Customize button.
Set the Date Range of the report.
From the Rows/Columns section, click the Group by drop-down arrow.
Pick Customer.
In the Filter section, mark the Distribution Account tick box.
Select All Expense Accounts.
Click the Run Report button.

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

Also, you can grouped the transactions by Vendor. By doing this, all the expense transactions that were not billed to your projects will show a blank entry under the Customer column.

Lastly, you can save the customization you've made for future purposes. You can read through these articles on how you can personalize the built-in reports in QuickBooks to match your business needs:

Leave a comment below if you have other questions or concerns. I'm always here to help.

I followed the above instructions and it worked to show the expenses that were not allocated to a project. This report should be a standard report in the report section for anyone looking to find unallocated expenses to a project. I have now saved the report in the clients QBO. This is why I appreciate classes so much! The only unfortunate thing about classes is that you are limited to QBO Plus at 40 classes. You would have to upgrade to advance to manage more then 40 jobs/classes at a time.

U

userhudthudson

Dear QB,

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

Sincerely,

Patience

J

jymcnabb

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.

Sign up

Login with SSO

Let's get you signed in

Login with SSO