Robotic Process Automation for Insurance: Direct Bill Commissions Reconciliations

The Lab Consulting

Do you really still have people performing these rote, error-prone chores?

“Reconciliation” is just a fancy word for “making sure things match.” It’s an essential  cross-checking chore that can be found in all industries. In insurance, you need to make sure that numbers from one source—say a carrier’s commission statement—match those in another—such as your brokerage’s online platform.

That’s exactly what we’ll explore—and automate—in this article. Indeed, this article is a companion to this video, which provides a screen-capture recording of the robot in action:

Different carriers, different statements

Any brokerage receives commission statements—what it uses to help pay its agents—from its different carriers each month. And each month, a human must devote a lot of time to poring through each statement, line-by-line, and making sure that the “commissions paid” match what were previously calculated in the brokerage’s online booking platform. If they match, they get logged as such.

If they don’t match, that’s a red flag. It means it’s time to take action and check for errors, either on the brokerage’s side or the carrier’s side.

And do you think that all those different carriers have agreed on a standard format for their statements? Of course not. This compounds the complexity of the challenge.

So to recap: Each month, a worker at the brokerage gets a stack of uniquely formatted commission statements, in PDF form. Then it becomes a grueling “side-by-side” chore:

  • Park the PDF on one side of your screen.
  • Log into the online platform on the other side of your screen.
  • Look at the PDF for the first commission and agent. Jot down the “commission paid”—or better yet, copy it to your computer’s clipboard.
  • Find that same commission and agent in the online platform. Look at the projected commission.
  • Check your notes. See if they match.
  • If they match, type (or paste) in the correct number, and move on to the next.
  • If they don’t, make a big note of that so you can address it afterward.

As you can see, this is time-consuming and error-prone. In fact, it takes the average knowledge worker (who’s hardly an “average” person; they’re highly trained and paid) about ten minutes to process just one statement. And given all the searching, noting, comparing, copying, and pasting, human workers generate a ten- to 15-percent error rate.

Insurance robotic process automation to the rescue

The Lab is able to configure a special robot—actually, just a small software program—to do everything that the human worker does, only faster and error-free.

Think of the robot as “just another worker,” only one that never tires, takes breaks, makes mistakes, or complains. It has its own log-in and password for the online system. And so it does just what the human did, only better:

  • It doesn’t have to work line-by-line. It memorizes the entire commission-statement PDF first.
  • Then it logs in, compares each commission, and pastes in the correct amount.
  • If the amounts don’t match, it pastes them into an “Exception report” Microsoft Notepad document.
  • It also creates a new Excel spreadsheet, logging all the info from its work. Isn’t that a nice touch for reporting?

But wait—what about all those different carrier-specific formats? Not a problem. The Lab simply configured different versions of the same bot to handle each one.

Real numbers, real results

The Lab can configure a robot like this, start to finish, in about two weeks. And where a human takes ten minutes, the bot does the work in 50 seconds! While humans generate a a ten- to 15-percent error rate, the bot’s error rate is zero. Not only that, but The Lab has scores of insurance bots ready to get to work for you!

And you might be surprised to learn that human workers love robots—because they free them up for higher-value activities.

Insurance executives are turning to The Lab to accelerate automation/AI readiness, lay the groundwork for strategic end-to-end process/product innovation, and implement Robotic Process Automation (RPA) “bots” to automate dozens of processes. With as few as three RPA bots from The Lab, you, too, can begin implementing on your company-wide strategic innovation roadmap—and start seeing hard-dollar benefits within weeks.

The best way to appreciate the speed and game-changing power of the automation suites installed by The Lab is to see it for yourself. Schedule a free, no-obligation 30-minute screen-sharing demo with The Lab, and you’ll see RPA bots in action. You’ll learn how we do all this from our U.S. offices in Houston, with nothing outsourced or offshored, and get all your questions answered by our friendly experts. Hedge your company against employee turnover, eliminate errors, and put your organization on a roadmap to accelerate your automation and AI initiatives. Simply call (201) 526-1200 or email to book your demo today!

Also check out the following articles on how we can help to digitize your insurance operation:





Schedule a call