Will importing this into QuickBooks create duplicate transactions?

No. Every row keeps its FITID — the unique transaction ID banks put in the file — in the Transaction ID column. QuickBooks uses it to recognise transactions it has already seen, so re-importing an overlapping date range won't double up your books.

My file has more than one account in it. What happens?

Each account is kept separate. Bank downloads often bundle a current account and a credit card into one file, each as its own statement section. Every transaction is tagged with its account number and type, and an Excel export puts each account on its own sheet instead of interleaving them.

Why do the dates in other converters come out with [0:GMT] on the end?

Because that's how the raw field is written — banks append a timezone offset to the timestamp. Only the date portion is meaningful for bookkeeping, so it's stripped here and you get a clean date.

What's the difference between QBO, OFX and QFX files?

They are the same underlying format with different extensions and headers. QBO is QuickBooks' Web Connect flavour, QFX is Quicken's, and OFX is the open standard both are built on. One reader handles all three, so this converter accepts any of them regardless of which one the page is named after.

Do negative amounts mean what I expect?

Yes. Money leaving the account is negative, money arriving is positive, and each row also carries an explicit Dr/Cr marker derived from that sign. Credit-card files follow the same convention from the bank's point of view, so a purchase is negative and a payment towards the card is positive.

Is my financial data uploaded anywhere?

No. The conversion runs in your browser using JavaScript — the file is never sent to a server. You can confirm it by opening your browser's Network tab while converting, or by disconnecting from the internet after the page loads and converting anyway.

What columns do I get?

Date, Payee, Description, Category, Transaction ID, Amount and Dr/Cr, plus Account when the file contains more than one. Payee and Category are derived on your device from the description — nothing is sent anywhere to work them out.

BalanceExtract

local

Format converter

Free OFX to CSV Converter

Runs entirely in your browser — your file is never uploaded to a server.

100% private

Never uploaded

Instant

Runs in your browser

CSV & Excel

Real spreadsheet output

No signup

No account, no card

Convert an OFX file to CSV

Drop your file below — runs entirely in your browser, nothing is uploaded.

Drag and drop your OFX file hereor click to browse your files OFX→CSV

Only have a PDF statement? That converts too.

A OFX file means your bank gave you structured data — which most banks only do for the last few months. Beyond that you get a PDF, and a PDF won't open in Excel. BalanceExtract reads those directly: it works out the column layout from the document itself, handles scanned statements with OCR, checks that every running balance reconciles, and flags any row it isn't confident about before you export.

Same CSV output, same on-device processing, nothing uploaded.

Convert a PDF statement6 pages free, no signup, no card

What is OFX, and what is an OFX file format?

OFX stands for Open Financial Exchange — a specification published in 1997 by Microsoft, Intuit and CheckFree so that banks and personal-finance software could exchange transactions without anyone screen-scraping a web page. An .ofx file is a plain text file written in that format: a statement section identifying the account, then one block per transaction carrying a date, an amount, a description and a unique identifier.

Two things about the OFX file format catch people out. Older files (OFX 1.x) are SGML rather than XML, so leaf tags frequently have no closing tag and generic XML tools reject them outright. And QFX and QBO are the same format underneath — Quicken and QuickBooks each add their own header fields, which is why a QBO file will often open perfectly well in a reader that expects OFX.

How to convert OFX to CSV in 3 steps

Step 1: Drop in your OFX file

Drag the file onto the box above or click to browse. It is read in your browser — nothing is uploaded to a server, which you can confirm in the Network tab.

Step 2: Check what was found

Every transaction is read out with its date, payee, description, amount and transaction ID, along with any warnings about rows that need a look.

Step 3: Download the CSV

The CSV file saves straight to your device, ready to open in a spreadsheet or import into your accounting software.

OFX is built for automated reconciliation, not manual review — which is exactly why converting it to CSV is useful when you actually want to look at the data yourself, or hand it to someone who doesn't use accounting software.

Quick summary

Reviewing an OFX export yourself, or handing it to someone without accounting software, means turning it into a real spreadsheet first — this reader handles both real-world OFX styles — older SGML-style files and newer XML-style files with proper closing tags — and QFX files too, since QFX is the same underlying format with Quicken-specific headers.

What's Inside an OFX File

Field	What It Contains
DTPOSTED	Transaction date
TRNAMT	Signed amount
NAME	Payee or description
FITID	A unique transaction ID
TRNTYPE	CREDIT or DEBIT

Real Format Variations This Handles

Two real OFX styles exist: older SGML-style files never close their tags; newer XML-style files do. A parser built for only one style silently breaks on the other.
QFX is the same format underneath: Quicken-specific headers on top of standard OFX — this reader doesn't need a separate parser for it.

Frequently Asked Questions

Will importing this into QuickBooks create duplicate transactions?: No. Every row keeps its FITID — the unique transaction ID banks put in the file — in the Transaction ID column. QuickBooks uses it to recognise transactions it has already seen, so re-importing an overlapping date range won't double up your books.
My file has more than one account in it. What happens?: Each account is kept separate. Bank downloads often bundle a current account and a credit card into one file, each as its own statement section. Every transaction is tagged with its account number and type, and an Excel export puts each account on its own sheet instead of interleaving them.
Why do the dates in other converters come out with [0:GMT] on the end?: Because that's how the raw field is written — banks append a timezone offset to the timestamp. Only the date portion is meaningful for bookkeeping, so it's stripped here and you get a clean date.
What's the difference between QBO, OFX and QFX files?: They are the same underlying format with different extensions and headers. QBO is QuickBooks' Web Connect flavour, QFX is Quicken's, and OFX is the open standard both are built on. One reader handles all three, so this converter accepts any of them regardless of which one the page is named after.
Do negative amounts mean what I expect?: Yes. Money leaving the account is negative, money arriving is positive, and each row also carries an explicit Dr/Cr marker derived from that sign. Credit-card files follow the same convention from the bank's point of view, so a purchase is negative and a payment towards the card is positive.
Is my financial data uploaded anywhere?: No. The conversion runs in your browser using JavaScript — the file is never sent to a server. You can confirm it by opening your browser's Network tab while converting, or by disconnecting from the internet after the page loads and converting anyway.
What columns do I get?: Date, Payee, Description, Category, Transaction ID, Amount and Dr/Cr, plus Account when the file contains more than one. Payee and Category are derived on your device from the description — nothing is sent anywhere to work them out.