There are 4 formats to choose from which have been provided for import into accounting software. You will need to check with your software provider which one is preferred for use within your accounting package or computer programme.
Available export formats are:
- Excel (.xlsx)
Excel is the default format because it’s the most commonly used export format and is recommended for viewing transactions using a MS Office compatible application – e.g. Microsoft Excel, Google Docs or Open Office.
Excel however, is not the recommended format for importing transactions into an accounting system as it may contain transactions that could be missing details or that may change. - CSV (Comma Separated Values) & TSV (Tab Separated Values)
CSV and TSV export formats include column headings by default to help you better identify the contents of the export file and to remove the need to manually add column headings when your accounting package requires them, such as MYOB and Xero.
If your accounting package doesn’t support headers, you can still choose to export without headers by unticking the ‘Include Column Headings’ option when exporting.
CSV and TSV export formats only include transactions that have been fully processed to match your statement. Find out more about excluded transactions here. - QIF – Quicken Interchange Format (dd/mm/yy and dd/mm/yy)
QIF exports only include transactions that have been fully processed to match your statement. Find out more about excluded transactions here. - OFX - Open Financial Exchange format
See http://www.ofx.net/FAQ/Faqs.aspx for more information around this file standard.