Commercial Insurance · monthly

Commission reconciliation against the carrier statement

Drop in a policy/commission export; get back commission per policy, rolled up by producer, with agency totals and the blended rate.

Drop in

policies with commission data (JSON or CSV)

Required columns
policy_noinsured_namecarrierproducerpremium_usdcommission_rate_pct

Optional: min_premium_usd (0 = all), statement_period_label

Get back

  • commission_lines register
  • by_producer summary
  • total_commission_usd
  • avg_commission_rate_pct

Commission reconciled — computed from your data

Sample outputs
total_commission_usd
by_producer
avg_commission_rate_pct

These fields appear in the XLSX/PDF artifact after a run on your own data.

How it runs

What every run guarantees

Deterministic

Byte-identical replay, 100% across 10,200+ controlled runs.

Fast

Compiled logic runs in seconds. Batches process at 25,000+ rows/sec.

Confirmed

A named human confirms the compiled logic once — the model is out of the loop on every run.

Auditable

Every artifact is SHA-256 content-addressed and hash-linked.

Usage-based

You pay per run, not per seat.

Output: XLSX / PDFTTV: 1 actionDeliverable (tier B)Inputs: 6

Run it on your file

10 free runs. No credit card. No setup. Drop in your export and get the register back in seconds.

Already have an account? Sign in →