Time to Retire Retro Reconciliation Tools?

Despite being one of the most fundamental business processes an insurance company performs, reconciliation retains a relatively low-tech reputation. This seems especially true if reconciliation is held up against other core systems such as policy administration and claims systems, which have been the beneficiaries of much new technological blood in recent years. Even with new reconciliation technologies available, many companies cling to manual methods of assuring that correct and legitimate data is posting to their financial systems. Addison, Texas-based Trintech Group PLC estimates that as of 2004, more than half of all reconciliation processes were done with spreadsheet tools, semi-manual and manual processes, or partially by systems of record. As of 2007, Trintech estimates that only 20% of these manual activities had been converted to automated systems.

Yet, this may be changing. According to Trintech, spending on reconciliation and transaction process management solutions by insurance companies is growing faster than overall IT spending.

Two large forces may be behind this trend. The first, largely external, force is the advent of tougher compliance regulations for insurance companies. If the passage of the Sarbanes-Oxley Act, which mandated more stringent requirements for sign-off and reporting, didn't convince insurers that the time is right to leave manual reconciliation processes behind, pending solvency requirements in Europe, and tightening accounting standards both here and abroad, may well do the trick.

The second driver is the realization that financial reconciliation data is an important feedstock for the business intelligence and predictive analytic efforts becoming increasingly prevalent within insurance operations. A modern reconciliation system can help insurers transmute raw data into actionable decision-support information.

TAKING THE PLUNGE

Automating any long-standing manual process rarely is routine, especially in an industry as prone to exceptions as insurance. With everything from agent commission to the bank accounts tied in to a reconciliation system, they are inherently complex.

Minneapolis-based Allianz Life Insurance Co. of North America was looking for a new reconciliation solution to increase capacity, meet aggressive accounting closing periods, better manage exceptions and reduce financial risk. At the time it decided to upgrade, Allianz' reconciliation procedures were done using a spreadsheet program, which consisted of several manual, time-intensive processes. In some instances, the reconcilers were dealing with more than 60,000 transactions in a day, which was difficult with a spreadsheet program, recalls Marc Olson, controller for Allianz.

For Allianz, the move to update its reconciliation process was catalyzed as the company looked to migrate to a common general ledger in light of the company's acquisition of Fireman's Fund Insurance Co., Novato, Calif.

Allianz constructed a proof of concept test case for all three vendors vying for the account, which included sample files, use cases and requirements. One test case called for a reconciliation of 55,000 lines of detail that had to be balanced to zero on a daily basis.

As senior engagement manager for Trintech, Brad Alexander led a team that fulfilled the RFP to Allianz. Though originally designed for the retail environment, Trintech's reconciliation engine, ReconNet, is well suited for financial services industries such as insurance, Alexander says.

However, the minutiae of the insurance industry did present some unique challenges. "Going in to Allianz, it was a bit of a new environment for us," he says. "We had not seen these sorts of reconciliations before. Where a retailer may reconcile source balances monthly, an insurer will do it daily. They want to tie back to the ledger every day."

THE IMPLEMENTATION

Allianz ultimately opted to go with Trintech. To Alexander and his team, which included a project manager and configuration specialist, this meant spending time in Minneapolis to familiarize themselves with Allianz's business before the ReconNet installation. Alexander says that, based on the sheer number of reconciliations Allianz had, the team decided that a phased approach would work best. Phase one would target 80 accounts.

To ease the implementation, the Trintech team would spend an entire day meeting with each business process owner, making sure they had the specifics down, Alexander says.

By meeting with process owners on site, the Trintech team was able to whiteboard and construct process charts to get a jump on the implementation. "We wanted to configure our software to meet their business processes," he explains. "But there's always some give and take when you move from a manual to an automated process."

Indeed, Alexander stresses that this communication is a two-way street, and in addition to listening to the process owners, his team also had to educate them about product features, functionality and methodology. "We have a standard implementation methodology that we use regardless of industry or project size," he says.

THE BIG CHALLENGE

As any project manager can attest, a large gap exists between a whiteboard and a completed implementation. The primary challenge for an insurer looking to implement an automated reconciliation product may well be assembling the data from a host of disparate systems.

"We needed files from all their core systems," Alexander recalls. "We met with the IT side and said 'these are the files we are going to need.' They knew it was coming."

Dealing with multiple legacy systems also presented some issues with timing, Alexander adds. Data sources that were relatively static were now being forced into a more transactional mode. "The multitude of source systems were inconsistent when they generated files," he says, adding that practices common in manual reconciliation, such as the future-dating of items, can throw off balances once automated.

"When going from a manual to automated environment, we came across exceptions with their systems," he says. "It's a little bit of back and forth to get what you need, but in the end we got there."

Moreover, many of the exceptions at an insurance company may be more implicit than explicit. No amount of whiteboarding, it seems, can ferret out every last known exception locked in an accountant's head. Indeed, enumerating business rules and recreating them in the automated environment is a large part of the implementation process.

THE PROGRESS

Trintech's ReconNet product is a hosted one. The goal, says Alexander, is to make reconciliation system work more like the ledger, with which it is mated. "They have to FTP us files everyday," he says.

With the implementation of the hosted solution, the data is sent from Allianz feeder systems and the ledger to ReconNet on a daily basis where it performs an automatic matching process based on specific criteria designed by the insurer. On a typical day, the reconciliations are updated overnight, and are ready for review and follow-up by the start of the next business day. As a result, the time spent on clearing each item has significantly decreased, which has provided greater efficiencies throughout the process, Olson says.

"Our reconciliation process has definitely become more automated with the implementation of ReconNet," Olson states, adding that currently, about 80% of the Allianz Life reconciliations performed in its treasury are completed using ReconNet. "It's enabled us to complete reconciliations timely and accurately and has the potential to extend the solution to other areas within the organization."

(c) 2009 Insurance Networking News and SourceMedia, Inc. All Rights Reserved.

For reprint and licensing requests for this article, click here.
Analytics Security risk Policy adminstration Compliance Data and information management
MORE FROM DIGITAL INSURANCE