Import Insurances (Insurance Module)

Overview

The Insurance module allows you to manage a list of insurances and rates in your portal and assign these to jobs, occupations, workplaces or customers.

This module is not enabled by default in portals, so if you are interested in learning more about switching this on for your portal, please contact our Support Team.

Use the Insurance Importer

You can import new or update existing insurances using the Config > Payroll > Insurance Importer. The importer allows a maximum of 5000 rows per import. If the number of insurances being imported exceeds this limit, you will need to split the import into multiple uploads.

Create a New Insurance using the .csv Template

You can download the blank .csv template from Config > Payroll > Insurance Importer by clicking on ‘Download template for insurances’.

The template will include a heading row that matches the columns in the Config > Payroll > Insurances report. You will need to enter the relevant details for each insurance on a separate row in the template.

Region	The option to assign a region will only appear if more than one region has been enabled in your portal.
State	The abbreviated state code for the insurance (eg NSW for New South Wales, VIC for Victoria)
Insurance ID	Not required for a new insurance, as the ID will be assigned when the insurance is created. If an ID is entered in this field, the system will assume that you are attempting to update an existing insurance.
Insurance Code	An alphanumeric identifier for the insurance
Classification Name	The name that the insurance will display as in your portal
Tags	Custom labels that attach to an insurance and can be used to search and filter for a specific insurance or group of insurances. For multiple tags, separate each with a comma
Gazetted Insurance Rate	The industry-standard insurance rate
Custom Insurance Rate	The insurance rate dictated to you by your insurer
Start Date	The date that the insurance should start in the system. Can only be set as the current or a future date  Formatted as YYYY-MM-DD
End Date	Optional field; if left blank, no end date will be applied to the insurance Formatted as YYYY-MM-DD
Notes	Additional details that you would like to report against the insurance

Update an Existing Insurance a New Insurance using the .csv Template

You can update existing insurances in bulk using the Export Re-Import Template CSV, which is available to download from Config > Payroll > Insurances.

This .csv includes a heading row that matches the columns in the Insurances report. You can edit the data for each insurance and then import the updated file using the Insurance Importer.

Some considerations when updating the Export Re-import Template are:

• the Region and State cannot be updated. These fields lock when an insurance has been created;
• the Insurance ID should be provided when updating an existing insurance. The ID will be used by the system to validate and modify the data from the .csv against the data in the portal;
• if no Insurance ID is provided, a new insurance will be created