Formatting rate sheets

  1. 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.
  2. 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

    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.

  3. 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.
  4. (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.
  5. 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.
  6. 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 2017-06-08 11:28:03 +0100

Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.