DEV Community: LAPIDAR

Agency bill and direct bill need different checks

LAPIDAR — Wed, 07 Oct 2026 07:17:38 +0000

Most independent agencies run both billing types. Often it is the same carrier, different lines, so two statements land in the same month and the same person reconciles them. They look alike. They are different jobs, and treating them as one is a common way for errors to survive.

Direct bill: the statement cannot show what is missing

On a direct bill statement the carrier tells you what it paid you. It cannot tell you what it did not pay. So matching each line to a policy is only half the work. The other half starts from your book and asks which commissions should have appeared this month and didn't. Those are the ones that cost money, and nothing on the page points at them.

Most differences you find are not errors, which is what makes this tiring:

Timing. A renewal effective on the 28th may be paid on next month's statement. Whether that is normal depends on the carrier.
Installments. If commission is paid as premium is collected, one policy becomes a series of small lines. If the insured misses a payment, the series gets shorter and the carrier has done nothing wrong.
Fees. A policy fee inside the premium base changes the commission without changing the rate.
Rate. The line differs from your schedule, or a new business rate was applied to a renewal.
Negative lines. Chargebacks can arrive weeks or months after the cancellation, and flat cancellations can reverse the whole commission.

Take one invented policy: $2,400 annual premium on a monthly plan, 12% commission, so $24 a month. Month one shows $24. Month two shows nothing. Month three shows $24. The gap could be a missed payment, a timing slip or a carrier error. The statement cannot say which. You need the billing history and sometimes a phone call.

Agency bill: you are reconciling two sets of records

An agency bill statement, often called an account current, lists what the carrier has processed for your agency and what you owe after your commission. Money moves from you to the carrier. You are comparing the carrier's records against yours before you send payment.

The checks are different. Every transaction should have an invoice. Every invoice should have a transaction. The commission the carrier took should match your schedule.

A few invented lines show how it goes. A new business item matches an invoice you issued and collected. A return premium matches a credit you issued. An endorsement has no invoice at all, so it was never billed and you may be about to pay the carrier for something your client has not been charged for. A renewal has an invoice but the client has not paid, which raises a separate question: how your carrier's terms treat premium you have not collected yet.

None of those is a dispute with the carrier. They are gaps in your own billing that the statement happens to expose. Rules about handling collected premium vary by state, so ask your regulator or accountant rather than a blog post.

Why the two should not share a checklist

The direct bill failure is a line that is missing or short, and nobody notices. The agency bill failure is paying out, or crediting yourself, on something that was not billed correctly. One starts from commission you expect to receive. The other starts from premium you invoiced. If you run both through "do the totals look about right", you will catch some of each and an unknown share of the rest.

Why it takes so long

No single check is hard. The time goes into everything around them.

Every carrier lays out its statement differently. Columns, signs, transaction names and grouping vary, and many arrive as PDFs.
Policy numbers do not always match. Carriers reformat them, add suffixes at renewal, or report under another producer code. Matching is often judgment, not lookup.
The billing types arrive mixed. One statement can combine direct bill, agency bill and non-policy lines such as overrides or contingent commission, each under its own agreement.
Items stay open for months. A discrepancy is raised, a correction is promised, and it may land two statements later or never. Tracking that means keeping a ledger of open items and keeping it current.
A missed line is invisible. Nothing flags it. You only find it if you went looking.

A small agency with a few carriers can do this carefully by hand. Expect it to take a recurring day or more each month, and expect it to get harder with every carrier you add. I would not describe it as simple, and I would be wary of anyone who does. In practice many agencies check totals, or only the largest lines, and that is exactly how smaller missing commissions go unnoticed for a long time.

What helps even without software

If you do this manually, keep direct bill and agency bill as separate passes with separate notes. For direct bill, work from your book outward and list what you expected. For agency bill, work from your invoices. Keep a running list of open items with the date you raised each one. And write down the carrier's rules on timing and chargebacks once, because you will otherwise rediscover them every month.

Doing all of that every month, for every carrier, is the work we are building Lapidar to take on.

Lapidar checks carrier commission statements against your book. It is in development; to follow along, join the early access list at getlapidar.com.

Why carriers stop paying renewal commissions

LAPIDAR — Wed, 07 Oct 2026 06:56:44 +0000

When a renewal commission stops arriving, the carrier usually didn't decide to stop paying you. Something changed on the policy, on your producer record, or on the carrier's side, and the payment followed that change.

