Skip to content

Set up and save your own CSV preset

Last reviewed 16 November 2026 · 6 steps

Pick a built-in preset, choose and reorder columns, set date and number formats, and save your own preset.

Free account

Steps

  1. Open Export options

    Open a statement and press Export CSV. The Export options panel opens. Under File type, choose CSV. Scroll to Export Settings.

    The Export options panel with the File type choices and Export Settings underneath.Open full size screenshot for step 1
  2. Choose a preset

    Under Presets, choose Standard (Date, Description, Debit, Credit and Balance), Excel Ready (one Amount column, with Bank, AccountHolder and AccountNumber, dates as YYYY-MM-DD) or Accounter (Date, Description and Amount).

    The Presets row with Standard, Excel Ready, Accounter and + Save current, above the columns list.Open full size screenshot for step 2
  3. Switch columns on or off, rename and reorder

    Under Columns, use each switch to include a column and type a new Header name. Drag a column by its handle to change the order. The file uses the new order.

    The columns list after Description has been dragged above Date.Open full size screenshot for step 3
  4. Set the formats

    Combine Debit/Credit merges them into one Amount column, with debits negative. Choose a date format, Decimal places and a Thousands separator. Fees can be a separate column, individual line items or a total row. The CSV header preview shows the exact header row.

    The date format, decimal places and thousands separator choices, with the CSV header preview.Open full size screenshot for step 4
  5. Save it as a preset

    Press + Save current. Under Save as new preset, type a name and press Save. Your preset appears beside the built-in ones. Select it and press Delete to remove it.

    The Save as new preset box with a name field and Save and Cancel buttons.Open full size screenshot for step 5
  6. Press Export CSV

    Press Export CSV. The file follows your settings.

Tips

  • Your settings and presets are kept in this browser, so they will not follow you to another browser.
  • Changing a column after choosing a preset unselects it. Save it under a new name to keep the change.
  • OFX, QIF and the Xero, QuickBooks and Sage CSVs have a fixed layout, so presets apply to CSV only.
  • Cells that start with =, @, + or - are written with an apostrophe in front, so a spreadsheet does not treat them as formulas.

If something goes wrong

Your preset has gone.
Presets live in your browser. Clearing browser data removes them. Save the preset again.
Save is switched off.
Type a name for the preset first.
The Fees column is missing.
It shows only when the statement has fees and fees are set to a separate column.