Find charges not checked as "billable"

NoVA123 · ‎July 11, 2023

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.

KlentB · ‎July 11, 2023

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:

Go to the Reports menu.
Under For my accountant, select Transaction List with Splits.
Click the Customize button, then set the appropriate period.
Select Change columns, then add the Customer and Billable options.
Choose Check, Bill, and Expense from the Transaction Type filter.
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

KlentB · ‎July 11, 2023

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:

Go to the Reports menu.
Under For my accountant, select Transaction List with Splits.
Click the Customize button, then set the appropriate period.
Select Change columns, then add the Customer and Billable options.
Choose Check, Bill, and Expense from the Transaction Type filter.
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 · ‎July 12, 2023

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

MichelleBh · ‎July 12, 2023

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 · ‎March 05, 2024

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 · ‎March 05, 2024

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:

Access your QuickBooks Desktop company.
Go to the Reports menu, and then choose Reports Center.
In the Search bar, enter All Income and Expenses.
Locate the report and then click the Customize button.
In the Filter section, locate Billing status and then choose your preferred status.
In the Account, choose Expense and other Expense account.
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 · ‎March 05, 2024

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.

Topics

Training

Community

Resources

Find charges not checked as "billable"