A 5-tab financial dashboard with 15 customizable widgets. Pipeline Gap Analysis shows your revenue shortfall and pipeline coverage. Carrier minimum written premium commitments tracked in real time. QuickBooks reconciliation snapshot across 5 balance categories.
Monthly Revenue
$284K
+8.2%
Outstanding Receivables
$62K
-$11K
Cash Flow (30d)
$147K
+$23K
YTD Commission
$1.92M
+12.4%
What it is
A 5-tab financial command center — Overview, Goals, Scorecard, KPI Tracker, Forecasts — with 15 customizable dashboard widgets. Built on live policy, commission, and pipeline data so every number updates automatically as your book changes.
The financial dashboard organizes everything across five tabs: Overview (your real-time financial snapshot), Goals (per-producer targets and progress), Scorecard, KPI Tracker, and Forecasts. Within those tabs, 15 widgets are configurable: Renewal Pipeline Chart, Commission Trend Chart, Producer Leaderboard, Pipeline Funnel, Goals Progress, Top Carriers, Forecast Snapshot, Tasks by Producer, and more. Add, remove, and arrange them to match how your agency reviews its numbers.
The QB reconciliation summary compares AMS balances against QuickBooks across five categories: Agency Commission YTD, Client A/R, Carrier Payables, Producer Payables, and Agency Cash Position. Each returns a status of MATCHED (≤$1 difference), VARIANCE, or NO_QB_DATA — so you know at a glance whether your AMS and your general ledger agree without running a manual comparison.
Core capabilities
Range selector: 30d / 60d / 90d / 6mo / 12mo. Pipeline Gap Analysis shows shortfall, monthly pace needed, and pipeline coverage.
The Forecasts tab shows 12-month rolling charts for Written Premium and Commission Revenue separately. The Pipeline Gap Analysis card calculates your revenue shortfall against target, the monthly new-business pace required to close it, the pipeline value needed, and whether your current weighted pipeline covers the gap. The Premium→Revenue Relationship card shows projected premium × average commission rate = projected revenue. Forecast formula settings are configurable by admins via a sidebar that applies changes instantly.
Agency Bill, Direct Bill, and Premium Financed billing types tracked separately — A/R splits correctly when a finance company funds the premium.
Each policy is classified as Agency Bill (client owes full premium), Direct Bill (client owes fees only, carrier collects premium), or Premium Financed (client owes down payment + fees; finance company funds the rest). Premium Financed policies split the client A/R into two separate invoices — preventing the full gross premium from appearing as client-owed when the finance company covers it. A dedicated mobile screen tracks payment statuses and flags defaults.
Track carrier volume commitments — bound premium vs. required minimum — with Met / On Track / At Risk / Off Track status.
Many carrier contracts include minimum written-premium requirements tied to contingency and program eligibility. Set the required amount and deadline per carrier. The system tracks actual bound premium against it in real time and shows a progress bar with a status badge: Met, On Track, At Risk, or Off Track — based on year progress vs. actual written premium. No manual updates.
For every Agency Bill policy: gross premium invoiced, commission owed, net payable to carrier — auto-created at bind.
When an Agency Bill policy is bound, Insurstein automatically creates a CarrierPayable record tracking three amounts: gross premium invoiced to the carrier, commission owed to your agency, and net payable (gross − commission) that you owe the carrier. The ledger shows exactly what your agency owes each carrier at any moment and supports partial payments — status moves PARTIALLY_PAID → PAID as remittances are recorded.
Per-producer cards showing On Track / At Risk / Off Track likelihood %, weighted pipeline value, and projected year-end.
The Goals tab displays an agency summary strip (total premium goal, YTD written, projected year-end, YTD commission) followed by per-producer cards. Each card shows rank, status badge with likelihood percentage, monthly pace annualized, weighted pipeline value, and a live progress bar toward the premium target. Commission data is masked for non-admin roles — producers see premium, retention, and new business metrics only.
5-category AMS vs QuickBooks comparison: Agency Commission, Client A/R, Carrier Payables, Producer Payables, Agency Cash — each MATCHED or VARIANCE.
The QB reconciliation summary returns five balance categories with a MATCHED (≤$1 difference), VARIANCE, or NO_QB_DATA status for each: Agency Commission YTD, Client A/R, Carrier Payables, Producer Payables, and Agency Cash Position. Per-category QB errors never crash the dashboard — each resolves independently. Drill into Client A/R or Carrier Payables for per-invoice or per-carrier breakdowns.
What they don't do
Replace manually-modeled revenue gap analysis with Pipeline Gap Analysis — shortfall, monthly pace needed, and pipeline coverage calculated automatically for any 30d–12mo window.
Stop logging into carrier portals to check commitment progress. Carrier minimum written premium commitments update automatically as policies bind and show Met / On Track / At Risk / Off Track.
End overstated receivables. Premium Financed policies automatically split into two invoices — client owes down payment + fees; the finance company covers the rest.
Stop pulling reports from both systems to compare balances. The QB Reconciliation Snapshot checks 5 categories and returns MATCHED or VARIANCE in seconds.
Replace spreadsheet tracking with the Producer Goals Command Center — per-producer likelihood percentage, weighted pipeline value, and projected year-end in real time.
Stop manually tracking what you owe each carrier. The Carrier Payable Ledger auto-creates at bind: gross premium invoiced, commission owed, net payable — with partial payment support.
What it takes off your plate
Calculates revenue shortfall against target, the monthly new-business pace required to close it, and whether your weighted pipeline covers the gap — for any 30d–12mo range.
Splits Premium Financed policy receivables into two invoices — client portion and finance company portion — so your A/R reflects what clients actually owe, not gross premium.
Creates a CarrierPayable record automatically when any Agency Bill policy binds: gross premium invoiced, commission owed, and net payable calculated without manual entry.
Compares bound premium against each carrier's required minimum and updates Met / On Track / At Risk / Off Track badges in real time as policies bind throughout the year.
Compares AMS balances against QuickBooks across 5 categories — Agency Commission YTD, Client A/R, Carrier Payables, Producer Payables, Agency Cash — and flags every VARIANCE.
Hides commission amounts on producer goal cards for non-admin roles automatically — producers see premium, retention, and new business metrics without exposing compensation data.
A day in the life
8:00 AM
Open the Forecasts tab. Pipeline Gap Analysis shows you're $38K short of the Q4 revenue target. Monthly new-business pace needed is $9.5K — your weighted pipeline covers 140% of the gap. No action required.
10:00 AM
Carrier D's homeowners program shows At Risk: 78% of the minimum written at month 9 of 12. You flag it for your commercial team — 4 binds this month would flip it to On Track.
12:30 PM
Before remitting to carriers, open the Carrier Payable Ledger. Carrier A this month: gross $94,200 − commission $12,400 = net payable $81,800. Record a partial payment — status moves to PARTIALLY_PAID.
2:00 PM
The Goals tab shows three producers On Track and one At Risk at 62% likelihood. The at-risk producer's weighted pipeline covers only 80% of the annual target — you schedule a 1:1.
4:30 PM
Run the QB Reconciliation Snapshot before closing. Agency Commission YTD: MATCHED. Client A/R: VARIANCE — drill in to find a $2,400 invoice posted in AMS but not yet synced to QuickBooks.
Daily impact
Pipeline Gap Covered
Carrier Minimums On Track
Carrier Payable (Net)
QB Categories Matched
Pipeline Gap Analysis, carrier minimum written premium tracking, automatic Carrier Payable Ledger, and a 5-category QB reconciliation snapshot — all updating in real time as your book changes.