cancel
Showing results for 
Search instead for 
Did you mean: 
shezz
Level 1

How do I add markup to my cost of products on an estimate on the online version of QuickBooks? The desktop version had a column for mark up via % or amount.

Intuit is becoming more and more garbage with quickbook. we are stuck using QuickBooks enterprises and it lacks API connection, We now are purchasing QuickBooks enterprises for our staff so they can sign on remotely and send out quotes to customers but now we find out QuickBooks online does not have a simple mark up solution, 

 

If you are a new business owner stay away from Quickbooks desktop and online, if you are running a wholesale distribution. Quickbooks will not help you grow when you are growing, this system is the only bottleneck that does not let us sync. 

rt23
Level 1

How do I add markup to my cost of products on an estimate on the online version of QuickBooks? The desktop version had a column for mark up via % or amount.

Does anyone know it this has been fixed yet with the online version?

jeffhhpllccpas
Level 2

How do I add markup to my cost of products on an estimate on the online version of QuickBooks? The desktop version had a column for mark up via % or amount.

I found a workaround kind of pain in the butt to setup, but it works for now I hope. 

1. Export your product/service list report to excel, delete the qb header and then make a table out the column headers and listings of it once in excel.  Keep this open.

2. Copy estimate to purchase order (chose this because it doesn't hit financials if you mess up) from estimate you want to see markup.

3. In vendor box on the purchase order type in "Estimate Markup" and add as new vendor.  In the purchase order number box put something like the estimate number or something you can associate with the estimate you are wishing to see markup and then save and close.

4. Run an open purchase orders detail report.  I customized it to group by vendor, report period of month to date (you can change this), and then just have date, num, vendor, product/service, memo/description, account, qty, rate, and total amount as the coumns.  Save this customization and name it whatever you want.  I named mine "Estimate Markup Report - Export to Excel".

5. Export to excel and then copy and paste into a new tab in the excel you still have open from earlier, named the tab Estimate Markup.

6.  Add two extra column headers to the right of total amount named sales price and markup percentage.

7.  In the cell immediately underneath the sales price input a vlookup formula for the table on the "Product Service List" Tab.  The formula that worked for me was =VLOOKUP(E7,'Product Service List'!$A$1:$E$7844,4,FALSE)  

8. Once the formula is entered click on the cell in which it is entered, should be K7, and hover over bottom right until you get a little cross.  Once you get the cross, left click and drag down a bunch of rows (that way when you copy and paste a future estimate markup report into it it should just fit right in.

9.  In column L on the same tab (Markup Estimate), change the formatting to percentage, then create a formula for the markup percentage.  I used =(K7-I7)/I7

10. You should then have everything needed to see the markup percentage by item on your estimate.  The good thing about doing it this way is you can see multiple estimates at one time as long as they are all have the vendor as Estimate Markup Report.  Once you are good with what you see you can go back in and delete the purchase order and create a new one with correct vendor or just change the vendor, but you can then print and save as pdf for future reference.

11.  The last thing is if you have a new product or service, you could add it manually to the excel and update the formula for the additional row or you can import the product/service list again into the excel and do as we did above.

 

Hope this helps!

Kitchens Inside Out
Level 2

How do I add markup to my cost of products on an estimate on the online version of QuickBooks? The desktop version had a column for mark up via % or amount.

This seems to only be good if the same markup is applied to the entire form.  For my business each line item has a different markup based on my contract with each vendor - all are different!

Kitchens Inside Out
Level 2

How do I add markup to my cost of products on an estimate on the online version of QuickBooks? The desktop version had a column for mark up via % or amount.

QB customer service - where are we on this issue???  Add the markup field now - two years and nothing???? be responsive to your clients.!!!!

GP1998
Level 1

How do I add markup to my cost of products on an estimate on the online version of QuickBooks? The desktop version had a column for mark up via % or amount.

Quickbooks online - which cloud based would be ideal for field operating businesses, particularly CONTRACTORS, is especially in need of a markup column during estimates and invoicing. How can this be left off the online version?? Should be a no brainer!  One more reason for me to stick with QB Desktop.

hunteryarbrough
Level 1

How do I add markup to my cost of products on an estimate on the online version of QuickBooks? The desktop version had a column for mark up via % or amount.

another example of why quickbooks online is a joke. what a money racket. preying on the ignorant

atreeves
Level 2

How do I add markup to my cost of products on an estimate on the online version of QuickBooks? The desktop version had a column for mark up via % or amount.

This feature has been requested for over 5 years now.  You continue to add advertisements and money generating services, but I pay almost $1000/year for this software and you won't add BASIC contractor features that clealry has hundreds of people asking for it.

 

Stop running commercials about how QBO is designed for contractors when you clearly don't listen to your customers or have any clue/desire to serve the contracting community.  So over QBO, can't find a replacement soon enough.

 

FFS add a way to markup estimates

tpmcma
Level 2

How do I add markup to my cost of products on an estimate on the online version of QuickBooks? The desktop version had a column for mark up via % or amount.

As far as I can tell, in Advanced version, you can create a Project, then within the project, click green button down arrow and select "Cost Estimate".  I think this could get you on track maybe.

Digman Construction
Level 2

How do I add markup to my cost of products on an estimate on the online version of QuickBooks? The desktop version had a column for mark up via % or amount.

I have submitted multiple feedback responses to fix this issue and nothing has been addressed. We NEED this added to estimates/invoices ASAP. Not offering it is affecting our business' ability to fully transition our three LLCs to the online version. GET THIS FIXED PLEASE. 

Digman Construction
Level 2

How do I add markup to my cost of products on an estimate on the online version of QuickBooks? The desktop version had a column for mark up via % or amount.

Intuit team, this issue NEEDS to be fixed!

TeriEmp
Level 2

How do I add markup to my cost of products on an estimate on the online version of QuickBooks? The desktop version had a column for mark up via % or amount.

Yeah., except when you go to make a PO out of it, nothing comes over except the item details, not the project, not the cost, nothing. 

JessT
Moderator

How do I add markup to my cost of products on an estimate on the online version of QuickBooks? The desktop version had a column for mark up via % or amount.

Hi TeriEmp,

 

I can see how helpful it is to be able to add markups when converting POs to estimates. While this isn't a feature right now, I suggest sending feedback so our engineers can consider adding such an option in future updates.

 

  1. Click on the Gear icon.
  2. Choose Feedback.
  3. Enter your feedback and click Next.

 

Your option right now is to manually update the price of the items when creating estimates.

 

Feel free to go back to this thread if you have other questions in mind. I'm just around to help.

TeriEmp
Level 2

How do I add markup to my cost of products on an estimate on the online version of QuickBooks? The desktop version had a column for mark up via % or amount.

Why? So they can continue to ignore it? It only takes 15 minutes of perusing the posts in here to see that nothing ever changes, Intuit doesn't actually care about innovating or creating the functions that people actually need. Why on Earth can desktop carry over costs from an estimate to a PO and QBO can't? There's no answer that paints Intuit in a positive light. They either can't figure out how to do it or they don't care. 

Let's not even address the fact that you don't convert a PO to an estimate, you convert an estimate to a PO. Ya'll really need to work on your bot algorithms. 

Digman Construction
Level 2

How do I add markup to my cost of products on an estimate on the online version of QuickBooks? The desktop version had a column for mark up via % or amount.

I have submitted multiple feedback responses to fix this issue and nothing has been addressed. We NEED this added to estimates/invoices ASAP. Not offering it is affecting our business' ability to fully transition our three LLCs to the online version. GET THIS FIXED PLEASE. 

PrecisionAuto
Level 1

How do I add markup to my cost of products on an estimate on the online version of QuickBooks? The desktop version had a column for mark up via % or amount.

Just switched from desktop to online for BETTER service. Im so over it already.

projects-command
Level 1

How do I add markup to my cost of products on an estimate on the online version of QuickBooks? The desktop version had a column for mark up via % or amount.

Please tell me how this helps. What a horrible solution, to take away the markup column. I dont know why I am staying with quickbooks. The desktop version was WAY better. 

JamesCrozier
Level 3

How do I add markup to my cost of products on an estimate on the online version of QuickBooks? The desktop version had a column for mark up via % or amount.

I tried a trial of Quickbooks Online Advanced and it never had cost estimate. It just had regular estimate.

TeriEmp
Level 2

How do I add markup to my cost of products on an estimate on the online version of QuickBooks? The desktop version had a column for mark up via % or amount.

In their infinite wisdom, they buried this inside of a project, and maned it project estimate. It's practically useless however, because it doesn't carry the cost or any of the client or project information over to the PO when you convert it. You can't even select which parts of the estimate go on a PO, because, you know, no one ever used more than 1 vendor on the same order. 

KMDezine Studio
Level 2

How do I add markup to my cost of products on an estimate on the online version of QuickBooks? The desktop version had a column for mark up via % or amount.

Still no way to add a markup to items on your estimate. So lame. worked in desktop version.

 

If we are reselling printing services, I NEED to add a markup. Now I have to calculate outside of QB and copy in the numbers to the estimate. Almost makes estimating useless in the software. Might as well create all estimates in the desktop version, and just create the invoices in the online version. This also is a waste of time, as you can't convert the desktop estimate to an online QB invoice and has to me done manually. SO LAME! Why is it so hard for them to see this is a crucial part of doing business?

Lending Hand
Level 1

How do I add markup to my cost of products on an estimate on the online version of QuickBooks? The desktop version had a column for mark up via % or amount.

You would use Quickbooks online advanced for this.

DanShanahanSPG
Level 1

How do I add markup to my cost of products on an estimate on the online version of QuickBooks? The desktop version had a column for mark up via % or amount.

I have sent a Feed back note to Quickbooks. But, feel compelled to leave an message in the quickbooks community.

 

My company just upgraded to quickbooks online. Our business functions on a Mark Up from our costs, which is a  basic business concept and was part of quickbooks Desktop.

 

Is it 100% true that QuickBooks  Online Advanced has Mark Up? I've read and researched different reivews and facts about Advanced having mark up for Estimates.

 

If not, Please, Quickbooks, add "Mark Up" to your Estimate forms. What might be all the ways you (Quickbooks Developers) can add Mark Up to your Estimate forms just like it was done in Quickbooks Desktop?

CharleneMaeF
QuickBooks Team

How do I add markup to my cost of products on an estimate on the online version of QuickBooks? The desktop version had a column for mark up via % or amount.

I appreciate you for sending feedback, Dan.

 

The markup feature is a valuable functionality that is currently unavailable in the QuickBooks Online Advanced version. We do not have a specific timeline for when this feature will be added to the online versions.

 

In the meantime, you'll want to consider using a third-party application. I suggest visiting our QuickBooks App Store page to find the app that suits your needs. Let me show you how:

 

  1. Head to the QuickBooks App Store.
  2. From the search box, enter any keyword.
  3. Then, press the Enter key on your keyboard.
  4. You can also use the Categories section.

 

Also, sending a lot of feedback helps the developers and product teams to understand how users are experiencing the software. It provides valuable insights into what can be improved. Sharing your ideas helps in continuous enhancements and updates to make the program more user-friendly and efficient.

 

Additionally, I've added these resources that'll help you set up, do things efficiently, and keep your books running smoothly in QuickBooks Online:

 

 

You can get back on this thread to stay informed if there are any updates regarding the availability of the option. If you have any other questions about setting up your books or the program's features, please don't hesitate to keep us posted.

DON N
Level 3

How do I add markup to my cost of products on an estimate on the online version of QuickBooks? The desktop version had a column for mark up via % or amount.

this is useless. how are we suppose to mark things up in business if we can have a column to do that. what a time waster for this simple fix.  who is running the program stuff. needs to be a business person not a school kid.

 

very disappointed in this program so far. looks like a lot of others are also.

DON N
Level 3

How do I add markup to my cost of products on an estimate on the online version of QuickBooks? The desktop version had a column for mark up via % or amount.

would be nice if after 5 years of feedback that they would do something about it. 

sounds like the government here.  all talk and do nothing

 

fix the markup column already.   wow

Need to get in touch?

Contact us