Direct bill reconciliation for independent agencies: the month-end steps, and where they stall

TL;DR

• Three records have to agree for every carrier and every month: the statement, your AMS and the bank deposit. Two agreeing proves less than it seems.
• The order matters. Tie the statement to the deposit, match every line, decide every exception, post, and only then release producer pay.
• Every unmatched line gets a reason: a transaction missing from your AMS, a carrier error, or timing. Anything unresolved goes on an open-items log that carries into next month.
• A carrier download moves statement data into your system. It can’t judge it, and it can’t carry what the carrier never sent.
• It stalls at scale because volume, formats and exceptions multiply, and each step waits on the one before.

We’re building Lapidar, a service meant to take much of this work over. It isn’t ready yet. This guide is about the order of the month-end steps and where they stop. For how the two billing types differ, see direct bill vs agency bill commissions; for the checks on each statement line, carrier commission statement reconciliation; for agency bill, how agency bill reconciliation differs from direct bill.

What it means in an agency: three records that must agree

On direct bill business the carrier bills the insured, collects the premium and pays your commission later, on a statement. Direct bill reconciliation is the month-end job of showing that the commission you received is the commission you were owed. Three separate records describe the same money:

• The carrier’s statement. What the carrier says it paid for the period, line by line, on its commission statement.
• Your agency management system. The policies and transactions in your AMS that should produce commission: new business, renewals, endorsements, cancellations and installments.
• The bank deposit. What actually reached the agency’s account.

Any two of these can agree while the third doesn’t. A statement can tie to the deposit to the cent and still leave out a renewal that is sitting in your AMS. It can match your AMS line for line while the deposit comes in short, because a chargeback from another statement was netted out of the same transfer. The month is reconciled when all three agree, or when every disagreement has a written reason and an owner.

Step 1: Collect the month’s statements

Statements don’t arrive together, or the same way. Some carriers send statement data as a download straight into your AMS. Others post a PDF or CSV on their agent portal, and someone has to log in, find it and save it. A statement that never came doesn’t announce itself.

So the month starts with a list rather than with matching: which carriers should have produced a direct bill statement for the period, which ones have, and in what form. That list has been getting longer. The 2026 Agency Universe Study found that independent agencies averaged 19.7 carrier appointments across all lines in 2025, up from 17.2 in 2024 (IA Magazine, October 2026). Not every appointment produces a direct bill statement every month, but an agency near that average collects statements from many carriers, each with its own layout and timing.

Downloads help where they exist. ACORD publishes its property and casualty standards in two formats, AL3 and XML, and describes AL3 as a one-way, batch method for carrying “policy and commission data”; its list of AL3 documents includes a separate standard for direct bill commission statement downloads (ACORD). What an AL3 file carries is explained in what is an AL3 file. Whether you receive one depends on whether a given carrier sends it for a given line, and on whether your system is set up to take it in. Where either is missing, the statement is a file someone has to fetch and read.

Step 2: Tie each statement total to the deposit

Before any line is matched, check that the statement describes money that actually arrived. That is less direct than comparing two numbers, for two reasons.

• One deposit can cover several statements. A carrier may send separate statements for different lines or agency codes and pay them in a single transfer, so no single statement equals the deposit.
• The deposit is net. Chargebacks and other adjustments come out before the money moves, so the deposit is smaller than the commission lines added together.

Against statement A alone, the deposit looks $2,960.00 too high; against both statements together it ties to the cent. A deposit that won’t tie becomes an open item of its own: a statement you haven’t collected, a payment split across two transfers, or a deduction nobody has explained. Posting waits until it is understood.

A tie-out shows the carrier paid what its statement says it paid. It says nothing about whether the statement contains everything it should. That is what the next three steps are for.

Step 3: Match every line to a policy and a transaction

Each statement line should land on a specific policy in your AMS and, where a policy has several transactions in the period, on the one that produced it: the renewal, the endorsement, the cancellation or the installment. Match a renewal and a mid-term change to the policy alone and the amounts get netted in the wrong place, which surfaces months later.

Carriers write policy numbers with their own prefixes and suffixes, report under different agency or producer codes, and pay on collection dates that put a transaction in a different month from your records. We go through those causes in why statements don’t match your agency management system.

Then run the match the other way. Start from your AMS and list the transactions that should have produced commission this period and have no line on any statement. A statement shows what the carrier paid and never what it left out, so this direction is the only one that finds a missing renewal commission.

Step 4: Decide every line that doesn’t match

An unmatched line, in either direction, isn’t finished until someone has decided why. Three reasons cover most of them:

• The transaction is missing from your AMS. The carrier processed something your records don’t have, such as an endorsement that was never entered, or a policy rewritten under a new number. Your records are behind: enter the transaction, then match.
• The carrier made an error. A line paid twice, or commission on another agency’s policy. Record it and raise it.
• It’s timing. The transaction is correct but belongs to another period: an installment not yet collected, a cancellation not yet processed, a renewal effective at month-end. Note which statement it should appear on, and check that it does.

Write each decision down with who made it and on what evidence. A decision nobody recorded gets made again next month, possibly differently.

Step 5: Paid against expected

