You can manage origin-based rates by uploading and downloading rate decks from/to a file (.xlsx or .xls), just like with standard rates.
Suppose a service provider, Owl Telecom, starts working with a new vendor, GlobalNet, that charges a base price per destination and applies surcharges if a call originates from a specific country. GlobalNet sends Owl Telecom an Excel file that includes the following sheets:
- Basic rates per destination code group, e.g., $0.05 per minute for calls to Turkey-Mobile Turkcell.
- Destination code groups with the corresponding phone prefixes, e.g., a code group “Turkey-Mobile Turkcell” includes prefixes like 90530, 90531, etc.
- Origin-based surcharges per origination code group (applied when a call is made to a specific destination from a specific origin number), e.g., a $0.02 per-minute surcharge for calls to Turkey-Mobile Turkcell from the EU and a $0.04 per-minute surcharge for calls from outside Turkey and the EU.
This sheet includes both the Basic rate code group and Extra rate code group columns to link surcharges to the destination code groups.
- Origination code groups with the corresponding phone prefixes, e.g., a code group “EU” includes prefixes 31, 32, etc., and a code group “Outside Turkey and the EU” includes prefixes of all other countries.
Adam, an admin at Owl Telecom, sets up a vendor tariff and uploads the received file. The system automatically parses the sheets from the uploaded file and displays them on separate tabs. Adam manually marks the first two sheets as representing "basic rates or groups" (used for destination-based pricing) and the next two sheets as representing "extra rates or groups" (used to apply origin-based surcharges).
Since this is the first time a file in this format is being uploaded, Adam manually matches the columns on each sheet with the corresponding rate parameters, such as codes, rate code group, price, etc.
The admin reviews the rates, and clicks “Upload.” As a result, the rate code groups are uploaded, and rates are seamlessly added to the vendor tariff.
Since Owl Telecom wants to use origin-based charging for their customers (large enterprises and call centers with end users in various countries), Adam configures the customer tariff and uploads rates in a similar way. When a customer requests a price list, the admin opens the customer tariff, downloads the rates into a file, and sends it to the customer.
This enhancement streamlines the management of tariffs with origin-based rates.
Organization of rate parameters in the file
A rate file must clearly link each price to the correct destination and origination:
- Basic prices must be defined for each destination code group.
- Origin-based surcharges (or extra rates) must be defined for a pair: a destination code group and an origination code group.
Rate codes that belong to destination and origination code groups can be listed:
- either on separate sheets (as in the example),
- or directly in the Basic rates and Origin-based surcharges sheets.
The system correctly handles both formats.
Configuration
Before uploading origin-based rates from a file, perform the following steps:
- Create destination and origination code group sets with the “Destination” and “Origination” rate matching modes, respectively (as described here).
Create at least one code group in each set to make the code group sets available for assignment; otherwise, the system will treat them as “drafts.” You don’t need to manually add all code groups with their corresponding prefixes – the system will automatically import them from the file. New groups will be marked with the corresponding icons at the “Review rate information” step of the rate import process. If any rate codes are missing in the system, they will also be added automatically to the rate code list.
- Create a tariff with the following settings (as described here):
- Set Define prices to Per code group (supports CLI+CLD rating).
- In the created tariff, navigate to Price selection rules and create a new rule that defines how to handle extra rates (i.e., add to basic rates as a surcharge) and includes the origination group set.
To upload a file, perform the standard steps: click Rate upload 
for the needed tariff in the list, or open the tariff, navigate to Rates, and click Rate upload.
Note that the price selection rule configured at step 2.b should be assigned to each basic rate. You can assign the rule during the “Data mapping” by creating a virtual column:
- Open a sheet of the "Basic rates or groups" type
- Click Add virtual column
- Select field Price selection rule
- Select the configured price selection rule, e.g., “Add surcharges based on CLI” as the default value
Specifics
Each rate parameter, such as basic price, can be mapped only to one column across all sheets of the same type ("Basic rates or groups" or "Extra rates or groups"). The only exceptions are the “Code group for basic rates” and “Code group for extra rates” parameters, as they can be present on multiple sheets.
