Prerequisites include:
- Setting up a Product
- Adding a Rating Event
Rating worksheets are an essential tool for reviewing the underwriting and rating details associated with individual quotes. They are also useful for troubleshooting any issues that may arise due to changes made to a specific product.
Each time you run a quote, a new version of the rating worksheet is automatically generated. This worksheet is unique to each individual quote and is driven by the data collected during policy intake.
Accessing the Rating Worksheet
- Select the Quote
Navigate to the customer page and select the quote you wish to review. (Note: You can choose any quote from the list, not just the most recent one. You can always return to previous quotes and review their corresponding rating worksheets. Any data associated with an individual quote is immutable.)
- Open the Quote Details
Click on the specific quote you wish to review. A pop-up window will appear with quote details. These details may include items such as policy limits, deductibles, and premiums by coverage, and are entirely configurable to fit your specific business needs.
In the example below, this product has been configured to show the Lifetime Limit ($10,000) and overall annual premium ($718.00) within the quote details window.
- Access the Rating Worksheet
In the upper right corner of this window, click on the ‘Worksheet’ button, and from the drop-down menu, select ‘Excel Worksheet’ to download the rating worksheet for that quote..
The downloaded worksheet will be your excel rater (added when setting up a rating event), populated with policyholder data that is specific to the quote you just selected. Below is the rating worksheet tied to the example given above. Here you can see the Lifetime Limit and Annual Premium amounts that were mapped to the quote details window, as well as rating variables used in calculating quoted premium.