Convert ANZ New Zealand CSV to QBO / QFX / OFX
Drop your ANZ New Zealand CSV or Excel export below and get a ANZ New Zealand → QuickBooks/Quicken/Xero file in seconds. Private — nothing leaves your browser.
Advanced — bank identifiers (for "file not recognized" issues)
QuickBooks/Quicken use INTU.BID to recognize the file. Pick your bank above to autofill, or paste your own.
Free: up to 25 transactions per file. Pro (one-time $29): unlimited.
How to export your transactions from ANZ New Zealand
ANZ New Zealand Internet Banking supports exporting transactions in multiple formats: CSV, QIF, OFX, and software-specific formats (Quicken, MYOB, Microsoft Money). EXPORT STEPS: Log in to ANZ Internet Banking (web) > select the account > 'View transactions' > set the date range > 'Export'/'Download' > choose the file format (CSV for spreadsheets; OFX/QIF for accounting software). CSV LAYOUT (ANZ NZ): columns are typically Type, Details/Particulars, Code, Reference, Amount, Date, ForeignCurrencyAmount, ConversionCharge - note ANZ NZ uses a SINGLE signed Amount (negative = debit) and splits the description across Particulars/Code/Reference (you usually concatenate them). Some exports place Date as DD/MM/YYYY (NZ DMY). A header row is present. QuickBooks model: NZ QuickBooks Online uses bank feeds, NOT US Web Connect - no credible INTU.BID for file acceptance. Use QBO 'Manually upload transactions' (CSV) - and note you may need to merge the multiple description columns and reformat DD/MM dates first. Page value: 'ANZ NZ gives CSV/OFX/QIF - here's how to deal with the multi-column description and DMY dates.'
Once you have the file, drop it into the converter above. LedgerBridge auto-detects the date, amount and description columns — adjust the mapping if needed, choose QBO for QuickBooks (or QFX for Quicken, OFX for Xero), and download.
Tips for ANZ New Zealand files
- Choose DD/MM/YYYY as the date format if auto-detect guesses wrong.
- If withdrawals come in as positive numbers, tick “Flip amount sign”.
- For credit-card exports, set the account type to Credit card.
- If QuickBooks rejects the file, open Advanced and confirm the INTU.BID — selecting “ANZ New Zealand” in the bank dropdown autofills it.
FAQ
How do I export a CSV from ANZ New Zealand?
ANZ New Zealand Internet Banking supports exporting transactions in multiple formats: CSV, QIF, OFX, and software-specific formats (Quicken, MYOB, Microsoft Money). EXPORT STEPS: Log in to ANZ Internet Banking (web) > select the account > 'View transactions' > set the date range > 'Export'/'Download' > choose the file format (CSV for spreadsheets; OFX/QIF for accounting software). CSV LAYOUT (ANZ NZ): columns are typically Type, Details/Particulars, Code, Reference, Amount, Date, ForeignCurrencyAmount, ConversionCharge - note ANZ NZ uses a SINGLE signed Amount (negative = debit) and splits the description across Particulars/Code/Reference (you usually concatenate them). Some exports place Date as DD/MM/YYYY (NZ DMY). A header row is present. QuickBooks model: NZ QuickBooks Online uses bank feeds, NOT US Web Connect - no credible INTU.BID for file acceptance. Use QBO 'Manually upload transactions' (CSV) - and note you may need to merge the multiple description columns and reformat DD/MM dates first. Page value: 'ANZ NZ gives CSV/OFX/QIF - here's how to deal with the multi-column description and DMY dates.'
Is my ANZ New Zealand data uploaded anywhere?
No. The conversion happens entirely in your browser. Your statement and account number never leave your device — safe even for client confidentiality requirements.
Will the file import into QuickBooks?
Yes. We generate a valid OFX 1.0.2 (SGML) document with the correct header and identifiers. Convert a small file free first to confirm it imports cleanly, then unlock unlimited.