Blog Layout

Tired of clunky accounting software? Say hello to Xero, the cloud-based platform designed to save you time and headaches. This guide walks you through transferring your chart of accounts to Xero, freeing you to focus on what matters most: running your business.

Xero at a Glance:

  • Revolutionizing Accounting: Launched in Australia in 2008, Xero transformed how small businesses access their finances.
  • Cloud-Based Convenience: Work on your accounts anytime, anywhere, from any device.
  • Streamlined Workflow: Connect Xero with over 500 integrations to optimise your accounting processes.


Before You Begin:

  1. Clean Up Your House: Archive unused accounts in your current system. Export your chart of accounts as a CSV file and remove obsolete entries.
  2. Balance Considerations: Xero imports account balances. Leave the balance column blank if you don't want to replace existing Xero balances.
  3. Review and Refine: Check and update account codes, types, and names for accuracy.


Understanding Xero File Formats:

  • OFX, QIF, CSV: These file formats are Xero's preferred choices for importing data.
  • CSV for Customization: The most common format for importing your chart of accounts or client contacts.


Preparing Your Data:

  1. Mandatory Fields: Fill out these four key fields for a successful import:
  • Account Code: Unique code for each account (up to 10 characters).
  • Account Type: Income, expense, asset, liability, or equity.
  • Account Name: Unique description (up to 150 characters).
  • Account Tax Code: Set the correct GST code for automatic calculations.

  2. Formatting Tips:

  • Each data column needs a header.
  • Limit your file to 700 rows. Large charts can be added directly to Xero after import.
  • Save your file as a text document if it contains non-English characters.


Importing Your Chart of Accounts:

  1. Log in to Xero.
  2. Go to Accounting > Advanced > Chart of accounts.
  3. Click "Import".
  4. Select "Xero" as the import source if using a Xero template.
  5. Choose your conversion date if importing balances.
  6. Browse and select your saved chart of accounts file.
  7. Click "Import".
  8. Review the import file for errors. Revise your file and re-import if needed.
  9. Click "Confirm".
  10. Select bank account types and enter corresponding numbers for any listed bank accounts.
  11. Click "Save".


Congratulations! Your chart of accounts is now in Xero.


Remember:

  • Accuracy is key! Double-check your data before importing.
  • Need help? Murray Nankivell Xero specialists offer free consultations to guide you through the process.


Embrace the Future of Accounting

With Xero and this guide, transferring your chart of accounts is a breeze. Enjoy the benefits of streamlined accounting and focus on what you do best: building your business.


If you get stuck on following these instructions, please call your Murray Nankivell advisor and they will be very happy to help.


By Megan Inverarity 07 Mar, 2024
How to take advantage of the 1 July super cap increase From 1 July 2024, the amount you can contribute to super will increase. We show you how to take advantage of the change. 
By William Altmann 06 Mar, 2024
The ATO Debt Dilemma Late last year, thousands of taxpayers and their agents were advised by the Australian Taxation Office (ATO) that they had an outstanding historical tax debt. The only problem was, many had no idea that the tax debt existed.
By Megan Inverarity 23 Feb, 2024
Can my SMSF invest in property development? Australians love property and the lure of a 15% preferential tax rate on income during the accumulation phase, and potentially no tax during retirement, is a strong incentive for many SMSF trustees to dream of large returns from property development. We look at the pros, cons, and problems that often occur.
Show More
Share by: