Insurance Data Solutions logo

Insurance Data Solutions

Bordereaux management and insurance data services for the London Market

Data & Analytics Established Bootstrapped
Visit Website

Overview

Insurance Data Solutions (IDS) is a bordereaux management and data-services provider for MGAs, coverholders, brokers and Lloyd's managing agents in the UK P&C and specialty market. The company was founded in 2006 by Paul Johnson and traded as New City Software Ltd for most of its history before renaming to Insurance Data Solutions Ltd in August 2024.

Its flagship product, the IDS Bordereaux Solution, automates delegated-authority data flows between coverholders, MGAs, brokers and Lloyd's insurers: binder setup and limit tracking, bordereaux processing for risk, premium and claims data, configurable data-quality validation rules, financial reconciliation and credit control, audit tracking, and Power BI reporting. A dedicated integration tool converts bordereaux data into RiskLink format for catastrophe modelling and supplies granular pricing data to Lloyd's insurers. Beyond bordereaux, IDS offers Power BI-based insurance analytics, system-to-system data migration, legacy-data archiving, and bespoke software development.

IDS is bootstrapped and privately owned, with no external funding rounds identified. It employs 11-50 people, including insurance-industry data analysts, testers, SQL developers and BI specialists. Its client base spans 50+ named insurers, brokers and MGAs drawn from the London Market and wider UK insurance industry, per the company's published case studies and client listings.

Products & Services

IDS Bordereaux Solution

Automates delegated-authority processes for coverholders, MGAs, brokers, TPAs and Lloyd's insurers, covering the full bordereaux lifecycle from binder setup through reconciliation and reporting.

Key Features

  • Binder setup and management, including contract limits, sections and third-party tracking
  • Bordereaux processing for incoming and outgoing risk, premium and claims data
  • No-code data-quality validation rules, both pre-built and customizable
  • Financial reconciliation and credit control
  • Audit tracking for insurer/coverholder compliance
  • Power BI dashboards for operational and regulatory reporting
  • Support for the Lloyd's Premium, Claim and Risk Standard V5 and requirements such as Flood Re
  • BDX-to-RiskLink integration tool for catastrophe modelling and pricing data

Target Users: MGAs, coverholders, brokers, TPAs and Lloyd's managing agents

Insurance Analytics

Power BI-based dashboards built around insurance KPIs, delivered as self-service cloud analytics. Past work includes a country and market-share analysis dashboard for a Lloyd's reinsurer and granular risk-data reporting for pricing teams.

Target Users: Insurers, reinsurers and MGAs needing operational and market reporting

Data Migration Services

System-to-system data migration and consolidation for insurance data and vendor systems, including binder-management and claims-data consolidation across multiple source systems, and migrations between platforms such as RDT Landscape and Open GI's Transactor.

Target Users: Insurers and brokers replacing or consolidating legacy systems

Data Archiving (Insurance Data Archiver)

Regulatory-compliant data archiving and retrieval for legacy insurance systems being decommissioned.

Target Users: Insurers and brokers retiring legacy platforms

Bespoke Solutions

Custom software development for insurance-specific data and process needs outside the standard product set.

Target Users: Insurers, brokers and MGAs with non-standard requirements

At a Glance

Founded
2006
Headquarters
Chelmsford, Essex, United Kingdom
Employees
11-50
Funding
Bootstrapped

Category & Focus

Category
Data & Analytics
Subcategories
Bordereaux Management Delegated Authority Catastrophe Modelling Data Integration Data Migration Data Archiving
Insurance Verticals
P&C Commercial Specialty/E&S Reinsurance
Target Customers
Carriers, MGAs/MGUs, Brokers, TPAs

Customers

  • BUPA
  • Direct Line
  • Markerstudy Insurance Services
  • Lockton
  • Howden
  • Arthur J. Gallagher
  • MS Amlin
  • Assurant
  • Endsleigh Insurance
  • Acorn Insurance
  • A-Plan
  • 1st Central
  • R&Q Insurance Holdings
  • Cedar Underwriting
  • Willis Networks
  • Sesame

Last updated: 2026-08-11