Preparing the data copying process – Preparing Chart of Accounts

To begin the data migration, the full chart of accounts needs to be extracted from the existing ledger. In MYOB, this is known as the “Accounts List,” where all accounts are grouped by type. This account structure should be copied into the new ledger in Xero, which also uses a chart of accounts. 
 
When copying data between ledgers, it is essential to start with the Chart of Accounts. The Accounts list must be copied from the source ledger into the target ledger before moving on to the Trial Balance and Fixed Assets. 

The first step in the process involves reading all accounts from the selected MYOB file. Click on Read All MYOB Accounts

This will populate all the MYOB ARL Accounts as shown below. 

Once this is done, click on Read All Xero Accounts . This will populate and show the total amount of Xero Accounts

As previously mentioned, this is a brand-new Xero file that includes a default Chart of Accounts automatically provided by Xero during the initial setup.

Since the Xero setup file already contains a default set of accounts, there may be overlaps when copied accounts from MYOB. To avoid duplication and maintain data consistency, it is standard practice to delete the existing Xero accounts before beginning a migration to a brand-new setup file. 

Click on Delete All Xero Files

Click OK to proceed 

Using the provided tool, there is no need to manually delete accounts one by one within Xero. The system facilitates bulk deletion with a single click, allowing all existing accounts in the Xero file to be removed efficiently.

Once the deletion is complete, a message stating “Account deletion is completed” will be displayed. The number of accounts deleted can be cross-checked and verified against the Xero file to ensure that all default accounts have been successfully removed.

To Verify if all Xero accounts have been deleted, click on Read all Xero Accounts again and see if the total number of xero accounts have reduced. Note that some xero accounts cannot be deleted

To begin copying data to xero, Click on Read All MYOB Accounts again. 

This will enable the Sync Accounts to Xero option. Click this to copy the data.

Upon clicking the button, a prompt will appear asking for confirmation to begin synchronising accounts to the selected Xero organisation. This prompt should be confirmed by selecting “OK.“

Once confirmed, the selected accounts will be synced from MYOB to Xero. This process, which would typically be time-consuming if done manually, is completed quickly and efficiently using the tool. 

A confirmation message will be displayed once the account creation in Xero is completed. 

Verify if the Synchronisation has been successful 

Once the sync is complete, click on Read all Xero Accountsto verify that the accounts from the MYOB file have been successfully created. 

This confirms that the Chart of Accounts from the source ledger has been fully copied to the new ledger. This completes the first step of the migration process—bringing all accounts into the destination ledger.

you can verify this in Xero as well. Simply log into Xero. Go to the Accounting and select Chart of Accounts 

Here you will see the chart of accounts copied from MYOB. You can verify if the sync is successfully by scrolling all the way down and seeing if the number of accounts tally with you see in Fixed Asset accounting.