Limited time only. 90% off QuickBooks for 6 months.
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
melissapeaktopeak
Level 1

I am looking for a report that shows all expenses that have been allocated to a customer or project and whether or not it has been marked as "billable"

 
3 Comments 3
BabyB
QuickBooks Team

I am looking for a report that shows all expenses that have been allocated to a customer or project and whether or not it has been marked as "billable"

Hi, Melissa. The closest report that shows all expenses assigned to a customer or project is the Transaction List with Splits. I'll walk you through the steps.

 

Please note that QuickBooks Online doesn’t have a specific filter to display only expenses billed to a customer. However, you can export the report and manually remove transactions that don’t apply. Here’s how:

 

  1. Navigate to the Reports menu.
  2. Enter Transaction List with Splits in the search field.
  3. Choose a Report period for the transactions you want to run.
  4. Click the Customize option.
  5. In the Filters fields, choose Transaction by type, equals, Bill, Billable Expense Charge, Cheque, or Expense.
  6. In the Columns section, ensure that Transaction type and Customer are checked.
  7. Click the Export icon so you can save and edit it outside QuickBooks.

 

Here's a sample of the report:

 

Please don't hesitate to reply if you need more assistance. We're just around.

brice94
Level 1

I am looking for a report that shows all expenses that have been allocated to a customer or project and whether or not it has been marked as "billable"

Regarding the Transaction List with Splits, how does it handle multiple projects per customer, as mentioned under Sales and customers in the Topics section?

recolor image online

LouiseG
QuickBooks Team

I am looking for a report that shows all expenses that have been allocated to a customer or project and whether or not it has been marked as "billable"

Hi there, Brice.

The Transaction List with Splits report in QuickBooks Online (QBO) manages and displays transactions associated with multiple projects under a single customer by breaking them down into separate, detailed line items. 

Each project is treated as a sub-category of the customer, and any transaction split across multiple projects is displayed as separate rows in the report. 

You can also customize the report to better identify the different projects associated with the same customer.

Please let us know if you have additional questions or concerns.

Need to get in touch?

Contact us