Select your platform and then browse by platform category

Who are you and what section are you in?

How do I import and export opening balances in EH Payroll classic?

Available for the following plans: Employment Lite, Employment Plus, Employment Unlimited
Available for the following Payroll plans: Essentials, Standard, Premium

Opening balances allows you to transfer your employee entitlement information, from your previous payroll platform over to EH Payroll classic. Whereas the purpose of historical gross earnings is so your payroll platform can calculate accurately the average wage earnings for your employees when they take leave. 

The Historic Gross Earnings and Opening Balances feature allows you to import in bulk your employee's opening balances and historical earnings and export this information if needed as well. You can also use this feature to configure the initial financial year for your business.

Getting started

The below premise will walk you through how to add your organisation's initial financial year.

Add initial financial year
  1. Click the   Business Settings menu.
  2. Click the Payroll Settings submenu.
  3. Click the Opening Balances button.
  4. Select the Tax Year from the Tax Year drop-down box.
  5. Click the Save button.
    Opening__NZ__1.jpg

Daily Activities

The below will walk you through how to import and export your organisation's opening balances and historical gross earnings.

Export opening balances
  1. Click the   Business Settings menu.
  2. Click the Payroll Settings submenu.
  3. Click the Opening Balances button.
  4. Click the Export   button.
  5. Click the Opening Balances button.
    Opening__NZ__2.jpg
  6. Choose from the following data type customisations:
    • Template with employee data.
    • Template with employee data (Including terminated employees).
    • Empty template.
  7. Select from the following file formats:
    • XLSX.
    • CSV.
  8. Click the Download button.
    Opening__NZ__3.jpg
Export historic gross earnings
  1. Click the   Business Settings menu.
  2. Click the Payroll Settings submenu.
  3. Click the Opening Balances button.
  4. Click the Export   button.
  5. Click the Historic Gross Earnings button.
    Opening__NZ__4.jpg
  6. Choose from the following data type customisations:
    • Template with employee data.
    • Template with employee data (Including terminated employees).
    • Empty template.
  7. Select from the following file formats:
    • XLSX.
  8. Click the Download button.
    Opening__NZ__5.jpg
Import opening balances
  1. Click the   Business Settings menu.
  2. Click the Payroll Settings submenu.
  3. Click the Opening Balances button.
  4. Click the Import   button. 
  5. Click the Opening Balances button.
    Opening__NZ__6.jpg
  6. Click the   Select File button.
    Opening__NZ__7.jpg
  7. Click the   Confirm Upload button.
    Opening__NZ__8.jpg

    Helpful Hint

    After the importing process finishes, a summary appears on your screen outlining what data successfully uploaded and what errors occurred.

    Opening__NZ__9.jpg
Import historic gross earnings
  1. Click the   Business Settings menu.
  2. Click the Payroll Settings submenu.
  3. Click the Opening Balances button.
  4. Click the Import   button. 
  5. Click the Historic Gross Earnings button.
    Opening__NZ__10.jpg
  6. Click the   Select File button.
    Opening__NZ__11.jpg
  7. Click the   Confirm Upload button.
    Opening__NZ__12.jpg

    Helpful Hint

    After the importing process finishes, a summary appears on your screen outlining what data successfully uploaded and what errors occurred.

    Opening__NZ__13.jpg

Explore related content

Was this article helpful?
0 out of 3 found this helpful