This is a list of places to look, not a diagnosis. Only the carrier can say why a particular payment didn't come, and the answer is sometimes ordinary. But if you go in knowing which of the ordinary explanations you have already ruled out, the conversation goes better.

This article assumes you have already confirmed the policy actually renewed. If you are not sure it did, start there. A policy that lapsed quietly will look exactly like a missing commission.

1. The carrier changed how it identifies the policy

A new policy number, a term suffix, a policy re-issued after a mid-term rewrite, or a move between companies in the same carrier group can all separate the renewal from the record that used to pay you. The money may well have been paid. It just isn't under the number in your book.

Before concluding anything, search the statement by insured name and renewal date, not only by policy number. Names are often truncated or reordered, so try a fragment.

2. Your appointment or codes changed

Several things live here, and they look alike from the outside:

Appointment ended. If a carrier appointment is terminated or lapses, renewal payments on existing business may continue, reduce, or stop, depending on your agreement. Read the contract. Don't assume either way.
Agency or producer codes changed. After a merger, an acquisition, a move between networks, or a name change, policies can stay attached to the old code. Commission is then paid to a code you may not be watching.
A producer left and the book was reassigned. Splits are set per producer. A policy can sit on a former producer's record and pay nothing to anyone you would expect.

If every renewal from one carrier is missing, this is the first group to check.

3. Another agent of record

When an insured signs a broker of record letter, or simply moves to another agent, the carrier may transfer the policy at the next renewal or sooner. From then on the commission goes to the new agent, while your own system may still show the policy as yours.

Whether that is legitimate depends on the paperwork. It is worth confirming the transfer was one you knew about.

4. The rate or schedule changed

Carriers revise commission schedules. A change can apply to new business, to renewals, or to both, from a stated effective date. Renewals often pay a lower rate than new business from day one, which is normal.

The useful question is whether the rate paid equals the schedule in force on the renewal date. A cut you were notified of is not an error. A cut nobody told you about is a question to ask.

5. The premium base changed

Commission is a percentage of something. If the policy was endorsed, audited, or renewed at a lower premium than you assumed, the commission shrinks without any change in rate. A renewal that looks 20% short may simply be a renewal on 20% less premium. Check the renewal declarations before you raise it.

6. The insured didn't pay, or paid late

On direct bill, commission generally follows collection. A non-payment cancellation can cancel the renewal, and a late payment moves the commission onto a later statement, so it may simply not be due yet.

Agency bill runs the other way. You may have kept a commission on a renewal that was never collected, and it could be charged back later. A missing payment and a pending chargeback can be two views of the same policy.

7. The carrier made a mistake

This happens, and it is the reason to do the check at all. A renewal can fail to load, be keyed against the wrong code, or be left out of a batch.

It belongs last on the list, though, for a practical reason: carriers will ask whether you have ruled out the ordinary causes, and a request that already answers those questions is easier to resolve.

Telling the causes apart

A rough guide, not a rule:

One renewal missing, others from that carrier paid. Look at a policy number change and the insured's payment status.
Every renewal from one carrier missing. Look at appointment status, agency code, or a statement that never arrived.
Paid, but lower than expected. Look at a schedule change, the premium base, and renewal versus new-business rate.
Policies from one producer missing. Look at the producer record, reassignment, and splits.
Paid to someone else. Look at a broker of record transfer.

When you ask the carrier

Send the policy number as it appears in your system, any number you suspect it changed to, the insured's name, the renewal effective date, the rate and amount you expected, and the statements you already checked. Ask which agency code the commission was paid to and which rate was applied.

Keep the answer. Carriers can give different answers to the same question a few months apart.

How far back you can claim depends on your agreement and, in some cases, on state rules. We can't tell you the limit for your carrier, which is a good reason not to let renewals sit unchecked for a year.

Why this is hard to keep up

Each cause above lives in a different place: the policy system, the producer records, the carrier's schedule notices, the statement itself. Finding a missing renewal means comparing every policy in your book against every statement, and the statements arrive in each carrier's own format. It is not hard in any single case. It is hard to do every month, for every carrier, without a gap.

That monthly comparison is what we are building Lapidar to do. It isn't available yet.

Lapidar checks carrier commission statements against your book. To follow along, join the early access list at getlapidar.com.

