Workers’ Compensation Premium & Audit Planner
Plan a payroll-rated workers’ compensation premium with a transparent comparison of estimated and audited payroll. Enter each payroll class and its final manual rate, then inspect how experience and schedule factors, a minimum premium, assessment and fixed fees affect the total. Compare class contributions, see a signed audit balance after premium-only payments, and review a cent-reconciled installment schedule. Export the inputs and exact calculations together. This is a declared planning sequence, not a carrier quote, classification service or universal jurisdictional rating formula. Hourly-rated systems are unsupported.
See the premium behind your payroll.
Compare estimated and audited payroll, trace the rating adjustments and plan the cash required.
One policy. Two payroll scenarios.
A payroll-rated planning comparison using your entered final manual rates. The declared sequence may differ from your carrier’s rules. Hourly-rated systems are unsupported; no rates or class codes are inferred.
1–12 characters; no automatic currency conversion.
1–100 characters; use a descriptive label for this comparison.
Rating assumptions
Declared order: class premiums → experience factor → schedule factor → minimum premium → assessment → fixed fees. Use your policy’s final manual rates. This sequence may differ from a carrier invoice.
Greater than 0 through 10, up to six decimals. Enter the factor supplied for your policy; this tool does not calculate it from claims.
Greater than 0 through 10, up to six decimals. For example, 0.9 reduces the preceding premium by 10%.
0–1,000,000,000 currency units, up to two decimals. Applied after both factors, before assessment and fixed fees.
0–100%, up to six decimals. Applies after the minimum; excludes fixed fees.
0–1,000,000,000 currency units, up to two decimals. Added after assessment.
Payment planning
The schedule uses estimated premium. Premium already paid is independent of this schedule and is subtracted from audited premium to estimate a balance.
0–100% of estimated billable premium, up to six decimals. Deposit rounds to the nearest cent, half up.
Whole count, 1–24. Sequence numbers are not calendar dates; the final installment reconciles cents.
0–1,000,000,000 currency units, up to two decimals. Charged on every scheduled installment, even a zero-principal one. No installments or fees when the deposit pays the premium in full.
Illustrative payroll-rated policy
What changed at audit?
Estimated payroll is USD 300,000; audited payroll is USD 360,000. The signed change is USD 60,000. The audit balance is independent of the planned deposit and installments; it is a planning estimate, not a carrier invoice or guaranteed refund.
Effective premium per 100 payroll units: estimated USD 2.84; audited USD 2.94. This includes minimum premium, assessment and fixed policy fees.
Follow each rating adjustment
Both comparisons use one currency scale. Each bar connects the prior amount to the next amount; a dashed border marks a decrease. Final premium bars start at zero. Values and signed rounding adjustments appear below each bar; CSV retains exact fractions.
Manual premium
Change: USD 8,250 · Result: USD 8,250
After experience factor
Change: USD −825 · Result: USD 7,425
After schedule factor
Change: USD 742.5 · Result: USD 8,167.5
After minimum premium
Change: USD 0 · Result: USD 8,167.5
Assessment
Change: USD 163.35 · Result: USD 8,330.85
Fixed fees
Change: USD 200 · Result: USD 8,530.85
Cent rounding
Change: USD 0 · Result: USD 8,530.85
Billable premium
Total: USD 8,530.85 · Result: USD 8,530.85
Manual premium
Change: USD 10,275 · Result: USD 10,275
After experience factor
Change: USD −1,027.5 · Result: USD 9,247.5
After schedule factor
Change: USD 924.75 · Result: USD 10,172.25
After minimum premium
Change: USD 0 · Result: USD 10,172.25
Assessment
Change: USD 203.445 · Result: USD 10,375.695
Fixed fees
Change: USD 200 · Result: USD 10,575.695
Cent rounding
Change: USD 0.005 · Result: USD 10,575.7
Billable premium
Total: USD 10,575.7 · Result: USD 10,575.7
Minimum-premium uplift: estimated USD 0, audited USD 0. Before cent rounding: estimated USD 8,530.85, audited USD 10,575.7. Exact raw values: 170617/20 and 2115139/200 USD, respectively.
Which payroll classes drive the change?
Paired bars share a scale of 0–USD 9,900. Solid green is estimated; outlined blue is audited. These class amounts include both factors but exclude the policy minimum, assessment and fees.
Office payroll
Estimated: USD 247.5 · Audited: USD 272.25 · Change: USD 24.75
Field payroll
Estimated: USD 7,920 · Audited: USD 9,900 · Change: USD 1,980
| Class | Estimated payroll | Audited payroll | Manual rate per 100 | Estimated base | Audited base | Change after factors |
|---|---|---|---|---|---|---|
| Office payroll | 100,000 | 110,000 | 0.25 | 250 | 275 | 24.75 |
| Field payroll | 200,000 | 250,000 | 4 | 8,000 | 10,000 | 1,980 |
Plan the premium cash flow
Each bar shows premium in solid green plus installment fee in outlined amber. Common scale: 0–USD 2,132.71. Periods are sequence numbers, not dates. Audited cash cost retains the same planned fees; it does not recalculate or refund them.
DepositUSD 2,132.71 = USD 2,132.71 premium + USD 0 fee
Installment 1USD 1,604.53 = USD 1,599.53 premium + USD 5 fee
Installment 2USD 1,604.53 = USD 1,599.53 premium + USD 5 fee
Installment 3USD 1,604.53 = USD 1,599.53 premium + USD 5 fee
Installment 4USD 1,604.55 = USD 1,599.55 premium + USD 5 fee
| Period | Premium | Fee | Cash payment | Cumulative premium | Cumulative cash | Premium remaining |
|---|---|---|---|---|---|---|
| Deposit | 2,132.71 | 0 | 2,132.71 | 2,132.71 | 2,132.71 | 6,398.14 |
| Installment 1 | 1,599.53 | 5 | 1,604.53 | 3,732.24 | 3,737.24 | 4,798.61 |
| Installment 2 | 1,599.53 | 5 | 1,604.53 | 5,331.77 | 5,341.77 | 3,199.08 |
| Installment 3 | 1,599.53 | 5 | 1,604.53 | 6,931.3 | 6,946.3 | 1,599.55 |
| Installment 4 | 1,599.55 | 5 | 1,604.55 | 8,530.85 | 8,550.85 | 0 |
Keep the assumptions with the comparison
- Payroll-rated planning only: each class uses entered payroll times its final manual rate per 100 currency units. Hourly-rated systems are unsupported.
- Estimated and audit payroll use the same rates and factors. Entered figures are illustrative assumptions, not carrier rates or class-code advice.
- Declared sequence: sum class premiums, apply experience factor, apply schedule factor, impose minimum premium, assess the resulting amount, then add fixed fees. Carrier and jurisdiction rules may differ.
- The assessment excludes fixed fees. This tool accepts an experience factor; it does not calculate one from claims or determine eligibility.
- Billable premiums and the deposit round to the nearest cent, half up. Raw amounts and signed rounding adjustments remain exact fractions.
- The deposit is a percentage of the estimated billable premium. The remaining premium is split into the selected number of installments; the final installment reconciles cents.
- Each scheduled installment incurs the entered fee, even if a very small balance produces a zero-principal early installment. A fully paid deposit creates no installments or installment fees.
- Periods are sequence numbers, not calendar dates. Audit cash cost retains the same planned installment fees, without refund or recomputation.
- Premium paid excludes installment fees and is independent of the planned schedule. A negative audit balance is a planning credit, not an entitlement to a refund or a carrier invoice.
- CSV preserves exact fractions, includes inputs and results, and prefixes formula-like text with an apostrophe. Currency is a display label; no exchange conversion occurs.
How to use this calculator
- Load Rising payroll example or Falling payroll example, then open Edit payroll and policy assumptions. Set a currency and policy label.
- Enter each class’s estimated and audited payroll for the same policy period, plus its final manual rate per 100 payroll units. Add, copy or remove classes as needed.
- Enter experience and schedule factors, minimum premium, assessment percentage and fixed fees. Check the declared sequence against the policy you are comparing.
- Enter deposit percentage, remaining installment count, fee per installment and premium already paid excluding installment fees. Select Apply premium plan.
- Review the premium comparison, rating adjustments, class contributions and payment schedule. Download premium CSV or show its selectable copy to retain exact inputs and results.
The Formula
The mathematical logic powering this calculation is:
For each payroll class, manual premium = payroll / 100 × entered final manual rate. Use estimated payroll and audited payroll for the same policy period, with the same class rates and factors. Do not apply a loss-cost multiplier again when the rate is already final. This model supports payroll-rated inputs only, not hourly-rated systems.
Declared order for each scenario: sum manual class premiums; multiply by experience factor; multiply by schedule factor; take the larger of that adjusted amount and minimum premium; assess that amount at the entered assessment percentage; add fixed policy fees. Assessment excludes fixed fees. This sequence is an explicit comparison assumption, not a statement that every carrier or jurisdiction uses it. The experience factor is supplied by the user; it is not calculated from claims.
Billable premium rounds to the nearest cent, half up. All preceding calculations are exact rational values. Report raw premium, signed rounding adjustment and final billable premium separately. Effective premium per 100 payroll units = billable premium / total payroll × 100, unavailable for zero payroll. Class contributions after factors do not allocate minimum uplift, assessment or fixed fees.
Premium change = audited billable premium − estimated billable premium. Audit balance = audited billable premium − premium already paid. Premium paid excludes installment fees and is independent of the planned schedule. A negative balance is a planning credit, not a carrier invoice or entitlement to a refund.
Deposit = estimated billable premium × deposit percentage, rounded to the nearest cent, half up. Divide remaining cents across the entered installment count: floor the regular installment to whole cents, then reconcile all remaining cents in the final installment. Each scheduled installment incurs its entered fee, even if a tiny balance creates zero-principal early installments. If the deposit pays the entire premium, there are no installments or installment fees. Periods are sequence numbers, not calendar dates.
Estimated cash cost = estimated billable premium + planned installment fees. Audited cash cost = audited billable premium + the same planned installment fees; fees are not recomputed or refunded. A fee is not part of the premium-only balance. The deposit and installment schedule do not assert actual payments have occurred.
Limits: 1–60 payroll classes, with unique letter-led IDs and 1–100 character labels. Payroll, minimum premium, fixed fees, installment fee and premium paid are 0–1,000,000,000 currency units with at most two decimal places. Final manual rates are 0–1,000 per 100 payroll units with at most six decimals. Experience and schedule factors are greater than zero through 10 with at most six decimals. Assessment and deposit are 0–100% with at most six decimals. Installments are whole digits from 1 to 24. Inputs are unsigned plain decimal strings; blanks, exponents, commas, signs and excess precision are invalid. Currency labels have 1–12 characters and do not convert currencies.
Display rounds half away from zero, retaining a tiny nonzero fraction when ordinary rounding would hide it. CSV retains exact fractions, all inputs, rating stages and payments. Formula-like labels are prefixed with an apostrophe. No live rates, class assignments, coverage advice, eligibility decisions, claims-based experience rating or carrier-specific endorsements are supplied.
Sources reviewed November 13, 2026: the Texas Department of Insurance explains payroll-based classification rates and rating adjustments; NCCI explains experience rating. These sources support those concepts, not this tool’s universal applicability. Washington L&I publishes hourly rates, illustrating why hourly-rated policies are outside this planner. No proposed future rates are used.Worked Example
If you input:
- Payroll classes: Office: estimated 100,000, audited 110,000 at 0.25 per 100. Field: estimated 200,000, audited 250,000 at 4 per 100. All amounts USD.
- Rating assumptions: Experience factor 0.9; schedule factor 1.1; minimum premium USD 1,000; assessment 2%; fixed fees USD 200.
- Payment assumptions: 25% deposit, four remaining installments, USD 5 fee each; USD 6,000 premium already paid, excluding installment fees.
Result:
Estimated manual premium is 250 + 8,000 = USD 8,250. Multiplying by 0.9 and 1.1 gives USD 8,167.50, above the minimum. Add 2% (USD 163.35) and USD 200 for USD 8,530.85. Audited manual premium is 275 + 10,000 = USD 10,275. After factors it is USD 10,172.25; assessment and fees give USD 10,575.695, rounded half up to USD 10,575.70. Premium increases USD 2,044.85, and USD 6,000 already paid leaves USD 4,575.70 due under this plan. The deposit rounds to USD 2,132.71. Remaining premium is USD 6,398.14: three installments of USD 1,599.53 and one of USD 1,599.55. Four USD 5 fees add USD 20, making estimated cash cost USD 8,550.85. Audited cash cost, retaining the same fees, is USD 10,595.70.
Frequently Asked Questions
Does this calculate an insurance quote?
No. It compares user-entered payroll, final manual rates and assumptions. It does not select class codes, obtain carrier rates or establish coverage.
Can I use it for hourly-rated policies?
No. The calculation uses rates per 100 payroll currency units. Some systems, including Washington’s published hourly rating structure, require different inputs and rules.
Does it calculate my experience modifier?
No. Enter the experience factor supplied for the policy. The tool does not use claims histories or determine eligibility for experience rating.
Why can payroll change without changing the premium?
The minimum premium can bind both scenarios. Cent rounding can also flatten very small changes. The breakdown shows minimum uplift and rounding separately.
Why is my audit balance different from the premium change?
Premium change compares audited with estimated premium. Audit balance compares audited premium with premium already paid, excluding installment fees.
What does a negative audit balance mean?
It is a planning credit under the entered assumptions. It is not a promise of a refund or a carrier statement; actual audit adjustments and policy terms may differ.
How are installment amounts reconciled?
The deposit is rounded to cents. Regular remaining payments are floored to cents and the last payment takes the remainder. Every scheduled installment has the entered fee, even if its premium portion is zero. A full deposit produces no installment fees.
Are assessment and minimum-premium rules universal?
No. This declared sequence applies the minimum after factors, then assessment, then fixed fees. Verify the applicable policy rules before interpreting the comparison.
Similar Calculators
Salary Calculator
Convert hourly wage to annual salary, or break down annual salary into hourly, weekly, and monthly amounts.
US Paycheck Tax Estimator
Estimate take-home pay after federal income tax, FICA, simple state/local rates, and deductions.
Sales Commission & Draw Calculator
Compare sales commission plans with marginal or retroactive tiers, quota bonuses, caps and draw balances. Visualize payouts across periods and export complete exact ledgers.
