Our work / Case study

A commission statement reader for Robert Nichols Insurance Group.

Every month, an independent agency gets a commission statement from each carrier it writes with, and someone checks them line by line. We built a reader that does the first pass.

Client
Robert Nichols Insurance Group
Location
Jupiter, FL
Industry
Insurance agency
What we built
Commission statement reader

Where the hours go.

Carrier statements arrive as PDFs, each laid out differently. Checking them means retyping policy numbers and amounts, then comparing them to what the agency expected.

The reader takes the statement as it arrives, pulls out every line, and checks each one against its own stated rate, so a person only looks at the lines that do not add up.

What we built.

  • Reads the statement as sent

    No reformatting and no setup per carrier. Upload the statement and every line is pulled out.

  • Checks every line

    Each line is recalculated from its own rate, and the lines must add up to the printed total.

  • The right premium

    Many statements print two premiums. Commission is checked against the one it is actually paid on.

  • Exceptions for a person

    Only the lines that do not add up go to someone to review.

  • Calculation only

    It checks and reports. No money moves through it.

Where it stands.

On the first real statement it saw, it read all 14 lines exactly and matched the printed total on the first try, in about 40 seconds.

A 247-line statement from a second carrier also tied on the first try. Across both, 13 of 261 lines needed a person to look at them.

Have a project like this? Let’s talk it through.

Thirty minutes, in person in Sioux Falls or on a call. No commitment, no pitch.

Book a free call

Thirty minutes, and we come prepared. No commitment, no pitch.

Book a Free Call

Send a message

Tell us what you are working on. We reply within one business day.