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: