Formatting rate sheets

Open the rate sheet from your provider and start a new workbook/spreadsheet in the program of your choice, so you have both a blank document to work on and the original rate sheet to work from.
On the first row of your new document, create the headings you require, depending if you want to only use the mandatory fields or also some of the optional fields:

Note
Any field that deals with rates (including Minimum Charge and Connection Fee) are all measured in minor currency (pence, cents, etc.)

Mandatory

Destination
Used for matching calls, this is typically a phone number in canonical format (ie +4420345671234) or possibly a charge code of some kind (ie UK GEOGRAPHIC).

Minimum Charge
If making a call needs to have a minimum charge, this amount will be calculated when billing calls. A typical example of this is where a call costs 0.5 per minute, with a minimum charge of one minute, but the call ends up lasting 20 seconds.

Connection Fee
Frequently used for premium numbers, this cost is added on top of the billable duration cost of a call.

Peak Rate
The call charge per minute applied if the call is made during peak hours.

Offpeak Rate
The call charge per minute applied if the call is made during off peak hours.

Weekend Rate
The call charge per minute applied if the call is made during weekend hours.

Optional

Note: If you want to add the optional column of Description to the end, for example, you'll need to add the optional columns before it, which in that case would be the three cost columns.

Peak Rate Cost
The cost of sale per minute for calls made during peak hours.

Offpeak Rate Cost
The cost of sale per minute for calls made during offpeak hours.

Weekend Rate Cost
The cost of sale per minute for calls made during weekend hours.

Description
A human-readable description of the destination or charge code used within the rate. If this column is omitted from the rate sheet, Billingbooth will use the charge code against the call description.

Duration Block
When processing call duration, the charge on the call will be rounded up to the nearest second based on the duration block. By default, this field is 1, meaning that all calls get charged on a per second basis. Putting a figure of 15 would round up to the nearest figure of 15, i.e. 15 seconds, 30 seconds, 45 seconds and so on. If you wanted to round up the charge of a call on a per-minute basis, a figure of 60 would be entered here.

Cost Duration Block
When processing call duration and working out cost of sale, the cost of the call will be rounded up to the nearest second based on the cost duration block. By default, this field is 1, meaning that cost of all calls get calculated on a per second basis. Putting a figure of 15 would round up to the nearest figure of 15, i.e. 15 seconds, 30 seconds, 45 seconds and so on. If you wanted to round up the cost of a call on a per-minute basis, a figure of 60 would be entered here.

Per Second Offset
The call will not begin to be charged until after the offset figure (entered in seconds) is reached. So if the offset figure is set to 60 seconds, and the call is 180 seconds long, only 120 of those seconds will be used when calculating the peak/offpeak/weekend fee. By default, this figure is zero. Typically useful for NGCS destinations.
With your headers in place, next you want to copy the values from your provider's rate sheet and paste them in the applicable columns in the rate sheet you're creating.
(Optional) Add your markup to the Peak Rate, Offpeak Rate and Weekend Rate columns. Follow our applying markup to rate sheets article if you need help with this.
Check that all values associated with cost are in minor currency (pence, cents, etc.). Follow our converting a rate sheet from major to minor currency article if you need help with this.
Once you're happy with all your values, save the file as a CSV (Comma Separated Values) file and you're ready to upload it.

Updated on 2018-11-28 20:29:04 +0000

Did you find it helpful? Yes No

Related Articles