To import the employee opening balances, go to: 'Payroll Settings' >'Business settings' > 'Opening Balances'.
Next, click the 'Import' button to the right of the page heading.
The following Import Opening Balances page will be displayed.
Select the file that you wish to upload and then click the 'Upload' button.
Once the file has been processed, a summary will be displayed.
When importing opening balances, employee records are matched according to the following criteria (in order of priority):
- If there is a National Insurance number specified then we will match the NI no to the employee.
- If there is an external ID specified, then we'll use the external ID to match the employee.
- Otherwise, we will use the combination of National Insurance number AND name to match the employee.
If you want to use this import file to remove data from the opening balances, in bulk, you'll need to use the value "(clear)" without the quotes in the appropriate field on your import file to remove it from the matching field on the opening balance page of the employee record.
Exporting Opening Balances
To export the employee opening balances go to 'Payroll Settings' > 'Business Settings' > 'Opening Balances'.
Next, click the 'Export' button to the right of the page heading:
The 'Export Opening Balances' page will be displayed:
Select the type of data that you wish to export, the file format and then click 'Download'.
If you have any questions or feedback please let us know via firstname.lastname@example.org