How do I manage rate levels on a rate?
When a tiered rate structure exists, the rate levels will help you calculate the amount based on a billing quantity. The quantity represents the amount that will be billed for each level. When the level type is a rate, the quantity will be multiplied by the amount that is stored in the Rate/Amount field. When the level type is an amount, the amount stored in the Rate/Amount field will be billed for each quantity level that applies.
Rates List - With Detail [Caselle Master]
Example
Example: The Rate Table, shown below, charges the first 60 units at.1100000 per unit, the next 140 units at 0.08290700 per unit, and the remaining units at 0.6040100 per unit. Fill the Quantity field with 9’s to charge the highest rate the remaining quantity.
Level 1
Qty: 60
Rate/Amt: .11000000
Type: Rate
Level 2
Qty: 140
Rate/Amt: .08290700
Type: Rate
Level 3
Qty: 99999999999
Rate/Amt: .06040100
Type: Rate
Setting up a rate level
These instructions will show you how to set up a rate level. Repeat the steps to set up each rate level. You can set up to 20 rate levels for each rate.
1. Open Connect Utility Management > Organization > Rates.
2. Find the Rate Levels section.
Rates, Rate levels
3. Use Quantity box to enter a number.
The quantity stores the amount that will calculate for the specified level. The system uses the value in the Quantity field to calculate a range. In the example above, the system will use the Quantity field to set the ending value. For Level 1, the system uses zero to 60; Level 2 is 61 to 140; Level 3 is 141 to 99999999999.
4. Use the Rate/Amount box to enter a rate or amount.
The rate/amount stores the value the system will use to bill for the quantity.
5. Use the Type box to select the type to assign to the value in the Rate/Amount box.
What kind of value is in the Rate/Amount box?
-
If the value in the Rate/Amount box is a rate, select Rate. The rate level will multiply the quantity by the rate.
-
If the value in the Rate/Amount box is an amount, select Amount. The rate level will multiple the quantity by the amount.Example: If the customer's quantity is 55 then, using the example above, the system will bill the amount of the 0.11.
Reviewing rate levels
Print the Rates List - with Detail [Caselle Master] to review the rate levels that have been set up for a rate. Open the Reports menu and then select Rate List.
202205, 2022
Copyright © 2025 Caselle, Incorporated. All rights reserved.
Related Articles
How do I use ascending block rate on a rate?
Use an ascending block rate structure for billing a service, such as water. As ascending block rate is a rate structure where the unit price of each succeeding block of usage is charged at a higher unit rate than the previous block. The ascending ...How do I add a rate?
Organization use rates to calculate a billed amount for electricity, water, sewer, and other services that bill based on the amount used by a customer. The rate allows you to customize how the billed amount is calculated and define what happens when ...Rate custom option list
Use a custom option to activate special billing functionality. The options in this list will change how Connect calculates a rate. If you need assistance, please contact customer service at (800) 243-8275 for more information. Use a custom formula to ...How do I format a rate number?
Assign a rate number. Usually, a rate is created for a specific service and the service number is assigned as the first digit of the rate number. Search window, rate number Example: 101, where 1 is the service number and 01 is the rate number for the ...How do I delete a rate?
Has the rate been used to create billing transactions? If the answer is yes, then the rate cannot be deleted from the Rates table. You can prevent other users and services from using the rate by changing the rate to stop allowing new billings. [More] ...