How Xero maps MYOB accounts to Xero
Learn how Xero maps your MYOB account information to Xero's chart of accounts. If you get errors when you import your MYOB accounts, this information will help you troubleshoot.
Code (MYOB: Account number)
Your account number in MYOB becomes your account code in Xero. Change the account number in your MYOB CSV file before you import it into Xero if it doesn't meet these criteria:
- The code is unique.
- The code includes letters, numbers or symbols, up to 10 characters. You can use symbols within the code, but not at the start.
Name (MYOB: Account name)
Ensure your account names meet these criteria:
- The name is unique.
- The name uses letters, numbers or symbols, up to 150 characters. You can use symbols within the name, but not at the start.
- For bank accounts, the name has fewer than 30 characters so it fits on the Dashboard.
Type (MYOB: Account type)
Xero uses the account type to determine where the account appears in your financial reports.
Xero maps MYOB account types as follows:
|MYOB account type||Xero account type|
|Accounts Payable||Current Liabilities|
|Accounts Receivable||Current Assets|
(You can select Bank, Credit Card or PayPal account during the import process)
|Cost of Sales||Direct Costs|
(You can select Credit Card account during the import process)
|Current Asset||Current Assets|
|Current Liability||Current Liabilities|
|Direct Cost||Direct Costs|
|Fixed Asset||Fixed Assets|
|Other Asset||Non-current Assets|
|Other Income||Other Income|
|Other Liability||Current Liabilities|
|Other Revenue||Other Income|
|Term Liability||Non-current Liabilities|
In addition, if you've used any of the following account names to group accounts in MYOB, Xero will import the accounts within the group and assign them the Xero account type shown:
|Account name used to group in MYOB||Xero account type|
|Current Assets||Current Assets|
|Fixed Assets||Fixed Assets|
|Current Liabilities||Current Liabilities|
|Long Term Liability||Non-current Liabilities|
|Other Current Liabilities||Current Liabilities|
|Other Long Term Liabilities||Non-current Liabilities|
Tax rate (MYOB: Tax code)
Xero maps MYOB Tax codes to Xero tax rates. If an account doesn't have a Tax code, Xero will import the account with the rate BAS Excluded, which you can update later.
|MYOB Tax code||Xero tax rate|
|None or other not in this list||BAS Excluded|
|GNR||GST Free Expenses|
|CAF||GST Free Capital|
|CAP||GST on Capital|
|FRE||GST Free Income (where account category is revenue or liability)|
|FRE||GST Free Expenses (where account category is expense, asset or equity)|
|GST||GST on Income (where account category is revenue or liability)|
|GST||GST on Expenses (where account category is expense, asset or equity)|
System accounts (MYOB: System accounts)
Xero uses some accounts in the chart of accounts, called 'system accounts', for special purposes. There is one system account in Xero which MYOB doesn't have: Tracking Transfers. Xero will create this system account when you import your MYOB file.
Here's how Xero maps MYOB's system accounts to Xero's system accounts:
|MYOB system account name||Xero system account name||Xero system account type||Xero system account tax rate|
|Accounts Receivable||Current Asset||BAS Excluded|
|Accounts Payable||Current Liability||BAS Excluded|
|Unpaid Expense Claims||Unpaid Expense Claims||Current Liability||BAS Excluded|
|GST||GST||Current Liability||BAS Excluded|
|Historical Adjustment||Current Liability||BAS Excluded|
|Rounding||Rounding||Current Liability||BAS Excluded|
|Retained Earnings||Retained Earnings||Equity||BAS Excluded|