Key — How to Read This Dashboard
Plain-English guide to every card
This page explains every card on the dashboard in everyday language — what each number means and how to use it to run the business. Everything updates based on the View Period you choose in the top-right corner; change it and every tab re-filters to that date range. Tap any section below to expand it.
Start Here — Core Concepts
View Period (top-right dropdown)
The date filter for the whole dashboard. Every metric reflects only business written/effective inside this window. Options: YTD, MTD, WTD, Daily, Rolling 13 Months, Previous Year, and each quarter (Q1–Q4).
How to use it: switch periods to compare the same metric over time (e.g., this year vs. last year). Pick “Rolling 13 Months” when you need persistency, since those metrics require more than a year of history.
Annualized Premium (AP)
The yearly premium a policy generates. If a client pays monthly, AP = monthly amount × 12. It puts every policy on a level playing field regardless of how often the client pays.
How to use it: this is your headline “how much business did we write” number for Life and Annuities.
Medicare = enrollments, not dollars
Medicare carriers pay a flat amount per enrollment, so Medicare is counted in heads (enrollments), never premium dollars. That’s why Medicare shows “1,861 enroll.” instead of a dollar figure.
How to use it: judge Medicare by enrollment volume and placement, not by AP.
Active / In-Force vs. Lapsed
“Active” or “In-Force” means the policy is alive and paying. “Lapsed / Terminated / Surrendered” means it’s no longer active.
How to use it: in-force counts show your living book; lapse-based metrics measure attrition.
The yellow “records outside period” banner
Tells you how many records the current View Period is hiding (e.g., older business excluded). It’s a heads-up, not an error.
How to use it: if a number looks unexpectedly low, widen the View Period.
Overview Tab
Total AP Written
Sum of annualized premium for all Life and Annuity business in the period.
How to use it: the single best gauge of how much new production the agency wrote.
Medicare Enrollments
Count of Medicare enrollments in the period.
How to use it: Medicare’s version of “production volume.”
Policies In Force
Number of currently-active policies across all lines.
How to use it: the size of your living book of business.
Avg AP / Policy
Average premium per Life/Annuity policy (Total AP ÷ those policies; Medicare is excluded since it has no premium).
How to use it: a “deal size” gauge — rising means bigger cases, falling means smaller ones.
Agent Retention
Percent of agents still actively producing over a rolling window.
How to use it: how sticky your sales force is; low retention means producers are leaking out the bottom.
Monthly AP Trend by Line
Premium written each month, stacked by product line (Life / Medicare / Annuities).
How to use it: spot momentum, seasonality, and which line is driving growth. (Medicare’s slice here is a rough dollar estimate, shown only so it’s visible on the chart.)
AP Mix
The premium split between Life and Annuities; Medicare appears as an enrollment count because it carries no premium.
How to use it: see how concentrated your production is in one product.
Sales by Line
A table of premium (or enrollments for Medicare), policy count, average size, and share for each product line.
How to use it: compare your product lines side by side.
Goal Attainment
Progress toward annual targets (targets get set in a future update).
How to use it: track pace against goal once goals are configured.
Leaderboard Tab
Life / Medicare toggle
Switches the whole tab between your Life book and your Medicare book. Life is measured in premium; Medicare in enrollments. The two are kept separate so each is judged on its own terms.
How to use it: review each product’s agents independently.
Active Agents
Agents who wrote business in the period for the selected product.
How to use it: how many producers are actually active right now.
Avg AP / Agent (Life) · Avg Enrollments / Agent (Medicare)
Average production per agent.
How to use it: per-head productivity; compare across periods or products.
Avg Policies / Agent (Life) · Avg Placed / Agent (Medicare)
Average policy count (or placed-enrollment count) per agent.
How to use it: are agents writing many small cases or a few large ones?
New Agents Recruited
Newly added agents (placeholder until recruiting data is wired in).
Monthly Agent Production Trend
How many agents were actively producing each month.
How to use it: is your active producer base growing or shrinking?
Agent Tier Distribution
Agents bucketed into Platinum / Gold / Silver / Bronze by production. Life tiers: Platinum ≥ $100k, Gold ≥ $50k, Silver ≥ $20k, Bronze under $20k AP. Medicare tiers: Platinum ≥ 100, Gold ≥ 50, Silver ≥ 20, Bronze under 20 enrollments.
How to use it: see the shape of your force — a few stars vs. many small producers.
Top Agent Leaderboard
Ranked list of top producers with tier, primary line, state, production, policies, and persistency. Search any agent by name.
How to use it: recognize top performers and spot who needs coaching.
Agent Search Tab (CEO only)
Single-agent scorecard
Type one agent’s name to see all the Leaderboard-style metrics for just that person, including their persistency cohorts.
How to use it: prep for a one-on-one or evaluate a single producer in depth.
Persistency Tab
12-Month Persistency
Of policies issued more than 12 months ago, the percent still active today. The industry-standard measure of whether business sticks — higher is healthier.
How to use it: the #1 quality-of-business metric. Needs more than a year of data, so view it under “Rolling 13 Months.”
13–24 Mo Persistency
The same idea for the second policy year; catches later lapses after first-year commissions are earned.
How to use it: see whether business holds up beyond year one.
Snapshot Active Rate
Of all policies in view, the percent active right now, with no time bound.
How to use it: a quick overall health check.
Lapse Rate
Percent of policies that lapsed = Lapsed ÷ (Active + Lapsed). The mirror image of persistency.
How to use it: track attrition; rising lapse rate is an early warning.
AP at Risk
Annualized premium tied to policies 61–90 days behind on payment — money about to lapse unless it’s saved.
How to use it: aim retention/save calls at this bucket.
12-Month Persistency Trend by Line
Persistency over time, broken out by product.
How to use it: catch a product or carrier whose quality is slipping.
Lapse Reasons
Breakdown of why policies lapsed (non-payment, terminated, surrendered, etc.).
How to use it: diagnose the root cause of attrition.
Geographic Tab
States with Policies
Number of states where you have business.
How to use it: the breadth of your footprint.
Top State
Your highest-premium state.
How to use it: know your stronghold.
Fastest Growing
The state growing fastest period-over-period.
How to use it: spot emerging markets to invest in.
US Map & Regions
Premium and policies shaded by state, plus a rollup by region.
How to use it: see where your business is geographically concentrated at a glance.
Carrier Tab
Active Carriers
How many insurance carriers you’re placing business with.
How to use it: the breadth of your carrier relationships.
Top Carrier Share
The percent of production with your single largest carrier.
How to use it: a concentration-risk indicator — too high means you’re exposed if that carrier changes terms.
AP by Carrier
Production ranked by carrier.
How to use it: see who your biggest partners are.
Concentration Risk
How production is spread across all carriers.
How to use it: a balanced spread lowers business risk; one dominant carrier raises it.
Financials Tab (CEO only)
Commission Revenue
Gross commissions and overrides the agency earned, from uploaded commission files.
How to use it: your top-line revenue.
Chargebacks
Commission reversals that happen when policies lapse early.
How to use it: the direct cost of poor persistency.
Net Revenue
Commissions minus chargebacks.
How to use it: what you actually keep.
Revenue vs. Expenses & Net Income
Profit-and-loss built from uploaded financial files.
How to use it: your bottom-line profitability.
Agency View Tab
By Owner / Upline
Production, agent counts, and product mix rolled up by agency owner / upline.
How to use it: see which downlines or agencies are driving results.
By Market Tabs (Life / Medicare / Annuities)
Life Insurance
Your Life book only: AP written, policies, and persistency for Life products.
Medicare
Placement = the percent of enrollments that went effective. Persistency = the percent of placed enrollments still active. Rapid Disenroll = cancelled within 90 days (only where the carrier provides a termination date). The breakdown chart shows every enrollment outcome (active, disenrolled, not placed, etc.).
How to use it: judge Medicare on placement and retention, not dollars.
Annuities
Annuity production and in-force business.
Hierarchy
Loading…
Company Overview
All lines · YTD 2026
Total AP Written
Annualized Premium · YTD 2026
Medicare Enrollments
—
YTD 2026 enrollments
Policies In Force
—
All lines, active
Avg AP / Policy
AP ÷ policies (excl Medicare)
Agent Retention
—
Rolling period
Monthly AP Trend by LineLast 12 months
AP Mix
Sales by Line
| Line | AP / Vol | Policies | Avg AP / Policy | % of Total |
|---|
2026 Goal Attainment
Agent Performance
Life · YTD 2026
Active Agents
—
Active in current period
Per agent · YTD 2026
Avg Policies / Agent
—
Per agent · YTD 2026
New Agents Recruited
—
YTD 2026
Monthly Agent Production Trend
Agent Tier Distribution
Top Agent Leaderboard
| # | Agent | Agency Owner | Tier | Primary Line | State | YTD Premium | Policies | Persistency |
|---|
Persistency & Retention
Rolling period view
12-Month Persistency
—
Issued > 12 mo ago, still active
13–24 Mo Persistency
—
Issued 13–24 mo ago, still active
Snapshot Active Rate
—
All policies, no time bound
Lapse Rate
—
Lapsed / (Active + Lapsed)
AP at Risk
—
Policies 61–90 days late
12-Month Persistency Trend by Line
Lapse Reasons
Persistency by Policy Year (Heat Matrix)
Cell color: green ≥90%, amber 80–90%, red <80%. Click cell to drill in.
Agent Search
Single-agent view · YTD 2026
🔎
Pick an agent above to view their Overview & Persistency.Geographic Distribution
Life by state · YTD 2026
Active States
—
States with ≥ 1 policy YTD
Top State
—
Highest premium state
Fastest Growing
—
Period-over-period
States Below Goal
—
Under threshold
US AP Heat Map
Less
More
Top 10 States by AP
| # | State | AP | Policies | vs Goal |
|---|
AP by Region
Reporting
Company-wide · YTD 2026
Carrier Performance
All lines · YTD 2026
Top Carrier AP
—
—
Top Carrier Share
—
—
Top Medicare Carrier Share
—
—
Top Medicare Carrier App count
—
—
AP by Carrier (Top 12)
Concentration Risk
Carrier & Product Performance
| Carrier | Line | Products | YTD AP | Policies | Persistency | Chargebacks | Trend |
|---|
💰 IMO Commission Revenue CEO ONLY
YTD · auto-calculated from uploaded commission files
Commissions Received
—
Gross commission revenue
Chargebacks
—
Reversals & clawbacks
Net Commission
—
Commissions − Chargebacks
Carriers Paying
—
Active commission sources
Monthly Commission Revenue
Commission by Carrier
Carrier Commission Detail
| Carrier | Line | Commissions | Chargebacks | Net | % of Net |
|---|
📒 P&L (Manual Upload)
No P&L uploaded yet
Total Revenue
—
YTD 2026
Total Expenses
—
YTD 2026
Net Income
—
YTD 2026
Net Profit Margin
—
Profitability
Revenue vs Expenses (Monthly)
Net Income (Monthly)
P&L Detail
Agency View
By upline · YTD 2026
Agency Owners
—
Synced from AMS
Agents Affiliated
—
Total assigned agents
Avg AP / Owner
Per agency owner
Avg Goal Attainment
—
Average across owners
Agency Owners
| Owner | Tier | Agency | Agents | YTD Premium | Policies | Persistency | Momentum | Share | Trend | Goal % |
|---|
🕵 Phantom Names
Show an alternate agency/owner name everywhere. The real name stays static in the background for data routing.
| Real name (static) | Phantom display | Updated |
|---|
Book of Business — Data Uploads
Multi-carrier upload engine
🔐 User Roles & Access
Admin = full access incl. this Data tab · CEO = everything except Data · Owner/Agent = scoped to their downline/own book. To add a brand-new login, create the user in Supabase (Authentication → Add user) first, then set their role here.
| Name | Role | |
|---|---|---|
| Loading… | ||
📤 Sale Submissions
New policies / applications written. Expected fields: Agent Name, Policy ID, Premium (or Enrollment), Status, Policy Date, optional State.
Drop a submissions file here
Accepts .csv, .xlsx, .xls, .txt, .tsv · one carrier at a time
💰 CommissionsCEO ONLY
IMO commission revenue from carriers (not agent payouts). Expected fields: Writing Number, Policy ID, Commission Amount, Chargeback Amount, Pay Date. Agency Owners and Agents cannot see this data.
Drop a commissions file here
Accepts .csv, .xlsx, .xls, .txt, .tsv · one carrier at a time
Uploaded Files
Total records: 0
Carrier → Insurance Line Detection
Carrier names are matched against this list to infer the insurance line. The wizard always lets you override.
LIFE
Mutual of Omaha, Protective Life, AIG, Pacific Life, North American, Banner, Principal, John Hancock, Lincoln, Prudential, Securian, Foresters, American Home Life
MEDICARE
Aetna, Humana, UnitedHealthcare, Cigna, Wellcare, Anthem, BCBS, Blue Cross, Devoted, Oscar, Centene, Molina
ANNUITIES
Transamerica, Athene, American Equity, Allianz, Midland National, Global Atlantic, Jackson, Symetra
🏛️ Manage Agency Owners
Add the agency owners (uplines) you want to track. Agents in the table below pull from this list.
👥 Agent → Agency Owner Assignment
0 agents
Assign each agent to their upline once. The mapping is saved in your browser and applied across all uploads.
| Agent | Premium | Policies | Assign To |
|---|
Life Insurance
YTD 2026
YTD AP
Life line
New Policies
—
Written YTD
Persistency
—
Rolling 12 months
Goal Attainment
—
vs annual target
Monthly AP Trend
Product Mix
Top Carriers — Life
| # | Carrier | Premium | Policies | Share |
|---|
Top Agents — Life
| # | Agent | Premium | Policies |
|---|
Medicare
YTD 2026
Submitted Apps
All enrollment applications
Placement
—
Went effective
Persistency
—
Active ÷ placed
Rapid Disenroll
—
<90 days, of placed
Monthly Enrollment Trend
Placement & Persistencyby enrollment outcome
Top Carriers — Medicare
| # | Carrier | Enrollments | Share |
|---|
Top Agents — Medicare
| # | Agent | Enrollments |
|---|
Annuities
YTD 2026
YTD Premium
Annuities line
Contracts Written
—
YTD
Persistency
—
Rolling 12 months
Goal Attainment
—
vs annual target
Monthly Premium Trend
Product Mix
Top Carriers — Annuities
| # | Carrier | Premium | Contracts | Share |
|---|
Top Agents — Annuities
| # | Agent | Premium | Contracts |
|---|