- Created by JohnW, last modified by AdrianC on Feb 04, 2016
You are viewing an old version of this page. View the current version.
Compare with Current View Page History
« Previous Version 24 Next »
https://help.myob.com/wiki/x/Dpyi
How satisfied are you with our online help?*
Just these help pages, not phone support or the product itself
Why did you give this rating?
Anything else you want to tell us about the help?
If you're setting up businesses for your clients, or if you're moving to MYOB Essentials from MYOB AccountRight or AccountEdge, you can replace the default accounts list with one imported from MYOB AccountRight.
1. Export your accounts list from MYOB AccountRight
You can use the Import/Export Assistant in MYOB AccountRight to export your accounts list. Make sure the file you're exporting is in either comma- or tab-separated format, and that it includes headers.
You need to include at least the following fields:
- Account Number
- Account Name
- Account Type
- Tax Code
- Inactive Account
See the AccountRight help for more details on how to export your accounts list.
Or, manually create an import file
If you're not using MYOB AccountRight or AccountEdge, but still want to import an accounts list, you can manually create a file containing your account information and import it into MYOB Essentials.
The imported list must be a text file (.TXT), in comma- or tab-separated format. You can create this file using Excel and save it as a Text (Tab Delimited) file. The first row must contain the headings "Account Number", "Account Name", "Account Type", "Tax Code" (for Australia) or "GST Code" (for New Zealand), and "Inactive Account", and each row must contain these details for a single account. For a list of the account types and tax/GST codes in MYOB Essentials, see below.
Want to download a sample import file? Right-click the sample file: AU | NZ and save it on your computer. Open the file, fill in your own account details and save it (as a .TXT file) before importing it into MYOB Essentials.
2. Import the accounts list into MYOB Essentials
To import the accounts list into MYOB Essentials, go to the settings menu () and choose Accounts List.
On the Accounts List page, click Import Accounts.
On the Import an accounts list page, click Upload list of accounts. Choose the .TXT file containing your accounts list, and click Open.
A summary appears on the page, explaining which accounts will be imported, which ones have unsupported tax codes, and which accounts can't be imported at all.
Click Continue.
The accounts list is imported, and an Import successful message appears at the top of the Accounts List page, describing details of what was imported. You can see your new accounts list by scrolling down to the table on this page.
Things to note
When you import accounts, all of your existing MYOB Essentials accounts will be replaced, except for:
- MYOB Essentials system accounts
- Accounts with balances in MYOB Essentials
- Accounts used in MYOB Essentials transactions
In addition to this, there are a few restrictions on which accounts will be imported, and what information will be brought into MYOB Essentials.
Accounts that won't be imported
You can’t replace:
- Accounts that have a balance in MYOB Essentials
- Accounts that have been used in transactions
- MYOB Essentials system accounts (those marked with a padlock). See the table below for details of which MYOB Essentials system accounts will be used in place of your AccountRight system accounts.
You can't import:
- Accounts with names containing any of the following special characters: < > ( ) # % ; + ' \ "
- AccountRight header accounts, as these don't exist in MYOB Essentials.
Other data that won't be imported
- Some tax codes (including consolidated tax codes such as WET) are not available in MYOB Essentials, and won't be imported. See the table below to see which tax codes will be assigned to accounts using these tax codes.
- Some account types are different between MYOB Essentials and MYOB AccountRight. See the table below to see how account types will be mapped.
- Opening balances and account balances will not be imported. The only information that will be imported is the account name, account number, account type, tax code, and whether the account is active or inactive
Using an imported accounts list when creating client businesses (MYOB Partners only)
When you use your Partner Dashboard to create a new business for a client, you can use an existing business as a template when choosing the chart of accounts.
So if you've imported a customised accounts list into one of your clients' businesses, it will always be available to use whenever you're creating a new business.
Account types and tax/GST codes
The tables below show how AccountRight accounts and tax codes are mapped to MYOB Essentials accounts.
When importing accounts into MYOB Essentials, you need to use the AccountRight types listed below. Also listed is the equivalent account types in MYOB Essentials.
Account types | |
---|---|
AccountRight | MYOB Essentials |
Bank | Banking |
Other Current Assets | Current Assets |
Fixed Asset | Fixed Assets |
Credit Card | Credit Card |
Other Current Liability | Current Liabilities |
Long Term Liability | Long Term Liabilities |
Equity | Equity |
Income | Income |
Cost of Sales | Cost of Sales |
Expense | Expense |
Other Income | Other Income |
Other Expense | Other Expense |
Other Asset | Current Assets |
Other Liability | Current Liabilities |
Accounts Receivable | Current Assets |
Accounts Payable | Current Liabilities |
Although you can't change system accounts, the following system accounts are available in MYOB Essentials.
AccountRight account name | Essentials account name | AU / NZ only |
---|---|---|
Discounts Taken | Discount received |
|
Discounts Given | Discounts given |
|
Superannuation or Superannuation Expense | Superannuation expense KiwiSaver expense | AU NZ |
Wages & Salaries or Salaries & Wages | Wages & salaries |
|
ABN Withholding Credits | ABN withholding credits | AU |
Trade Debtors or Accounts Receivable | Account receivable |
|
ABN Withholding Payable | ABN withholdings payable | AU |
Trade Creditors or Accounts Payable | Accounts payable |
|
GST Collected | GST collected |
|
GST Paid | GST paid |
|
PAYG Withholdings Payable | PAYG Withholdings payable | AU |
Payroll Deductions Payable or Payroll Deductions | Payroll deductions |
|
Superannuation Payable | Superannuation payable KiwiSaver payable | AU NZ |
NA | Allocate me (Withdrawal) |
|
NA | Allocate me (Deposit) |
|
Historical Balancing Account / Historical Balancing | Historical Balancing |
|
Current Earnings / Current Year Earnings | Current year earnings |
|
Retained Earnings | Retained earnings |
|
GST Input Tax Adjustment | GST input tax adjustment |
|
GST Output Tax Adjustment | GST output tax adjustment |
|
PAYE Tax Payable | PAYE withholdings payable | NZ |
If an account uses a tax code that doesn't exist in MYOB Essentials, it will usually be assigned the NTR tax code. Note that consolidated tax codes aren't supported in MYOB Essentials.
Australia
AccountRight | MYOB Essentials | Notes |
---|---|---|
FRE | FRE |
|
CAP | CAP |
|
GNR | GNR |
|
GST | GST |
|
N-T | NTR |
|
GW | NTR | Consolidated Tax Codes are not supported in MYOB Essentials. AccountRight accounts imported with consolidated tax codes are assigned the NTR tax rate. |
IMP | NTR | |
LCG | NTR | |
LCT | NTR | |
VWH | NTR | |
WEG | NTR | |
WET | NTR | |
WST | NTR | |
ABN | ABN |
|
INP | INP |
|
ITS | ITS | |
EXP | EXP |
New Zealand
AccountRight | MYOB Essentials |
---|---|
S15 | S15 |
S | S |
Z | Z |
E | E |
IMP | I |
N-T | Z |