Exporting payroll data to MYOB

Data mapping

It is important to map all the necessary data before you run your first export. It is also important to keep the below data mapping in mind as you add/remove staff and loadings into both systems in the future.


Go to the Account → Staff page of your account. Ensure the staff IDs match the staff card IDs you have in MYOB.


Go to the Settings → Awards page of your account. Ensure the loading codes of the awards you are using match the Payroll Categories you have in MYOB.

Creating the export template

  1. Go to the Add-ons → Manage add-ons page.
  2. Click the MYOB AccountRight File tile.
  3. The create MYOB AccountRight option will appear, with default of Do not export for Job field.
  4. Click Save.

Running an export to MYOB

Now the export template is created, it will be simple to download a file to upload into MYOB each pay cycle. To do that:

  1. Go to the Payroll → Pay cycles page. Ensure the pay cycle you wish to export is Ready to process.
  2. Click the Export button next to the pay cycle you want to export.
  3. Find the MYOB template you created in the first two steps and click the Export button.
  4. The system will generate a file you can then upload into MYOB by following the steps below.

Importing the file into MYOB

Go to File → Import/Export Assistant.

MYOB import step 1

Select Timesheets from the Import drop-down then Browse for the file you just downloaded from Ento.

MYOB import step 2

Select Tabs in the Data is separated by options, and Headers Or Labels in the The first line of the file contains options.

MYOB import step 3

Click the Auto Match button. Ensure the fields have been matched correctly and press the Next button.

MYOB import step 4

Your timesheets should now be imported.

Was this article helpful?

Exporting payroll data to MYOB
3.89 of 19 votes