A matched line has found its policy. That doesn’t make the amount right. Every matched line still needs its commissionable premium and rate checked against your own schedule, not the rate printed on the statement. A renewal can match its policy exactly and still be paid at 10% where your schedule says 12%. Those checks are in what you expected to be paid, with installments covered in what to check on a direct bill statement and rate differences in the rate isn’t the rate you think.

Step 6: Post, then release producer payables

Once the statement ties to the deposit and every line is either matched or decided, the receipt can be posted against the transactions in your AMS. Producer pay comes after that, not before.

The order matters because a producer split is usually calculated from the commission the agency received. Post a statement with undecided lines and every error flows into producer statements: a short-paid renewal becomes a short-paid producer, and a duplicate becomes producer pay that has to be recovered when the carrier reverses it. Chargebacks pass through the same way, as commission chargebacks explained describes.

Lines still open at month-end need a rule: hold the producer share on disputed amounts, or pay on what was received and adjust later. Which rule applies is a matter for your producer agreements; the reconciliation needs it to be the same every month. We go through split rules, chargebacks and orphan lines in producer commission splits.

Step 7: Carry open items forward, then raise them with the carrier

Month-end rarely closes with nothing open. Timing items, deposits that didn’t tie and carrier errors roll into the next month, and the open-items log is what lets next month start where this one stopped. For each item it needs the policy, the statement and line (or the fact that there is no line), the amounts expected and paid, the reason, when it was raised and with whom, who owns it on your side, and the statement where the correction should appear.

Next month starts with that log, before the new statements: did the timing items arrive, did the promised corrections land, and is anything old enough to escalate? An item raised once and never followed up costs as much as one nobody noticed.

Carrier errors need enough detail for the carrier to act on them; what to include is set out in raising it with the carrier.

What a download changes, and what it doesn’t

Where a carrier sends its direct bill commission statement as a download, the data reaches your AMS without anyone keying it in, and one download network presents this as a way to automate the monthly commission process and get commissions reconciled each month (Ivans). Even so, a download can only carry what the carrier sends: if a cancellation never comes through, your AMS still shows the policy in force and keeps expecting commission on it, and that phantom commission shows up as missing until someone confirms the policy’s status with the carrier. The other gaps are in what a download can’t tell you; the download moves the work from typing to checking, and the checking is still there.

Why this is hard at scale

Each step above is manageable for one statement. Month-end is every step, for every carrier, at once, and three things multiply each other:

• Volume. More carriers, more lines per statement, more installment policies, each a separate line to match.
• Formats. Each carrier has its own layout, policy-number habits and transaction codes, and a layout change breaks whatever worked last month.
• Exceptions. Every unmatched line needs a decision, and open items from earlier months come back alongside the new statements.

The steps also wait on each other. A deposit that won’t tie holds up posting, posting holds up producer pay, and one unexplained line can hold up the close for a whole statement. When the month runs long, the usual shortcut is to stop at the tie-out: the deposit matches, so the statement is called reconciled. That is how a missing renewal or a wrong rate goes unnoticed for months.

The cost isn’t only hours. An IA Magazine piece from September 2026 lists the checking agents end up doing themselves (setting statements against carrier reports, following policy activity, checking renewals, chasing the reason a payment changed) and points out that verifying commission eats into time for clients and new business even when nothing turns out to be wrong (IA Magazine, September 2026).

Where Lapidar fits

The parts of this workflow that don’t scale by hand are reading each carrier’s PDF or CSV statement, matching every line to your book in both directions, checking paid against expected, and keeping open items alive until they are settled. That’s the work we’re building Lapidar to take over, inside the Lapidar web app, beside your AMS rather than in place of it. Lapidar is in development and not live, it has no customers yet, and we’ll say so until that changes. For what a full check of past statements involves, see commission audits for independent agencies. If you’d like to try Lapidar when it’s ready, the early-access list is below.

Frequently asked questions

Is direct bill reconciliation the same as commission reconciliation?

It is one part of it. Commission reconciliation covers every way commission reaches the agency, including agency bill and payments that aren’t tied to a single policy, such as contingent commission. Direct bill reconciliation is the monthly workflow for commission that carriers pay on policies they bill themselves: making the statement, your AMS and the deposit agree, then posting, paying producers and carrying open items forward.

Does my AMS do direct bill reconciliation?

Partly, depending on the system and how it is set up. Some systems can receive downloaded statements, post receipts and list lines they could not match. What a system cannot do by itself is decide why a line doesn’t match, or notice commission that never produced a line at all. Our page on whether your AMS reconciles commissions lists the questions to ask your vendor.

How long should direct bill reconciliation take?

There is no reliable benchmark, and we won’t invent one. It depends on how many carriers send you direct bill statements, how many arrive as PDFs rather than downloads, how many lines each one carries, and how many exceptions are still open from earlier months. A more useful thing to watch is the open-items log: if it grows every month, the process isn’t keeping up.

Sources

1. ACORD, Property & Casualty Data Standards.
2. Ivans, Ivans Download for Agents, product page.
3. IA Magazine, What Compensation Administration Means to the Agent-Carrier Relationship, September 16, 2026.
4. IA Magazine, Evolving Channel: Key Findings From the 2026 Agency Universe Study, October 1, 2026.

All four pages were checked on October 7, 2026.

Lapidar is commission reconciliation software for independent insurance agencies, in development. Related: carrier commission statement reconciliation, step by step.