Automating Pricing in QuickBooks: Quantity Discounts

from The QuickBooks Blog

In a previous article, we touched on how the right pricing is critical for all businesses. Just a small move in price strategy can significantly impact operating profits – and businesses can control, customize, and automate pricing with ease in the Platinum and Diamond editions of  QuickBooks® Desktop Enterprise. This includes the ability to offer quantity discounts, manufacturer markdowns, scheduled promotions, and custom pricing by class, among several other ways. This is all possible using the Advanced Pricing module, included with all QuickBooks Enterprise Platinum and Diamond subscriptions.

Let’s dig deeper into Quantity Discounts.

With Quantity Discounts, QuickBooks automatically changes the prices of items on sales forms, according to the quantity breaks you create. This is a key benefit of Advanced Pricing – the ability to trigger discounts based on exact desired volume or quantities – popularly known as “quantity price breaks.” For example, QuickBooks can automatically adjust prices on sales forms when a customer buys 10 to 19 items, 20 to 29 items, or 30 or more items.

To apply Quantity Discounts using Advanced Pricing, you need to first enable Advanced Pricing:

  1. From the Edit menu, select Preferences.
  2. On the left pane, select Sales & Customers, and then click on the Company Preferences
  3. In the Custom Pricing section, select Enable Advanced Pricing.
  4. (Optional) Tell QuickBooks how to handle price rounding.
  5. Select OK to save.

Note that Quantity Discounts are set on an individual item basis, rather than on a global basis – which is how Price Rules are designed. To set up Quantity Discount conditions:

  1. From the Lists menu, select Item
  2. Double-click on an individual item for which you want to create a quantity discount. You can also create a new item.
  3. Select the Qty Discount
  4. In the Quantity Discount window:
    1. In the Qty From column, enter the minimum number a customer must purchase to receive the discount. For example, if you want to create a discount for customers who purchase 10 or more of this particular item, enter 10 in the field.
    2. In the Discount % column, enter the discount either as a discount percent, a fixed price, a markup percent, or a margin percent. For example, if you want to offer a 10% discount, enter 10 in the Discount %
  5. (Optional) Repeat steps 4 and 5 to create additional quantity discounts for the same item. For example, in addition to the 10% discount for purchases of 10 or more, you can create a second discount level that offers a 25% discount for customers who purchase more than 20 items. In that case, enter 20 in the Qty From field and 25 in the Discount %
  6. Select OK to save.

A word of caution: QuickBooks Advanced Pricing uses the total quantity per line item when applying quantity discounts, instead of the total quantity of an item on the total sales form. So, when an item appears on more than one line of a single sales form, QuickBooks does not combine the quantities of that item across all lines and apply the quantity discount rule. Essentially, you want to ensure that multiple quantities of the same items are entered on no more than a single line on a sales transaction.

continue reading on



Mario Nowogrodzki, CPA.CITP, is founder and principal of Mendelson Consulting (, an accounting technology firm that assists entities with planning, selecting and implementing business management systems. The firm was selected as Top Technologist by the Sleeter Group and Top Integrations Advisor by Insightful Accountant. Nowogrodzki is a member of the Florida Institute of CPAs Business Technology Section; a contributing author and speaker for Intuit, Accountex, and the Woodard Group. Contact him at or at 954-447-0250.

Leave a Reply

Feel free to give us a call.

We look forward to hearing from you!