cancel
Showing results for 
Search instead for 
Did you mean: 
NoVA123
Level 3

Find charges not checked as "billable"

TL;DR: I need to filter a report by customer/project that shows any expenses paid but not checked as "billable". 

 

I am running a report for a customer/project and I've determined that I have expenses that were paid and tagged to the customer/project and the option to check the "billable" option was missed

 

I have run transaction reports, P&Ls, balance sheets, etc. and cannot find a way to filter to expenses that did not get categorized as "billable" for a specific customer/project.

 

Note: this is not found in the default "Unbilled charges" report. 

Solved
Best answer July 11, 2023

Best Answers
KlentB
Moderator

Find charges not checked as "billable"

I understand the importance of accurately tracking billable expenses, NoVA123. Rest assured, I'm here to assist you in finding a solution.

 

There is a report in QuickBooks Online that can help you identify expenses that were paid but not categorized as billable for a specific project. By customizing the Transaction List with Splits, we can refine it to display data that match your criteria. Let me guide you through the process:

 

  1. Go to the Reports menu.
  2. Under For my accountant, select Transaction List with Splits.
  3. Click the Customize button, then set the appropriate period.
  4. Select Change columns, then add the Customer and Billable options.
  5. Choose Check, Bill, and Expense from the Transaction Type filter.
  6. Hit Run report.

 

If a transaction is billable, it will be indicated as Yes in the Billable column. Otherwise, the field will remain blank. You can click the amount to open the entry and edit it accordingly.

 

Additionally, I've compiled a selection of articles that will provide you with valuable insights on maximizing QBO's reporting capabilities:

 

 

Should you require any further clarification or assistance in dealing with your other tasks, please do not hesitate to reach out to me again. I'll always have your back. Have a productive week ahead!

View solution in original post

12 Comments 12
KlentB
Moderator

Find charges not checked as "billable"

I understand the importance of accurately tracking billable expenses, NoVA123. Rest assured, I'm here to assist you in finding a solution.

 

There is a report in QuickBooks Online that can help you identify expenses that were paid but not categorized as billable for a specific project. By customizing the Transaction List with Splits, we can refine it to display data that match your criteria. Let me guide you through the process:

 

  1. Go to the Reports menu.
  2. Under For my accountant, select Transaction List with Splits.
  3. Click the Customize button, then set the appropriate period.
  4. Select Change columns, then add the Customer and Billable options.
  5. Choose Check, Bill, and Expense from the Transaction Type filter.
  6. Hit Run report.

 

If a transaction is billable, it will be indicated as Yes in the Billable column. Otherwise, the field will remain blank. You can click the amount to open the entry and edit it accordingly.

 

Additionally, I've compiled a selection of articles that will provide you with valuable insights on maximizing QBO's reporting capabilities:

 

 

Should you require any further clarification or assistance in dealing with your other tasks, please do not hesitate to reach out to me again. I'll always have your back. Have a productive week ahead!

NoVA123
Level 3

Find charges not checked as "billable"

Thank you very much @KlentB . This was exactly what I was needing. I appreciate the help and quickness in your response. 

MichelleBh
Moderator

Find charges not checked as "billable"

We are so happy to hear that your issue resolved, NoVA123

 

On behalf of my colleagues, you're welcome. Feel free to reach us back by leaving a comment below or posting again in the Community forum if you have any additional QuickBooks-related questions.

 

We'll also make every effort to provide you with the best possible assistance.

AGM2017
Level 1

Find charges not checked as "billable"

Is it possible to run this report in Quickbooks Desktop Enterprise?  I need to make sure I have checked off the billable box for all expenses.  I cannot find a report like this in the desktop version.

Kurt_M
QuickBooks Team

Find charges not checked as "billable"

We appreciate you joining the thread, @AGM2017.

 

Checking here on our end, you can run the All Income and Expenses report and customize it to show the details you need and review them. We'll gladly write down the steps to get you going:

 

  1. Access your QuickBooks Desktop company.
  2. Go to the Reports menu, and then choose Reports Center.
  3. In the Search bar, enter All Income and Expenses.
  4. Locate the report and then click the Customize button.
  5. In the Filter section, locate Billing status and then choose your preferred status.
  6. In the Account, choose Expense and other Expense account.
  7. Once done, click the OK button.

 

You can visit this page to learn more about how to add more details into your report: Customize reports in QuickBooks Desktop.

 

