Importing Pay Run Journals into MYOB

Although there is no direct integration with MYOB, you are able to manually export pay run journals into your MYOB AccountRight or MYOB AccountRight Live system.

Follow these steps below to export the journals into your MYOB account.

Getting started

Set up the Integration
  1. Firstly, go to Payroll Settings.
  2. Click on Integrations.
  3. Select Add MYOB from the list of journal services. myob10.jpg
  4. A further sublist will appear where you can then choose between AccountRight and AccountRight Live. Select and click Enable. myob_integration_2__2_.jpg
Chart of Accounts Settings

Now your journal service is enabled, make sure that your Chart of Accounts has been imported and configured properly. These settings can be found by going to Payroll Settings then select Chart of Accounts

Mapping GL Accounts

Complete a Pay Run
  1. Next, click on Pay Runs.
  2. Select a pay run or create a new one.
  3. When you have finalised a pay run, you will see the button to Export to MYOB.export_to_myob__1_.jpg
  4. Click Export to MYOB. The system will generate a TXT file that is ready to be imported into the relevant MYOB system. This is in a format that is compatible with MYOB. 
Import the TXT file into MYOB
  1. Log into your MYOB account
  2. From within MYOB AccountRight, click the File option in the top left hand corner and select Import/Export Assistant.
  3. export_myob.jpg
  4. Select Import Data.
  5. Then click Next.export_myob_2.jpg
  6. Next, select Transaction Journals from the list of importable data.
  7. Then Browse and select the CSV file that was downloaded from the Pay Run page of the payroll business file.export_myob_3.jpg
  8. Keep Tabs and Headers or Labels as the format options.export_myob4.jpg
  9.  Select Auto Match for the fields to be imported:myob5.jpg
  10. Finally, select Import (after backing data up, if desired).myob6.jpg
  11.  The next page will confirm the import, along with any errors or warnings associated with it.myob7.jpg

Helpful Hint

You can also refer to the following MYOB link: Importing data.

Further information

Import Skipped: Use of “Header Accounts” in Chart of Accounts Mapping

One of the reasons your journal import may be skipped is the use of “Header Accounts” in Chart of Accounts Mapping.

MYOB has two account types: Header Accounts and Detail Accounts. Header Accounts are collections of various Detail Accounts (eg. Phone, Electricity, Gas) under one common grouping (eg. Utilities). Header Accounts are not able to have transactions recorded against them directly and if any should be included in your Chart of Accounts mapping, it will cause the entire import to be skipped.

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

Comments

0 comments

Article is closed for comments.