Documentation

How CommissionIQ Works

CommissionIQ automates commission reconciliation for independent insurance agencies. Upload carrier statements, match against your policy book, and surface underpayments in minutes instead of days.

Step by Step

01

Upload Carrier Statements

Upload your carrier commission statements in PDF or CSV format. CommissionIQ parses each line item — carrier name, policy number, insured name, and commission amount — automatically.

  • Supports PDF and CSV file formats (up to 20 MB)
  • Automatic line-item extraction from unstructured PDFs
  • Review parsed results before reconciliation
  • Works with any carrier statement format
02

Import Your Policy Book

Import your expected commission records via CSV or enter them manually. These are the commissions you should be receiving based on your book of business.

  • CSV import with automatic column mapping
  • Manual entry for individual policy records
  • Duplicate detection prevents double-counting
  • Inline editing for quick corrections
03

Reconcile Automatically

CommissionIQ matches every statement line item against your policy records. Matched items are confirmed. Unmatched or mismatched items are flagged as discrepancies for your review.

  • Policy-number and carrier-name matching
  • Commission amount comparison (expected vs. actual)
  • Automatic categorization: matched, unmatched, discrepancy
  • Results available in seconds, not days
04

Review Discrepancies

See exactly where carriers shorted you. Every discrepancy shows the expected amount, actual amount, and the difference — giving you the data to dispute underpayments with confidence.

  • Underpayments flagged with exact dollar difference
  • Missing commissions identified (policy exists, no payment received)
  • Chargebacks and clawbacks surfaced for review
  • Export-ready data for carrier disputes

Features

PDF & CSV Parsing

Upload carrier statements in any format. Our parser extracts line items from structured CSVs and unstructured PDFs, so you don't have to re-key data.

Automated Matching

Our reconciliation engine compares every statement line item against your expected commissions by policy number, carrier, and amount — surfacing mismatches instantly.

Discrepancy Reports

Every flagged item shows expected vs. actual amounts with the exact difference. Use these reports to dispute underpayments and recover lost revenue from carriers.

Multi-Carrier Support

Manage statements from every carrier in your book. CommissionIQ handles the format differences so you can reconcile your entire portfolio in one place.

Policy Book Management

Import your full policy book via CSV or add records one at a time. Edit expected commission amounts inline, and duplicates are caught automatically.

Secure by Design

Your commission data is encrypted at every layer. Row-level security ensures each agency only sees their own data. We never share your data with carriers or third parties.

Security & Privacy

Encrypted

All data encrypted in transit (TLS) and at rest. Your commission data never touches an unencrypted surface.

Isolated

Row-level security ensures each agency only sees their own data. No cross-tenant data access is possible.

Private

We never share your commission data with carriers, third parties, or other platform users. Your data stays yours.

Frequently Asked Questions

What carrier statement formats do you support?

CommissionIQ accepts PDF and CSV files up to 20 MB. Our parser handles both structured CSV exports and unstructured PDF statements. If your carrier provides statements in either format, CommissionIQ can parse them.

How accurate is the PDF parsing?

Our parser uses heuristics to extract line items from PDFs, including policy numbers, insured names, and commission amounts. For best results, we recommend reviewing parsed line items before reconciliation. CSV uploads provide the highest accuracy since the data is already structured.

Can I reconcile statements from multiple carriers?

Yes. Upload statements from any carrier, and import your full policy book covering all carrier appointments. CommissionIQ matches line items by policy number and carrier name across your entire book.

How is my data secured?

All data is encrypted in transit and at rest. Row-level security (RLS) ensures each agency can only access their own records. We never share commission data with carriers, third parties, or other users of the platform.

What happens when a discrepancy is found?

Discrepancies are flagged with the expected amount, actual amount, and the dollar difference. You can review each one on the Discrepancies page and use this data to file disputes with carriers or investigate further.

Is there a cost to get started?

CommissionIQ is free to start. Sign up, upload a statement, and run your first reconciliation at no cost.

Ready to find your missing commissions?

Free to start. No credit card required.

Get Started Free