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

Easy way to markup material inside invoice to make it go towards labor behind the scenes?

QuickBooks Desktop 2020
I typically enter bills and use Items to categorize the materials for a remodel job, then mark the item as billable on the bill so that when I generate an invoice I just add the materials from all the bills using the 'Add Time/Costs' feature.  This creates a 1:1 ratio and no markup on materials.  Some materials take a lot of time to source and customer interaction so I'd like to markup the material itself on the invoice, but if I do that then the P/L doesn't really show that markup as labor, which is what it technically is.  

When I enter the bill I can't alter/change prices or add a labor charge or it will throw off the bills.

If I change the item price inside the invoice then that just throws off the books.

Is there an easy way when using Items in QB Desktop to correlate markup on material to a labor category? 

5 Comments 5
DHeraV
Moderator

Easy way to markup material inside invoice to make it go towards labor behind the scenes?

Yes, there's an easy way to correlate markup material to a labor category in QuickBooks Desktop (QBDT), @CCCBuilder. I'm here to walk you through the process for a seamless experience.

Since you have already enabled the Markup feature in QuickBooks, you can now add a markup percentage on your items. Here's how:
 

  1. In your QBDT file, go to the Lists menu, then select Item List.
  2. Locate and select the item you want to add a markup.


     
  3. Click on Edit Markup.


     
  4. Select the Type of Markup you want on the dropdown.


     
  5. Make sure to add a Cost and Markup Amount.


     
  6. Once ready, click on OK to save.

 

Please note that the markup amount won't show when creating a bill in QuickBooks. It'll instead reflect on the invoice when creating one. Kindly refer to the images below for visual reference. Note: The images contain dummy names.

 


 



Moreover, if you consider adding a default markup percentage on all of your items in the future, here's how:
 

  1. In your QBDT file, click on the Edit menu, then select Time & Expenses.
  2. Go to the Company Preferences section.
  3. Add an amount in the Default Markup Percentage field.
  4. Select OK to save.

 

If you require additional aid with your inventories and transaction forms, please let me know by leaving a response below. I am ready to assist you in any way possible.

CCCBuilder
Level 1

Easy way to markup material inside invoice to make it go towards labor behind the scenes?

I do not currently have Markup enabled. I went through preferences but did not see the option, so currently when I edit an Item I do not see the "Edit Markup" option.

I assume I also need to point Markup towards my Labor income account whenever I enable it?  

 

Thank you

Maybelle_S
QuickBooks Team

Easy way to markup material inside invoice to make it go towards labor behind the scenes?

I'm here to ensure you can successfully add Markup to your items in QuickBooks, CCCBuilder. Let's work together to get your Markup set up and running smoothly.

 

In QuickBooks Desktop (QBDT), Markup doesn't need to be enabled to appear in the item window. It will only be visible if the item type is set as Inventory.

 

Here's how:

 

  1. Go to the Lists menu, and choose Item List.
  2. Choose an inventory item.
  3. Click Edit Markup.
  4. Select the Type of Markup you want on the dropdown.
  5. Add the Cost and Markup Amount.
  6. Hit OK.

 

If you have any questions or encounter any difficulties along the way, feel free to add a comment below. I'll be more than happy to assist you and guide you through the process. Have a great day!

julieka
Level 1

Easy way to markup material inside invoice to make it go towards labor behind the scenes?

I am also searching for a way to add markup on invoices.  I have tried setting the global preferences, editing the markup of the Item, and even by customer, with no success. I buy so many non-inventory materials and parts specifically for each job that I use one 'Item' when entering all of them, thus there is no fixed price; i.e., I have to set the default price and markup price for the Item at zero, and this means all three markup methods do not make the calculation.  I am using Enterprise with Gold subscription.  I am wondering if a Platinum will make this work?

KayePe
QuickBooks Team

Easy way to markup material inside invoice to make it go towards labor behind the scenes?

Thanks for joining us here in the thread, @julieka. Let me help you further with setting up a markup on invoices.

 

When using QuickBooks Desktop (QBDT), you can have a markup on your items to apply to the invoice. In your case, since you don't have a fixed price, I recommend creating a new item for the markup which you can update every time you create an invoice. Here's how:

 

  1. In the Lists menu, go to Item Lists.
  2. Click the Item dropdown, then New.
  3. Choose Other charge for the item type.
  4. Leave the amount as zero and click OK to save.

 

On the other hand, you can also utilize the price rule or advance pricing. With this, you would need to have the Platinum version for this feature. Note that when you create a price rule, you will set a fixed percentage and it will automatically calculate the price.

 

Also, the default markup percentage from your company preferences is for billable expenses only which will be billed to your customers.

 

Moreover, visit this link as your guide when running and personalizing a report in QBDT: Customize reports in QuickBooks Desktop.

 

For more queries about managing your invoices in QBDT, reply below. I'm here to assist you. Take care!

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us