Why general reporting software doesn't fit insurance
The big reporting platforms are built around marketing and analytics APIs — Google Ads, Meta, GA4. Insurance carriers don't expose anything comparable. There's no connector to point at a carrier statement, so the entire category of API-based dashboards leaves the agency's core numbers untouched. The data isn't missing; it's trapped behind logins the tools can't open.
That leaves agencies in spreadsheets. Manual commission reconciliation means exporting each carrier's statement, matching every line to the book of business, and spotting what's short by eye. It's slow, it's repeated every statement cycle, and a missed underpayment is money the agency simply never collects. The format is wrong for the job — but the API tools can't replace it because they can't reach the source.
How reportr fits the way agency data actually lives
You upload your book of business as a roster CSV. reportr then reads the commission actually paid from the carrier portal you're logged into and reconciles it against what you were owed, line by line — flagging entries that are short-paid, unpaid, or uncatalogued (paid but not in your roster). It uses the official API where a carrier has a usable one and reads the rendered portal page where there isn't, all client-side in your own session, without logging in for you or warehousing the data.
The output is a branded, white-label PDF carrying your logo, brand and accent colors, and a footer note — clean enough to share with a carrier when you're disputing an underpayment or with a partner who needs the numbers. A capture health signal flags whether each run pulled clean data, so a portal layout change warns you rather than shipping an empty statement. The engine itself is vertical-agnostic; insurance commission reconciliation is simply where it starts.
Three approaches to insurance agency reporting
| Spreadsheets | General reporting software | reportr | |
|---|---|---|---|
| Reaches carrier portals (no API) | Yes, manually | No | Yes, reads the portal you're logged into |
| Reconciles expected vs. paid commission | By hand | No | Line by line, automatically |
| Flags short-paid / unpaid / uncatalogued | If you catch it | No | Yes |
| Branded white-label output | Build it yourself | Yes | Yes, logo + colors + footer |
| Effort per statement cycle | High, repeated | Low but can't reach the data | One click |
| Warns on bad or empty capture | No | N/A | Yes, capture health signal |
frequently asked
- Why can't a tool like Whatagraph or DashThis report on carrier commission?
- They connect through platform APIs, and carriers don't publish usable APIs for commission data. With nothing to connect to, those dashboards can't reach the numbers. reportr reads the carrier portal directly in your own session instead.
- What does reportr actually reconcile?
- You upload your book of business as a roster CSV, and reportr compares the commission actually paid (from carrier statements) against what you were owed, line by line. It flags entries that are short-paid, unpaid, or uncatalogued — paid but missing from your roster.
- Is my carrier data sent to a server?
- No. Extraction happens client-side in the portal session you're already logged into. reportr doesn't log in for you, doesn't bypass access controls, and doesn't centrally warehouse the data. Host permissions are narrow and consent is per source.
- Is reportr only for insurance?
- Insurance commission reconciliation is the starting vertical, but the underlying engine is vertical-agnostic. Other verticals such as wealth/RIA and marketing are planned as future adapter packs on the same extraction and reporting engine.
Last updated June 8, 2026