Switching platforms with an in-force book is the step most MGAs dread. The Import screen takes clients and policies from Excel or CSV, validates every row and writes nothing until you confirm, so the move is a spreadsheet exercise rather than a project.
Step by step
- 1Create the products first, so imported policies can be linked to them; rates and rules can follow later.
- 2Open Import, choose Clients and download the template. Required column: Name. Fill it from your current system and upload. Headers are recognised automatically (the template's and common variants); columns it does not recognise are listed so you can rename them in the sheet.
- 3Check the validation summary: rows the import cannot use are listed with the reason. Fix the sheet or accept that those rows are skipped, then import.
- 4Choose Policies and download that template. Required: Client name, Product, Premium, Inception date, Expiry date. Client names must match the clients you just imported.
- 5Upload, review and import. Imported policies appear in Policies with their dates and premium and are picked up by renewals when their expiry approaches.
What to clean before you upload
- One spelling per client. The policy import links on the client name; 'ABC Ltd' and 'A.B.C. Limited' become two clients.
- Dates as dates, premiums as numbers; both European and British notation are read, but text like 'TBC' is not.
- Decide what you migrate: in-force and recently expired policies, usually. Claims history and documents can stay in the old system's export, kept with the full data export you take from it.
After the import
- Imported policies have a premium but no rate breakdown, because they were not rated here. At renewal you choose: re-rate with your current tables or carry the premium.
- Imported policies are not placed under a binder, so they stay out of your bordereaux here; the old system's final bordereau covers them. The renewal is bound here, under the binder you pick on the submission, and reports from then on.
- Spot-check ten policies against the old system before you tell brokers the new portal is live.
Questions
- Can brokers and policyholders see imported policies?
- Yes, once the policy is linked to their organisation or client record, exactly like a policy bound here.
- Can we import rate tables the same way?
- Rate tables, questions and rules are imported per product with the product workbook, not with the Import screen.