We can run the Uninvoiced charges report, rogeraf.
This report displays the list of your billable expense charges. Then, we can filter to show only the data for the specific customer.
I'll show you how:
I've also added these articles that talks about Projects in QuickBooks Online:
You always have me if you still need my help!
OK, let me get this straight:
In Desktop expenses to a customer or project are flagged as billable or unbillable. Therefore, at any time you can have billable, unbillable and billed.
In QBO it looks like you have "billable yes" and "billable no". When you invoice a client "billable yes" is converted to "billable no" so you lose all records of unbillable expenses? That seems remarkable if i am understanding correctly!
But you are saying there is no way to generate a report of all of the "billable no" items?
Also no way to report all of the expenses associated with a client or a project? That seems quite remarkable since that implies all the data is lost and cannot be recovered after you invoice the client or project.
Any assistance is much appreciated!
It's good to have you back here, rogeraf.
Pulling up the Unbilled Charges report and customize it shows your billable expenses that are still unbilled to a client or project. You may want to refer the steps provided by my colleague above to get the information needed.
For more detailed information on how to customize reports, here's an article you can refer: Customize reports in QuickBooks Online.
I'll be around if you have any other concerns.
Thanks for the feedback, but maybe I am being unclear. Forget about billable, etc. and lets simplify the question.......
How can i generate a report for all of the expenses assigned to a customer irregardless of whether it is billable or not? I can generate a time report that shows the total amount of time on a customer, but I cannot generate an expense report that shows the total expenses assigned to the project.
Am i just missing something? Should be needed by anyone doing time&materials work.
Thanks in advance for any feedback.
Thanks for getting back to us, @rogeraf.
To see all the expenses and time you haven't added to an invoice, you can pull up the Unbilled time and expenses report for each customer. This can be done by going to the Project Reports tab in the Project menu.
Just in case, I'll add these articles for future reference:
Please know that I'm only a few clicks away if you have any other questions or concerns. I'll be here to assist. Have a wonderful rest of the day!
Thanks for the feedback, but again it is missing my question. There are three states a bill can have:
- To be billed
- Not billable
When our bookkeeper enters bills i need to be able to easily review for errors as to whether they are entered correctly as "to be billed" and "not billable". I also need to identify the "not billable" for clients occasionally.
So the question is: How can i get a report of all bills that are labeled as "not billable"? I know this status is maintained internally in QBO since you can calculate: "total number of bills" - "bills paid" - "bills to pay" and you don't get zero if you have "not billable" bills. I just cant figure out how to do a report???
Hi there, @rogeraf.
I understand that you want a report where you can track non-billable bills.
I recommend pulling up the Transaction List with splits then customize it for you to see the non-billable bills.
This report will both show the billable and non-billable transactions. You'll want to export it so you can take out manually the billable transactions.
I'm attaching these articles for future reference:
If you still having some confusion, don't hesitate to comment below. I'd be glad to help you. Thank you.
I know you've been through a lot already, rogeraf.
Let's get this sorted out. The suggested report given by my colleague by running the Transaction Lists with splits will give us the information needed. We'll have to make sure that the Customer/Client box is also checked mark so we can easily track those expenses that are unbilled to clients.
The screenshot below will show you how reports will appear:
This report displays your both billed and unbilled transactions.
If in case you're interested in exporting your reports, you can refer to this article for the detailed steps: Export your reports to Excel from QuickBooks Online
Please tag me directly if there's anything else I can do to help. Thanks!
I know what you are saying and what you want, because I'm trying to do the same thing!
I want to run report of all the expenses that were entered into QB for the month. That report has a column that says 'billable,' and beside each expense it says 'yes,' or 'no.'
And there is also a column that says customer.
There is a report just like this for employee time. But we definitely need this for all expenses. It's not about seeing which billable expenses have not yet been billed, but maybe I forgot to click the 'bill to client' button and now I will never know about it! If I could run a report and see something that I know should have been billed to a client but it says 'no,' in the billable column then I know I made a mistake and can fix it!!!
Thanks for joining us here, kjbj.
We appreciate and have taken note of your feedback about the the billable expense report in QuickBooks Online.
For now, the only to determine if a transaction wasn't tagged as billable is if the Billable column (Transaction List with Split report) is blank. If you can see that the transaction does not have a Yes under this column, you can click on the amount to open the transaction. Then, edit the transaction accordingly.
Visit us again in the Community if you need anything else.