When Should an MGA Replace Its Spreadsheet Rating Model?

There is nothing inherently wrong with spreadsheet rating.

Some of the sharpest underwriting logic in the market still lives in workbooks. Spreadsheets are flexible, transparent to the people who built them and fast to change when a product is still evolving. They are often the right place to start.

The problem is not that spreadsheets are bad. The problem is that many businesses ask them to keep doing a job they have already outgrown.

Why spreadsheet rating lasts so long

Because it works - until it does not.

A well-built spreadsheet can support a product for quite a while. The underwriter trusts it. The product owner understands it. It can be amended quickly. On day one, it often feels lighter and more practical than implementing a full rating engine.

That is why teams keep it longer than they expected. The move away does not happen because the logic stops being valid. It happens because the operational demands around the logic change.

The signs you are outgrowing it

One common sign is person dependency. Only one or two people are truly comfortable changing the workbook, troubleshooting it or validating a new version. That creates concentration risk.

Another sign is version uncertainty. Teams are no longer fully sure which workbook is live, what changed between versions or how consistently the rules are being applied.

A third sign is workflow friction. The spreadsheet may still produce the right price, but the output has to be manually copied into other tools for documents, admin or reporting. At that point, the pricing logic is no longer the whole job. It is one step in a much larger process that the workbook was never designed to support.

And finally, there is pace. If pricing changes are becoming harder to control, test and deploy, the business starts losing agility rather than gaining it.

The real decision is about operating model, not maths

This is important.

Moving away from spreadsheet rating does not mean abandoning the underwriting thinking embedded in the model. The rating logic may still be excellent. The business is really deciding whether that logic should continue to live inside a tool built for individual flexibility or move into an environment built for shared operational use.

That is an operating model decision.

The question is not, "Is the spreadsheet clever enough?" The question is, "Is the spreadsheet still the right way to deliver this logic across the team, at this scale, with this level of control?"

When to keep it a little longer

There are sensible reasons to stay with spreadsheets for a while.

If a product is still being tested, volumes are low, the logic is changing quickly and the downstream process is contained, a spreadsheet may remain the most practical tool. It can help the business learn before it hardens the model into a more structured environment.

But that only works if the business stays honest about the trade-offs. Temporary flexibility becomes dangerous when it is mistaken for a long-term operating model.

How to move without losing the logic

The best migrations preserve the underwriting intent while changing the delivery mechanism.

That usually means documenting the rules properly, identifying where judgments and referrals occur, separating data inputs from calculations, testing outputs in parallel and moving product by product rather than trying to boil the ocean.

In other words, you do not migrate the spreadsheet as a file. You migrate the logic as a controlled rating capability.

This is why the move often feels easier once the team starts. The hardest part is usually not rebuilding the mathematics. It is deciding to stop depending on the workbook as live infrastructure.

The commercial upside

Replacing spreadsheet rating at the right moment can improve more than pricing.

It reduces key-person risk. It makes changes easier to govern. It improves consistency across users. And, if done well, it helps connect pricing to documents, administration and reporting so the quote does not have to be rebuilt downstream.

That is where a lot of the value hides. The business does not just get a cleaner rating engine. It gets a cleaner path from submission to bind.

A simple threshold question

Ask this: if the person who knows the spreadsheet best disappeared for two weeks, would the business still feel fully comfortable quoting, changing rates and supporting the downstream workflow?

If the honest answer is no, the spreadsheet is probably carrying too much of the operating model.

That does not make it a bad tool. It just means the business has reached the point where it deserves better infrastructure around the logic.

Bertie helps MGAs move beyond spreadsheet-dependent rating by turning pricing logic into a connected workflow that also supports documents, administration and bordereaux. If your workbook is still holding things together through force of habit, the time to replace it may be closer than you think.