How it works

Drop the .ofx file

Look for "Money", "OFX" or "Microsoft Money" in your bank's download options.

Confirm the account

We show the account type, the statement period, the number of transactions and the ending balance.

Download

Choose a full CSV, an Excel workbook, or the CSV layout for QuickBooks Online, Xero or Wave.

What's inside an OFX file

Open Financial Exchange was created in the late 1990s so banks could send statements to personal finance and accounting software in one agreed format. An OFX file is plain text. It starts with a header that states the version, then a sign-on block, then one or more statements. Each transaction is a STMTTRN block with a type, a posting date, an amount, a unique ID and a payee name.

That structure is great for software and awkward for people. Converting to CSV turns each STMTTRN into a row so you can read, sort and total the transactions.

How the conversion handles OFX quirks

Unclosed tags (OFX 1.x): values run until the next tag, and empty tags such as a blank <MEMO> don't swallow the following fields.
Dates with time zones: values like 20260115120000.000[-5:EST] are read as the calendar date the bank intended, January 15, with no shift from your own time zone.
Encoded characters: & becomes "&" again, so "AT&T" reads correctly.
Long payee names: OFX 1.x limits NAME to 32 characters. When the full name is in the memo, the full version is used.
Credit cards: statements in a CCSTMTRS section are labeled as credit card accounts, and money spent stays negative.

Using the CSV in a spreadsheet

The CSV opens directly in Excel, Google Sheets or Numbers. Dates are written as MM/DD/YYYY and amounts as plain numbers, so formulas work straight away. If you plan to work in Excel, choose the Excel download: dates and amounts arrive as typed cells, there's an autofilter on the header row, and a Summary sheet totals money in and money out.

A quick check before you rely on the numbers:

Compare the number of transactions with your online banking for the same period.
Check that the ending balance in the summary matches the bank's statement.
Keep the Transaction ID column. It's the bank's own identifier and the easiest way to find duplicates if you later combine several downloads.

Need QBO instead of CSV?

If you want to import an OFX file into QuickBooks and it's being refused, the issue is almost always the missing Intuit tags rather than the transactions. Converting OFX to QBO rewrites the file in the Web Connect format QuickBooks expects, with a valid header, the INTU.BID tag and unique transaction IDs.

Frequently asked questions

What's the difference between OFX 1.x and OFX 2.x?

OFX 1.x uses SGML, where many tags are never closed (<TRNAMT>-45.10 on its own line). OFX 2.x is XML, with every tag closed. Banks still use both, and this converter reads either one.

Is OFX the same as QBO or QFX?

Almost. QBO (QuickBooks) and QFX (Quicken) are OFX files with extra Intuit tags. That's why an OFX file renamed to .qbo is usually rejected: it's missing INTU.BID. The QBO file viewer can confirm what's missing.

My OFX file has several accounts. What happens?

Some banks bundle checking, savings and cards into one download. The converter shows the first account and tells you how many the file contains.

Why are some transactions missing compared to my online banking?

OFX downloads normally include only posted transactions. Pending card authorizations appear once they post. Also check the date range you selected when downloading.

Can I get the running balance?

OFX files don't carry a balance per transaction, only the ledger balance at the end of the period. The Excel summary sheet shows that ending balance, and you can rebuild a running balance in the spreadsheet.