Commission reconciliation software for US independent agencies
Founding pilot open: 7 agencies.
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 See what the pilot includes
Secure checkout by StripeCancel anytimeFirst month refunded if no discrepancy in 30 daysLive status
Statement · Carrier 07
Illustration · Example data
| 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% | — | 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 | |
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 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.
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.
- Written premium
- $2,750.00
- Rate on your schedule
- ×15.00%
- Expected commission
- $412.50
- Paid on the statement
- $330.00
- Short
- −$82.50
Missing, underpaid, paid twice: what slips by when nobody reads every line.
-
Missing.
A policy is in your book, but no commission came through for it this period.
ExampleEX-10490 · $660.00 expected -
Underpaid.
The commission was paid at a lower rate than the one on your schedule.
Example15% expected · 12% paid · −$82.50 -
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
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.
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.
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.
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.
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
- 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.
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, read what the software does and doesn’t do, or compare it with a spreadsheet and your AMS’s commission tools, or see named options compared. On AMS360? Using an AMS360 export.
Secure checkout by StripeCancel anytimeFirst month refunded if no discrepancy in 30 daysLive status
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.
- 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.
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, 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 and we’ll tell you when a seat opens.
- What does it cost?
- The founding agency plan 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).
- Who is behind Lapidar?
- Lapidar is built and run by Alan Balcerowiak, a software engineer in Wieliczka, near Kraków, Poland, who answers 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 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 and using an AMS360 export.
- 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, in the privacy policy and the data processing addendum.
- 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 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.
- 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 is open to 7 agencies. Create an account, subscribe from inside it and upload your first statement the same day.
Further reading
Guides
Start with reading a carrier commission statement line by line, then see how reconciliation works month to month. If money has gone quiet, read why renewal commissions go missing and how chargebacks arise. For the month-end routine, see direct bill reconciliation, step by step and what a carrier download does and doesn’t carry. If you pay producers, read producer commission splits; for the annual carrier payment, insurance agency profit sharing; before an acquisition, buying an insurance book of business. When a renewal stops or a statement won’t tie out, read why carriers stop paying renewal commissions and why a commission statement doesn’t match your AMS; for agency bill, see agency bill reconciliation, and for the difference between the two, direct bill vs agency bill. On the other side of a sale, see selling an insurance book of business; when moving policies to a new carrier, tracking commissions through an insurance book roll. To close the books each month, follow the insurance agency month-end close; before paying producers, see how to audit producer commission payouts. Starting out? Read how to get insurance carrier appointments and how personal and commercial lines commissions differ.
Glossary
Plain definitions in the insurance commission glossary, including commission statement, agency bill and contingent commission.
Tools and services
Free tools: the commission calculator, chargeback calculator, pro rata & short rate cancellation calculator, loss ratio calculator, contingent commission calculator, producer split calculator, retention value calculator, book valuation calculator and the commission statement decoder; to track the whole agency, the insurance agency KPI calculator. Every calculator is listed on the free tools page. Carrier by carrier, see what each carrier publishes about its commission statements. Data: agency statistics and top P&C carriers by state. Comparing software? See commission software compared. By agency type: reconciliation for personal lines agencies and for commercial lines agencies, and every page by agency type and AMS on one list. For how we work with your system, see reconciliation against your AMS; for the review itself, a commission audit for independent agencies.