cancel
Showing results for 
Search instead for 
Did you mean: 
jjules
Level 2

Which QBO report(s) can list all expense transactions and show Customer/Project for each expense?

I have entered Customer/Project for the relevant expenses. For added "Customer" column for General Ledger report, but it only shows customer name in Deposit rows. The Customer field is blank for Expense rows. I tried other reports but they don't allow Customer column to be added. Did I miss something?
10 Comments 10
AileneA
QuickBooks Team

Which QBO report(s) can list all expense transactions and show Customer/Project for each expense?

Hello, jjules. 

 

Thank you for reaching out to the Community. We can run Transactions List by Vendor report. This report shows the transactions( income and expense) assigned to the project. You can customize it by following these steps: 

 

  1. Go to Reports on the left panel. 
  2. Enter Transactions List by Vendor in the search bar. 
  3. Select the Report period and click the Customize button. 
  4. Click Filter, and select Expense from the Transaction Type drop-down list. 
  5. Press the Run report button. 

 

I've got these articles for reference: 

 

 

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. 

jjules
Level 2

Which QBO report(s) can list all expense transactions and show Customer/Project for each expense?

Thank you, I followed your steps but my Transactions List by Customer does not show Expense transactions.

To be clear: our organisation has many expense transactions for the report period. Andfor most of the expenses we have entered data in the Customer/Project field. I think all the expense transactions should be in the report...  but I get none!

When I filter for transaction type Expenses, QB shows, under the heading, "This report does not contain any data."

When I clear the filter (so it should show ALL transaction types) then the report shows Deposits, Invoices and Payments. But still NO expenses are shown.

 

What is wrong?

 

LieraMarie_A
QuickBooks Team

Which QBO report(s) can list all expense transactions and show Customer/Project for each expense?

Hi there, @jjules.

 

Expenses billed to customers are tracked as billable expense charges since these are expenses you incur on your customer's behalf when you perform work for them. 
 

  1. Go to the Reports menu.
  2. In the Find report by name field, type in "Transaction list by Customer." Then, press Enter.
  3. Click the Customize button.
  4. Modify the reporting period.
  5. Go to the Filter section.
  6. In the Transaction Type drop-down, select Billable Expense Charge.
  7. Select the customers/projects' names from the Customer drop-down.
  8. Click Run report.

 

Project reports are also available from the Project Center. If these expenses are not yet invoiced to the customer, you can utilize the Unbilled time and expenses report to see all the billable expense charges.

 

  1. Go to the Projects menu.
  2. Choose a project name.
  3. Select the Project Reports tab.
  4. Click the View link to open the Unbilled time and expenses report.

 

You can check out this article to see the complete list of available reports for your QuickBooks Online version: Reports included in your QuickBooks Online subscription.

 

You can also export them to Excel to help give you the flexibility to use them. Simply click the Export icon and select Export to Excel

 

Furthermore, here are some helpful resources to help you get a better grasp of the project feature:

 

Please let me know if there's anything else that I can help with your reports. I'm always here to assist. Have a wonderful day.

jjules
Level 2

Which QBO report(s) can list all expense transactions and show Customer/Project for each expense?

Thanks @LieraMarie_A , my question was not about "billable expenses".  Please look at the following screenshot:

expense_customer_name.png




We need a report that includes all Expenses like the one above. We need the report to have a column for Customer/Project, The column should show "This name". How can I get this kind of report?

 

JessT
QuickBooks Team

Which QBO report(s) can list all expense transactions and show Customer/Project for each expense?

Thanks for the screenshot, jjules!

 

I've read the previous responses, and I'd like to directly answer your question by saying there isn't a report that will show the customer/project column.

 

What you can do is run the Transaction List by Vendor report and export it to Excel. Then, manually add a Customer/Project column and enter the name of the customer or project in each expense transactions. You can also remove other transactions that you don't need.

 

I see that my colleagues have already provided some references about customing reports, you can check them out.

 

If you'd like short and direct responses in the future, just tag me in. Have a good one!

pradyumn
Level 1

Which QBO report(s) can list all expense transactions and show Customer/Project for each expense?

I think under the filter-'Vendor' you should select all. Then all expenses are coming. before that I was facing the same issues as you're.

LaterWhen
Level 3

Which QBO report(s) can list all expense transactions and show Customer/Project for each expense?

Manually add the customer in excel after the report is pulled???!!!  Then what is the point of being able to enter it into QBO, not to mention how much work it would be to do this for every transaction that was allocated to a customer!

 

This is a gap in QBO reporting service. 

LaterWhen
Level 3

Which QBO report(s) can list all expense transactions and show Customer/Project for each expense?

I will share with you my work-around to this gap in QBO.  Run a Profit and Loss by Customer report and filter for the Customer you need data for.  Set  "display columns by" to customers.  Then you will have a report showing all the expense account.  If you then click on the Total Expenses at the bottom of each customer you will get an itemized report of the expenses allocated to the customer. But you can only run the report for oen customer at a time because the customer name is not available to include in the detailed report. The expenses are grouped by expense account. If you want to ungroup them, you will have to export to excel and fiddle. 

Carmen888
Level 1

Which QBO report(s) can list all expense transactions and show Customer/Project for each expense?

Select the project from the 'Project List' then click on COST OF GOODS SOLD and that will bring up the report you are looking for.  Also do the same for EXPENSE and OTHER EXPENCE

Giovann_G
Moderator

Which QBO report(s) can list all expense transactions and show Customer/Project for each expense?

Thanks for joining the thread, Carmen888.

 

We appreciate the additional information you've provided to run a report displaying the expenses transactions. It gives other users an option to collect data that is more important to them.

 

They can also export the report to Excel and add more columns. I've also included this article to help them determine which reports are available in each QuickBooks Online subscription: Reports included in your QuickBooks Online subscription.

 

Thanks for your time, Carmen888. Take care and have a great day.