Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
We do mostly Time and Material projects for customers in QBO. These projects might take weeks or months. We might have hundreds of expenses ranging from a couple of dollars to hundreds of thousands of dollars. These could be fuel purchases, hotel charges, supply purchases, and some flow through Purchase Orders and many do not. We use Projects inside QBO and we mark all expenses and purchases as billable and assign them to their respective Project. So far so good.
When we invoice the customer, we use only a few line items to capture all of these costs into categories such as Parts & Equipment, Consumables, Rentals, Travel Expenses, Contract Labor, etc. We do NOT list every individual expense on the invoice which would result in dozens of pages for each billing. That would be insane and our customers do not want that, nor do we.
Currently, we run reports for all expenses related to a project, then add these totals to the line items on the invoice manually. Unfortunately, this leaves all of these hundreds of expenses as unbilled in QBO. It also makes keeping track of what has been billed and what hasn't been billed very difficult. There is currently no way I am aware of to mark unbilled activity as billed without adding it to an invoice. Seems like a Catch-22.
My thought was to use BUNDLES (in service items) to solve this problem. It works beautifully to hide all of the expenses and consolidate them to a single line item. However, there is no way to add markup to the entire bundle or edit the subtotal which leaves us unable to use this method. Maybe I'm missing something?
Does anyone know of how to add billable expenses to an invoice so they are not individually visible to the customer while still being able to mark them up? If that is not yet possible, is there some workaround to mark billable expenses in a Project as billed?
Thanks for being detailed about your concern, @jdriver.
Allow me to chime in and provide some insights on how billable expenses in QuickBooks Online (QBO) works.
In QBO, all information from a billable expense transaction will be displayed once added to the invoice. The option to hide and consolidate them to a single line item is unavailable. As a workaround, you can consider using a third-party application to achieve this feature. In the App Store, you'll find apps that integrate with QBO. Let me guide you how:
The program is also designed to mark billable expenses as billed when it is added to the invoice. If you need to mark them as billed without linking them to an invoice, you may also want to use a third-party app.
Monitoring and tracking your project’s profitability in QBO is a breeze. For the detailed steps and how it is done, check out this article: Set up and create projects in QuickBooks Online.
I'm always here if you have additional questions about billable expenses in QBO. Let me know in the Reply section below. Take care and have a good one.
Thank you for your reply. Are you aware of any apps that provide the functionality I have described? I have been unable to locate one. This is a very specific request and such information is not usually provided in their descriptions. Anyone else know of some workarounds or can recommend a specific app?
Hi there, jdriver.
Thanks for getting back to us.
While we're unable to recommend what app to use, you can enter a specific keyword in the search bar or browse the Category section of the Apps Center to filter the results. Before subscribing to any app or services, I suggest reading some reviews online or trying their trial options available to ensure that you'll find all of the features you need.
Additionally, here's are some articles that you can read to track manage your billable expenses in QuickBooks Online:
Just drop me a comment below if you have any other questions and I'll get back to you as quickly as possible.
I have this same issue and the answer you received here was as unhelpful to me as I assume it was to you. Did you ever find a convenient solution?
I also have this issue/question/request and find the answer provided unhelpful. If QB can't/won't recommend or suggest apps developed to address this need that they're aware of, then it seems that they should address the need. If they are unable to address the need at this time, then it seems appropriate to suggest specific apps or resources (by name) that will address their customer need.
Has anyone found a solution? We also have this same issue.
I appreciate you for joining the thread, @JasperContracting.
Let me share some information about the billable expenses in QuickBooks Online (QBO).
Currently, the option to consolidate your billable expense into one line item is unavailable. My colleagues from this thread are correct about looking for a third-party application that allows integration with QBO to do the option. You can check out applications here: QuickBooks App Store
I understand how beneficial this feature is to your business and other business owners. It also helps shorten the list when billed to your customers. Nevertheless, please know that our product engineers are always open to any suggestions that will benefit the number of business owners and improve the application.
With this, I recommend you send your feedback directly to them. This way, they can consider this feature to be added to future updates. Here’s how:
Moreover, you can track your project’s profitability by utilizing this article: Set up and create projects in QuickBooks Online
Feel free to get in touch if you need further assistance with the billable expenses. I’m just one post away from assisting you. Have a good one!
The best (and maybe only) way I've figured out how to do this is a bit of a hacky workaround. But what I'll do is add all of the billable expenses to an invoice, then proceed to delete them all choosing "No, keep it" when asked "Would you also like to unlink the billable expense?". This way, you have all of the underlying vendor invoices linked up, but you can enter your own custom line items. Not super pretty, but it gets the job done for us.
Hi there, @sull0509.
I appreciate you for letting the Community know the steps you used. It will surely help other users who have the same issue.
If you need tips and related articles when managing your account in the future, feel free to visit our Community website for more insights.
If there's anything else you need help with, please come by the Community. We're here to lend a hand. Wishing you and your business continued success.
THANK YOU FOR ASKING THIS QUESTION!! SAME THING HAPPENS w/ my Company!
I saw ONE response a while back and it said instructions for going to the "gear" icone on the far right, (which they said wasnt actually a gear function) but yet opens an option to BATCH -UNCHECK - MULTIPLE BILLABLE EXPENSES AT ONCE. I have Yet to find this tool!
I appreciate you for joining the thread, @CaitPHG. I'll be glad to help you with this.
Solely QuickBooks Online Plus and Advanced have access to the billable expenses feature, which only affects charges for Unbilled Expenses.
If you need to batch delete the multiple billable expenses, Quickbooks will hide unbilled expenses and label them as closed without requiring you to create an invoice. Here's how:
1. On the menu page, click Dashboard.
2. Select the Get things done tab.
3. In the address bar, change qbo.intuit.com/app/homepage to qbo.intuit.com/app/managebillableexpense. Then, click Enter.
4. Enter the appropriate date, then hit Save.
If you need to enter multiple expenses or bills at the same time, you can visit this article: Create multiple bills or expenses in QuickBooks Online Advanced.
Feel free to reach out to us again if you have further questions about your unbilled expenses. We're available 24/7. Stay safe, CaitPHG.
Thank you, I will try that.
Has anyone found a good solution for this other than the canned responses from QuickBooks customer service? I have lost business due to too much information on my invoices. I need to be able to consolidate all billable time and expenses to one single number with a brief description of the work completed, but keep the ease of importing time directly to an invoice, and well as the data for internal use. We use QuickBooks Time, and have had to change all of our time to not billable, run a report, and create invoices manually.
No unfortunately, I have not. I am still doing the same thing as you.
I figured it out!!
This came from a link that I was not allowed to post for some reason, but it works!
Follow the steps, and play around with the settings until the invoice displays the info that you want your customer to see. You can create an invoice with all of the line items and markups, but it will collapse everything on the invoice that is sent to your client to either groups or one single number. Once you change the settings, you have to create a test invoice and click print or view PDF to see how your customer will actually see it. Hope this helps!!
Could i ask which version of QB you are using for this workround, as on QBO i am not seeing under Account & Settings-Sales the information you gave to consolidate the billed items? Thank You Diane
What 323woodwork refers to is "Custom form styles." Presently those forms are directly under the gear icon (upper right) in the left column below Accounts & Settings. Basically you create a new form (template) for an invoice that is grouped by type and then also subtotal and hide the detail. I've attached a screen shot of the the page in the custom form editor where the options are for this... at the bottom show activity options.
Once you have this custom form... when you want to create an invoice like this... create the invoice, load in all the billable items, then at the bottom select Customize and then the form you created.
I find this situation entirely unacceptable. On 11/27/23 you sent us a Discontinuation Notice for QB Premier. For background, we have been users of QB for 20 years and have over 1,000 projects, hundreds of customers, and thousands of invoices that have Expense Summary items on them using an Item we cal "Reimbursable Group" using the Group functionality in QB. This feature allows us to bundle expenses together into a single line item on an invoice.
While I don't have an issue with you moving to a Subscription Model for QB, I don't see how you think you can force longtime users to move to your QB Online Platform without providing equivalent functionality. This is "basic" functionality in QB and must be provided before you Discontinue your Desktop product.
For the record, I'm happy to pay an annual fee for the Desktop product until you get equivalency in place, but without equivalency we simply cannot use your QB Online Product.
I create a bundle for example called Time and Materials with no description and add 2 items to my bundle 1.labor and 2.materials I mark the bundle so customer doesn't see the items. Then when I create an invoice I add the bundle to my invoice and in the blank description feild I usually enter the work we did or maybe a brief list of the materials or xxhrs@$××. I then add my labor and billable expenses. After I do that I drag the billable items so they are added to the bundle. Pretty much to same as dragging the items to reorder them on a invoice. If you do this correctly you'll notice the line number will change. This adds the billable items to the bundle along with their totals. Save and print and you will only see the bundle. This way if you need to later check the invoice if a question arises you can click edit invoice and review the items and labor instead of removing the expense but keeping it linked. The original 2 items you can just leave them blank or you can remove them instead. I hope this helps.
I create a bundle for example called Time and Materials with no description and add 2 items to my bundle 1.labor and 2.materials I mark the bundle so customer doesn't see the items. Then when I create an invoice I add the bundle to my invoice and in the blank description feild I usually enter the work we did or maybe a brief list of the materials or xxhrs@$××. I then add my labor and billable expenses. After I do that I drag the billable items so they are added to the bundle. Pretty much to same as dragging the items to reorder them on a invoice. If you do this correctly you'll notice the line number will change. This adds the billable items to the bundle along with their totals. Save and print and you will only see the bundle. This way if you need to later check the invoice if a question arises you can click edit invoice and review the items and labor instead of removing the expense but keeping it linked. The original 2 items you can just leave them blank or you can remove them instead. I hope this helps.
How do you keep the subtotal in the invoice? If you delete the individual items it removes it from the subtotal. I too would like to not have each detailed billable item on an invoice - only the total
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here