Similar to a pricing sheet or scale with different levels of pricing, the Rate Matrix calculates the price of a service based on values in your Custom Fields. When creating an Estimate or Job, the pricing will be automatically added assuming the Custom Field is set up correctly at the Account-level.
Rate Matrices are typically used for a Flat Rate service mode. To create a Rate Matrix, use the following steps:
- Go to Settings > Services or Settings > Products.
- Click the name of the item you want to add a Rate Matrix to or add a new item.
- Go to the "Rate Matrix" tab.
- In the Calculation dropdown list, select the calculation for this item. There is help text to help you decide which one you need.
- In the Based on this Custom Field dropdown list, select a Custom Field that’s already set up. The system will use this field to calculate pricing. The Custom Field must be a "Number" type and designated to Accounts.
- Set the minimum price range for this service in the From and To fields. For any range of between the From and To fields, your service will be charged at that minimum price.
- Click Add Matrix Item to add additional lines to the matrix.
- Use the Copy Matrix button to copy information from the first line item down through the rest. Note that the Copy Matrix button does not copy all fields.
- Ensure all line items of the matrix are filled out including the final row.
- Click Save when finished.
In the example below, the range is 0 to 1000 square feet at a rate of $40.00. For every 3000 square feet over 8000, the range goes up at an equal rate of $8.97. The final row of the matrix allows you to set a rate for every contingency