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.

Staff

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

Loadings

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 Payroll → Export templates page, and click the Create new button.
  2. Give the export a name like “MYOB” and Select MYOB from the Type drop-down and click the Save button.

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
2.25 of 4 votes