Question 1

What is insurance commission reconciliation?

Accepted Answer

Insurance commission reconciliation is the process of comparing carrier commission statements against your agency management system (AMS) to verify that all policy commissions were paid correctly and to identify discrepancies or missing payments.

Question 2

What file formats does Commission Wizard support?

Accepted Answer

CSV, Excel (XLSX, XLS), and PDF. Enterprise plans include AI-powered PDF Vision for scanned or complex PDF documents.

Question 3

Does it work with my agency management system (AMS)?

Accepted Answer

Yes. Commission Wizard works with any system that exports to CSV or Excel, including Matrix, Applied Epic, AMS360, HawkSoft, EZLynx, and others. No integration or API setup needed.

Question 4

How does policy number matching work with different formats?

Accepted Answer

The system supports exact, prefix, and fuzzy matching. If your AMS has policy 12345 and the carrier report has 12345-397657, prefix matching identifies them as the same policy.

Question 5

How are insurance agent commissions calculated?

Accepted Answer

Commission Wizard supports a flexible chain: start with the carrier commission or calculate from premium times a custom rate per agent, deduct an optional running cost for agency operations, then split the remainder between agency and agent. All percentages are configured per agent per carrier and saved for reuse.

Question 6

Can agents log in to see their own commissions?

Accepted Answer

Yes. Create a Viewer account linked to any agent. They see their personal commission dashboard, payment history, and can export reports without accessing other agents' data.

Question 7

How does Commission Wizard track agent payments?

Accepted Answer

Record payments by check, ACH, wire, or cash in each agent's profile. The system calculates the outstanding balance automatically: total commissions earned minus payments made.

Question 8

Do I have to upload my AMS file every month?

Accepted Answer

No. Save your AMS export as a reusable template. For future reconciliations, just upload the new carrier statement and select your saved AMS file.

Question 9

Does Commission Wizard keep a history of past reconciliations?

Accepted Answer

Yes. Every reconciliation is saved with full detail including matched records, discrepancies, column mappings, and agent splits. You can review or re-download the report from any past job at any time.

Question 10

Can I generate commission statements for individual agents?

Accepted Answer

Yes. Generate Excel or PDF reports for any agent filtered by period, with a carrier-by-carrier summary and policy-level detail.

We use cookies

Blog

The Complete Guide to Insurance Commission Reconciliation for Independent Agencies

5 Problems with Manual Commission Reconciliation (And How to Fix Them)

Commission Reconciliation Software for Insurance Agencies: What to Look For in 2026

AI Assistant