How to read a carrier commission statement

LAPIDAR — Wed, 07 Oct 2026 06:51:19 +0000

A carrier commission statement looks like a list of numbers. It is closer to a ledger written in the carrier's own shorthand. Every carrier picks its own column names, sign conventions, and ways of grouping transactions.

This article covers what most statements contain and what each part tells you. It won't make the next step easy. Reading a statement is the smaller job. Checking it against your book is the larger one.

Start with the header

Before any line item, work out whose money this is and what period it covers. The header usually carries the carrier name, your agency or producer code, the statement date, and the period in which the transactions were processed.

Three things go wrong here more often than people expect.

More than one code. An agency with several producer codes, or one that writes through a network or aggregator, can receive several statements from a single carrier. A statement you never received looks the same as commission you never earned.

Statement date versus processing date. The statement date is when the document was produced. The transactions on it may have been processed weeks earlier, and the policy effective dates can be older still.

A statement that covers only part of the carrier. Some carriers issue separate statements by line of business or by program. The one in front of you may be one of several.

The columns

Names differ, but most statements carry some version of these.

Policy number. The key everything else hangs on. It may be formatted differently from your system: a prefix, a term suffix, no dashes.
Insured name. Useful as a fallback match. Often truncated or reordered.
Transaction type. New business, renewal, endorsement, cancellation, audit, and so on. Some carriers use only abbreviations. This column largely decides which commission rate should apply.
Effective date. The date of the policy term or the transaction. It is not the date you were paid.
Premium. The premium the commission was calculated on. A statement may use written or earned premium, net or gross, and it doesn't always say which.
Rate. The commission rate applied. Some statements print it. Others leave you to divide commission by premium.
Commission. The amount paid or taken back on that line. Check the sign convention: some carriers print negatives in parentheses, some with a minus sign, some in a separate debit column.

A short example

These are invented lines from an invented carrier.

Policy	Type	Effective	Premium	Rate	Commission
EX-20114	New	Jul 8	3,200.00	15%	480.00
EX-20087-01	Renewal	Jul 1	2,100.00	10%	210.00
EX-19932	Endorsement	Jun 20	-400.00	12%	-48.00
EX-19410	Cancel	Mar 2	-1,750.00	12%	-210.00

Even four lines raise questions. The renewal paid 10%. Is that the renewal rate in your agreement? The second policy number carries a suffix your system may not have. The last line is a cancellation on a policy that went effective in March, appearing on a July statement. That is a chargeback, and it deserves its own look: was the return premium right, and was it taken at the rate it was originally paid?

Adjustments and the bottom of the page

After the policy lines, many statements add sections that don't belong to any one policy: carry-forward balances from earlier months, fees, advances, corrections. Then come the totals.

Two habits help here.

First, check that the lines add up to the total the carrier prints. A gap can mean a line was dropped when the PDF was produced, or that a prior balance has been folded in without a label.

Second, check that the total matches the deposit. On direct bill, the payment that reached your bank should equal the statement's net amount. If it doesn't, the difference needs an explanation, and you want that explanation to come from the carrier.

What usually isn't on the statement

Contingent commission is generally paid and reported separately, under its own terms, often once a year. Overrides may arrive the same way. Don't expect an ordinary monthly statement to reconcile to either.

Why the format makes it harder

Some carriers send CSV or Excel files. Many send PDFs, and a PDF is a picture of a table. Extracting it can merge columns, split a long insured name across two rows, or drop a negative sign, and a dropped sign is exactly the kind of error that survives into a total.

None of this is difficult in principle. It is slow, and each carrier has its own quirks, so the work grows with every carrier you write with.

After reading: what to compare

Reading tells you what the carrier says it paid. To know whether that is right, two checks follow:

Every line has to be matched to a policy in your book and tested against the rate you should have received.
Every policy in your book has to be accounted for in turn. The absence of a line is not visible on a statement, and absence is where a missing renewal hides.

The second check is the one people skip, because nothing on the page prompts it. A statement can be internally perfect and still be missing a policy that should be on it.

Statements and your own records also disagree for ordinary reasons: timing, policy number formats, premium bases, transfers. Some differences are legitimate and some aren't. Telling them apart is the work.

The scale problem

An agency with a handful of carriers can do this carefully for a while. As the number of carriers, producers, and codes grows, so does the number of formats to parse and the number of places a line can quietly fall out. That recurring comparison, every policy against every statement, is what we are building Lapidar to do. It isn't available yet.

