On this page
Overview
Price plans are your company's price catalogues. All the billed products are added to at least one price plan in order for billing to be applicable. Subscribers and customers are billed for their purchases based on the rates defined in the price plan usually agreed upon contract signing.
Major features
- Use price plans to define rates for every billable product that is added to a subscription, job or activity with the exception of usage services which are added in dedicated Usage Price Catalogs.
- Provide discounts to customers by defining lower than base rates for a specific period, or for a certain purchased quantity
- Create conditional price plans, where rates specified can be applied only on fulfilling conditions specified on each price plan, making them a powerful tool used for providing several types of promotions and discounts to customers.
- Easily manage overall price adjustments due to changed tax rates
Setting Up Price Plans
Price plan rate models
Before setting up your price plans, it is important to understand the different rate models that exist and how billing handles each rate model. When adding new products to the price plan, the rate models available for selection depend on the classification of the product which can be one of the following: expense, termed service, one time service or physical good.
Rate Model | How it works | Applicable for Product Classification | Calculation Logic | Example |
---|---|---|---|---|
Flat Rate | Applies a single fixed price. | Expenses | Final price is based on the base amount | Setup fee: €20 |
Flat Rate, Quantity Based
| Applies a single fixed price based on the quantity of the product, which starts from a base rate and can be modified as the quantity increases, by using a multiple tiers table. If used for termed services, then the logic changes according to the number of the distributors. The quantity of the service will be measured based on the number of authorised distributors of the service. The service will be billed only once, taking into consideration the applicable price.
| Termed services, physical goods | Not cumulative; If the quantity falls into multiple tiers , then the final price is equal to the price of the highest level . If the quantity does not fall into any quantity range, then the final price is equal to base rate price | A channel available from multiple TVs (rooms in the house with different decoders):
|
Flat Rate, Duration Based | Applies a single fixed price based on the duration of the services, which starts from a base rate and can change as the duration required to provide the service increases, by using a multiple tiers table. | One-time services | Not cumulative; If the duration falls into multiple tiers, then the final price is equal to the flat rate price of the highest level. If the duration does not fall into any quantity range, then the final price is equal to the base rate price | Installation service: for 1 hour the charge is €10 and from 2 to unlimited hours the charge is €8 then:
|
Tiered Rate, Quantity Based | Applies a price which starts from a base rate and can progressively change as the quantity increases, using a price table made up of multiple tiers. | Termed services, physical goods
| Cumulative; If the purchase of a product falls into multiple tiers, then the final price is calculated by adding up the base rate and the rates of each tier. If the duration does not fall into any quantity range, then the final price is equal to the base rate price | Antenna: If for 1 antenna the price is €10 and from 2 to unlimited units the price is €8 then:
|
Tiered Rate, Duration Based | Applies a price which starts from a base rate and can progressively change as the duration required to provide the service increases, using a price table made up of multiple tiers. | One-time services | Cumulative, If the duration of the service falls into multiple tiers, then the final price is calculated by aggregating the base rate and the rates of each tier. | Installation service: for 1 hour the charge is €10 and from 2 to unlimited hours the charge is €8 then:
|
Tiered Rate, Maturity Based | Applies a price which starts from a base rate and progressively changes as the subscription maturity (age length) increases, using a price table made up of multiple tiers.
| Termed services | Cumulative; If the subscription age falls into multiple tiers, then the final price is calculated by adding up the base rate and the rates of each tier. | Channel: if for the first month the channel is for free, from the second to third month is €10 and then until binding end is €20 then
|
Price Plan fields
This table contains an explanation of the sections of price plans Data Entry page, a description of the usage of its fields and additional information.
Mandatory Configurable
Main Information | |
---|---|
Code: The code of the price plan which is used to identify the plan throughout the system along with the name. Due to constant price changes, price plans usually have multiple versions, each applicable for a specific period. The code is always the same, for all versions of the price plan. Type: The type of the Price Plan which can be either Base or Conditional and it is generated automatically by the system when creating the price plan. Effective Date: The date that the price plan rates can be used for billing. A new effective date is set in each version of the price plan automatically. Expiration Date: The date that the price plan rates can no longer be used for billing.
Base Price Plan : Used when creating a new conditional price plan. The rates from the base price plan rates will be applied if the conditions specified in the conditional price plan are not met. | |
Rates
| |
Define the rates of the products. The rates are categorised and can be filtered by product classification: physical good rates, One time services rates, termed services rates, expenses rates.
Product Information: The product that is rated, along with product type and product classification. Code: The rate code used by the system to identify rates. It is automatically generated but is editable. Product Bundle: The product bundle related with the selected product. This information is visible only if the specified product is used as a component belonging to a product with a type classified as flexible bundle product which is only applicable for termed services. Rate Model: The rate model that is applicable on the rate. The available rate models depend on the classification of the product to be rated, as described in the Rate Model Table. Base Amount: The rate that is applied if tiered rates are not provided or are not applicable. Base amount also has a UOT(Unit of Time) which is applicable and mandatory for termed services and one-time services. Effective Starting From: This is applicable for termed services only and is used to determine when the recurring charge will become active. The following options are available:
| |
Tiered Rates | Tiered Rates are used to define a different rate than the base rate either for a particular period or quantity, according to the rate model selected. Check the Rate Model Table to understand the application of the tiered rates. Level: A level number to identify the order by which levels are considered. From: The value from which the tier level applies. To:The value up to which the Tier level applies. A selection can be done from:
Amount: The amount to be applied for the tier level. |
Selection Conditions | |
Only available for conditional price plans Conditions which are used to validate whether the price plan can be selected for a subscription or a job | |
Validity Conditions | |
Only available for conditional price plans Conditions which are used to determine if the rates denoted by a price plan can be applied during billing or not. Billing will revert to using the respective base price plan rates if any conditions in the conditional price plan are violated. | |
Allowed Organisational Units | |
The organisational units that can select and assign the price plan on billing term schemes (as allowed price plans to be used), subscriptions and jobs. |
Related configuration areas
The following modules are related to price plans and must be configured in order to be able to start using them
Manual Link | Area | Description | |
---|---|---|---|
Products | Product Types and Products | The products that you would like to provide a rate for must already be configured. Note that if the price plan is already created then upon creation of the product you can also add it to the Price plan through the Product's screen. | |
Billing Term Schemes | Once price plans are created they are added in the 'allowed price plans' tab of the billing term schemes in order to be available for selection on jobs and subscriptions |
Using Price Plans
Multiple effective price plans can be created and the applicable one (according to the customer's agreement terms) can be selected when creating a subscription or a job. If conditional price plans are available then they are also available for selection given that the selection conditions defined on the price plan are met, but will only e used during billing if the 'validity conditions set on the price plan are met.
Selecting and creating a price plan
Specify the criteria that match the price plan you are interested in or use NEW from the Actions Menu to create a new plan. Provide the mandatory information in the price plan fields table before you SAVE the plan.
Amend existing price plan rates
Price plans already assigned on a subscription or a job cannot be modified, as rates are agreed between the customer and the business when creating the subscription or job. There are occasions however that even price plans that are already added to customers must be amended. For example, a change in VAT or the overall increase of rates regardless of the contract.
Customers who that have the price plan updated on their job or subscription will be billed with the new price plan rates. Although this is the default behaviour of the system, the user has the option to define (via Billing Definitions) that until the 'binding end date', customers should be charged the previous price plan rates.
- Search for the price plan you wish to amend and from the Data Entry page click on Actions > Replace from the Actions Menu to open the Replace Price Plan Form modal.
- New Price Plan's Effective Date: Define the date from which the new price plan rates will take effect.
- Adjust Rates by '%': Add a % to update all rates in the price plan or leave empty to make manual updates.
If you would like to increase rates then add a positive number, if you would like to decrease all rates then add a negative number. If you want to manually change rates of each product then leave this field blank.
- Click on SAVE to close the modal.
If the Adjust Rates By % is defined then, all rates will be automatically updated. - Click on EDIT from the Actions Menu to start updating the price plan rates.
Automatically calculate and apply discount to rates
You have the option to offer a discount on already defined base or tiered rates provided that the price plan is not already in use. By using the Calculate Amount link, you can define a discount as an amount or percentage (%) and the system will calculate and set the new discounted price. The action is available on adding new product rates or editing existing.
- Select the product rate you want to update.
- Click on Calculate Amount link, either on the base or tiered rate.
- In the modal
- Provide a number in the 'initial amount' text box (this can be the same or different than the base/tiered amount).
- Select between amount and percentage and provide a number in the text box below.
- Click anywhere outside the text box and check the calculated rate.
- Click on SAVE to apply the change.
- The system will set the amount that has been calculated, regardless if the 'initial amount' provided was different to the base or tiered amount.
- Positive numbers must be used in offering a discount.
If a negative number is used, then the System will ADD this to the initial amount instead.
Initial Amount Discount Amount Calculated Amount 10.00 5.00 5.00 10.00 -5.00 15.00 10.00 5% 9.50 10.00 -5% 10.50
Adding new product to existing price plans
While you cannot change price plans that are already in use you can use Add New Product action to define rates for new products to existing price plans. An alternative to this, is to add the product to an existing price plan when creating the new product directly from the Products data entry page.
- Click on the name of the plan you would like to add a new product rate to go to the Data Entry page.
- Click on Actions > Add New Product from the Actions Menu.
- Use Quick Search or click on the magnifying glass to search for the product .
- In the modal provide all the necessary information for the creation of the Product as explained in the fields table.
Creating a conditional price plan
Conditional price plans as implied by the name can be added and used for billing jobs or subscriptions only if two types of conditions are met. These conditions are defined in the price plan.
- Selection Conditions: If satisfied, the price plan will be available where a price plan is selected to be added to a job or subscription.
- Validity Conditions: If satisfied, the rates from the applied price plan will be used when billing the job or subscription. Validity conditions are required because from the time that a (job or subscription) price plan is set until the time that is it is billed, the 'selection conditions' may no longer be satisfied. It is recommended to have the same conditions defined for selection and validity.
If during billing, the validity conditions are not met, then the system will get the rates from the base price plan that was used when creating the conditional price plan.
- Click on NEW from the actions menu to create a new price plan.
- Provide the information in the section as in the case of a base price plan and make sure you select a Base Price Plan that the system will use in case the selected conditional price plan conditions are not met during Billing
- Rates
All the rates available in the selected Base Price Plan will be present here. Change the rates accordingly or use the Replace Price Plan action to change all the rates simultaneously by a certain percentage.
SELECTION & VALIDITY CONDITIONS
- The process for adding Selection or Validity conditions is the same.
Follow the steps below: In 'Evaluation Settings' there are 2 options that can be set at 2 different levels to select whether all conditions or at least one condition should be met.
General: Select whether conditions for all the condition groups should be met or at least one.
Condition Group Specific: Select whether conditions for all rows within each of the condition group should be met or at least one.
Once the Evaluation Settings are in place, click on each of the condition groups in the group list on the left to start defining the group row conditions.
Click on ADD to add a new row.
or
ADD FROM TEMPLATE to select an existing condition group row.
Templates are condition group rows that have been previously saved to be reused. They already contain information such as type, operator and value.- Type: Select the type of the condition from the drop-down list.
- Operator: Select whether the values defined should be:
- Equal
- Not Equal
- Value: Click on the ADD VALUES link to open the modal to add values for each condition group row, i.e. for the type you have selected.
- Like in Evaluation Settings, set whether all the values defined in the modal should be met, or at least one.
Value 1 - Value 20: Use Quick Search or click on the magnifying glass for a search modal to select the values to be set as conditions.
- Like in Evaluation Settings, set whether all the values defined in the modal should be met, or at least one.
- Save as Template: Save the values per Condition Group as a template so that it can be reused in other condition groups of the same type.
- Click on the SAVE AS TEMPLATE link and provide a name and description.
- Once all the Condition Group rows are complete, repeat the process for a new Condition Group.
- Allowed Organisational Units
- Add the organisational units that can select and assign the Price Plan
- Add the organisational units that can select and assign the Price Plan
- Allowed Organisational Units
Click on SAVE to save the Price Plan
- The process for adding Selection or Validity conditions is the same.
Different values will be available for selection for each type selected in the condition group.
The available types are:
- Subscription Type: Evaluated against the subscription type of the subscription being billed; that is, the offering the customer is subscribed to. (only available for 'selection conditions')
- Billable Entity Maturity: Evaluated based on the maturity of the billable entity, which means whether is a new or existing subscription or job. (only available for 'selection conditions')
- Billable Entities Existing Products: Evaluated against physical goods or services added to the subscription or job
- Billable Entities Products To Be Added: Evaluated against products that will be added to the subscription or job . (only available for 'selection conditions')
- Billable Entities Existing Price Plans: Evaluated against existing price plans; for example if you have multiple subscriptions billed from the same account, it evaluates based on the price plans on the subscription (only available for 'selection conditions')
- Billable Entities Owner Groups: Evaluated against the group that owns the subscription or job
- Accounts Receivable Classifications: Evaluated against the classification of the account owner that owns the subscription or job
- Accounts Receivable Credit Ratings: Evaluated against the credit rating of the account owner that owns the subscription or job
- Accounts Receivable Payment Preference: Evaluated against the payment preference of the account owner that owns the subscription or job
- Billing Term Scheme: Evaluated against the billing term scheme of the subscription or job
- Billing Terms Binding State: Evaluated against the binding state of the subscription; for example whether the subscription is in and out of binding
- Billing Terms Binding Period: Evaluated against the binding period of the subscription; for example if its annual or 2 years
- Billing Terms Billing Frequency: Evaluated against the billing frequency of the subscription; for example if its billed monthly or annually
- Segmentation: Evaluated against accounts receivable that belong to a selected segment (list)
Defining product bundle pricing
A product bundle is a product which is made up of multiple component products; for example an offering to a customer where a single package includes multiple channels.
There are two types of product bundles, fixed and flexible.
- Flexible Bundle Products: Products that have a variable selection of constituent products as components.
- Fixed Bundle Products: Products that have a fixed selection of constituent products as components.
The price of fixed bundle products can be set just like the rest of the products. Flexible bundle products which is only applied to termed service, allow the user to:
- Define a price at bundle level; one price for all included products.
- Define a price at the product level and differentiate when a product is sold as a stand-alone product or as part of a bundle.
- Define both prices and bill for both the bundle and each product individually.
Add a rate at the bundle product Level
Add the product and in the 'Rates' section provide all the required information and leave empty 'Applicable Only If Part of Bundle'
Add a rate for a product when provided through a bundle
Add the product and in the 'Rates' section provide all the required information and for 'Applicable Only If Part of Bundle' select the bundle in which the product belongs, and for which you are defining the rate.
Add a rate for a product that belongs to a bundle but is also sold as a standalone product.
- Add the product and in the 'Rates' section provide all the required information and leave empty 'Applicable Only If Part of Bundle'
- Add the product again and in the 'Rates' section provide all the required information and for 'Applicable Only If Part of Bundle' select the bundle in which the product belongs, and for which you are defining the rate.
Applying business flows on price plans
Bulk adjustment of rates based on tax changes
Tax changes don't need to be a big hassle. Price Plan Adjustment Run Definitions allow you to define rules that will be used to adjust all affected price plan rates whenever vat or tax rates changes.
Once the definition is created and scheduling setting set, SUBMIT the definition. Once the run is completed, it will create a new version of each affected price plan and calculate the new rate for products whose tax rate has changed. Note that the adjustment runs should not be used in case the rates in the price plans are not tax inclusive. Refer to Tax Definition, for more information.
Price plan adjustment run definition fields
This table provides an explanation of the sections of the definition Data Entry page, a description of the usage of its fields and additional information.
Mandatory Configurable
Criteria | |
---|---|
VAT Rates | VAT Rate Change as of Date: Defines the date on which the VAT Rate changes to a new rating period. VAT Rates: A selection of VAT Rates. Multiple VAT rates can be selected and at least one should be specified. |
Price Plans | A selection of price plans on which the adjustment will be applied exclusively. Only non-expired price plans whose 'effective date' is before the 'VAT Rate Change as of Date' will be available for selection. If no price plans are specified, then all non-expired price plans whose 'effective date' is before the 'VAT Rate Change as of Date' will be considered |
Products | Products to be adjusted A selection of products and/or product types, whose rates will be adjusted. Products not to be adjusted: A selection of products and/or product types, whose rates should NOT be adjusted. |
Process Runs | |
Displays the Runs that were executed for the specific Definition. Each Run includes the Price Plans that were processed. In case of an error, the error code and description is displayed. | |
Scheduling Settings | |
Define the scheduling settings which can either be now or in the future.
|
Price Plans Business Example
Scenario
Company ZX wants to set the rates for the following products, with the following billing requirements:
- TV Subscription Start-up fee
- Start up fee: €5
- Start up fee: €5
Installation Service Fee based on the duration, providing a Tiered Rate:
€20 per hour
- 1 hour: €20 per hour
- 2 - 5 hours: €15 per hour
6- unlimited: €10 per hour
i.e. 5 hours of repairs = (1*20)+(4*15) = €80
Repairs based on the duration, providing a Flat Rate:
- €20 per hour
- 1 hour: €20 per hour
- 2 - 5 hours: €15 per hour
6- unlimited: €10 per hour
i.e. 5 hours of repairs = 5*15 = €75
- €20 per hour
- Antennas based on the quantity, providing a Flat Rate:
- Antennas
- 1: €10
- 2: €9
- 3: €8
- 4 - Unlimited: €7
i.e., buying 3 antennas = 3* €8 = €24
- Antennas
- Decoders based on the quantity, providing a Tiered Rate:
- Decoders
- 1: €10
- 2: €9
- 3: €8
- 4 - Unlimited: €7
i.e. Buying 3 decoders = €10 + €9 + €8 = €27
- Decoders
VOD Service fee, based on the number of distributors that the Services are supplied to, providing a Flat Rate:
- VOD Subscription Service
- Only Main Distributor (i.e.,.1): €5
- Main and Twin 1 Distributors (i.e. 2): €4
- Main, Twin 1 & Twin 2 Distributors (i.e. 3) : €3
- For any additional distributors (i.e. <= 4) : €2
- VOD Subscription Service
PPV Service fee, based on the number of distributors that the Services are supplied to, providing a Tiered Rate:
- VOD Subscription Service
- Only Main Distributor (i.e.,1) : €5
- Main and Twin 1 Distributors (i.e., 2): €4
- Main, Twin 1 & Twin 2 Distributors (i.e., 3) : €3
- For any additional distributors (i.e., <= 4) : €2
- VOD Subscription Service
Gold Service Subscription, based on a monthly fee with a free three month trial period:
- For the first three months, the Subscription will cost €0 per month
- Starting from the fourth month the Subscription will cost €20 per month
Solution
Create the following Base Price Plan
- Create the price plan
- Once created add the rates into the plan
- Check the table below and see the rate type and model that should be used to satisfy each requirement
Product Name | Product Rate Type | Rate Model | Base Amount | Tiered Price | Comments | |||
---|---|---|---|---|---|---|---|---|
Tier Level | From | To | Tier Amount | |||||
Start Up Fee | Expense | Flat Rate | €5 | Tiered Rates not allowed for Rate Type: Expenses | ||||
Repairs | One Time Service | Flat Rate, Duration Based | €10 | |||||
1 | 1 | 1 | €20 | |||||
2 | 2 | 5 | €15 | |||||
3 | 6 | Unlimited | €10 | |||||
Installation Service Fee | One Time Service | Tiered Rate, Duration Based | €20 | 5 hours of repairs = (1*20)+(4*15) = 80 | ||||
1 | 1 | 1 | €20 | |||||
2 | 2 | 5 | €15 | |||||
3 | 6 | Unlimited | €10 | |||||
Antenna | Physical Good | Flat Rate, Quantity Based | €10 | Buying 3 antennas = 3* €8 = €24 | ||||
1 | 1 | 1 | €10 | |||||
2 | 2 | 2 | €9 | |||||
3 | 3 | 3 | €8 | |||||
4 | 4 | Unlimited | €7 | |||||
Decoder | Physical Good | Tiered Rate, Quantity Based | €10 | Buying 3 decoders = €10 + €9 + €8 = €27 | ||||
1 | 1 | 1 | €10 | |||||
2 | 2 | 2 | €9 | |||||
3 | 3 | 3 | €8 | |||||
4 | 4 | Unlimited | €7 | |||||
Gold | Termed Service | Tiered Rate, Maturity Based | €20 | Subscription billed for a year: (3*0) +(9*20) = €180 | ||||
1 | 1 | 3 | 0 | |||||
2 | 3 | Unlimited | €20 | |||||
VOD Service | Termed Service | Flat Rate, Quantity Based | €5 | Service is distributed on 4 distributors = 4*2 =€8 | ||||
1 | 1 | 1 | €5 | |||||
2 | 2 | 2 | €4 | |||||
3 | 3 | 3 | €3 | |||||
4 | 4 | Unlimited | €2 | |||||
PPV Service | Termed Service | Tiered Rate, Quantity Based | €5 | Service is distributed on 4 distributors = (1*5) + (1*4) + (1*3) + (1*2) = €14 | ||||
1 | 1 | 1 | €5 | |||||
2 | 2 | 2 | €4 | |||||
3 | 3 | 3 | €3 | |||||
4 | 4 | Unlimited | €2 |
Notes
- If you are using a previous release, view CRM.COM Release Changes.
- Use the Price plans WEB API to view rates from existing Price plans from an external system, such as a customer portal.
Glossary
CRM.COM Term | Definition |
---|---|
Usage Services | Services that are provided upon customer request and are billed based on their usage. |
Subscription | A collection of customer services billed on a recurring, usage or one-time basis. |
Job | A small project initiated by the operator for customers, involving the delivery and billing of services, products and activities. Customer requests and orders, such as that for a new subscription, can be initiated and registered through a job. |
Activity | Small task or action that is either stand-alone or must be completed as part of a larger project. |
Expenses | Services that are provided just once, usually upon customer request, and are billed just once. |
Termed Services | Services which are billed for a term and they cycle |
Physical Goods | A tangible commodity which is provided to customers, such as cameras, decoders and magazines. Physical Goods can be traceable or not traceable. |
One -time Services | Services which are only provide once and billed based on their duration |
Provisioning Distributors | Distributors are used to relate subscription services and subscription associated devices to a specific Provisioning Provider as well as define what services will be available from each device, if more than one device is available on a single subscription. CRM.COM offers integration with several providers. |
Segments | Lists of records in CRM.COM based on conditions that are defined using CRMQL (CRM.COM Query Language), a business query language developed by CRM.COM. |