To import the employee opening balances, first go into Payroll Settings and then to the Opening Balances menu:
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 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 tax file number specified and it is not a 'special' TFN (see: Special Tax File Numbers), then we'll the tax file number to match 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 tax file 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, first go into Payroll Settings and then to the Opening Balances menu:
QBO users get to Payroll Settings by clicking on the ‘Payroll Settings’ button:
Next, click the Export button to the right of the page heading:
The 'Export Opening Balances' page will be displayed:
Simply 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 [email protected]