---
title: "Commission Reconciliation Software for Agencies | Lapidar"
url: https://getlapidar.com/
description: "Insurance commission reconciliation software for independent agencies: every carrier statement line checked against your book. Founding pilot open to 7 agencies."
last_modified: "Tue, 20 Oct 2026 12:39:00 GMT"
source: getlapidar.com (HTML converted to Markdown at the edge)
---

# Commission reconciliation software for US independent agencies

[Founding pilot open: 7 agencies.](https://getlapidar.com/pilot/)

Every dollar. _Checked._

Carriers pay you from statements nobody at the agency has time to check. Lapidar is commission reconciliation software that matches every line against your book and your commission schedules, and shows you what is missing, underpaid or paid twice.

[Open an account](https://app.getlapidar.com/signup) [See what the pilot includes](https://getlapidar.com/pilot/)

[Secure checkout by Stripe](https://getlapidar.com/pilot/#billing)[Cancel anytime](https://getlapidar.com/terms/#cancel)[First month refunded if no discrepancy in 30 days](https://getlapidar.com/terms/#plan)[Live status](https://status.getlapidar.com/)

Statement · Carrier 07

Illustration · Example data

**Illustration with example data: one carrier statement checked against the book of business. Seven lines, three to look at.**

| Policy | Premium | Rate | Expected | Paid | Result |
| --- | --- | --- | --- | --- | --- |
| EX-10477 | 1,840.00 | 15% | 276.00 | 276.00 |  |
| EX-10479 | 1,215.00 | 12% | 145.80 | 145.80 |  |
| EX-10482 | 2,750.00 | 15% | 412.50 | 330.00 | Underpaid |
| Schedule says 15%, paid at 12%. Short −$82.50 |  |  |  |  |  |
| EX-10486 | 960.00 | 12% | 115.20 | 115.20 |  |
| EX-10486 | 960.00 | 12% | — | 115.20 | Paid twice |
| Same policy, same period. Likely to be taken back later. |  |  |  |  |  |
| EX-10490 | 4,400.00 | 15% | 660.00 | — | Missing |
| In your book, renewed in August. Not on this statement. |  |  |  |  |  |
| EX-10493 | 2,310.00 | 15% | 346.50 | 346.50 |  |

7 lines checked against the book3 to look at

01The statement

## A dozen carriers. A dozen formats. One afternoon to check them.

Some statements come as PDFs from the carrier portal, some as CSVs, each laid out its own way. The policy numbers don’t always match what’s in your AMS. Most months you spot-check a few carriers and trust the rest.

For scale: independent agencies averaged 19.7 carrier appointments across all lines in 2025, up from 17.2 in 2024, according to the [2026 Agency Universe Study](https://www.iamagazine.com/2026/10/01/evolving-channel-key-findings-from-the-2026-agency-universe-study/) from Future One and the Big “I”.

So a rate drops at renewal and nobody catches it. A renewal never gets paid. An endorsement gets paid twice and charged back four months later. None of it comes with a notice, and finding it by hand means hours every month with the statement and the AMS side by side.

On one statement

- Direct bill
- Agency bill
- Overrides
- Chargebacks

02One line, checked

## What a checked commission line looks like.

Every line on the statement is matched to a policy in your book and to the rate on your commission schedule. Then the commission is worked out again from premium and rate, and compared with what the carrier actually paid.

Carrier 07 · EX-10482Example data

**Written premium**
$2,750.00

**Rate on your schedule**
×15.00%

**Expected commission**
$412.50

**Paid on the statement**
$330.00

**Short**
−$82.50

Paid at 12.00% instead of 15.00%. Goes on the report with the statement line it came from.

03What it looks for

## Missing, underpaid, paid twice: what slips by when nobody reads every line.

1. Missing.
   A policy is in your book, but no commission came through for it this period.
   ExampleEX-10490 · $660.00 expected
2. Underpaid.
   The commission was paid at a lower rate than the one on your schedule.
   Example15% expected · 12% paid · −$82.50
3. Duplicate.
   The same line paid twice, on one statement or across two. That money tends to be charged back later.
   ExampleEX-10486 · $115.20 × 2

04How it works

## Upload your statements. Keep your AMS.

What you’ll need Your carrier statements, a book export from your agency management system, and your commission schedules.

1. ### Upload your statements.
   CSV, Excel or PDF with a text layer, the way your carriers send them (no scanned PDFs yet). There’s no fixed carrier list; layouts agencies flag in the app come first.
2. ### Every line is matched against your book.
   Each line goes to a policy in your book export and a rate on your commission schedule, including lines where the carrier writes the policy number differently from your AMS. That matching is the hard part, and it’s where most of our work is going.
3. ### You get a plain discrepancy report.
   Missing, underpaid, paid twice, with the dollar amount. Each item points to the statement line it came from, so you have what you need when you call the carrier.

05Where things stand

## Built for independent agencies on Main Street.

Independent P&C agencies, from a handful of carriers to a few dozen, where the owner or the office manager reconciles commissions by hand, or doesn’t get to it at all.

If you have a full-time accounting team and an enterprise system doing this already, we’re probably not for you yet.

### As of today

**Product**
Founding pilot, 7 agencies

**Customers**
None yet

**Testimonials**
None to show

**Pricing**
[Founding pilot, $99 a month plus tax](https://getlapidar.com/pilot/)

**Figures on this page**
Example data, except one cited study

### What we won’t do

- Contact your carriers on your behalf.
- Sell or share your data, or use it for anything but checking your commissions.
- Show you a number we made up.

06Founding pilot

## The founding agency pilot.

Upload carrier statements (CSV, XLSX or text PDF) and a book export. Get back what is missing, underpaid, paid twice, charged back or not in your book, with a printable carrier letter. No OCR for scanned PDFs yet, and no AMS integration. Create a free account, subscribe from inside it and start uploading.

See [a sample report](https://getlapidar.com/sample-report/), read [what the software does and doesn’t do](https://getlapidar.com/commission-reconciliation-software/), or compare it with [a spreadsheet](https://getlapidar.com/compare/spreadsheet-vs-commission-reconciliation-software/) and [your AMS’s commission tools](https://getlapidar.com/compare/ams-commission-tools-vs-lapidar/), or see [named options compared](https://getlapidar.com/compare/insurance-commission-software/). On AMS360? [Using an AMS360 export](https://getlapidar.com/for/vertafore-ams360-agencies/).

[See what the pilot includes](https://getlapidar.com/pilot/)

[Secure checkout by Stripe](https://getlapidar.com/pilot/#billing)[Cancel anytime](https://getlapidar.com/terms/#cancel)[First month refunded if no discrepancy in 30 days](https://getlapidar.com/terms/#plan)[Live status](https://status.getlapidar.com/)

### Terms

**Price**
$99 a month plus tax

**Locked for**
12 months

**Open to**
7 founding agencies

**Access**
Right after checkout

**Cancel**
Anytime

**Refund**
If no discrepancy in first 30 days

## Not sure yet? We’ll run one free check on one of your real statements.

No account and no card, and nothing to cancel afterwards.

**Send**
One month’s commission statement from one carrier (CSV, Excel, or a PDF with selectable text) and your book export for that carrier. If the export has no commission rates, tell us the rate you expect.

**How**
Reply to our email, or write to [contact@getlapidar.com](mailto:contact@getlapidar.com).

**You get**
The report the app produces, on your own data: every finding for that carrier, each with the statement line it comes from.

**Your files**
Used only for this check and deleted afterwards. The report goes only to you.

What the report looks like, with invented data: [the sample report](https://getlapidar.com/sample-report/#free-check).

07Questions owners ask

## Questions owners ask

**What is Lapidar?**
Web software for US independent P&C insurance agencies. You upload carrier commission statements and an export of your book; Lapidar checks every line against your book and commission schedules and lists what is missing, underpaid, paid twice or charged back, with a printable letter to the carrier. It is new: a founding pilot that opened on October 10, 2026, with no customers or published results yet.

**Can I use Lapidar today?**
Yes, through the [founding agency pilot](https://getlapidar.com/pilot/), open to 7 founding agencies. You create a free account, subscribe from inside it and can upload the same day. If the pilot is full, write to [contact@getlapidar.com](mailto:contact@getlapidar.com) and we’ll tell you when a seat opens.

**What does it cost?**
The [founding agency plan](https://getlapidar.com/pricing/) is $99 a month plus applicable sales tax or VAT, calculated at checkout, locked for 12 months for the 7 founding agencies. Creating an account is free. Cancel anytime; the first month is refunded on request if no discrepancy turns up in your first 30 days ([terms](https://getlapidar.com/terms/#plan)).

**Who is behind Lapidar?**
Lapidar is built and run by [Alan Balcerowiak](https://getlapidar.com/about/), a software engineer in Wieliczka, near Kraków, Poland, who answers [contact@getlapidar.com](mailto:contact@getlapidar.com) himself. Billing goes through Stripe. There are no customers, case studies or reviews yet, and no SOC 2 or other certification; the [about page](https://getlapidar.com/about/) lists what works and what doesn’t.

**Does it integrate with Applied Epic, AMS360 or HawkSoft?**
No. Lapidar has no direct connection to any agency management system. You keep your AMS, export your book from it as CSV or XLSX and upload that next to your statements. See [reconciliation against your AMS](https://getlapidar.com/ams-commission-reconciliation/) and [using an AMS360 export](https://getlapidar.com/for/vertafore-ams360-agencies/).

**Does it work with PDF statements?**
Yes, if the PDF has a text layer. Statements also read as CSV or XLSX. There is no OCR, so scanned or photographed PDFs don’t read at all. There is no fixed carrier list: some layouts need a column mapping the first time, some may not read cleanly yet, and layouts agencies flag in the app decide what we support next.

**Is my data safe?**
Statements are used only to check your commissions, stored on one server in an OVHcloud data center in London, encrypted in transit, and never sold or shared. You can delete them at any time; after a subscription ends they are kept 30 days, then deleted. Not in place yet: two-factor login, disk encryption at rest and off-site backups. Details on the [security page](https://getlapidar.com/security/), in the [privacy policy](https://getlapidar.com/privacy/) and the [data processing addendum](https://getlapidar.com/dpa/).

**What are the alternatives to Lapidar?**
The commission tools in your AMS (Applied Epic, AMS360, HawkSoft, EZLynx and others), dedicated commission tools such as AgencyBloc or Commissionly, a spreadsheet, or an outside firm that reconciles for you. [Commission software compared](https://getlapidar.com/compare/insurance-commission-software/) sets them side by side, each claim linked to its source.

**Is Lapidar insurance commission tracking software?**
Tracking software records the commission that came in. Reconciliation checks it against what should have come in, worked out from your book and your commission schedules, including commission that never produced a statement line. Lapidar is insurance commission reconciliation software for that second job, now in a founding pilot; it sits beside your agency management system and covers gaps in [what your AMS may already check](https://getlapidar.com/ams-commission-reconciliation/).

**What should commission reconciliation software check?**
Whichever tool you look at, ours included, ask whether it:

- works out expected commission from your own schedule instead of trusting the statement’s rate;
- finds missing commission starting from your book, since a missing renewal prints no line;
- reads the PDF statements your carriers send, not only CSV files;
- matches policy numbers that differ between the carrier and your AMS;
- catches the same line paid in two periods;
- ties a chargeback to the payment it reverses;
- carries open items forward until they clear;
- says how it stores your statements and when it deletes them.

**Will you contact my carriers?**
Never. The report is yours, and so is the decision about what to pursue.

## Be among the first agencies to have every line checked.

The [founding pilot](https://getlapidar.com/pilot/) is open to 7 agencies. Create an account, subscribe from inside it and upload your first statement the same day.

[Open an account](https://app.getlapidar.com/signup) [See a sample report](https://getlapidar.com/sample-report/)

08Further reading

## Further reading

### Guides

Start with [reading a carrier commission statement line by line](https://getlapidar.com/guides/how-to-read-a-carrier-commission-statement/), then see [how reconciliation works month to month](https://getlapidar.com/guides/how-to-reconcile-carrier-commission-statements/). If money has gone quiet, read [why renewal commissions go missing](https://getlapidar.com/guides/missing-renewal-commissions/) and [how chargebacks arise](https://getlapidar.com/guides/commission-chargebacks-explained/). For the month-end routine, see [direct bill reconciliation, step by step](https://getlapidar.com/guides/direct-bill-reconciliation/) and [what a carrier download does and doesn’t carry](https://getlapidar.com/guides/what-is-an-al3-file/). If you pay producers, read [producer commission splits](https://getlapidar.com/guides/producer-commission-splits/); for the annual carrier payment, [insurance agency profit sharing](https://getlapidar.com/guides/insurance-agency-profit-sharing/); before an acquisition, [buying an insurance book of business](https://getlapidar.com/guides/buying-an-insurance-book-of-business/). When a renewal stops or a statement won’t tie out, read [why carriers stop paying renewal commissions](https://getlapidar.com/guides/why-carriers-stop-paying-renewal-commissions/) and [why a commission statement doesn’t match your AMS](https://getlapidar.com/guides/commission-statement-not-matching-agency-management-system/); for agency bill, see [agency bill reconciliation](https://getlapidar.com/guides/agency-bill-vs-direct-bill-commission-reconciliation/), and for the difference between the two, [direct bill vs agency bill](https://getlapidar.com/guides/direct-bill-vs-agency-bill-commissions/). On the other side of a sale, see [selling an insurance book of business](https://getlapidar.com/guides/selling-an-insurance-book-of-business/); when moving policies to a new carrier, [tracking commissions through an insurance book roll](https://getlapidar.com/guides/insurance-book-roll/). To close the books each month, follow [the insurance agency month-end close](https://getlapidar.com/guides/insurance-agency-month-end-close/); before paying producers, see [how to audit producer commission payouts](https://getlapidar.com/guides/how-to-audit-producer-commission-payouts/). Starting out? Read [how to get insurance carrier appointments](https://getlapidar.com/guides/how-to-get-insurance-carrier-appointments/) and [how personal and commercial lines commissions differ](https://getlapidar.com/guides/personal-lines-vs-commercial-lines-commissions/).

### Glossary

Plain definitions in the [insurance commission glossary](https://getlapidar.com/glossary/), including [commission statement](https://getlapidar.com/glossary/commission-statement/), [agency bill](https://getlapidar.com/glossary/agency-bill/) and [contingent commission](https://getlapidar.com/glossary/contingent-commission/).

### Tools and services

Free tools: the [commission calculator](https://getlapidar.com/tools/commission-calculator/), [chargeback calculator](https://getlapidar.com/tools/commission-chargeback-calculator/), [pro rata & short rate cancellation calculator](https://getlapidar.com/tools/pro-rata-cancellation-calculator/), [loss ratio calculator](https://getlapidar.com/tools/insurance-loss-ratio-calculator/), [contingent commission calculator](https://getlapidar.com/tools/contingent-commission-calculator/), [producer split calculator](https://getlapidar.com/tools/producer-commission-split-calculator/), [retention value calculator](https://getlapidar.com/tools/client-retention-value-calculator/), [book valuation calculator](https://getlapidar.com/tools/book-of-business-valuation-calculator/) and the [commission statement decoder](https://getlapidar.com/tools/commission-statement-decoder/); to track the whole agency, the [insurance agency KPI calculator](https://getlapidar.com/tools/insurance-agency-kpi-calculator/). Every calculator is listed on [the free tools page](https://getlapidar.com/tools/). Carrier by carrier, see [what each carrier publishes about its commission statements](https://getlapidar.com/carriers/). Data: [agency statistics](https://getlapidar.com/data/independent-insurance-agency-statistics/) and [top P&C carriers by state](https://getlapidar.com/data/pc-carriers-by-state/). Comparing software? See [commission software compared](https://getlapidar.com/compare/insurance-commission-software/). By agency type: [reconciliation for personal lines agencies](https://getlapidar.com/for/personal-lines-agencies/) and [for commercial lines agencies](https://getlapidar.com/for/commercial-lines-agencies/), and every page by agency type and AMS on [one list](https://getlapidar.com/for/). For how we work with your system, see [reconciliation against your AMS](https://getlapidar.com/ams-commission-reconciliation/); for the review itself, [a commission audit for independent agencies](https://getlapidar.com/commission-audit-for-independent-agencies/).
