MYOB
Microkeeper exports each pay run as a MYOB Transaction Journal: a file with its wages, super, PAYG withholding and net pay against your MYOB accounts, which you import into MYOB.
| Required plan | All plans |
|---|---|
| Required access | Settings to set up accounts, and Report and Payroll to export pay runs |
This guide covers how to:
- Add your MYOB accounts and Jobs.
- Export a pay run's Transaction Journal.
- Import the journal into MYOB AccountRight.
Before you export to MYOB
Set the ABN's accounting system to MYOB. See Choose the accounting system for each ABN.
Add your MYOB accounts and Jobs
Open the ABN's Chart of Accounts, from ABN and Pay Cycles. While it has no accounts, it opens the Quick Add Common Accounts window with MYOB's usual payroll accounts:
| Account Name | Account Number |
|---|---|
| Payroll - Wages & Salaries | 6-4100 |
| Superannuation | 6-4200 |
| Superannuation Payable | 2-1355 |
| PAYG Withholding Payable | 2-1350 |
| Business Bank Account #1 | 1-1110 |
Change any to match your MYOB accounts list, and click Add Accounts. Add other accounts with Add Account, using the MYOB account number. See Add your account codes.
To post wages to MYOB Jobs, such as a project or venue, add each Job on the Tracking Category 1 tab, with its MYOB Job Number as the name. See Add tracking categories.
Export a pay run's Transaction Journal
- Navigate to Menu > Payroll > Payruns and open the pay run.
- Click Complete Payrun, then 3. Export.
- Check each line's Description, Account and Job, and click Save Settings. See Map each pay run line to an account.
- Click MYOB Export, then your MYOB version: Current (2015+), or Legacy (v19 or earlier).
The journal downloads as a tab-separated text file, dated the pay run's Payment Date, with these columns:
| Format | Columns |
|---|---|
| Current (2015+) | Date, Memo, Allocation Memo, Account Number, Is Credit, Amount, Job |
| Legacy (v19 or earlier) | Date, Memo, Allocation Memo, Account Number, Debit Amount, Credit Amount, Job |
The Memo is the same on every line and names the pay run. Each line's Allocation Memo is its Description from 3. Export.
Import the journal into MYOB AccountRight
Open the Import/Export Assistant
In MYOB, go to File > Import/Export Assistant.
On the Welcome screen, choose Import Data and click Next.
Choose the file
In Import, choose Transaction Journals. Click Browse, choose the file from Microkeeper, and click Next.
Set Data is separated by to Tabs, and The first line of the file contains to Headers or Labels. Click Next.
Match the fields and import
On Match Fields, click Auto Match, then Next.
Click Import.
The Conclusion shows the records imported without errors.
If MYOB shows an error, check each account number in the ABN's Chart of Accounts is in your MYOB accounts list.