Codium Logo Codium Logo
  • Services
  • Industries
  • Our Work
  • About
  • Blog
Blog · Insurance

Policies in one system, claims in another, and spreadsheets in between

The policy system does not know about the claim. The claims desk cannot see the endorsement. Accounts reconciles both from a spreadsheet at month end. Specialist insurers get stuck here for years.

25 July 2024

Specialist insurers and underwriting agencies tend to build up their systems one product at a time. The first product ran on a policy admin tool. Claims were few enough to track in a spreadsheet. Accounting was Xero. Then a second product came along with different rules, and a second spreadsheet. A broker portal was bought separately. Years later the business runs across four systems, and what holds them together is a person with a spreadsheet and a good memory.

The individual systems are usually fine. The problems are in the gaps between them.

What falls in the gaps

  • The claims desk cannot see the policy as it stands today. An endorsement went through last week. The claims handler is looking at the schedule from inception. The claim gets assessed against the wrong cover.
  • Premiums and claims are reconciled by hand. Accounts matches payments to policies and claim payments to claims from exports, in a spreadsheet, at month end. Anything that does not match waits until someone has time to investigate.
  • Simple customer questions take two systems and a phone call. "What is the status of my claim, and when is my renewal due?" cannot be answered from one desk.
  • Reporting is assembled rather than run. Loss ratios by product need policy counts from one system, claims from another and premium from a third. The board pack takes a week to put together.

Containing it

The gaps can be narrowed before anything is rebuilt. Use one policy number consistently across every system, so records can at least be matched. Schedule an export from the policy system into the claims spreadsheet, so handlers are looking at yesterday's endorsements rather than last year's. Build a reconciliation template that flags mismatches automatically instead of relying on someone to spot them.

These reduce the damage. They do not remove the person in the middle, and they do not give anyone a single view of a customer.

One workflow from quote to claim

Insurers who have solved this run a single system with the policy at the centre. Quotes are produced against the product's rules and bound into policies. Endorsements, renewals and cancellations are steps in a workflow with full history. A claim is raised against the policy as it stood on the date of loss, with the cover visible to the handler. Premiums, instalments and claim payments flow through to accounting, coded to the policy and the claim. Because everything is in one place, loss ratio by product is a report rather than a project.

This is the kind of system we build for insurers and brokers: quote and bind portals, policy administration, claims management with structured capture and status updates for the customer, document generation and payment reconciliation, all on one database. Every insurer's products and rules are a bit different, which is why an off-the-shelf platform built for standard products tends to bend your process to fit it. The first thing we do is map how a policy actually moves from quote to claim in your business.

If your policies, claims and accounts are joined by spreadsheets, have a look at what we build for insurance, or tell us how a policy moves through your business today.

Insurance 2024
Keep reading

More from the blog

Has your business outgrown Excel? Seven signs, and what to do about each one
15 Oct 2026

Has your business outgrown Excel? Seven signs, and what to do about each one

Spreadsheets fail slowly, so nobody notices the day they stop being a tool and start being the system. Here are the signs, the fix...

What has changed in custom software development over the last 12 months
2 Sep 2026

What has changed in custom software development over the last 12 months

Software development continues to evolve quickly, but the last 12 months have seen some particularly significant changes in the wa...

How do you know which asset is about to fail before it does?
30 Jul 2026

How do you know which asset is about to fail before it does?

The failure was there in the data for three inspections before the breakdown. Nobody could see it because the data was spread acro...

All articles

Want to talk about your own project?

Tell us what's slowing your business down. One of our digital strategists will talk it through with you.

Get in touch Call 1300 887 103
Codium Logo
Codium Pty Ltd.
Ground Floor, 207 Greenhill Road
Eastwood, 5063
Adelaide, South Australia
  • 1300 887 103
  • sales@codium.com.au

Development

  • Software Development
  • Mobile Apps
  • Software Integration
  • Hardware Integration
  • Microsoft Access
  • Replace Spreadsheets

Managed Services

  • Software Takeover
  • Software Support (SLA)
  • Managed Hosting
  • Private AI Hosting
  • On-Premise AI

AI

  • AI for Business
  • AI Reporting

Strategy

  • Technology Partner
  • UI / UX Design
  • Due Diligence (M&A)
  • Why Projects Succeed
  • What Software Costs

Technologies

  • PHP · Laravel
  • JavaScript · Vue.js
  • AWS

Company

  • About Us
  • Industries
  • Our Work
  • Blog
  • Careers
  • Contact Us
  • Customer Feedback
  • Remote Support

© Codium Pty Ltd. All Rights Reserved.

  • Terms of Business
  • Privacy Policy
  • Quality Policy
  • Security Policy
  • Customer Experience Charter
Back Top
Codium
Services
All services Strategy
  • Technology Partner
  • UI / UX Design
  • Technology Due Diligence
  • Why Projects Succeed
  • What Software Costs
Development
  • Software Development
  • Mobile App Development
  • Software Integration
  • Hardware Integration
  • Microsoft Access Databases
  • Replace Spreadsheets
Managed services
  • Software Takeover
  • Software Support (SLA)
  • Managed Hosting
  • Private AI Hosting
  • On-Premise AI
AI
  • AI for Business
  • AI Reporting
Industries
All industries
  • Construction
  • Finance
  • Government
  • Health
  • Insurance
  • Manufacturing
  • Mining
  • Retail & E-commerce
  • Transport & Logistics
Our Work About Blog
Get in touch Call 1300 887 103