Definition:Rating worksheet
📋 Rating worksheet is a detailed document used by underwriters and actuarial teams to calculate the premium for a specific policy or account. It lays out every factor that feeds into the final rate — from base rates and experience modifiers to loss ratio adjustments, schedule rating credits or debits, and any applicable surcharges or discounts. In commercial lines especially, these worksheets serve as the transparent arithmetic behind what a policyholder ultimately pays.
⚙️ The worksheet typically begins with a classification code and a corresponding base rate, then applies a sequence of multiplicative and additive adjustments. An underwriter might factor in the insured's claims history, the specific exposure units for the line of business, territory factors, and deductible credits. In workers' compensation, for instance, the worksheet incorporates the experience modification rate from the applicable rating bureau. Each step is documented so that the logic can be audited by supervisors, regulators, or reinsurers reviewing the book.
💡 Without a well-constructed rating worksheet, the pricing process becomes opaque and vulnerable to errors that compound across an entire book of business. Regulators in many jurisdictions require insurers to maintain and produce these worksheets on demand, particularly during market conduct examinations, to demonstrate that rates are not unfairly discriminatory. For MGAs operating under delegated authority, providing complete rating worksheets back to the carrier is often a contractual obligation — a critical piece of the governance framework that keeps binding authority agreements functioning smoothly.
Related concepts