Reconciling direct bill commission statements against the policy records
Some carriers deliver the direct bill commission statement through download, so AMS360 or Applied Epic can auto match most rows against policy transactions. The rest arrive as portal PDFs in whatever column order the report writer chose. What survives auto matching is the interesting part: a statement line with no policy behind it, or an amount that disagrees with the rate recorded for that carrier and line. Hardest is the row that never came, because a policy that paid nothing raises no exception anywhere.
A certificate request arrives as a sentence in an email, and answering it correctly requires deciding which endorsements the policy actually grants.
The agency management system is the record, and a standardised download feed keeps parts of it current. The feed is positional flat file in origin, its coverage varies by carrier and by line of business, and a policy that arrives without matching an existing record lands in a queue somebody clears by hand.
- Vertafore AMS360
- Applied Epic
- Excel
When this is the wrong thing to build
Pick something else if nobody has written down what each carrier pays by line. Without that table the work can only find rows that disagree with each other, never rows that disagree with the agreement, and building the table is the actual first project.
The constraint that shapes it
Producing a quote or binding coverage happens under a licence that is issued per state and per line, and separately under a carrier appointment, so a person can be licensed without being appointed. More on how this sector works.
Two sources of truth. One queue of the rows that do not line up. Read what this shape is, or start from one of these.
- Rebuilding an annual operating expense reconciliation from the lease
- Reconciling a broker trust account three ways every month
- Matching a closed transaction back to the lead that produced it
- Collapsing two overlapping MLS feeds into one property list
- Widening a conflicts search past exact spelling
- Rebuilding a billable day from the trail the systems already keep
- How do I find commission a carrier never paid on an active policy?
- What causes unmatched lines on a direct bill commission statement download?
- Can I import a carrier commission PDF into Applied Epic reconciliation?
- Why does the commission amount differ from the rate in the policy record?
- How do agencies reconcile statements from carriers with no commission download?
Back to insurance agencies, or see how this is priced and scoped.