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.

Workers’ compensation studio

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.

Illustrative payroll-rated policy

What changed at audit?

Estimated premium
USD 8,530.85
Before installment fees
Audited premium
USD 10,575.7
Same rates and factors; audited payroll
Premium change
USD 2,044.85
Audited minus estimated premium
Additional premium due
USD 4,575.7
After USD 6,000 in premium-only payments

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.

Estimated premium (USD)
010,575.7

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

Audited premium (USD)
010,575.7

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 payroll and premium in USD
ClassEstimated payrollAudited payrollManual rate per 100Estimated baseAudited baseChange after factors
Office payroll100,000110,0000.2525027524.75
Field payroll200,000250,00048,00010,0001,980

Plan the premium cash flow

Planned deposit
USD 2,132.71
Installment fees
USD 20
Separate from premium-only payments
Estimated cash cost
USD 8,550.85
Audited cash cost: USD 10,595.7

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

Estimated premium payment schedule in USD
PeriodPremiumFeeCash paymentCumulative premiumCumulative cashPremium remaining
Deposit2,132.7102,132.712,132.712,132.716,398.14
Installment 11,599.5351,604.533,732.243,737.244,798.61
Installment 21,599.5351,604.535,331.775,341.773,199.08
Installment 31,599.5351,604.536,931.36,946.31,599.55
Installment 41,599.5551,604.558,530.858,550.850

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

  1. Load Rising payroll example or Falling payroll example, then open Edit payroll and policy assumptions. Set a currency and policy label.
  2. 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.
  3. Enter experience and schedule factors, minimum premium, assessment percentage and fixed fees. Check the declared sequence against the policy you are comparing.
  4. Enter deposit percentage, remaining installment count, fee per installment and premium already paid excluding installment fees. Select Apply premium plan.
  5. 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