Automating Policy Renewals: From the Excel Spreadsheet to an Intelligent System for Insurance Agencies

The renewal paradox: the most important revenue line is also the worst managed

For an insurance intermediary, renewals are not an administrative task: they are the economic backbone of the agency. Keeping an existing customer costs a fraction of acquiring a new one, and renewal commissions represent the most stable and predictable share of turnover. Yet in a sector that, according to IVASS data, counts tens of thousands of registrants on the Single Register of Intermediaries, the management of deadlines continues to rely on tools that have not changed in twenty years: Excel spreadsheets, shared calendars, sticky notes on the desk, the owner's mental reminders.

The result is predictable. Policies that expire without anyone noticing in time. Customers who receive the phone call "the day before" or, worse, "two days after". Renewals lost not because of price or competition, but through sheer operational disorganisation. In a market where consumers have learned to compare offers online in minutes, an intermediary who does not systematically oversee the renewal phase is literally handing its portfolio to the competition.

The current landscape: figures that should make every agency owner think

The Italian regulatory framework has profoundly changed the rules of the game. Since 2013, with the Decreto Sviluppo Bis, automatic renewal has been abolished for motor liability policies: the contract ceases automatically at expiry and the customer must make an informed choice. This means that every single motor liability expiry is now a critical moment at which the customer can leave, stay or compare the competition. For non-motor property, life and accident policies, automatic renewal is still possible, but here too the disclosure obligation towards the policyholder — with notice at least 30 days before expiry — has become a market standard.

Added to this is a structural fact that few intermediaries actually calculate: in a mid-sized agency with 1,500-2,000 active policies spread across several lines of business, daily expiries range from 5 to 15 a day. If monitoring is manual, all it takes is a week's holiday, someone off sick or a period of high claims activity to lose complete control. It is not uncommon for an agency to discover it has "forgotten" dozens of expiries only at the end of the month, when the damage is already done.

The reasons a customer does not renew are well known and recurring: premium increases, changing needs, aggressive offers from competitors and — the most frustrating of all for an intermediary — simply a lack of timely communication. This last point is where technology can intervene decisively, because it does not require renegotiating prices or changing products: it only requires that you stop leaving to chance a process that should be industrialised.

There is also a hidden-cost dimension. An agency employee who spends two hours a day "checking the week's expiries", cross-referencing Excel spreadsheets, copying phone numbers, writing reminders and sending emails one at a time is burning between 40 and 50 hours of work a month on activities an automated system would carry out in seconds. In an agency, that time is worth real money: it is time taken away from advisory work, claims management and acquiring new customers.

Where you start: the invisible chaos of the Excel spreadsheet

When we go into an agency to design a deadline management system, the initial snapshot is almost always the same. There is an Excel spreadsheet — sometimes two, sometimes seven — listing the policies with their inception and expiry dates. The file is updated manually every time a new policy is issued or an existing one is renewed. There are often columns with colour codes: red for "urgent", yellow for "coming up", green for "done". Sometimes there is a macro that sends an email alert, built years ago by someone who no longer works at the agency.

The problem is not Excel itself, which is an excellent tool. The problem is that Excel is not designed to manage an ongoing operational process with dozens of actions a day, multiple people involved and a need for traceability. The structural limits are obvious: the file gets saved in different versions on different computers, one employee's changes overwrite another's, notifications do not go out automatically, there is no reliable history of "who did what", there is no connection with email, SMS or WhatsApp, and above all there is no priority logic. A home policy with a 300-euro premium is treated exactly like a business policy worth 15,000 euros.

This is the most critical point. Without priority, operational risk concentrates where it shouldn't: the agency invests the same amount of time in a marginal customer and a strategic one, because the Excel spreadsheet cannot tell them apart.

What gets built: the anatomy of an intelligent deadline management system

An automated policy deadline management system, built to measure for an agency, is not simply "Excel with notifications". It is a software module that redesigns the process from scratch, starting from a different question: instead of asking "which policies expire this week?", it asks "which actions must I carry out today, in what order, for which customers, through which communication channel, and what results did I get yesterday?".

The first block is the intelligent calendar engine. Every policy issued or renewed automatically generates a sequence of operational deadlines: the 60-day advance notice, the customer notice at 30 days, the reminder at 15 days, the direct contact at 7 days, the final action on the expiry day, the post-expiry follow-up for policies not renewed. These deadlines do not live in a spreadsheet: they live in an operational dashboard that tells the operator every morning exactly what to do, ordered by priority.

The second block is the scoring and value-based prioritisation system. Every customer and every policy is classified according to configurable parameters: annual premium, line of business, customer tenure, multi-policy status (customers with more than one policy), claims history, margin for the agency. The system uses this information to order expiries not by date, but by economic relevance. A business policy worth 12,000 euros expiring in 35 days is placed at the top of the list ahead of a motor liability policy worth 400 euros expiring in 10 days, because losing the first costs the agency thirty times more.