Lapidar checks carrier commission statements against your book. To follow along, join the early access list at getlapidar.com.

Five ways an agency loses commission without noticing

LAPIDAR — Wed, 07 Oct 2026 06:51:18 +0000

Most commission problems don't announce themselves. The deposit arrives, the total looks about right, and the month closes. The loss, if there is one, sits inside the lines.

Here are five patterns worth knowing. None is exotic, and several have a legitimate version, which is what makes them hard. We're building Lapidar, a tool that checks statements against an agency's book. It isn't available yet, so this is about the problem, not a product.

This is written for property and casualty business. Life and health commissions have their own rules.

1. A chargeback that is wrong

A chargeback is commission the carrier takes back, usually because premium went back to the insured: a cancellation, an endorsement that lowers premium, an audit. Most are legitimate. The amount should normally equal the returned premium times the rate the commission was originally paid at.

It goes wrong when the rate differs from the original, when the return premium isn't the one on the cancellation, or when the event is not one you can find. A policy paid at 12% shouldn't be charged back at 15%.

Take an invented example: $500 returned premium, paid at 12%. The expected chargeback is $60. If the statement shows $75, that is $15 you will not notice unless you look at that line and know the original rate.

Chargebacks also arrive late. Audits happen after the term ends, and backdated cancellations can show up a month or more after you expect them. That is why a list of your own cancellations and premium-reducing changes helps: a negative line then matches something you already know about.

2. A commission paid twice, or a chargeback taken twice

Duplicates run in both directions. A carrier can pay the same commission on two statements, which feels like a gain until it is reversed later, sometimes months later, as a correction. Or a chargeback can appear on one statement and again on the next.

Neither shows up when you read one statement alone. You have to look across several months. The first kind is a surprise waiting to happen. The second is money you have to claim back.

3. The wrong rate

Commission is premium times rate, and the rate is where errors hide, because many statements don't print it. You divide commission by premium and compare the result with what you should have been paid.

"What you should have been paid" is itself not simple. Schedules change on effective dates. Renewals often pay less than new business. Different producers can have different splits, and a rewrite can reset the transaction type. A rate that looks wrong may be right under a schedule you forgot about, and one that looks fine may be a quiet cut.

The question to ask is whether the rate paid equals the schedule in force on the effective date. If you were told about a reduction, it is not an error. If you weren't, it is a question for the carrier.

4. Policies that aren't in your book

Some lines on a statement match nothing in your management system: a policy number you don't recognize, or a familiar insured under a new number. There are legitimate reasons. A renumbered policy, a transfer into your agency, a policy written outside your system.

There is also the reverse worry: policies you wrote that the carrier has no record of paying you for. Either way, the work is the same. Every statement line needs a home in your book, and unmatched lines need an explanation instead of a shrug. If they sit unexplained, you can't tell a harmless mismatch from money paid to the wrong place.

5. Renewals that never arrive

This one is invisible by construction. A missing renewal is not a wrong line. It is a line that isn't there, so nothing on the statement prompts you to look.

The reasons are usually ordinary: a changed policy number, an appointment or agency code that changed, a broker of record transfer, a lower premium base, an insured who paid late. Sometimes it is a carrier error. Working out which means starting from your book of policies renewing this month and checking each against the statement, rather than starting from the statement.

Because renewals recur, an unchecked one costs you again next year, and how far back you can claim depends on your agreement and sometimes state rules. We can't tell you the limit for your carrier.

What the five have in common

Each needs a comparison between two things that were never designed to be compared: the carrier's statement, in the carrier's format, and your own records, in yours. Each also has an innocent version, so a mismatch alone proves nothing. You have to find the cause before you can decide whether to raise it.

And none of it is hard in a single case. What makes it a real job is repetition: every carrier, every month, every policy, with the formats changing and PDFs dropping a sign now and then.

A reasonable starting point

If you do nothing else, keep your own list of cancellations and premium-reducing changes, note the rate each commission was paid at, and look at renewals from your book rather than from the statements. Those three habits turn several of the patterns above from invisible into visible. They won't cover everything, and they take time.

Reconciling every line against your book each month is the work we're building Lapidar to do.

Lapidar checks carrier commission statements against your book. To follow along, join the early access list at getlapidar.com.