What's Included
Enterprise plans include PDF Vision AI. See documentation for setup details.
Commission Wizard identifies each column — policy number, premium, commission, agent and more — from your past uploads, AI analysis of the data and content checks. Every detection shows a confidence score. Correct one and the system remembers it; after about 10 carriers, 90% of columns are recognized on their own.
Every carrier sends a different layout. Commission Wizard reads CSV, Excel (.xlsx, .xls) and PDF — pick the PDF pages from thumbnails — and works with any AMS that exports to CSV or Excel: Matrix, Applied Epic, AMS360, HawkSoft, EZLynx and others. No per-carrier setup.
Prefix matching finds '12345' in '12345-TX001'. Fuzzy matching pairs 'John Smith' with 'Jon Smith'. Numeric tolerance absorbs rounding, and dates match across formats. The system suggests which columns to compare.
Reconciling by hand — VLOOKUP, side-by-side spreadsheets, line-by-line checks — takes 40 to 80 hours a month. Here you upload both files, confirm the columns and download the report. Processing runs in the background, so you can close the page.
Each reconciliation produces an Excel workbook: an executive summary, a sheet per agent, matches with discrepancies highlighted, and the policies found only in your AMS or only in the carrier file — named after them, like 'Only in Progressive'.
Every agency's agents, jobs, files and payments are kept separate, and so are its learned column patterns. Four user roles control who sees what, passkeys allow passwordless sign-in, and formulas hidden in carrier files are neutralized.
Our AI learns column patterns by name, not by carrier. When it learns that 'Policy Number' means a policy ID in one file, it automatically applies that knowledge to every file using the same column name — after ~10 carriers, 90% of columns are recognized instantly.
Upload files in any format — CSV, Excel, or PDF. The system automatically detects headers, cleans data, and extracts what you need. Enterprise plans include PDF Vision AI for scanned documents and complex multi-page reports.
Track every dollar from carrier statement to agent payment. Configure splits, custom rates, and running costs per agent per carrier — the system handles the math and generates detailed reports automatically.
Side by Side
See how automation transforms your commission processing
| Feature | Manual Process | Commission Wizard |
|---|---|---|
| Monthly Time Investment | 40-80 hours | Minutes per statement |
| Column Detection | Manual mapping | 90%+ auto-detection |
| Learning Curve | Weeks of training | AI learns as you go |
| Scalability | Limited by staff | Unlimited files |
| Error Detection | Prone to oversight | Automatic flagging |
| Agent Commissions | Manual spreadsheets | Automatic per-agent splits |
| Report Generation | Hours of Excel work | One-click export |
| Monthly Cost (Labor) | $1,000-4,000 | From $23/month |
How We Compare
See how automated reconciliation compares to spreadsheets and built-in AMS tools
| Feature | Commission Wizard | Spreadsheets | AMS Built-in |
|---|---|---|---|
| Any carrier format | Yes | Manual setup | Electronic feeds only |
| AI column detection | Yes | No | No |
| Learns over time | Yes | No | No |
| Policy number variations | Prefix, fuzzy, exact | VLOOKUP only | Varies |
| Agent commission tracking | Yes | Manual | Basic |
| Agent payments | Yes | No | Varies |
| Agent self-service | Yes | No | No |
| Audit trail | Yes | No | Varies |
| Setup time | Minutes | Hours/carrier | Implementation project |
| Starting price | $29/month | Free | Quote-based, per user |
End to End
From file upload to agent payment — every step in one system.
Save your AMS export once with its column mappings. Each month you only upload the new carrier statement.
After each reconciliation, agents and their commissions are saved by carrier and period. Every profile shows YTD totals, a 12-month trend and policy-level detail.
Record payments by check, ACH, wire or cash and see each agent's balance. Voided payments stay in the audit trail.
Premium, commission received, agent payouts and agency revenue, with 12-month trends and a breakdown by carrier.
Agents get their own login to see their commissions, policy detail and payments — and nothing else.
Policies the carrier paid that are missing from your AMS can be assigned to any agent. Rates, running costs and splits apply automatically, with an audit trail.
Calculation Modes
Every agency structures commissions differently. Commission Wizard adapts to yours.
By default, the system uses the commission amount directly from the carrier statement and applies the agent's split percentage. Formula: Agent Commission = Carrier Commission × Split %.
Enable this during the Commission Columns step when agents have individually negotiated rates. Instead of using the carrier's commission, the system calculates commission from the premium. Set a rate per agent per carrier — for example, 10% or 15%. Formula: Calculated Commission = Premium × Rate %. Then the split applies to the calculated amount. Rates are saved per agent per carrier and loaded automatically in future reconciliations.
Enable this to deduct an agency fee before the agent split. The running cost covers your operational expenses for managing clients — policy servicing, claims handling, administrative overhead. Set a percentage per agent per carrier. Formula: Running Cost = Commission × Running Cost %. Net Commission = Commission - Running Cost. Then the split applies to the net amount.
Policy premium: $1,000. Custom commission rate: 10% → $100 commission. Running cost: 10% of commission → $10 to agency operations. Net commission: $90. Split: 50/50 → $45 to agent, $45 to agency. Total agency revenue: $45 (split) + $10 (running cost) = $55. Every number is tracked per policy, per agent, per carrier, per period — and appears in the Excel report.
Transparency & Audit
Every reconciliation is saved with full detail — files used, column mappings applied, comparison settings, record counts, and match rates. The Jobs page lists all past jobs with date, status, AMS and carrier names. Click any job to review detailed records by category (matches, AMS only, carrier only, discrepancies), search and filter within each tab, or re-download the Excel report. Use this for resolving agent disputes, verifying commission accuracy, or responding to financial audits.
From any agent's detail page, export a commission report filtered by period. The Excel report includes a carrier-by-carrier summary (premium, commission, rate, running cost, net commission, split, agent payout) and a policy-by-policy detail table. The PDF report contains the same data in a printable format. Use these as official commission statements for agent distribution or payment documentation.
Access & Permissions
Four roles to match how your agency works.
Process files, manage agents, manage payments, organization settings, billing management. Full control of everything.
Same as Owner except cannot access billing. Can invite users, change roles (processor and viewer only), reset passwords (except owner).
Process commission files, manage agents, manage per-agent payments. Cannot access organization settings or billing.
See only their own commission data and payment history. Cannot process files, see other agents, or manage anything. Linked to a specific agent record.
Got Questions?
CSV, Excel (.xlsx, .xls), and PDF. For PDFs, you select which pages contain the commission data using thumbnail previews. Enterprise plans include PDF Vision AI for scanned documents.
Yes. Commission Wizard works with any system that exports to CSV or Excel — Matrix, Applied Epic, AMS360, HawkSoft, EZLynx, and others. No integration or API setup needed.
The system supports exact, fuzzy, prefix, numeric, and date matching. If your AMS has '12345' and the carrier has '12345-397657', prefix matching identifies them as the same policy. Fuzzy matching handles name variations like 'John Smith' vs 'Jon Smith'.
An operational fee the agency deducts from each commission before the agent split. It covers policy servicing, claims support, and admin overhead. You set it as a percentage per agent per carrier.
Yes. Create a Viewer account linked to any agent. They see their personal dashboard with KPI cards, commission chart, history table, payment summary, and can export reports — all without accessing other agents' data.
Yes. Every job is saved with full detail. View matched records, discrepancies, and missing policies anytime. Re-download reports or review column mappings that were used.
When you confirm or correct a mapping, the system remembers it — by column name, not by carrier. So if 'Pol #' means policy_number in Progressive, it also means policy_number in State Farm, Swyfft, and any other carrier. After about 10 carriers, 90%+ detection without manual input.
Have more questions? Contact us or read the documentation.
Last updated: October 2026
Reconciling commissions by hand takes 40-80 hours a month. Get them back.
14-day free trial · No credit card required