Importing insurance policies brings both coverage details and insurance beneficiaries into SurgeTK. This information powers your Net Worth report (via cash value policies) and your Beneficiaries report (for policies with listed beneficiaries).
At a glance
Start the import from Households or Imports.
Choose Import account data, then select Insurance.
Required field: Policy Number (must be unique per policy).
Client ID is required when creating new policies (to tie them to the correct client).
All other fields are optional but strongly recommended.
Beneficiaries can be imported at the same time as policy details.
Upload one spreadsheet at a time (multiple files at once are not supported).
Confirm the column mapping and run the import.
SurgeTK supports both creating new policies and updating existing ones in the same run.
After completion, review the import report on the Imports page.
Before you start
Download the Insurance Import Template (recommended)
Using the template ensures your headers auto-map to SurgeTK fields.Required fields
Policy Number – the unique identifier for a policy. Used to detect duplicates and updates.
Client ID – required for new policies to link them to the correct client record.
Optional (but recommended) fields
These fields provide valuable data for reporting and planning:Client ID – ties each policy to the correct client.
Policy Number – unique policy identifier (required).
Cash Value – include if the policy has one. Policies with cash value roll into the Net Worth report.
Carrier Name – e.g., Mutual of Omaha, Prudential.
Policy Type – e.g., Whole Life, Term Life.
Policy Sub Type – optional subtype or rider category.
Effective Date – inYYYY-MM-DDorMM/DD/YYYY.
Expiration Date – inYYYY-MM-DDorMM/DD/YYYY.
Beneficiary Name – inLast, Firstformat.
Beneficiary Type – Primary / Contingent.
Beneficiary Percentage – expressed as 0–100. Beneficiaries tied to cash value policies appear in the Beneficiaries report.
Step 1 — Open the import modal
As with other imports, you can start from:
Households: Go to Households →Click Add or Update button → Import Data.
Imports: Go to Imports → Click Import button.
Step 2 — Choose what to import
Select Import account data.
Click Next.
From the list of account data import types, choose Insurance.
Step 3 — Upload your spreadsheet
Upload one spreadsheet at a time. Multiple files at once are not supported.
If your data is split across multiple sheets, run imports separately until all policies are in.
Click Next to continue.
Step 4 — Map your columns
On the mapping step, match each spreadsheet column to the correct SurgeTK field.
At minimum, you must provide:
Policy Number
Client ID (for new policies)
Additional mappings strengthen reports and Value Adds:
Cash Value → for net worth calculations.
Beneficiary details → for beneficiary reports.
Click Import when ready.
Step 5 — Monitor progress (don’t refresh)
The progress indicator will show:
Created — new insurance records added.
Updated — existing policies updated.
Duplicates — policies flagged as duplicates.
Failed — rows that could not be imported, with error details.
Do not refresh or navigate away until the import completes.
Step 6 — Review the import report
Go to Imports to view a record of your run. From there you can:
Open the import report to see results.
Re-download the original spreadsheet you uploaded.
Best practices
Use stable Policy Numbers. Don’t change them between imports.
Include cash value. Any policy with a cash value is automatically included in the Net Worth report.
List beneficiaries. Beneficiaries tied to cash value policies will appear in the Beneficiaries report.
Format names consistently. Use
Last, Firstformat for beneficiaries.Iterate safely. Import additional spreadsheets as needed—one at a time.
FAQs
Q: Can I import multiple spreadsheets at once?
No. Upload one spreadsheet at a time.
Q: Do I need Client ID for updates?
No. If updating an existing policy, the Policy Number is enough. Client ID is only required when creating new policies.
Q: Will cash value policies show in reports?
Yes. Any insurance record with a cash value is included in the Net Worth report.
Q: Where do insurance beneficiaries show up?
Beneficiaries for policies with cash value are included in the Beneficiaries report.
Q: Does this import handle non-insurance beneficiaries?
No. Beneficiaries for financial accounts are imported separately through the Beneficiaries import.
Quick start tip: Download the template, fill in Policy Number and Client ID, add cash value and beneficiaries where applicable, then import one file at a time.