Get 50% OFF QuickBooks for 3 months*

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Work smarter and get more done with advanced tools that save you time. Discover QuickBooks Online Advanced.
suzannek1
Level 4

How do I pull a report of just billable expenses for a customer?

When I pull an pnl for a customer/job, I get both billable and non-billable expenses.  There is no filter for this.  How can I pull a report that sholws me just the billable expensses for theat customer?
7 Comments 7
KimberlyS
QuickBooks Team

How do I pull a report of just billable expenses for a customer?

It's such a pleasure to have you here, @suzannek1.

 

Instead of running a Profit and Loss Report, we can use the Transactions List by Customer Report and display only the billable expenses.

 

Here's how:

 

  1. Go to the left navigation panel, then choose Report.
  2. On Find report by name, enter and select Transaction List by Customer.
  3. Choose a Report period for the transactions you want to run.
  4. Click on Customize.
  5. Under Rows/Columns section, select Change columns.
  6. Check the Customer and other details you want to display.
  7. Proceed to the Filter section, then check Transaction Type.
  8. Beside Transaction Type, choose Billable Expense Charge.
  9. Hit Run report, then click Save customization.

 

After running a report, you can also export reports, lists, and other data from QuickBooks Online. This will allow you to download and create a backup file for your data.

 

Inform us right away if you have further questions or clarifications about managing your transactions and running a report in QuickBooks Online. Stay productive!

suzannek1
Level 4

How do I pull a report of just billable expenses for a customer?

This doesn't break it down by accounting code so it is pretty useless.  The pnl really needs to have the ability to view only billable expenses as well as all expenses like desktop did. 

LeizylM
QuickBooks Team

How do I pull a report of just billable expenses for a customer?

I can point you in the right direction, suzannek1. I'll drop some steps to show the details you want to pull under the Report section in QuickBooks Online (QBO).

 

We can get the straightforward details you need by generating a Transaction List with Splits report. 

 

Here's how:

 

  1. Go to Reports.
  2. Locate in the Search bar the Transaction List with Splits.
  3. Click Customize.
  4. Under the Rows/Columns, select Customer.
  5. In the Filter section, check Transaction Type and select Billable Expense charge and Bill. 
  6. Once done, click Run Report.

 

Moreover, would you mind elaborating more about what you mean by Accounting Code? This way, I can provide you with the best resolution. 

 

However, if you're referring to an Account, we can customize and select it under the Rows/Columns. I've added screenshots for your reference.

 

 

Additionally, you can customize your reports in QBO to easily view the transactions that you need the most.

 

You can also visit this page if you want to record payments for your bills. See the steps outlined here: Enter and manage bills and bill payments in QuickBooks Online. Or, pay multiple payments for bills. 

 

If you require additional support or have any remaining inquiries regarding generating reports, just kindly leave a reply. We're here to provide assistance whenever you need it. Have a good one!

adtnyr
Level 1

How do I pull a report of just billable expenses for a customer?

You cannot do this in quickbooks. 

  1. Go to Reports.
  2. Locate in the Search bar the Transaction List with Splits.
  3. Click Customize.
  4. Under the Rows/Columns, select Customer.
  5. In the Filter section, check Transaction Type and select Billable Expense charge and Bill. 
  6. Once done, click Run Report.

 

There is no option to group by customer under rows/columns. Only Nothing, Account, Name, or Transaction type. 

jeanbiverly_
QuickBooks Team

How do I pull a report of just billable expenses for a customer?

Hi there, @adtnyr

 

You'd be glad to know that you can group the rows or columns by Name to group them by customer. Simply select the option "Name" from the Group by dropdown, then click Run report.

 

Just in case you want to email your report to multiple email addresses, here's a helpful article you can visit: Email a sales form or report to multiple email addresses.

 

Should you have any other concerns besides grouping the rows or columns by customer, please let us know by replying to this thread. We're always available to help.

Ashley1245
Level 1

How do I pull a report of just billable expenses for a customer?

Has there been any useful updates on this? I've also been searching for this report with no luck. 

RhoiceW
QuickBooks Team

How do I pull a report of just billable expenses for a customer?

Thank you for participating in this thread, Ashley1245. 

 

As mentioned by my colleague KimberlyS, we can pull up the Transaction List with Split report to show your customers' billable expenses. Here's how:

 

  1. On the Reports, search for the Transaction list with Splits.
  2. Click Customize. Under Rows/Columns, click Change columns and check Billable.
  3. Press Filter, and under Transaction type, click Bill and Billable Expense Charge.
  4. Click Run report.

 

I've added a screenshot for your visual reference.

 

 

In addition, you may check this article to guide you on how to modify your reports: Customize reports in QuickBooks Online.

 

Also, you can visit this page if you want to learn how to enter a prior balance for a customer who owes you money or a vendor you need to pay: Manage outstanding balances for customers and vendors in QuickBooks Online.

 

If you need help with running reports, just let us know. We're always available to assist you. Take care.

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.

Need to get in touch?

Contact us