All articlesGrowth

Switching From Spreadsheets (or Notion) to a Real Adviser CRM

Somewhere in your business right now there's a spreadsheet that started as a temporary fix. Maybe it's a Google Sheet with tabs for each policy type, a Trello board with a column for every renewal stage, or a Notion database someone set up on a quiet Friday afternoon because it doubled as a decent enough note taking app for advisers who weren't ready to pay for a CRM yet. Two years and a few hundred clients later, it's still there — creaking, colour-coded, and quietly terrifying to touch.

For a sole adviser with eighty clients, that setup can work well enough. You know where everything lives because you built it. The trouble starts when the book grows, another adviser joins the FAP, or someone goes on leave and a colleague has to find last Tuesday's meeting notes buried in a cell you labelled with a phone number instead of a client name.

Multiply that by a team, and it gets worse. One person's Notion board doesn't automatically become the whole FAP's client record, and a Trello card that says 'call back re: mortgage change' tells you nothing about which policies that client holds or when anyone last spoke to them. Everyone ends up keeping their own version of the truth, which is fine right up until someone leaves, a client complains, or the FMA asks to see the file.

Why does a spreadsheet or Notion stop working as your book grows?

A spreadsheet is a filing cabinet, not a system. It stores what you put into it, but it doesn't do anything with that information unless someone remembers to look. Nobody gets pinged when a client's cover is renewing in 90 days — you find out when the renewal notice lands, or worse, when the client rings to ask why nobody called first. Notion pages don't flag life events either; a note about a new mortgage or a new baby just sits there until the client complains their premium no longer matches their circumstances.

  • No renewal automation — renewals get tracked by memory or a calendar reminder someone forgot to set
  • No shared visibility — when an adviser is away, their notes and client history live in files only they know how to find
  • No real audit trail — edits overwrite each other with no record of who changed what or when
  • Notes scattered everywhere — a call summary in Notion, an email thread in your inbox, a policy list in a spreadsheet, and none of it in one place

What you lose without a real audit trail

This is the part that tends to matter most once a book gets big enough to attract scrutiny. General best practice around adviser conduct places real weight on being able to show, after the fact, what was discussed with a client and when — not just that good advice was given, but that it can be evidenced months or years later. A shared spreadsheet with no version history, or a Notion page anyone can quietly edit, doesn't give you much to point to. Exactly what's expected depends on your licence and FAP, so it's worth confirming the detail with the FMA, your licensee, or a compliance adviser — but 'a shared spreadsheet' is rarely a confident answer to 'show me your notes from that meeting.'

This is where a proper adviser CRM earns its keep. AdviserDesk, for instance, timestamps notes as they're written and keeps a full chronological thread per client, so there's one record of what happened and when, rather than four half-updated ones scattered across apps. Renewals surface automatically inside a 90-day window instead of relying on memory, and cover-gap detection flags the client whose mortgage just changed, or whose cover hasn't been touched in years, before it turns into an awkward conversation.

What does switching from Notion or a spreadsheet to a CRM actually involve?

The good news is that switching doesn't mean retyping a few hundred client records by hand. Most of what's sitting in your spreadsheet, or exportable out of Notion — names, contact details, policy types, providers, renewal dates — maps cleanly onto a CRM's client and policy fields. The usual first step is exporting what you have as a CSV. If you're coming from another CRM like TAP or Adviser Plus rather than a spreadsheet, that export is already more structured, which makes the move even more straightforward.

AdviserDesk's team migrates clients, policies and renewal dates from that CSV within 48 hours, and it's included free — so the actual data-moving part of switching is mostly a wait, not a project.

What takes longer is the adjustment, not the import. In the first week, expect to spend time checking that policy data landed where you'd expect it, setting up a bulk email segment or two (a 'renewing in 90 days' list is usually the first one worth building), and getting used to writing meeting notes into the client record instead of a separate app. It's not instant fluency — you're shifting muscle memory, not just data — but the shape of the work is the same as before. You're just doing it in one place instead of four.

That's the whole game, really. A spreadsheet or a Notion board can hold information, but it can't chase a renewal, flag a gap, or prove what happened in a meeting eighteen months ago. Export what you've got, let the migration handle the boring part, and build your first week around renewals and notes rather than admin. Do that, and the system starts working for you instead of the other way round.

Frequently asked questions

A spreadsheet or Notion board stores information but doesn't act on it — nobody is notified when a client's cover is renewing, life events like a new mortgage go unflagged, and there's no shared audit trail across a team, which becomes a real problem once your book or FAP grows.

Export your existing spreadsheet, Notion database, or CRM (such as TAP or Adviser Plus) as a CSV. AdviserDesk's team then migrates clients, policies, and renewal dates from that file within 48 hours, included free, so the transfer itself takes days, not weeks.

A CRM that timestamps notes as they're written and keeps a full chronological client thread supports general best practice around evidencing suitability and advice given. Specific record-keeping obligations depend on your licence and FAP, so confirm the detail with the FMA, your licensee, or a compliance adviser.

Run your book on AdviserDesk

The AI-powered CRM for NZ insurance advisers. Free for 30 days, cancel any time.

Start free trial