Price Rules (aka Price Levels) in QuickBooks Online

Price Rules is currently available in Plus plan only. It’s not available in Essentials and Simple Start plans. Customer type is linked to price rules feature at this time.

Using pricing level you can establish different price points for Customer, more helpful for inventory items. But with customer type, you can filter the sales report which is probably helpful data to all the users

How to set up and use special pricing for selected or all customers in QuickBooks Online?
1. Setup New Customer Type (Dashboard > Sales > Customers > Customer types > New Customer type).
2. Turn on Price Rules (Gear > Your Company > Account and Settings > Sales > Products and Services > Turn on Price Rules).
3. Setup New Price Rules (Gear > Lists > Products and Services > Drop-down arrow under MORE > Price Rules).
4. Create Invoice or Sales Receipt (Create + sign > Customers) > Select (or use default) Price Rules under Rate column.

Educational and Instructional Video:

QuickBooks Online QBO Price Rules (aka Price Levels) – Special pricing for selected or all customers

Coming QBO Improvement – Price Rules (aka Price Level List on QB Desktop)

Manage your multiple price lists for different customer types with ease.
Eliminates the hassle of maintaining and remembering who gets what price for what items.

To turn the Price Levels ON in QBO (COMING FEATURE):
Gear at the upper right corner > Your Company > Account and Settings > Sales > Products and Services > Show Price Rules drop down on sales forms > ON > Save.

On Customer Information page, new ‘Additional Info’ field (next to Attachments) is added to enter Customer Type and Price Rules.

QuickBooks Online - Buy now and save 50%

Step-by-Step Guidance: create sales receipt template with bundle and enter daily sales summary

In this free video tutorial, you will learn step-by-step instructions on how to create sales receipt template using bundle feature and also how to enter daily sales summary using that template. This video tutorial is specifically designed for retail, service and restaurant businesses. If you’re a bookkeeper or office staff whose job tasks include entering daily sales summary into QuickBooks, this is the video you must watch. Watch this video in its entirety and you will know how to handle daily sales summary the right away.

How to batch switch from service items to non-inventory parts without going into each individual item

You can batch “Change type” from service to non-inventory type or non-inventory to service in QBO. However, for service to inventory or non-inventory to inventory type, you can’t do batch change type, you will need to edit and change one item at a time.

To make batch “Change type” from service to non-inventory type:
1) Click find (little funnel arrow-down)
2) Select “Service” from Type selection
3) Click “Apply” button
4) From the Service type list, Click “All” checkmark
5) “Change type” box should expand (far right corner)
6) Select “Make non-inventory item”

In case, you need to revert back to change type again, follow the steps again.

batch change type 1
batch change type 1
batch change type 2
batch change type 2

You can’t also change batch item list mapped to GL account type in QBO list page. You will need to upload a CSV or Excel file (from gear > tools > import data > products and services).

If you found our answers useful then please contribute few bucks to support this forum. Thank you!

Thank you!

Sign up QuickBooks USA

Handy reference to inventory item fields

Here is a handy reference on how to fill out fields in an inventory item screen you are creating.

You might not see some of these fields in your inventory item screen depending on your choices in Company Gear icon (upper right corner). You will need to enable Quantity on Hand (QOH) inventory tracking in Company Settings.

From the home page screen:
- Company Gear (upper right corner)
- Settings
- Company Settings
- Sales
- Products and Services
Show Product/Service column on sales formsAdds a Product/Service column on sales forms so you can choose from a list of products and services to include.
Track quantity and price/rateAdds Quantity and Rate fields to sales forms so you can track this information for products and services.
Track quantity on hand Lets you track available stock for each product you sell and its related inventory costs.

Click on the screenshots below to enlarge them
inventory tracking settings

Inventory item screen fields

FieldsReference Guide
NameEnter the name of the product item you are selling or Stock Keeping Unit (SKU). SKU could be manufacturer's part name or your own unique product code.
SKUManufacturer's part number or your own unique product code.
Note: You cannot select SKU on sales forms at this time. However, you can search it on Products and Services page.
Upload PhotoRecommended dimensions are 120 x 120 pixels.
Is sub-product/serviceIf the product is a sub-item, select it from the list under parent product name. Do not use parent product name. In our example, "Tools" is the parent product name and "Pipe Wrench" is the sub product item.
Track Quantity on Hand (for inventory items)
I track quantity on hand for this product. This enables inventory cost accounting.
When you select this checkbox, "Initial Quantity On Hand" and "As Of Date" fields will be displayed.
Initial Quantity On HandEnter a zero or actual quantity on hand. Bear in mind!! These two factors must be taken into account when computing actual quantity on hand: 1) all vendor purchased inventory items are recorded in QuickBooks (no unentered vendor bills left); 2) all sales invoices and sales receipts are shipped out (no outstanding shipments left).
Make sure actual quantity you are entering is 100% accurate. QBO is not that friendly when it comes to making inventory adjustments later.

As Of DateEnter "as of date".
Inventory Asset Account
Use default "Inventory Asset" account. It is best not to change it.
Sales Information
Description on sales forms
This is what the customer/client see on all sales forms (invoices and sales receipts).
Purchasing Information
Description on purchase forms
This is what the vendor sees on purchase orders.
Price/RateEnter the price you will sell it for. You can also change this price when creating a sales form.
CostEnter actual cost if you have "initial quantity on hand". Do not create sales form if you have zero Quantity on Hand.
Income account
(Sales of Product Income)
Default is "Sales of Product Income" account. It is okay to select other product income account.
Expense account
(Cost of Goods Sold)
Default is "Cost of Goods Sold" account. It is better not to change it.
Is taxableSelect "Is taxable" checkbox if the product item you are selling is taxable.

inventory fields


YouTube Tutorial Video: