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.

Components of an account in your Xero chart of accounts - Type

Don't change your MYOB account types in your import file. Xero will map them automatically.

Xero maps MYOB account types as follows:

MYOB account typeXero account type
Accounts PayableCurrent Liabilities
Accounts ReceivableCurrent Assets
AssetCurrent Assets
Bank

Current Assets

(You can select Bank, Credit Card or PayPal account during the import process)

Cost of SalesDirect Costs
Credit Card

Current Liabilities

(You can select Credit Card account during the import process)

Current AssetCurrent Assets
Current LiabilityCurrent Liabilities
DepreciationDepreciation
Direct CostDirect Costs
EquityEquity
ExpenseExpenses
ExpensesExpenses
Fixed AssetFixed Assets
IncomeSales
LiabilityCurrent Liabilities
Other AssetNon-current Assets
Other ExpenseExpenses
Other IncomeOther Income
Other LiabilityCurrent Liabilities
Other RevenueOther Income
OverheadOverheads
PrepaymentCurrent Assets
RevenueRevenue
SaleSales
Term LiabilityNon-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 MYOBXero account type
Current AssetsCurrent Assets
Fixed AssetsFixed Assets
Current LiabilitiesCurrent Liabilities
Long Term LiabilityNon-current Liabilities
Other Current LiabilitiesCurrent Liabilities
Other Long Term LiabilitiesNon-current Liabilities

Tax rate (MYOB: GST code)

Xero maps MYOB GST codes to Xero tax rates. If an account doesn't have a GST code, Xero will import the account with the rate No GST, which you can update later.

Components of an account in your chart of accounts - Tax rate

MYOB GST codeXero tax rate
ENo GST
NoneNo GST
N-TNo GST
RRRZero Rated
S1515% GST on Income (where account category is revenue or liability)
S1515% GST on Expenses (where account category is expense, asset or equity)
Zero RatedZero Rated

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.

What are system accounts?

Here's how Xero maps MYOB's system accounts to Xero's system accounts:

MYOB system account nameXero system account nameXero system account typeXero system account tax rate

Accounts Receivable

Trade Debtors

Accounts ReceivableCurrent AssetNo GST

Accounts Payable

Trade Creditors

Accounts PayableCurrent LiabilityNo GST
Unpaid Expense Claims Unpaid Expense ClaimsCurrent LiabilityNo GST
GSTGSTCurrent LiabilityNo GST

Historical Balancing

Historical Adjustment

Historical AdjustmentCurrent LiabilityNo GST
RoundingRoundingCurrent LiabilityNo GST
Retained EarningsRetained EarningsEquityNo GST