CSV to OFX converter

What is an OFX file, and why convert to one?

OFX (Open Financial Exchange) is the format banks use when they send transactions directly to software. Unlike a CSV, an OFX file describes every field: this is the date, this is the amount, this is the payee, and this is a unique ID for the transaction. That makes imports faster and safer:

• No column mapping. The app knows what each value is.
• Fewer duplicates. Each transaction has a stable ID, so most apps skip lines you've already imported.
• Consistent dates and amounts. No more arguing with day-first and month-first dates.

Apps that import OFX

The converter writes OFX version 1.0.2, the most widely supported version. It's accepted by Xero, Sage, FreeAgent, Zoho Books and GnuCash, among many others. For QuickBooks, use the CSV to QBO converter instead — QuickBooks expects the QBO variant, which adds an Intuit bank ID.

How to convert

1. Download transactions from online banking as CSV or Excel.
2. Drop the file on the converter above and check that the totals match your statement.
3. In step 3, pick Bank or Credit card, set the currency, and optionally add the last four digits of the account number.
4. Download the .ofx file and import it in your accounting app's bank statement import screen.

Credit card OFX files

Choose Credit card as the account type for card statements. The file then uses the OFX credit card statement section, which most apps need in order to import into a credit card account rather than a bank account. Charges should be negative in the preview; if they appear as money in, tick Swap money in and money out in step 2.

Frequently asked questions