Get 50% OFF QuickBooks for 3 months*

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
CGhent
Level 1

Multiple costs per item

My vendor creates contract pricing based on my customer. This means one item number could have multiple costs based on who I am selling it to. Is there some way to accommodate this in QuickBooks Enterprise Desktop?

1 Comment 1
Tori B
QuickBooks Team

Multiple costs per item

Hey there, @CGhent.

 

How are you doing today? I hope all is well. 

 

It sounds like the Advanced Pricing feature would come in handy here. QuickBooks tracks single cost for inventory valuation; however, you can use Price Rules to automatically adjust your sales prices based on customer specific contracts. 

 

Here's how you can set it up: 

 

First, you'll need to enable Advanced Pricing:

 

  1. Click on Edit, then select Preferences.
  2. Tap Sales & Customers, then hit Company Preferences.
  3. In Custom Pricing, select Enable Advanced Pricing.
  4. Tell QuickBooks how to handle price rounding.
    • To not use rounding, choose Don’t round prices.
    • To use the same rounding for all price rules, select Use the same rounding across all price rules, then select a rounding option.
    • To set the rounding for each price rule separately, choose Set rounding on each price rule.
  5. Hit OK.

 

Next, you'll need to create customer specific price rules. Here's how: 

 

  1. Go to Lists > Price Rule List.
  2. Click on Price Rule > New and name it (e.g., "Contract - Customer A").
  3. Tap on Add (+) to add a Condition and select Customers to choose the specific client.
  4. Set the price adjustment (e.g., a percentage or fixed amount based on cost or base price).
  5. Use Price Overrides if you need to set a specific, exact dollar amount for particular items under that contract. 

 

As an alternative you can also assign price levels per item. Here's how: 

 

 

  1. Go to Lists > Price Level List > New and click on Per Item.
  2. Associate this price level with a customer in the Customer Center under the Payment Settings tab.

 

Before making these changes, it's important to keep in mind:

 

  • When advanced pricing is activated, QuickBooks changes the price levels in your company file into price rules.
  • If both a billing rate and a price rule apply to an item, QuickBooks will apply the billing rate, not the price rule.
  • Price rules won't apply to estimates or invoices created from estimates with the markup column.

 

For more information about using Advanced Pricing, check out Set up and use Advanced Pricing.

 

That should do the trick. Please don't hesitate to let me know if you have any additional questions or concerns. Take care! 

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.

Need to get in touch?

Contact us