- Created by JohnW, last modified by AdrianC on Feb 10, 2016
You are viewing an old version of this page. View the current version.
Compare with Current View Page History
« Previous Version 25 Next »
https://help.myob.com/wiki/x/IACy
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 accepted account types and tax/GST codes, 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 for the list of accepted account types.
- 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
When creating an import file, use the following Account Types for your accounts. Any other account type will cause the import to fail.
Also make sure you don't use the same account number more than once.
Account Type |
---|
Bank |
Other Current Assets |
Other Asset |
Fixed Asset |
Credit Card |
Other Current Liability |
Other Liability |
Long Term Liability |
Equity |
Income |
Cost of Sales |
Expense |
Other Income |
Other Expense |
Accounts Receivable |
Accounts Payable |
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 |