Price Lists

A price list is a list of customized prices that you can map to a transaction such as invoice, estimate, sales order, credit note, purchase order, bill, recurring bill or vendor credits. It allows you to customize the standard rate and bid your products or services at a higher or lower rate for any specific customer or vendor whenever needed. Price lists can also be associated to a contact.

Managing Price Lists

Create and manage customized price lists for your items and associate it to individual contacts or to the Invoices, Estimates, Sales Orders, Credit Notes, Purchase Orders, Bills, Recurring Bills or Vendor Credits you create for them.


Why should I use a Price List?

A price list lets you have a set of predefined prices for specific contacts while the rest of them would be charged at the normal rate. For instance, you can assign a price list to your first ever customer, and mark the prices of items down by 10% to show your gratitude. Similarly, you could also create a price list for your vendors based on the price they offer at different seasons, and apply them to transactions, instead of editing the item price.

Some examples of when a price list can be used for products:


Enabling Price Lists

To enable price lists in Zoho Books

You can now start creating customized price lists for your customers.


Creating a New Price List

Follow these steps to create a new price list for your business:

Type

Fields Description
Sales Associate the price list to a customer or to sales transactions like Invoices, Estimates, Sales Orders, etc.
Purchases Associate the price list to a vendor or to the Purchase Orders, Bills, Recurring Bills or Vendor Credits.

Item Rate

Fields Description
Markup or markdown the item rates by a percentage Item rates gets increased or reduced by a percentage.
Enter the rate individually for each item You can set rates manually for each item.

Markup or Markdown the Item Rates by a Percentage

Percentage
Price List - Markup or Markdown

Fields Description
Markup Item rates get increased based on the percentage entered.
Markdown Item rates get reduced based on the percentage entered.

Round Off To
Price List - Round off

Fields Description
Never Mind Item rates do not get rounded off.
Nearest Whole Number Item rates get rounded off to the nearest whole number.

Enter the Rate Individually for Each Item

Currency
Price List - Currency dropdown

Select the currency

Enter the individual prices of items
Price List - New Rate


Associating a Price List

There are two types of price list: Sales Price Lists and Purchase Price Lists, depending upon what you chose while creating a price list. You can associate a Sales Price List to a customer or to the Estimates, Sales Orders, Invoices or Credit Notes. You can associate a Purchase Price List to a vendor or to the Purchase Orders, Bills, Recurring Bills or Vendor Credits.

Associate a price list to a contact

You can associate a price list with specific items or markups to contacts by following the steps mentioned below:

Note:
Only the Sales Price Lists will be listed in the Price List dropdown of customer contacts and only Purchase Price > Lists will be listed in the Price List dropdown of vendor contacts.

Choose Price List in contacts

Now, when you create an Estimate, Sales Order, Invoice or a Credit Note for this customer contact, the price list will automatically be associated to the transaction.

And, when you create a Purchase Order, Bill, Recurring Bill or a Vendor Credit for the vendor contact, the price list will automatically be associated to the transaction.

Associate a price list to a transaction

You can directly associate sales price lists to sales trasactions and purchase price lists to purchase transactions. To associate a price list directly to a transaction,

Note: Only the Sales Price Lists will be listed in the Price List dropdown of sales transactions and only Purchase Price Lists will be listed in the Price List dropdown of purchase transactions.

Choose Price List in Invoice


Importing & Exporting Price Lists

You can import sales and purchase price lists into your Zoho Books account either from a CSV (Comma Separated Values), TSV (Tab Separated Values) or XLS (eXceL Spreadsheet) file and export sales and purchase price lists created from your Zoho Books account as a CSV or XLS file.

Import Price Lists

Price List - Import

Note: You can download a sample file and cross-check if the file to be imported is of the same format.

Import Price list - Select file

Import Price list - Select encoding type

Import PL

Confirm Import

Export Price Lists

You can export the price lists in CSV or XLS formats from Zoho Books. To export price lists:

Export PL

Export Price list - Save

Other Actions

Edit, delete, mark as active or inactive

You can also mark your price lists as Active or Inactive and Edit or Delete your price lists.

Price list - other actions

Price list - Mark as active

Price list - Delete

Filter price lists

There are three filters based on the type price list: All Price Lists, Sales Price Lists and Purchase Price Lists. All Price Lists is selected by default.

To view only the sales price lists or purchase price lists, then click the dropdown and select Sales Price Lists or Purchase Price Lists respectively.

Filters


Was this document helpful?
Thank you for your feedback!
TOP