Overview
Use the Rate Sheet Wizard to apply across-the-board percentage adjustments or fixed dollar increases to your rate sheet base values. This provides an efficient way to adjust rates for inflation, market fluctuations, or margin targets without manual data entry. ToolWatch displays a yellow alert banner across the top of the preview window if any selected rows have no base value and cannot be updated. Once applied, updates permanently overwrite your rate sheet base values with no one-click revert option, making pre-submission verification essential.
Step-by-Step Instructions
Click Job Cost and Billing on the left-hand navigation sidebar to expand the menu.
Click Rate Sheets.
Click the hyperlinked number in the Rate Sheet ID column for the rate sheet you want to update.
Click Update Wizard in the top options toolbar.
Open the Update Type dropdown menu and select Percentage Increase/Decrease or Flat $ Increase.
Enter your adjustment figure in the Calculation field using positive numbers for increases or negative numbers for decreases (enter the dollar amount if using Flat $ Increase, which only supports positive increases).
Click Preview Changes to load the proposed adjustments.
Review the figures across the Base Value, New Base Value, and Change ($) columns, and check the bottom-left metrics bar to confirm that the Included count, Excluded count, and Total Value Change match your planned adjustments (all items are selected by default; if you only want to update specific items, follow the steps in the How to Filter and Select Items in the Preview Window section).
Select the Show excluded rows checkbox at the top left (which displays the count of excluded items in parentheses) if you need to review models marked --/no data that lack baseline records and will remain unchanged (you may need to scroll down to view)..
Click Apply to [X] rows to finalize and permanently commit your updates to the rate sheet.
How to Filter and Select Items in the Preview Window
Click the master checkbox to the left of the Category column header to deselect all line items.
Type an equipment type into the Category search field to isolate those specific items.
Select the individual checkboxes next to the specific models you want to adjust, noting that each selection automatically updates the Included count at the bottom left and adjusts the number displayed on the dynamic action button.
Click Apply to [X] rows to permanently commit the updates to the selected items only.