Import/Export Employee Opening Balances (Initial Values)

Follow

To import the employee opening balances, first go into (Business) 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 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

Matching Criteria

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

Deleting Data

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 support@yourpayroll.com

 

Powered by Zendesk