The third block is the multichannel communication engine. The system automatically sends communications to the customer on the channels they have stated they prefer: email for the "traditional" customer, SMS for those who don't read their mail, WhatsApp Business for younger demographics, and possibly a push notification if the agency has a dedicated app. The messages are personalised with the policyholder's details, the policy details, the new premium when available, and contain direct links to confirm the renewal, request information or book an appointment. Everything is tracked: who opened the email, who clicked, who did not respond and needs to be called again.

The fourth block is the operator alert layer. When the customer does not respond to two automated communications, the escalation system passes the case to the human operator with all the data ready: last contact, policy value, history, suggested action. The operator does not waste time reconstructing the context: they find it ready in the dashboard and can focus on the one thing that matters, the conversation with the customer.

The fifth block — the one that closes the loop — is the monitoring and analysis dashboard. The agency owner sees in real time the renewal rate by line of business, by operator, by value band. They can compare the current month with the same month of the previous year. They can spot anomalies ("why has the motor liability renewal rate dropped by 15% this quarter?") and intervene before the problem becomes a trend.

Practical implementation: how to move from spreadsheet to system without stopping the agency

The transition is the most delicate moment, and it is also where most digitalisation projects fail. Our experience teaches us that the switch works when it respects three principles.

The first is progressive migration. You don't throw Excel out overnight. You start by importing the existing data into the new system, keeping a dual track for a few weeks: the system runs in parallel with the legacy spreadsheet, the agency checks that everything matches, the operators get used to the new interface without feeling disoriented. Only when confidence is consolidated is the spreadsheet retired.

The second is customisation around real workflows. Every agency has its own operational logic, its own way of classifying customers, its own communication formulas, its own standard timescales. A standardised, industrial software package forces the agency to adapt to the software. A tailor-made system, on the contrary, moulds itself to the workflows that already work, eliminating only the inefficiencies. The system must speak the agency's language, not the other way around.

The third principle is integration with existing tools. The deadline system does not live in isolation: it must talk to the agency's management software, the email system, any insurer platforms, and the CRM if present. Integrations must be designed from the outset, because an isolated system that requires data to be re-entered by hand is destined to be abandoned within a few weeks.

In practice, the typical path starts with an analysis of existing processes (1-2 weeks), continues with the design of the tailor-made system (4-6 weeks of development), proceeds with data migration and operator training (2 weeks), and stabilises over the first 60-90 days of use, during which the system is refined on the basis of real feedback from those who use it every day.

What results to expect: the concrete value of automation

Without promising miracles, there are structural benefits that appear in the first weeks of use. The first is the reduction in the number of deadlines handled late or forgotten: it goes from a natural but significant percentage to practically zero, because the system does not forget and does not go on holiday. The second is the recovery of person-hours: the manual checking activities that absorbed a substantial part of an employee's day are eliminated, freeing up time for higher-value activities such as advisory work and cross-selling.

The third benefit, less immediate but more strategic, is the improvement in the retention rate. When the customer receives the right communication on the right channel at the right time, they perceive the agency as professional and attentive, and this increases the likelihood that they will renew even in the face of small premium increases. A customer who feels "looked after" is a customer who is harder to poach.

Finally there is a fourth effect, the one that often convinces the most sceptical owners: visibility over the data. For the first time the agency sees its own renewal figures objectively, can compare employees' performance, identify the lines of business to work on better, and discover that certain customers "they thought they had lost" are in fact recoverable with a targeted action. This visibility transforms decisions that were previously based on intuition into decisions based on data.

Conclusion: renewals deserve the same rigour as new business

For too long, insurance intermediaries have invested energy in finding new customers while neglecting the defence of existing ones, entrusting the renewal phase to improvised tools. It is an economic paradox: significant resources are spent to acquire a new customer, and then that customer is at risk of being lost because no one called them in time for the renewal. In today's market, where online competition is a click away and consumers are used to quick comparisons, the quality of renewal management has become a structural competitive advantage.

A126 develops tailor-made management software for insurance intermediaries, building deadline automation systems that adapt to the real processes of each agency: from migrating existing data to designing the prioritisation logic, from multichannel integration to the monitoring dashboard for the owner. We do not sell licences for a standard product: we design the tool around the way your agency works, because we believe it is the software that must adapt to the organisation, not the other way around.

Want to understand how to turn deadline management from a cost centre into a growth lever for your agency? Get in touch for a free consultation: together we will analyse your current workflows and show you, with the data in hand, where you can recover time, revenue and customers.

A126 Corporate Advisors — Tailor-made software for insurance intermediaries who want to industrialise their processes without losing their own way of working.