Importing transaction history into an accounting package

Last updated: 24/08/2017 08.50 AM

Why should I not use Excel to import transactions into an accounting package?

We do not recommend using this format for importing transactions into an accounting system as it may contain transactions that could be missing details or that may change. 

However, Excel (.xlsx) is the default and recommended format for viewing transactions using a MS Office compatible application - e.g. Microsoft Excel, Google Docs or Open Office.

The exported file is pre-formatted with logically ordered columns, so you shouldn't need to spend any time upfront formatting the file or moving columns around before you can use it.

Other available export formats are:

  • OFX - Open Financial Exchange format (see  for more information around this file standard)
  • QIF - Quicken Interchange Format
  • CSV - Comma Separated Values
  • TSV - Tab Separated Values

If you choose a different export format, this will be your new default setting so you won't need to change it again.

Contact us

By phone

on 0800 269 296

6am to 12 midnight,
7days a week


Contact us online

Visit an ANZ branch

Find your nearest branch