“Bordereau Mapping”, the process of creating rules to transform a bordereau into a system or data standard, has long been the main issue associated with capturing data relating to delegated underwriting authorities. 

The tools used by insurers and brokers today to manipulate, standardise and validate bordereau data require excessive amount of manual effort to consistently work over time and, as is often the case, scope is reduced to facilitate any form of success. The process is time-consuming, prone to error and misinterpretation which has historically best been performed by costly, skilled resources at Managing Agents who are required to have technical and business knowledge.

This is unworkable across a market with thousands of spreadsheet formats and to compound the problem, the people tasked with extracting the data are not those who created it. They are at least one step removed, such as Insurers and Brokers or even further removed such as an outsourced service provider (who require approval from the Insurers and Brokers for all mappings). Such as situation leads to assumptions being made when questions arise to avoid the otherwise complex and time-consuming query process involving the Coverholder or TPA.

In 2017, with autonomous cars, hover-bikes and job stealing robots just around the corner, surely there is a better approach?