This Company Rate Change topic describes how to set up and post a Company Rate Change batch using one specific amount for different Invoice Item codes. For example, you may want to increase all recurring lines with the Item code of Monitoring by $1.50 per month. Further, you may only want to increase customers with this item code which currently has a monthly rate of at least $24.95 per month and up to $29.95 per month. Or you may only want to increase monthly rates that are currently at $24.95 per month by $1.50 per month. Using this method you can accomplish any of these scenarios plus much more by accurately setting the rate change options to accomplish your desired rate increase.
Once the Company Rate Change batch has been created, you may save it and continue working with the batch making changes up until the point the batch has been posted. Once a batch has been posted, no further changes can be made to the batch, however, you may view posted batches by selecting the check box at the bottom of the Company Rate Change List ‘Include Posted Increases’.
To begin the process, navigate to the Client Management menu and select the Company Rate Change menu option. The Company Rate Change List will be displayed. Click the New button located at the bottom of the form to start a new batch. Once the Company Rate Change Form opens, enter a Description for the batch at the top of the form. Proceed on to the next section, Setup Information.
Setup Information
Effective Date – select from the drop-down list, the month/year the rate change will become effective.
Use Item Codes – select this option button.
Increase or Decrease – Most typically you will select the Increase button.
Percentage or Flat Amount – Select the Flat Amount button.
Set All Items / Amount – Select the check box, select all items, and then enter the default amount that will be used to increase recurring lines.
Customer Types – select Commercial, Residential, or Both. Only customers with the type selected will be eligible for a rate change.
RMR Minimum – If you only want to include customers with a particular minimum monthly rate, then enter that amount in this field. Example: if you may have some customers for whom you charge a very low rate, such as $1.00 per month, and do not want to increase those recurring lines. If you enter $1.01 as the RMR minimum, those recurring lines less than $1.01 will be excluded from the batch. You can also use this field in combination with the RMR Maximum amount to include a limited monthly rate range of customer recurring.
RMR Maximum – If you only want to include customers with a monthly rate up to a certain amount, then enter that amount in this field. Example: If most of your customers have a monthly rate of 29.95 but a few are above that amount and you do not want to increase those that are currently above 29.95 per month, then you would enter 29.95 in this field. You can use this field in combination with the RMR Minimum amount to include a limited monthly rate range of customer recurring.
Exclude Recurring Items - The two fields in this area allow you to exclude customers who have received a rate change or have a contract start date that is within a specified number of days. This allows you to exclude customers who have recently received a rate change or maybe a new customer.
The rate increase date exclusion formula subtracts the number of days from the Company Rate Change Effective; if the last increase date is greater than this calculated date, the recurring line will be excluded. When Company Rate Change batches are posted, the recurring line that is being ended by the rate increase program is marked with a last increase date equal to the effective date for the batch. The typical setting for this field is 365 days.
The contract start date exclusion formula subtracts the number of days from the Company Rate Change Effective; if the contract start (System record) date is greater than this calculated date, the recurring line will be excluded. The typical setting for this field is 365 days.
Save As New Setup (optional) – If this check box is selected, the selections made on the Setup Information will be saved and a new Company Rate Change batch is automatically created with the same setup parameters for use as the basis for future rate changes.
Once all information is filled in, proceed to the Branches setup form.
Branches
Select which branches to include in the batch. You may check the box All Branches located at the bottom of the form if you prefer to evaluate all customers recurring in all branches. You must select at least one branch.
Once the branch selections have been made, proceed to the Items setup form.
Items
The Items form will display a list of all the recurring type Invoice Item codes, their description, and an amount column that will automatically be populated with the default amount that was entered on the Setup Information form. If there are Invoice Item codes that you do not want to rate increase, type in the amount of zero for these Items. You may also change the amount on any Item code to any amount less than the default amount. Click the Save button located at the bottom right of the Items form and re-open the batch to continue to the Notes form.