Best Method to Integrate Your IBOR and ABOR Data

The Best Method to Integrate Your IBOR and ABOR Data

Integration of a firm’s Investment Book of Record (IBOR) with its Accounting Book of Record (ABOR) is consistently one of the most complex and important data management challenges for insurance investment organizations. Properly unified information from each of these systems is critical to investment decision-making by front-office personnel.

IBOR and ABOR systems occupy their own space within the insurer’s technology stack and cater to different user groups with differentiated needs, knowledge, and skill sets.  

IBOR systems provide portfolio managers with a robust security master enriched with market data, security analytics, risk calculations, compliance, and trading optimization tools.  

ABOR systems emphasize tax lot calculations like book values, accretion, and gains/losses.  

Depending on each specific system’s capabilities, insurance companies also need to make considerations for regulatory reporting, NAIC ratings, capital charges, and agency reporting, which requires an integration of ABOR and IBOR data.  

The IBOR/ABOR integration challenge

Integration of these data sets is a common obstacle for insurance companies given the varying levels of granularity and lack of a one-to-one relationship across data sources.  

Many-to-one and one-to-many data relationships require specific methodologies to  calculate averages, weighted averages, and aggregate other data points. Standard aggregation methodologies are not well defined across the industry; therefore, firms must create their policies and programmatically automate the calculations to ensure the policies are adopted at an enterprise level within the organization.  

In cases where both systems do exhibit matched granularity, there is still a challenge to appropriately map  data records  across  systems.  Within the insurance space, one common challenge is mapping tax lots across various systems. This is just as much a workflow and process consideration as it is a technology issue. Proper procedures must be enacted, governed, and followed to ensure that required data flows into respective systems at each stage of its lifecycle, and that data flows appropriately and consistently between systems. 

Solution: Centralized business logic

There are many options to address these challenges depending on the resources available to the organization. The crux of the discussion typically revolves around the need for business logic, how it should be constructed and maintained, and where it should be deployed into a larger data pipeline.  

In general, the preferred method should be an option that centralizes all the necessary logic to a single location that has access to all the necessary data inputs.  

In many organizations, this takes the form of a data warehouse. This has the benefit of codifying centralized logic into data structures, archival of all inputs and outputs, robust auditing, and support to downstream processes to deliver files or populate reports. 

Other options that could include the encapsulation of business logic into the reporting layer, desktop tools, or any manual task are sub-optimal in almost any scenario.

Data Flows

data flows
Simplified investment data flows, exhibiting the differentiation of data sets, the need for a "hub," in this case a data warehouse, and the requirement to further disseminate that data downstream.

Achieving a ‘gold copy’

One key capability provided by the centralization of business logic to a holistic data warehouse is that data source hierarchies must be robustly maintained.  

ABOR and IBOR have broad sets of data unique to each system, but there is considerable overlap between the two as well.  

Given there are data fields that may exist in both systems, it is imperative to have a mechanism to dictate the preferred source, secondary, tertiary, and subordinate sources for each data element. Records that are cleansed and processed in this manner are typically referred to as “gold copy” data. 

In insurance portfolios, where accounting drives much of the investment process, ABOR is likely to be the primary source for most inputs covered by the system, while IBOR would be the primary source for the rest.  

In a consolidated data set from these two sources, a single data element could have lineage back to either system. When users work with this data, they should understand the provenance of these outputs, elevating the need for reporting metadata alongside any report data set. 

Here is an example that shows how a data source hierarchy can be established for any field (e.g. Duration and Rating), with the hierarchy value indicating the order of evaluation. 

Data Source Hierarchy

data source hierarchy

The primary source for Duration is IBOR, and it has provided a value, so it gets chosen. ABOR is the primary choice for Rating, but the value is not available, so the logic moves to the second choice, which is IBOR.  

The source of the data values can change over time depending on the availability of data. It is critical to report the metadata explaining the lineage of each field, as illustrated in the third table. 

Take the next step to integrate your IBOR/ABOR data

Integrating ABOR and IBOR data is just one of many data challenges facing insurers. Read more about these challenges – and innovative solutions – in our ebook, Solving Investment Data Challenges for Insurers

ABOUT GRANDVIEW ANALYTICS

Grandview Analytics is a technology consulting and data management software company serving financial institutions. We offer data strategy, technology implementation, systems integration, and analytics consulting services as well as an outsourced data management and reporting service powered by our proprietary, cloud-based platform, Rivvit.

Our services drive improved business processes, integrated technologies, accurate and timely data, and enhanced decision-making capabilities. Our seasoned team of financial industry professionals brings deep business and technical domain expertise across asset classes and trade lifecycle. With hands-on financial industry experience, we execute on complex initiatives that help clients optimize ROI on data and technology investments.

Share:

RECENT NEWS

Adding Value When Putting Data Technologies Together

Grandview CEO Matt Biver moderates a CDO and Data Leaders’ Summit 2023 panel discussion sharing perspectives on enterprise data management as a function and how to plan for value when executing transformation initiatives.