Bank Account Mapping for MYOB files

16 October 2014
0 Comments

At Xerocon 2014 we received some excellent feedback on what Partners would like us to do. We are excited to announce the first of several new features.

Simple Bank Account Type Selection

After uploading your file you can now select how you want bank account types to appear in Xero.

In your file bank accounts will be set as either bank, credit card, asset or liability accounts.

We recommend that any accounts that require bank feeds or reconciliation should be set up as bank accounts or credit cards and all other accounts be changed to an asset or liability account. This is because you cannot create manual journals to bank accounts in Xero.

NOTE: If you change a bank account or credit card to an asset or liability this will result in a loss of link between payments and contacts for this account.

The benefit of changing the account types to an asset or liability is that you are still able to make payments to these accounts and also do manual journals.

If you have had to change bank account type in Xero you will appreciate how much of a time saver it is to be able to choose the appropriate type upfront, prior to starting the conversion.

Where do the Bank Account Mapping Defaults come from?

To help you get the selection right, we create some smart defaults. Any bank account or credit card identified in the source system is shown in one of two lists. At the top, we show all bank/credit card accounts that had been reconciled in the source file. You can see the reconcile date to make it easier to see whether they are still relevant. Any asset accounts a preset to Bank, the Liability accounts to Credit Cards.

The second list shows all other bank accounts that have not been reconciled (or not reconciled after the conversion date). These are normally more useful to be imported as Current Assets or Current Liabilities and default to these choices. They are still coming across with the ability to pay invoices/bills from them.

Can I change account types myself in Xero?

Should you need to modify bank account types you can do so in Xero afterwards. It is not a simple process so we have written a blog post with more details about this: