Skip to main content
N
NoVA123
July 11, 2023
Solved

Find charges not checked as "billable"

  • July 11, 2023
  • 1 reply
  • 0 views

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. 

Best answer by KlentB

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!

1 reply

KlentB
KlentBAnswer
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:

 

  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!

    N
    NoVA123Author
    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
      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.

      Terms & ConditionsAccessibility statement