Skip to content
On this page

Customer groups and group pricing

Last updated: 6 November 2026 · 4 min read

A customer group lets you treat a kind of customer the same way, such as wholesale buyers, staff or regular contractors. The group can lower or raise the selling price automatically when you make a sale.

Before you start: To link a group to a selling price list, create the list first under Product setup > Selling Price Group. A customer can be in only one group at a time.

Create a customer group#

  1. Go to Contacts > Customer Groups (1). The list shows each group with its Calculation Percentage (%), Selling Price Group and number of customers.
  2. Select Add (2).

Customer Groups list with the Customer Groups menu item and the Add button marked

  1. Enter the Customer Group Name (1), for example Contractors.
  2. Choose the Price calculation type (2): Percentage or Selling Price Group. The next section explains both.
  3. For Percentage, enter the Calculation Percentage (%) (3), for example -5.
  4. Select Save (4). BillBook shows Success and the group appears in the list.

Add Customer Group pop-up with the name, price calculation type, percentage and Save button marked

To change a group later, select Edit on its row.

Group discount or selling price group#

Each group works out prices in one of two ways:

  • Percentage: the selling price is the product's normal price plus the percentage. A negative number lowers the price and a positive number raises it. Staff at -10% pay 10% less, and Loyalty Members at -2% pay 2% less. A Contractors group at -5% pays 5% less.
  • Selling Price Group: the group uses one of your own price lists, such as Wholesale, instead of a percentage. Choose the list in Selling Price Group (2).

Add Customer Group pop-up with Selling Price Group chosen, showing the price group list

To put a customer in a group, choose it in Customer Group on the customer's form (see Customers and suppliers), or add them from the group page as shown next.

On Sell > Add Sale, choosing a customer fills in the group's price automatically. Here Mr Nimal Senanayake (1) belongs to Wholesale, so Default Selling Price (2) switches to Wholesale, and the pay term from his contact (30 days) is filled in too. A red Customer Due note under the name reminds you what he already owes.

Add Sale screen with a Wholesale customer chosen and Default Selling Price set to Wholesale

Add or remove members#

  1. On the Customer Groups list, select View on a group's row, or the customer count. The group page lists its members, with cards at the top for Members, Active, With due and Total due.
  2. Select Add customers (1).
  3. Search for a customer by name, business, ID or mobile number and pick one or more. Customers who are already in another group show Now in and the group name. They are moved to this group.
  4. Select Add to group (1).

Add customers pop-up with a customer picked and the Add to group button marked

To take someone out, select Remove (2) on their row and confirm with OK. BillBook asks Remove from group? and explains that the customer is not deleted, only left without a group.

Customer group page with the Add customers button and a Remove button marked

Tip: On the list, Add on a group's row opens the same Add customers window straight away.

Customer Groups report#

Go to Reports > Selling > What sells best and select the Customer Groups Report tab (1) to see which kinds of customers your sales come from. Choose a Business Location and a Date Range. Each group shows its invoices, customers, sales, returns, net sales, average invoice and share of sales, and the cards at the top show Net sales, Top group and Customers in groups. Sales made without a group are listed as No group (2).

Customer Groups Report tab with the tab and the No group row marked

Each sale counts under the group it was made with, even if the customer later moves to another group. Select a group name to see what it bought.