Data Import - Leave Balances

Leave Balances can be imported for all (or some) employees in your company against any leave type which can hold a balance (i.e. not Take Only leave types). This import is done by client Payroll Administrators opposed to the Support Team. 

Data must be entered into the supplied template attached to this page using the correct format. Failure to do so will either result in an error for most leave types, or different and incorrect balances being imported in the case of Annual Leave.

Importing:

To import the leave, navigate to the Employee tab > Import Leave Balance > either Selected or All Employees.

There are two different types of Import types, 

(1) Implementation Import Type

(2) Additional Entitlement/Accrual Import Type

Implementation Import Type:

The Implementation import type is used when doing new implementations or leave conversions when you want to update the leave balances to new values.

This import enables you to import entitlement balances, or leave taken in advance

What are the columns for?

• Balance in Hours

  • For a implementation (no existing balance), this value will simply be imported into the current entitlement

  • For a leave conversion (existing balance), this will zero out any existing entitlement and leave taken, and this value will be imported into the current entitlement.

  • If Importing values for Accrual Taken and Accrual Taken Value, this column should contain a 0.

  • Despite the name of this column, if the leave unit is Days (or Weeks), this value should be in Days (or Weeks).

• Balance includes Accrual

  • This should usually contain N (meaning No).

  • If this column contains Y, the balance you import will be reduced by the accrual to calculate the entitlement.

• Accrual Taken and Accrual Taken Value

  • Using these columns is the equivalent of entering leave taken in advance like this

• If entering a value in one of these columns, you need to enter a non-zero value in both

• When using these columns, you must have a 0 in the Balance in Hours column

• If you are not using these columns, they should be left blank

• Do not add a $ to the Accrued Taken Value

• For a leave conversion (existing balance), the leave taken will be adjusted so that the leave taken in advance matches the values specified. This could require the application creating negative adjustments, and an additional leave taken adjustment will be created if they currently have an entitlement balance.

When uploading the file, you will also be asked to select the date you wish to calculate the accrual for. This date is only used if the Leave Type being imported accrues (e.g. Annual Leave) and 'yes' is being used in column 6. The date selected should be the Period End Date of the last closed pay run.

Leave Balance Import Template:

Additional Entitlement/Accrual Import Type:

The csv file needs to include the additional leave to be added to the employees' existing entitlement or accrual balance.

Any additional entitlement will be added to the Current Entitlement line on the leave summary screen for Annual Leave and the latest entitlement line for other leave types (e.g. Sick Leave).

Select the Additional Entitlement/Accrual option and use Browse to locate the csv file to import.

Follow the wizard through the validation step (Step 2). This will display any invalid entries which will be ignored on import.

In Step 3 you can check the entitlement and accrual totals before proceeding with the import. In the example below both the accrual and entitlement had 1 on the csv import file, so the balances will both increase by 1.

After the import is complete the adjustments will be visible on the leave summary screen (Show Adjustments). As with manual adjustments the latest open pay packet will need to be merged in order to see the updated Leave Liability.

Additional Leave Balance Import Template:

Please note:

• For Annual Leave imports we suggest trialing the import with a small number of employees before attempting this on a large scale., to ensure the calculations are working as you expect.
• All leave imported will appear in the bottom / most recent row (year) in the Leave Summary Screen. Leave will not be allocated or split into the entire range of tenure.
• Importing leave will replace the Leave Summary Screen for the employee. This is a permanent process and importing leave cannot be reversed.