Lledger
← Documentation

CSV Import Guide

How to download and upload bank transactions from every major NZ bank.

Auto-detection: Ledger automatically detects which bank your CSV is from. Just upload the file as-is — no need to rename columns or reformat.

ANZ

Expected columns

Date,Amount,Payee,Particulars,Code,Reference,Tran Type,This Party Account,Other Party Account,Serial,Transaction Code,Batch Payment,Originating Bank/Branch,Processed Date

How to export

  1. 1.Log into ANZ Internet Banking
  2. 2.Go to Accounts → select your account
  3. 3.Click 'Export' or 'Download transactions'
  4. 4.Select format: CSV
  5. 5.Choose your date range and download

ASB

Expected columns

Date,Unique Id,Tran Type,Cheque Number,Payee,Memo,Amount

How to export

  1. 1.Log into ASB FastNet Classic
  2. 2.Go to Accounts → Transaction History
  3. 3.Select date range
  4. 4.Click 'Export' → 'CSV'
  5. 5.Download the file

BNZ

Expected columns

Date,Amount,Payee,Particulars,Code,Reference,Tran Type

How to export

  1. 1.Log into BNZ Online Banking
  2. 2.Go to Accounts → select account → Transactions
  3. 3.Click 'Export' button
  4. 4.Select CSV format
  5. 5.Set date range and download

Westpac

Expected columns

Date,Amount,Other Party,Description,Reference,Particulars,Analysis Code

How to export

  1. 1.Log into Westpac One
  2. 2.Go to your account → Transaction history
  3. 3.Click the export/download icon
  4. 4.Choose CSV format
  5. 5.Download

Kiwibank

Expected columns

Date,Description,Amount,Balance

How to export

  1. 1.Log into Kiwibank Internet Banking
  2. 2.Go to Accounts → Transactions
  3. 3.Select date range
  4. 4.Click 'Download' → CSV

Emerge (SBS Bank)

Expected columns

Date,Details,Amount,Balance

How to export

  1. 1.Log into Emerge
  2. 2.Go to Account Activity
  3. 3.Select date range
  4. 4.Click 'Export' → CSV
  5. 5.Note: Emerge sometimes splits payments. Use the edit/delete feature in Ledger to fix incorrect imports.

Generic CSV format

If your bank isn't listed, Ledger will try to parse any CSV with at least a Date, Amount, and Description column. The column order doesn't matter — Ledger detects them automatically.

Having trouble? Email us your bank's CSV format and we'll add support within 24 hours.