How to Track Aetna Commissions Automatically.
Feed source: Aetna Producer World CSV export. Ingestion cadence: Monthly. Zero spreadsheets, zero manual reconciliation.
This guide uses unLocked CRM's Commission Auto Sync, with 332 carrier commission integrations.
The 7-Step Setup.
- 01
Step 1 — Connect Aetna to Commission Auto Sync
Log into unLocked CRM → Commission Auto Sync → Add Carrier → select Aetna. Enter your writing agent number (NPN/broker ID) and portal credentials or upload API key.
- 02
Step 2 — Import historical Aetna statements
Upload the last 12–24 months of Aetna statements as CSV or PDF (Aetna Producer World CSV export). Commission Auto Sync parses every line item — policy, product, commission rate, chargeback, and split.
- 03
Step 3 — Map Aetna products to your book
Commission Auto Sync auto-matches Aetna policies to your unLocked client records by NPN + policy number. Unmatched records surface for one-click manual mapping.
- 04
Step 4 — Turn on automated ingestion
Every monthly Aetna statement now ingests automatically. New commissions post within hours of release without any manual work.
- 05
Step 5 — Set up variance and chargeback alerts
Configure alerts for missed payments, split discrepancies, and chargeback events. Alerts fire to email + SMS the moment Aetna deviates from expected commission.
- 06
Step 6 — Reconcile downline overrides (agencies only)
If you have a downline, configure hierarchy rules once. Commission Auto Sync splits Aetna statements into producer, override, and agency shares automatically.
- 07
Step 7 — Run monthly Aetna P&L
Use Commission Auto Sync dashboards to see Aetna revenue by producer, product, and month. Export a board-ready P&L in one click.
Common Aetna Commission Headaches (All Solved)
MA vs PDP separated on different statements
CVS/Aetna dual-branded plans occasionally mis-attributed