Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Connect with and learn from others in the QuickBooks Community.
Join nowIs there a way to set a markup percentage on items you sell? Currently I have a separate excel file where I have to plug in the cost price of each item and then I have a formula that tells me what the sales price is if I want to sell it at a 40% markup before tax.
Solved! Go to Solution.
Hello @NeuroManager,
As of the moment, we can only enter the cost of the item and the sales price when setting up an inventory item.
In the meantime, what you have practiced is the best option to set this up.
I suggest sending the same message to our developer team by feedback. This way, they'll know of the things need to be added and improve the product preference which will help you and other users about the inventory set up. Simply go to the Gear icon then select Feedback.
Let me know if you have any other questions by clicking the Reply button. I'll be always around to help.
When will this feature be introduced. I have no idea why it would be on desktop and then removed from the online version. This is one of the most basic features of invoicing especially for companies that dont bill time but create items for customers and need to know their cost and profit.
This has been asked of customers for years and Intuit seems uninterested.
Very disappointed!
Hello @NeuroManager,
As of the moment, we can only enter the cost of the item and the sales price when setting up an inventory item.
In the meantime, what you have practiced is the best option to set this up.
I suggest sending the same message to our developer team by feedback. This way, they'll know of the things need to be added and improve the product preference which will help you and other users about the inventory set up. Simply go to the Gear icon then select Feedback.
Let me know if you have any other questions by clicking the Reply button. I'll be always around to help.
Thanks
You're welcome NeuroManager!
Please know that I'm always around here in the Community if you have any other questions. Have a great day!
I think the customers need a straight answer as to whether this option is on the table to be added? It makes no sense to have a more expensive platform that lacks basic business functions of the desktop version.
Is this going to be fixed?
I feel that we as customers should be told if this feature is going to be added to the online version. I dont understand why this would not be included as its a huge component of daily business to know what your profit margin is when creating an estimate.
It makes no sense to have a more expensive platform without the original features that customers use. I tried to send feedback via the gear icon and it wouldnt let me.
From a very frustrated customer.
Hello there, @leighann1.
Whether you need to track expenses, run payroll, or pay and file your taxes, you can count on QuickBooks to make all of these tasks easier. Allow me to share some additional information on how QuickBooks Online handles markup percentage on product and service items.
Currently, the markup feature in QuickBooks Online is used only with billable expenses on the vendor side. So when you have billable time or expenses and you decided to pass it on to your customers - you’re able to set a markup when you invoice the customer.
On the other hand, you can check out the bundle feature of QuickBooks Online. This allows you to add mark ups to the products and service you offered to your clients. The big plus in there is that you can include bundles in creating your estimates.
Here's how:
That should do it! Keep us posted here in the Community if you have other questions about managing your product and service lists. I'd be happy to answer all your inquiries.
Where is the markup feature that I see on the screenshots you posted?
Also, is that feature unavailable on the Expense side? So when products are purchased from a vendor at wholesale and then resold from our office to customers is there no way to have that markup button?
Hello there, NeuroManager.
I appreciate you for joining this thread.
Are you referring to the first screenshot above? If so, the markup option is only available when you create a Bill. As mentioned by my colleague, if you wish to pass the billable time or expense to a customer, you can use the markup you created and apply to an invoice.
While the mark up option in QuickBooks Online can only be use with billable expense on the vendor side, you can check out the QuickBooks Blog for product updates and new features available.
Should you have additional questions, feel free to let me know. I'd be delighted to help.
When will this feature be introduced. I have no idea why it would be on desktop and then removed from the online version. This is one of the most basic features of invoicing especially for companies that dont bill time but create items for customers and need to know their cost and profit.
This has been asked of customers for years and Intuit seems uninterested.
Very disappointed!
As I read thru this thread, it sounds like there IS a way on the desktop version to do this? Can someone explain how? Am I correct in understanding that on the desktop version there is a way to enter a formula using an inventory item's cost for QB to calculate the price?
Thanks,
J
Thank you for chiming in the thread, @JenMontana13.
In QuickBooks Desktop, the markup percentages on products can be viewed on the description of sales transactions. If you want to edit the markup percentage of the item, just go to the Lists menu and select Item List.
Then look for the inventory item and click it twice. This will route you to the Inventory Part details. Just click the Edit Markup tab and enter all the necessary information for the markup.
Also, the Price Level function in QuickBooks Desktop allows you to set prices for all your inventory and expense items. However, this is only available to QuickBooks Desktop Enterprise customers.
To mark up items on an invoice by expense type, you can perform these steps:
Please let me know if you have other questions. I'll be here to help. Have a good one.
Thanks!
I'll try this next. I don't recall seeing an option in the inventory item for edit markup. I'll check it out!
Hi there, nicolatopus.
Currently, the Mark up button in the Item list page is only available in QuickBooks Enterprise.
To remove the mark up option from the estimate page, you'll need to uncheck the Markup box through Customize Data Layout.
Here's how:
1. From the Estimate page, click the formatting tab.
2. Choose Customize Data Layout.
3. Select the Columns button.
4. In the Screen section, uncheck the Markup box.
5. Click the OK button.
Please check this article to learn how to compute for the average cost and know which report will help with inventory management: Understand Inventory Assets and COGS tracking.
Please know that you're always welcome to post if you have any other concerns. Wishing you and your business continued success.
I never thanked you. Found it and it's done.
I think I am having the same issue as NeuroManager. I am creating a bill, but the columns that I have available to me are not the same as your screenshot. I've attached a screen shot of what my interface looks like.
BTW, I'm loving QBO. Keep up the good work and thanks for your prompt support responses!
Let me provide you a few information about adding columns on bills, ross13.
Normally, these are the basic columns that you'll see on a bill. Please see the screenshot below:
For the Class column, you may have to enable the feature first in the Account and Settings to show it on the form. Here's how:
In addition, you can only add a custom field to your invoices, estimates, and sales receipt.
Moreover, we really appreciate you for using QuickBooks Online (QBO). If there's anything else that you want us to help you with sales forms, just let us know and we'll always make sure to get back to you. Stay safe and healthy!
I probably should have been more specific. The column I am looking for is the Markup % column.
Thank you for following up with us, @ross13.
I can share with you some information about markups in QuickBooks Online (QBO).
I've read your initial post and the screenshot provided by ChristieAnn above is for QuickBooks Desktop. With QBO, you can add the column by turning on the feature from the Accounts and Settings.
Here's how:
After that, try creating a bill, then review the column/s available.
For more resources about markups and billable expenses, I recommend opening this article.
As you continue working with QuickBooks, I also suggest checking out the different topics from our help articles as additional tips in the future.
Please let me know how else I can help you with customizing the columns of your transactions. I'm more than happy to help. Have a great day!
That did it! Thanks so much.
Go to Vendors. Then Item List. Right click on any item. Click Change Prices. Then select the type of item, like Non-Inventory Part. Then select the items you want by checking them, or select Mark All, like I do. Then enter the amount or percentage you want to change items by. Be sure to write "%" after the number if you're doing a percentage. Then click Adjust. I like to check a couple items to make sure the 2nd column is accurate in reflecting the change I wanted. Then click OK once you're satisfied and to save the changes.
Hi! I can only see this suggestion (adding mark up to billable expenses) when it comes to marking up the prices for the client's end. I'm wondering if we are allowed to do basically budgeting here in QB. in our company, we have external accountants yet we are the ones doing the budgeting for each project. so we mark up the prices from trades/suppliers and that marked up price will be the prices of that specific client. these items do depend on our standardized mark-up percentages per trade. so how do we do this in QB? we are doing it now, of course through excel, but we are planning to integrate this in QB. is this possible?
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