Bordereaux reporting

OWIT Global Blog

How to Overcome Bordereaux Reporting Challenges

On Aug 1, 2018

Since the 1880’s when Lloyds of London wrote its first reinsurance policy, the use of bordereaux reports has been to report policy, cash and eventually claim transactions from the agents/brokers conducting business “on behalf of” the underwriters/reinsurers who are ultimately responsible for the risk. 

Despite replacing the original manual report generation by applying modern technologies to generate and deliver bordereaux reports, efficient and accurate bordereaux file processing has remained elusive in the insurance industry.

A significant challenge has been how data is both cumulated and absorbed in the value chain.  MGA/MGUs struggle to get data from existing solutions into formats suitable for their multiple carriers, and carriers have difficulty efficiently and accurately absorbing the report data to transform it into “actionable data”.  Whether it’s determining how much premium is due, or what claims are being paid, the actual creation, distribution and absorption of data via bordereaux files still remains a manually intensive process. 

While the insurance industry has made great strides in defining standardized data sets to be used by trading partners, the adoption of these data sets has been slow.  Even when standardized formats for reporting are used, the issue of data disparity still exists.  Most of the stakeholders in this data-sharing scenario, have not fully implemented standardized data standards in their internal systems. The reasons are varied, with often cited factors being the high cost and effort required to updating existing and functioning systems.

Whether it’s a Microsoft Excel file, a CSV file or a database, the ideal systems are capable of quickly and easily mapping and converting the data to a normalized data standard and format.  Companies might consider defining and managing new solutions to support this need. 

For example, pre-defined business rules can assist in converting the data without the high costs of IT and data migration specialists, resulting in a much quicker turn-around time from the point a new bordereaux file format is created until the data is usable by the receiver.


While bordereaux reporting has long been a challenge for insurers, today’s modern technologies offer new tools and methods to streamline and finally tackle the bordereaux reporting conundrum.

Neal Quiros

By Neal Quiros

Neal plays a vital role in the solution design, build and implementation for OWIT Global customers, with the goal of meeting and exceeding each client’s unique automation needs. Neal also has an integral role in setting standards for the company’s business analysis process. With 35+ years of insurance industry experience Neal offers an impressive depth of knowledge and experience derived from his successful IT implementation projects with carriers and intermediaries in the industry. Prior to joining OWIT Global, Neal was most recently the Americas Insurance Solutions Director with UniRisx Ltd. During his long career he has also been instrumental in helping insurance industry companies transform their operations while at IVANS as a Solutions Analyst, a Software Solutions Consultant at Ebix, and a Solutions Analyst at IVANS. He began his insurance career managing commercial lines claims operations for CNA, eventually being named Assistant Vice President overseeing claims operations for Florida.

Blog Comments