From Excel spreadsheets to a custom management system: digitalising an insurance agency or intermediary

The moment Excel stops being enough

In almost every insurance agency and in many brokerage offices there is one file that "holds everything together": the portfolio spreadsheet. One row per policy, columns for client, insurer, line of business, premium and expiry date; next to it, a second sheet for commissions, a third for open claims, and a folder full of versions — portfolio_2025_final, portfolio_2025_final_UPDATED. It works, and often it works for years. As long as the portfolio is small and only one person touches the file, Excel is an honest tool: flexible, immediate, free.

Then the agency grows. Three people now update the file, the policies number in the thousands, the lines of business multiply. And the symptoms always arrive in the same order: two versions of the file that no longer match, an important renewal discovered too late, a commission statement that does not reconcile with the insurer's account, hours spent at month-end manually reconciling what a system should reconcile by itself. The problem is not Excel as such: it is that a spreadsheet was born to do calculations, not to run a process involving several people, several data sources and traceability obligations.

What a custom insurance management system is

An insurance management system is software that centralises the intermediary's client records, policies, instalments, renewal dates, collections, commissions and documents in a single database, and keeps them consistent with each other: when a piece of data changes, it changes once and everywhere. "Custom" means the system is built around the actual procedures of that specific agency or brokerage firm — its main lines of business, the way it calculates commissions for its sub-agents, its collaboration agreements — instead of forcing the agency to adapt to an off-the-shelf package designed for an average intermediary that does not exist.

The practical difference from a spreadsheet lies not in individual features but in structure: a management system has a single master record for each party, validation rules on data, a history of who changed what and when, and automations that keep working while the office is closed.

The structural limits of spreadsheets

Duplicated data and client records that drift apart

In Excel the same client exists several times: one row in the policies sheet, one in the claims sheet, a separate address book for emails. When an address or a certified email changes, someone has to remember to update it everywhere — and sooner or later that does not happen. From that moment on, the agency has two different truths about the same client and no longer knows which one is right. A management system solves the problem at its root: the client is a single record, and policies, claims, documents and communications all attach to it.

Renewal dates entrusted to people's memory

The missed renewal is the most measurable cost of manual management: a client who is not notified in time is an exposed client, and often a lost one. In Excel the renewals calendar is a date filter someone has to remember to apply; in a management system it is a process that runs by itself, flags the policies approaching expiry, prepares the communications and keeps track of who has been contacted and who has not. We dedicated a full article to exactly this transition: automating policy renewals, from Excel to an intelligent system.

No audit trail — and compliance notices

A registered intermediary operates within a precise regulatory framework — from pre-contractual documentation to suitability assessment and record keeping — supervised in Italy by IVASS, the national insurance authority. A spreadsheet cannot say who changed a value, when and why; it keeps no versions; it does not link the document to the policy. In the event of a dispute or an inspection, reconstructing the history of a file managed in Excel and shared folders is an archaeological dig. A well-built management system, by contrast, produces traceability as a side effect of everyday work: every operation leaves an orderly trace, and the client file is complete by construction.

The functions a custom system must cover

A single master record for clients, insurers and collaborators

This is the foundation of everything else: every party — client, insurer, sub-agent, introducer — exists exactly once, with its contact details, privacy consents and history. Reliable searches, correct communications and figures that reconcile all descend from here.

Policies, instalments and the renewals calendar

The operational core: policies with their life cycle (issue, renewal collection, suspension, cancellation), instalments collected and outstanding, a renewals calendar that automatically feeds alerts and work lists. The quality test is simple: every morning the system should tell each person in the agency what needs doing today, without anyone building the list by hand.

Collections, commissions and account statements

This is where Excel does the most damage, because commission calculations follow different rules per insurer, line, product and collaborator. A custom system encodes the rules once and applies them always: reconciliation of insurer statements, calculation of inbound and outbound commissions, sub-agent statements generated from the same data — one source, no double keying.

Documents the system reads, not just stores

The most modern part of digitalisation: the documents arriving at the agency — premium receipts, contracts, certificates — can now be read automatically with artificial intelligence tools that extract the data and attach it to the right policy or client. This is not science fiction but established practice, which we covered in AI and document management: the archive stops being a folder full of PDFs and becomes a queryable database.

A portal for the end client

Once the data is properly organised in a management system, exposing it to the client becomes natural: their policies, their renewal dates, documents to sign, a channel for requests. It is a service that builds loyalty and cuts repetitive phone calls — provided it is designed well, as we discussed in our article on the client portal for the insurance intermediary.

Digitalising without stopping the agency

The most common fear is the leap into the void: "we cannot stop for a month to change systems". It is a well-founded fear if the project is conceived as a big bang, and an unfounded one if it is conceived in phases. The approach that works starts from the point of greatest pain — almost always renewals and portfolio — and brings a first module into production in weeks, not years; the historical data in Excel is not lost, it is imported: the existing sheets become the starting base of the client records and portfolio, cleaned of duplicates during migration.

It is also worth building today with tomorrow in mind: regulation is pushing towards natively digital processes, from the electronic signature of insurance contracts — governed in Italy by IVASS Regulation No. 8/2015 — to the European eIDAS 2 framework on digital identity. A custom management system is the natural place where these pieces integrate over time, instead of remaining separate tools.

In summary

Excel is the right tool to start with and the wrong one to grow with: no single master record, no automation, no audit trail. A custom insurance management system centralises clients, policies, renewals, collections and documents in one coherent system built on the agency's actual procedures; it is introduced in phases, starting from the module that solves the most urgent problem, and the historical spreadsheet data becomes the starting point, not an obstacle. The measurable result: less time lost in reconciliations, fewer missed renewals, and compliance that is produced automatically, simply by working.

Frequently asked questions

How long does it take to move from Excel to a management system?

With a phased approach, a first operational module (typically client records, portfolio and renewals calendar) can be in production within a few weeks; the rest of the system grows through successive iterations, without ever stopping the agency's daily work.

Is the historical data in the spreadsheets lost?

No: it is imported. The existing sheets are analysed, cleaned of duplicates and loaded into the system as the starting base. Migration is in fact the perfect opportunity to fix records that had been drifting apart for years.

Does a custom system make sense for a small agency too?

Yes, if it is sized correctly: "custom" does not mean huge, it means built on actual procedures. A small agency needs a few functions done well — single master records, renewals, commissions — not a system with a hundred modules it will never use.

What is the difference between a custom system and an off-the-shelf vertical?

The standard vertical offers predefined functions that are the same for everyone: it costs less upfront but forces the agency to adapt its procedures to the software. The custom system does the opposite: it encodes the existing procedures, integrates with the tools already in use and evolves with the agency.

At A126 we build custom management systems for agencies, brokers and insurance-sector operators: single master records, portfolio and renewals, commissions, automatic document reading and client portals, designed around the actual procedures of the people who will use them. If you want to understand how to leave your spreadsheets behind without stopping your agency, contact us for a free consultation.

A126 Corporate Advisors — custom management software for the insurance and reinsurance sector.