Advanced Pricing in QB Enterprise

Thanks for posting here with your concern, cgcorder.

I've come to help you set up advanced pricing levels in your account.

With the advanced pricing feature in QuickBooks Desktop (QBDT), you can automatically change the prices of items on sale based on the price rules you create. Also, you can create quantity discounts on specific items. 

Let us first activate the Advanced Pricing feature. To do that:

1. Go to Edit from the menu bar and select Preferences.
2. Select Sales & Customers and click on Company Preferences.
3. In Custom Pricing, click Enable Advanced Pricing.
4. Choose how QuickBooks handles price rounding.
5. Once done, select OK.

Once activated, you can create price rules with conditions, you can refer to this article for more detailed information: Set up and use Advanced Pricing. Also, it includes steps if you'll want to create a quantity discount for specific items.

Moreover, I've added this reference to guide you in setting up custom rates or prices for particular customers: Set up custom rates or prices for employees, vendors, or customers. 

You're always welcome to reply in the comments below if you have additional questions about setting up price levels. We'd be delighted to assist you further. Keep safe!

I've done all that. I need an example.

Hey there, @cgcorder.

When advanced pricing is activated, you can use price levels to set up custom pricing for particular customers or jobs. You can use this feature on sales forms to adjust the price of an item. 

Here's how to create and use a price level:

1. From the Lists menu, go to Price Level List.
2. Select Price Level at the bottom, then choose New.
3. Enter the price level name then choose Per Item Price Levels as the price level type. This Lets you set custom prices for items associated with different customers or jobs. For example, you might use a per-item price level for your preferred customer (James) who is charged $8 for product A/reporting (regularly priced at $10 for Tom). In another example, you might have a specific customer you agreed to charge $50 per hour for reporting time (regularly priced at $70) and $30 per hour for administrative time (regularly priced aT $35 per hour). 
4. Select OK.

Please take note that this is only available if you have QuickBooks Desktop Premier or Enterprise editions.

When applying price levels, you have two options:

Option 1: Apply a price level directly to items on a sales form

1. Create an invoice or any sales transaction
2. Go to the Rate column then select the drop-down and choose a price level to apply to the item. Note that the amount shown next to each price level is the adjusted amount of the item.
3. Save the transaction.

Option 2: Associate a price level with one or more customers or jobs.

1. Go to the Customers menu and select Customer Center.
2. Double-click a customer in the list.
3. Go to the Payment Settings tab.
4. Click the Price Level drop-down and choose the price level you want to associate with the customer.
5. Select OK.

For more info, you can check out this article: Set up custom rates or prices for employees, vendors, or customers.

Feel free to place a concern below if you need further assistance. I'm always around to help. Enjoy your day!

Hi RaymondO,

This is much better than the first response I received. One thing though...

What if Tom and James were employees charging different rates for the same item for 1 customer?

Thanks for coming back, @cgcorder. 

The steps that I've shown above are intended if you set up your employees as customers or jobs. That's why I recommend using the Price Levels feature to set up custom pricing for them. Doing this will easily adjust the price of an item while creating a sales form. 

If you want to use advanced pricing with these employees, then we can set up custom rates for service items using the Billing Rate Levels feature.

You'll want to use this if you find that one standard rate for a given service is not always sufficient. For example, different employees doing the same service might bill at different rates based on experience level or labor burden costs.

Once you create billing rate levels and associate them with employees, each time you create an invoice with billable time, QuickBooks automatically fills in the correct rate for each service item based on who did the work.

Here's how to create a billing rate level:

1. From the Lists menu, select Billing Rate Level List.
2. Click the Billing Rate Level drop-down list then choose New.
3. Enter the billing rate level name then choose the billing rate type.
   • Fixed Hourly Rate if you want the billing rate to be fixed. When you choose this, you need to enter the hourly rate in the Hourly Rate field.
   • Custom Hourly Rate Per Service Item if you want to use a different hourly rate for each service item performed by people with this billing rate level.
      

To use billing rate levels, follow the steps in this article: How to use billing rate levels in QBDT. 

Keep me posted if you still have questions or concerns with price rules. I'm always here to help. Take care and have a good one.

RaymondO,

I can do the billing rate for the employee and the pricing for the customer within the same invoice? 

If so, what would the price rule name need to be? 

Thanks for following up with the Community, cgcorder.
 

You're correct, you can do your billing rate for an employee and pricing for a customer in the same invoice. After creating your billing rate lelvels and associating them with employees, QuickBooks will automatically fill in the appropriate rate for service items based on who performed the work when an invoice with billable time is created.
 

As for naming price rules, you can name them whatever you prefer their titles to be.
 

I've also included a detailed resource about working with price rules which may come in handy moving forward: Set up & use Advanced Pricing
 

If there's any additional questions, I'm just a post away. Have an awesome day!

Sometimes the employee rate changes per job/customer. How would that work?

Thanks for getting back here in the thread, @cgcorder.

Please know that when setting up price rules inside QuickBooks Desktop (QBDT), there's an option to add a date for the duration until when you'd like the price for that specific item to stay. After that period, the item prices will revert to their original price from when you first added it to your company.

I'll walk you through the process to get you going. These are the steps:

1. Access your QuickBooks Desktop company and then go to the Lists menu, then select Price Rule List.
2. Click the Price Rule, then choose New.
3. Enter a name for the rule in Price Rule Name, and then enter a brief description of the rule in Description.
4. Select Add (+) to add a condition, and then click whether the condition applies to Item, Customers, Class, or Sales Reps.
5. Repeat step 5 if you want to create more conditions.
6. Enter the date when the price rule goes into effect in From. You'll then enter the date when the price rule expires in To.
7. Enter a percent or amount to increase or lower the price based on the item's base price or cost.
8. To make this price rule exclusive, select Exclusive Rule. QuickBooks won't combine exclusive rules with any other rules.
9. To set custom prices for specific items, select Price Overrides and then once done, click the OK button.

For further guidelines, please see this article: Set up and use Advanced Pricing.

Aside from that, I've got you this reference to help you add more details to your reports inside QBDT: Customize reports in QuickBooks Desktop.

@cgcorder, feel free to mention me in the comment section below if you need further assistance with this. You can also post here again if you have any additional QuickBooks-related concerns. I've got you covered. Take care!