Furthermore, you can check this article to help you keep your current report settings for future use: Create, access and modify memorized reports.

 

It's been a pleasure to have you here today. Feel free to visit us in the Community space if you need assistance generating business reports with specific details inside QuickBooks. Have a good one.

AGM2017
Level 1

Find charges not checked as "billable"

Unfortunately the Billing Status does not produce anything on the report. I did already try that (and I tried again following the steps you recommened just in case I missed a miracle step previously).  In my researched the Billing Status "unbilled" pulls up any expenses you have marked as billable, but not yet billed to the customer.  There is no filter to show expenses not marked billable.  I've tried many different options and it seems impossibe to produce a simple report showing if a box is checked or not.  I even sat on the phone with Quickbook Support for 45 minutes.  Extremely frustrated.  Thank you for trying to help.  This is not resolved.



KMBLRPC
Level 1

Find charges not checked as "billable"

This was pretty good but not perfect.  I can't seem to filer by customer when I run this report. Please help.

KimberlyS
QuickBooks Team

Find charges not checked as "billable"

Your browser requires some troubleshooting to overcome issues that prevent you from filtering the report by customers, KMBLRPC. I'll be pleased to share the detailed process to get you started.

 

In QuickBooks Online, the Transaction List with Splits report will only add a column for customers you've added to each item when creating vendor transactions. Hence, ensure to add them accordingly so they'll populate the report.

 

If your transactions are well set up, I recommend accessing your company using a private window. You're unable to filter the report by customers due to corrupted cache files, which causes unexpected behavior that interrupts your navigation experience.

 

To begin with, you can proceed to these keyboard shortcuts:

 

  • Google Chrome: Ctrl + Shift + N
  • Safari 11 or newer: ⌘ + Shift + N
  • Mozilla Firefox: Shift + Ctrl + P
  • Microsoft Edge: Ctrl + Shift + N

 

Once it works, clear the cache from your regular browser to refresh the website's preference. You can also use the different supported browsers for the best and most secure experience when running the software.

 

On the other hand, you might want to memorize your report to save its current customization settings. This can also be sent via email in a recurring schedule if necessary.

 

Please always consider getting back to us if you have future concerns about running and customizing reports in QuickBooks Online. We're always here to handle all your queries.

KMBLRPC
Level 1

Find charges not checked as "billable"

That didn't help at all.  

KMBLRPC
Level 1

Find charges not checked as "billable"

I don't understand why that didn't help at all.  I not only use QBO through Chrome but I also have the QBO app for desktop.  It doesn't matter how many times I clear everything or log in using incognito or restart my computer for the 100th time, sorting by customer isn't an option.  Is it possible to sort by customer?  Did I go through all this for nothing?

Kevin_C
QuickBooks Team

Find charges not checked as "billable"

It is not possible to directly sort the transaction list with splits by customer, KMBLRPC. I will share further details below.

 

You can add the customer column to the report. However, you cannot directly filter it to show billable expenses. Instead, you can filter by the associated vendor to display transactions related to your customers. Let me show you how:

 

  1. Go to the Reports menu and select the Transaction List with Splits report.
  2. In the upper-right corner, tap the Customize button.
  3. Click the Change columns link, then place a checkmark next to the information you want to see, specifically the Billable and Customer columns.
  4. From the Filter dropdown, choose the transactions in the Transaction Type section.
  5. Select the associated vendors from the Name section.
    download.png
  6. Click Run report to display the data.
    download.png

 

For the time being, I suggest forwarding your feedback to our product development team regarding the option to sort transactions by customer in the Transaction List with Splits report. They can review it and may consider implementing it in the future. Here’s how:

 

  1. Go to the Gear icon at the top and click Feedback.
  2. Enter your feedback and product suggestions.
  3. Tap Next to submit them.

 

I've also included this article for your reference to save your reports to Excel, which will provide more options for personalizing your company's data: Export your reports to Excel from QuickBooks Online.

 

We greatly value your feedback as it helps us enhance our program. Should you have any further questions regarding customizing your reports, please feel free to contact me. I'm here to assist you.

KimAnnVA
Level 5

Find charges not checked as "billable"

Please stop telling people to clear their browser as a "first thing", this sounds like some super old troubleshooting advice that doesn't appear to be the issue with most of us.  I call on a payroll issue, clear the browser, payroll taxes in the wrong place, clear the browser, etc.

 

It is not fun signing back into everything after the browsers are all cleared!!!

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us