πŸ“Š
CEO DASHBOARD
Insurance Marketing Organization — Executive View
Last Updated
Awaiting first upload

Company Overview

All lines · YTD 2026
πŸ’΅
Total AP Written
Annualized Premium · YTD
πŸ“‹
Medicare Enrollments
YTD 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
YTD AP Mix
Sales by Line (YTD)
LineAP / VolPoliciesAvg AP / Policy% of Total
2026 Goal Attainment

Agent Performance

All lines · YTD 2026
πŸ‘₯
Active Agents
Active in current period
πŸ’°
Avg AP / Agent
YTD per agent
πŸ“‘
Avg Policies / Agent
YTD per agent
πŸ†•
New Agents Recruited
YTD
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.

Geographic Distribution

Premium & policies 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
#StateAPPoliciesvs Goal
AP by Region

Carrier Performance

All lines · YTD 2026
🏒
Active Carriers
In current period
πŸ‘‘
Top Carrier Share
πŸš€
Fastest Growing
Period-over-period
🧩
Active Products
Across all carriers
AP by Carrier (Top 12)
Concentration Risk
ℹ️
Top 3 carriers represent of premium. Consider diversification if > 60%.
Carrier & Product Performance
CarrierLineProducts YTD APPolicies PersistencyChargebacksTrend

πŸ’° 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
CarrierLine Commissions Chargebacks Net % of Net

πŸ“’ P&L (Manual Upload)

No P&L uploaded yet
ℹ️
Upload your monthly P&L (Excel or CSV) below to populate this section. The dashboard will auto-categorize rows as revenue, expense, or net income — you can correct any misclassification. No bank connection.
πŸ’΅
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
Configured in Data tab
πŸ‘₯
Agents Affiliated
Total assigned agents
πŸ’°
Avg AP / Owner
Per agency owner
🎯
Avg Goal Attainment
Average across owners
Agency Owners
OwnerAgency AgentsYTD Premium PoliciesPersistency Goal %

Book of Business — Data Uploads

Multi-carrier upload engine
πŸ”’
Data stays in your browser. Carrier files are parsed locally and never sent to any server. Your uploads persist across refreshes — use Clear All Data to wipe.
πŸ“€ 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

🍎
Mac users: .numbers files can’t be read by browsers. In Numbers, go to File β†’ Export To β†’ Excel first.
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.
AgentPremiumPoliciesAssign 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
#CarrierPremiumPoliciesShare
Top Agents — Life
#AgentPremiumPolicies

Medicare

YTD 2026
πŸ“‹
YTD Enrollments
Medicare uses enrollments
πŸ†•
New Enrollments
First-time enrollees
βœ…
Persistency
Rolling 12 months
🎯
Goal Attainment
vs annual target
Monthly Enrollment Trend
Product Mix
Top Carriers — Medicare
#CarrierEnrollmentsShare
Top Agents — Medicare
#AgentEnrollments

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
#CarrierPremiumContractsShare
Top Agents — Annuities
#AgentPremiumContracts