Extract data from commission statements
Unstract reads carrier commission statements, sales commission reports and override statements in each carrier's own layout, and sends every policy line, rate and chargeback to your agency management or accounting system as checked data.
| POLICY · INSURED | PREMIUM | RATE | COMMISSION |
|---|---|---|---|
| BOP-8831042 Lakeview Bakery · BOP · NEW | 4,280.00 | 15.0% | 642.00 |
| CA-5520917 Marlow Plumbing · AUTO · RENEW | 9,640.00 | 12.5% | 1,205.00 |
| WC-7714306 Trellis Landscaping · WC · RENEW | 12,350.00 | 8.0% | 988.00 |
| GL-6602184 Brightwater Dental · GL · ENDT | 615.00 | 15.0% | 92.25 |
| HO-3390551 Delgado, R. · HOME · NEW | 2,184.00 | 15.0% | 327.60 |
| CA-5498830 Kessler Freight · AUTO · CHARGEBACK | (3,120.00) | 12.5% | (390.00) |
| Total commission due | 25,949.00 | — | 2,864.85 |
Kessler cxl 9/30, paid to J. Ortiz in July
Chargebacks reverse commission paid on policies cancelled mid-term
{ "carrier": "Ridgeway Mutual Insurance Co.", "agency": "Cedar Hollow Insurance Agency", "agency_code": "40217-CH", "statement_period": "October 2026", "statement_number": "CS-2610-40217", "total_premium": 25949, "chargebacks": 390, "commission_due": 2864.85, "eft_date": "Nov 14, 2026", "confidence": 0.97}
Trusted by insurance teams around the globe
Every carrier pays you on its own statement
One agency can deal with thirty carriers, and each one sends commissions in a different file, with its own column names and its own codes for a cancellation.
Statements printed for sign-off, then scanned back in crooked
Three carriers, three names for the commission column
Split worksheets where someone corrected the producer share in pen
A month's carrier download with statement, chargebacks, overrides and EFT notice
A national carrier's export with thousands of policy lines
Agency accountants rekey each carrier's statement line by line into the book, so producers wait weeks to be paid, chargebacks hit the wrong person, and a short-paid rate goes unnoticed until the carrier contract renews.
Unstract reads each statement in the carrier's own layout, extracts every policy line with its premium, rate and commission, checks the lines against your book and the carrier agreement, and sends the result to your agency management or accounting system.
Commission statement data extraction, from the carrier's file to the producer's check
Parse the statement, extract each policy line, then run the payout around the data. Each product works on its own; stacked, they take a carrier statement to producer pay without anyone keying it.
Parse commission statements with every policy line on its own row
Get the full text of a carrier statement, whether it arrived as a portal PDF, a scanned printout, an emailed spreadsheet or a 48-page download with chargeback notices inside. Policy number, insured, line, transaction code, premium, rate and commission stay on one row, a chargeback keeps its brackets, and the statement total stays tied to the EFT amount printed beside it.
Send the text to your own LLM, or make parsing the first step of the commission payout workflow.
Learn more about LLMWhispererTurn each carrier commission statement into one record your accounting team trusts
List the fields your agency pays producers from, such as agency code, policy number, transaction type, premium, rate and commission, and every carrier's statement returns in the same JSON structure. A scanned regional carrier and a national carrier's spreadsheet fill identical fields. Values are checked on the way out: a rate that differs from the carrier agreement, or a chargeback on a policy the carrier never paid you for, comes back flagged with the reason.
Call it as an API from your accounting workflow, run it as an ETL pipeline on the folder where carrier downloads land, or make it one step in the full payout run. The same setup handles sales commission report extraction for agencies that receive a summary report instead of line detail.
Learn more about Document StudioRun commission payout from the carrier statement to the producer
Describe in plain English how your agency handles commission statements, and Flow's agents build the workflow. Statements are collected from carrier portals and inboxes as they post, each policy line is matched to the policy in your book, the rate is checked against the carrier agreement, and each producer's share is worked out by your split rules. Results post to your agency management or accounting system, such as Applied Epic, AMS360, QuickBooks or NetSuite, and payouts go to payroll. You approve the workflow once, and every statement runs through it the same way.
Choose where a person steps in: a policy that is not in your book, a rate off the carrier schedule, a chargeback with no original payment, or a statement that does not tie to the carrier's EFT. Only those lines stop, with the statement row and the policy record side by side for a commissions or accounting specialist. Everything else is paid on time.
Learn more about FlowExtract commission statement data now. Automate the payout when you're ready.
Start for free and run your own carrier statements through parsing and extraction today. Matching to your book, producer splits and posting begin with a consultation.
Carrier statements, commission reports and what arrives with them
Documents
- Carrier commission statements
- Sales commission reports
- Chargeback statements
- Override statements
- Contingent and profit-sharing commission statements
- Bonus and incentive statements
- Carrier portal commission downloads
- Commission detail spreadsheets
- Direct-bill commission statements
- Agency-bill statements
- EFT and commission payment advices
- Producer split worksheets
- Carrier commission schedules
- Any other carrier's statement, in its own layout
Fields captured
For the people who make sure producers are paid right
Month-end no longer starts with rekeying thirty carrier statements, so the accounting team closes commissions in days and spends its time on the lines that do not match.
Overrides and sub-producer commissions arrive as data, so a broker or MGA can pay its downstream agents from the same statement it received, without retyping it.
Agencies send back fewer disputes about missing or misrated policies, because their statements are read the same day and any gap is raised with a policy number attached.
Each month's earnings, chargebacks included, are visible per policy, so an independent agent can see what was paid and what was clawed back without a spreadsheet of their own.
Producers paid sooner, fewer lines worked by hand
Built for producer pay and carrier contract terms
Commission statements show what each producer earns, which clients pay which premium under which policy number, and the rates each carrier agreed to pay your agency. That is a payroll file, a client list and your negotiating position in one document.
- Encrypted in transit and at rest.
- Carrier statements and producer earnings are never used for model training.
- Access by role, carrier and producer, so a producer sees their own lines and every manual match or edited rate is logged.
- You set retention: statements are deleted when your accounting and carrier audit policy allows.
- Self-hosted deployment for agencies and carriers that keep compensation data inside their own environment.
What agency accountants and producer compensation teams ask first
The payout depends on reading the statement first. Unstract extracts every policy line, rate and chargeback from the carrier's file, matches each line to your book, applies your producer split rules and posts the result. People only see the lines that do not match.
One that reads statements as they post instead of waiting for someone to key them. Commission statement OCR turns the file into text, extraction turns the text into policy-level data, and the payout workflow runs on that data the same day the carrier pays.
A carrier statement lists each policy the carrier paid commission on. A sales commission report is usually the agency's own summary by producer, or a carrier's roll-up by line. Unstract reads both and returns them in the same record structure, so a summary can be checked against the line detail behind it.
Unstract handles a new carrier's layout without a template. You describe the fields once, and "Comm Amt", "Agent Comp" and "Commission Due" all fill the same field. A carrier that changes its statement format needs no rework.
Spreadsheets and portal exports run through the same pipeline as PDFs and scans. A national carrier's file with thousands of policy lines comes back as one record per line, with the statement total checked against the sum of the lines.
A chargeback is extracted with the policy number, the cancellation date and the amount reversed, then traced to the original payment so it comes back from the producer who was paid. Override and contingent commission statements are read as their own lines and kept apart from policy-level commission.
Yes. Load each carrier's commission schedule, and every line's rate is compared with the agreed rate for that line of business and transaction type. A rate that differs comes back flagged with the expected value beside it.
Matched lines post to Applied Epic, AMS360, QuickBooks or NetSuite, or to the import file your system already reads. Producer payouts go to ADP or Paychex, and producer statements can be generated from the same data.
Unstract is SOC 2, ISO 27001, GDPR and HIPAA compliant. Statements are encrypted in transit and at rest, never used to train models, and deleted on the schedule you set. Agencies and carriers that keep compensation data in-house can self-host; see the Trust Center.
In a consultation we set it up around your top carriers' statements, a policy export from your book and your split rules, and most agencies post their first month within days. To try the extraction now, start for free and upload one statement.
Bring last month's carrier statements to the consultation
The scanned ones, the portal spreadsheets, the chargebacks nobody has traced and a policy export from your book. We read them live and show every line matched or flagged.