

Lloyds of London – The Business Challenge
The London market could benefit from greater levels of digitization and automation. The widespread usage of spreadsheets across the network was cumbersome and Lloyds required a partner that could convert this multitude of data into cloud-based systems using low code software.
- Lloyds has over 150 insurers covering risks for the world’s biggest catastrophe claims.
- Lloyds were receiving more and more data requests from overseas regulators and the expectations from those regulators was increasing - both in terms of the frequency of their data requests, and the size of the data sets that needed to be collected.
- Approved data need to be shared to different governments and regulators in their own unique formats
- For the Lloyd’s claims team to meet these data requests, a solution was required that would remove the arduous manual functions of collecting data, checking, and validating catastrophe data from Excel spreadsheets
- Existing processes were time consuming inefficient and often inaccurate
- Lloyds of London needed and automated Solution
Lloyds of London - Profile
Lloyd's is one of the world's oldest and most established international insurance and reinsurance markets in the world, transacting business worth billions of pounds in premiums every year. Lloyd's is a broker market.
- Incorporated: 1871 as Society of Lloyd's
- Employees: 2,042
- Total Assets: As of 2019 this consisted of £52.8 billion of syndicate-level assets, £27.6bn of members' "funds at Lloyd's" and over £4.4bn in a third mutual link which includes the Central Fund.
The Optalitix Solution:
Optalitix developed a low code product that converted claims spreadsheets into a cloud-based system and gave insurers an easy-to-use interface for them to submit their reports. Optalitix engaged with market members, both managing agents and third-party administrators to integrate them into the process and in so doing built a very successful portal incorporating feedback from the market.
- The portal automatically and immediately validates data admissions from Insurers with visible flags appearing for any data errors. With data being checked upon submission, it gives the insurer the ability to correct any errors before it reaches the Claims Team, saving wasted time chasing insurers
- Validation rules and flexible checking were also built in, Lloyd’s can amend these rules as risks underwritten change, futureproofing the portal.
- The system is simple to use and very secure - having passed Lloyd’s security and penetration testing requirements.
- The system was built in two months
Optalitix Models Value
Value to Lloyds of London- Lloyds were spending thousands of hours each year dealing with and validating catastrophe claims data and providing reports to regulators manually. The new Portal removed the data validation bottleneck, finding invalid data and chasing Insurers for updated submissions significantly reduced. Data is checked upon submission, at the source not the destination, with visual flags highlighting any invalid to Insurers Optalitix models creates a master template that combines all possible data fields and sends accompanying instructions on which fields need to be populated per event. This has to reduces bureaucracy, and significantly limits the time spent on data entry. Insurers have more capacity to better analyse claims data and to look for opportunities to improve claims performance.Value to Regulators Regulators as they are getting clearer more accurate claims data. Regulators are also accessing better insight into total damage sooner by region, which is important considering the devastating impact that Hurricanes, firestorms and windstorms can have on communities.
Success and Outcomes
- 110 External users on the system
- 13000 Admin hours saved each year
- $1000000 in saved revenue each year
- $3Billion in claims processed in 2021
“Optalitix gave us a new ability to save productive hours by gathering data and allowing us to report on it to regulatory agencies in a very effective manner.
The time that has been saved has given us much more freedom to analyse claims data and look at how to improve performance, rather than just managing data flow.”
- Carey Bond, Head of Claims for the Americas
Optalitix are Insurance Times Awards Gold Winner - Release
Optalitix wins the Gold award for Excellence in Technology – Service Provider (General) category at the 2021 prestigious Insurance Times Awards. Read more here.

The role of an underwriter should not be underestimated
The multi-faceted contribution an underwriter makes to any insurance business transcends simply assessing risk. Read more about underwriting and the impact of it.
Changes to FCA Insurance Pricing
New rules from 2022 ensure customers who are renewing their insurance policies receive a quote no more than they would be quoted as a new customer. Read more.
The future of systems with embedded Excel models
The ease with which Excel models can now be converted and the number available requires a new age of system design. Find out more in this guide.
Convert pricing models using an Excel converter.
Optalitix have determined that using Excel converters to convert pricing models is the most efficient and effective method. Take a look at the features and more.
Converting Spreadsheets - The 3 Options
At Optalitix, we are able to convert spreadsheets in 3 ways: by recoding the system, using an existing commercial platform, or using an Excel converter.
Spreadsheet models need to go digital
Spreadsheets should move to cloud-based systems in order to benefit from rich features such as dashboards, databases and seamlessly integrated AI and automation.
Spreadsheet dependancy and pricing
Spreadsheets are frequently used for pricing due to their ability to build complex calculations quickly in a flexible coding environment. Read our guide now.
Optalitix powered United Trust Bank’s step into the future with instant mortgage decisioning
The mortgage market is always changing. Few banks are able to offer an instant decision on a mortgage, yet the United Trust Bank (UTB) is one of them. Read more.
Five reasons why pricing in the cloud will increase sales
Cloud based pricing ensures that everything from conversion to compliance is streamlined, efficient and controlled ultimately leading to increased sales.
Spreadsheet Sense Check
As business strategy evolves and growth is more dependent on cloud based tools like AI, machine learning and data, the value of spreadsheets might be affected.

Big Data Processing for Multiple Insurers
The insurance sector is data rich and decisions are made quickly using real time data. Find out how GoCompare embraced AI to add value to their partner offering.
Learn about Lloyd’s Lab – an influential insurtech accelerator
Membership in Lloyd's Lab allowed Optalitix to scale up and develop innovative ideas in collaboration with the world's largest insurance market. Learn more now.
Learn about Mass Challenge – a US based start-up accelerator
