- Created by BrianQ, last modified by AdrianC on Jan 27, 2016
You are viewing an old version of this page. View the current version.
Compare with Current View Page History
« Previous Version 14 Next »
https://help.myob.com/wiki/x/aAOy
ANSWER ID:4185
This page explains how to manually import your MYOB Payroll journals into AccountRight or other accounting software.
Want to automate this process?
Payroll can integrate automatically with AccountRight as described in Integrating Payroll with your accounting software.
Setup
There are few things that you need to set up, but once this is done it is an easy procedure to complete each pay period.
In your accounting software, you first want to ensure the following:
- Make sure that you have the following accounts in your Chart of Accounts:
- Liability account for Wages or Payroll Liability, such as Wages Clearing
- Expense Account for Wages and Salaries, or one for each department
- If you use Job Centres, print a list of all your job codes (this is found in the Accounts tab reports index)
- Create a folder on your hard drive where MYOB Payroll will save the journal file, such as My Documents\Payroll
- Export the chart of accounts from your accounting software ready for use in MYOB Payroll. Make sure the export file is a comma-separated .txt file called "accounts.txt" containing the following fields: account code, account description, and account type (optional), e.g. 2-2000 Wages Liability.
For more information on this, see the Payroll Help (Help > Contents).
The next steps in the setup process depend on what MYOB accounting software version you are using (new or Classic AccountRight).
- Go to the File menu and choose Import/Export Assistant.
- Select the Export Data option then click Next.
- In the Export field, select Accounts.
- In the Select Accounts type field, select Account Information.
- Click Next.
- For the Separate data using option, select Commas.
- Deselect the option Include field headers in the file.
- Click Next.
- From the list of Available fields, click Account Number, then click Add. Also add Account Name and Header.
- Click Export.
- Save the export file with the default name (ACCOUNTS.TXT).
- Save the file in the folder created in step 2 above.
- Go to the File menu and choose Export Data then choose Accounts, then choose Account Information.
- For the Export File Format field select Comma-separated, and for the First Record is field select Data Record.
- Click Continue.
- Select Account Number, Account Name, and Header, then click Export.
- Save the export file with the default name (ACCOUNTS.txt).
- Save the file in the folder created in Step 2 above.
With your accounting software set up, it's time to set up Payroll.
- Go to the Tools menu and choosing Options then clicking Accounting tab.
- Choose Other as the Accounting System.
- In the Path field, click the Browse button (...) and locate the path for the folder containing the ACCOUNTS.txt file (as created in step 2 above). Note: If you receive a System Error "9/Data type mismatch", see our support note .
- For the Default General Ledger Code for Payroll Liabilities, select the account for Payroll (wages).
- Click OK.
- Go to the Maintenance command centre and click Maintain Departments.
- For the General Ledger Expense Code, specify the applicable account for each Department.
- If you use Jobs in your Accounting software you can enter the Job number as the Cost Centre Code in each relevant Department. This needs to be typed exactly the same as the Job Number in your accounting software.
- Go to the Maintenance command centre and click Maintain Pay Codes.
- Select the TAX pay code then click the Other tab.
- For the General Ledger Liability Code, select your PAYE Liability account.
The setup is now complete!
Creating the journals
Each time you Finalise the pay, the payroll.txt file is created. This file is in the path located in the path as defined in Tools > Options (the folder created at step 2 above). As with the setup, this process differs depending on your accounting software.
- Go to the File menu and choose Import Data then choose Transaction Journals.
- For the Import File Format field select Comma-separated.
- For the First Record is field select Data Record.
- Click Continue.
- Browse to the Payroll.txt file, select the Payroll.txt file saved in the folder created in step 2 earlier in this support note.
- Click Open.
- Click Match All then click Import. Note: In AccountRight Premier/Enterprise, the Allocation Memo needs to be matched manually.
- The imported journal can now be found in AccountRight as a general journal.
- Go to the File menu and choose Import/Export Assistant.
- Select the Import Data option then click Next.
- In the Import field, select Transaction Journals.
- Click Browse and select the Payroll.txt file saved in the folder created in Step 2 earlier in this page.
- Click Next.
- Select the Commas and Data options, then click Next.
- Match the fields by clicking Match All or match the fields individually by name, then click Next.
- If you want to make a backup of your AccountRight company file, click Back up, otherwise click Import.
- Click Close. The imported journal can be found in your AccountRight company file as a general journal.
After you have imported the wages journal from MYOB Payroll to clear out the Payroll and PAYE Liability accounts, the following transactions need to be entered into your MYOB accounting software:
- Go to the Banking command centre and click Spend Money. Select the Pay from Account: option and specify the Cheque account (the Account No needs to be set to your Payroll Liability account (2-xxxx)).
- The payment to the IRD for PAYE can also be entered as a Spend Money transaction, with the PAYE liability account selected.