Rate Sheet Format

Rate Sheets provided to Billingbooth must be in CSV (Comma Separated Values) format, and need to include a minimum of six columns in the following order:



Mandatory

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


2. Minimum Charge

If making a call needs to have a minimum charge, this amount measured in minor currency (pence, cents, etc) 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.


3. Connection Fee

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


4. Peak Rate

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


5. Offpeak Rate

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


6. Weekend Rate

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


Optional

You can also include three cost columns and a description column:




7. Peak Rate Cost

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


8. Offpeak Rate Cost

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


9. Weekend Rate Cost

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


10. 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.


11. 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.


12. 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.


The cost columns are never shown to your customers, and are used by Billingbooth to work out the profit per call.


All rates are measured in minor currency (pence, cents, etc), and a full list of all possible chargeable call destinations should be included within a single rate sheet. A header row is expected, and will be skipped when determining rates.


See attached sample sheet at the bottom of this page for reference.


To easily add a margin on top of all your rate, please watch our simple Excel tutorial:




csv
Updated on 2016-11-29 21:57:05 +0000

Did you find it helpful? Yes No

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