Convert NAB CSV to QBO / QFX / OFX

NAB's personal Internet Banking help lists the export formats as a spreadsheet, a QIF file, or a PDF. It does not list QBO, QFX, or OFX. QuickBooks Desktop and Quicken Web Connect do not import QIF. Use the spreadsheet.

Convert your file now: open the converter. It runs in your browser, your statement is never uploaded, and it's free up to 30 transactions per file.

Export transaction history

Access your transaction history says you can view up to two years (731 days) of transactions. To export:

  1. Log in to NAB Internet Banking with your NAB ID and password.
  2. Open the Accounts menu and select Transaction history.
  3. Optionally sort a column, filter, or search.
  4. Select Export to export all or some of the transactions as a spreadsheet, a QIF file, or a PDF.

To view more than the first 30 days, NAB says to choose an alternative date range. The spreadsheet is the file to convert. NAB Connect, the business platform, is a different set of screens and is not covered here.

CSV columns

The source linked below does not publish the column headings in the file. After you download it, use the header row you actually see. In the converter, map a date, a description, and either one signed amount or separate money-in and money-out columns. The preview rewrites dates as YYYY-MM-DD so you can confirm the day and the month before you download.

Convert it

  1. Open the converter and drop in the CSV or Excel file. Excel (.xlsx or .xls) is fine.
  2. If the bank put your name or account number above the table, set the header row to the row that names the columns.
  3. Map the date, the description, and either one signed amount or separate paid-in and paid-out columns. Confirm the dates in the preview, which shows them as YYYY-MM-DD.
  4. Choose QBO for QuickBooks Desktop, QFX for Quicken, or OFX, and download.

Import the converted file

FAQ

Is the QIF file a Quicken Web Connect file?

No. Quicken says QIF will not work with Web Connect. Export the spreadsheet and convert it to QFX or QBO.

How far back can I go?

NAB says transaction history covers up to 731 days, and that the default view is 30 days until you pick another range.

The export is Excel, not CSV.

NAB says "spreadsheet". The converter reads xlsx and xls as well as CSV.

Sources

Last checked: 2026-10-28. Menus move. If a label on this page does not match what you see, use the bank's own help page linked below.