CSV to OFX Converter
Turn a bank or credit card CSV export into an OFX statement file
Free, no signup. Runs entirely in your browser — files stay on this device.
Drop your file here or browse from your device
Accepts CSV, TSV, TXT. Maximum input: 10 MiB. Files above this hard limit are rejected before local processing.
CSV to OFX at a glance
| Output | OFX 1.0.2 (SGML, Windows-1252), the version most desktop apps import, or OFX 2.2 (XML, UTF-8) |
|---|---|
| Accounts | Checking, savings, money market, line of credit (bank statement) or credit card (card statement) |
| Amounts | Exact: kept as whole numbers of cents, never floating point. One signed column, or debit and credit columns |
| Dates | YYYY-MM-DD, MM/DD/YYYY, DD/MM/YYYY, 20240115 and "15 Jan 2024" styles; day-first or month-first is detected from the file and can be set |
| Transaction IDs | Each transaction gets a FITID built from its date, amount and text, so converting the same CSV again gives the same IDs |
| Payee | OFX 1.0.2 allows 32 characters in NAME; longer payees are cut there and kept in full in MEMO |
| Rows that cannot be read | Left out and listed with the reason, never guessed |
Convert a bank or credit card statement saved as CSV into an OFX file that personal finance and accounting software can import. Upload the CSV, check which columns hold the date, payee and amount, and download the .ofx file.
Banks lay out their CSV exports differently, so the converter reads the column names and lets you correct them. It handles one signed amount column or separate money-out and money-in columns, day-first or month-first dates, decimal commas, currency symbols, amounts in parentheses and CR/DR markers.
Amounts are copied digit for digit, never rounded. A row whose date or amount cannot be read exactly is left out and listed, so nothing is guessed. The statement is built in your browser; your transactions are not uploaded.
Continue your workflow
Finished this step? Take the result into a focused tool for what comes next.
How to Convert CSV to OFX
- Download your transactions from your bank as CSV, then upload the file here
- Check the Date, Amount (or Money out and Money in) and Payee columns
- If the dates are day-first or purchases show as positive, set Dates or Flip signs
- Choose the account type, add your account number if your software matches on it, and download the .ofx file
Features
- Detects date, payee, amount, debit, credit, memo and check number columns by name
- One signed amount column or separate money-out and money-in columns
- Reads currency symbols, thousands separators, decimal commas, (parentheses) and CR/DR
- Flip signs for card exports that show purchases as positive numbers
- Bank or credit card statement, OFX 1.0.2 or 2.2
- Repeatable transaction IDs so a second import of the same file can be spotted as duplicates
- Runs entirely in your browser, no upload or signup
Use Cases
- Import transactions into GnuCash, Moneydance, Banktivity or YNAB when your bank only offers CSV
- Load older statements into accounting software that reads OFX bank feeds files
- Convert a credit card CSV into a card statement your finance app can reconcile
- Rebuild a statement file after cleaning or merging CSV exports
Frequently Asked Questions
How do I convert a CSV bank statement to OFX?
Upload the CSV, confirm which columns hold the date, the payee and the amount (or the money-out and money-in columns), choose checking, savings or credit card, and click Download. The .ofx file lists every transaction with its date, signed amount and payee.
Which programs can import the OFX file?
OFX is read by GnuCash, Moneydance, Banktivity, YNAB, Xero, MYOB and many other finance and accounting apps. Each app has its own import screen, usually under File > Import or the bank account settings. Some apps match the file to an account by its account number, so type yours in the Account field.
Will Quicken or QuickBooks accept it?
Not reliably. Quicken and QuickBooks expect a QFX or QBO file that carries an Intuit bank ID registered to your bank, and this converter does not invent one. For QuickBooks, ExcelTool has a dedicated CSV to QBO converter. For Quicken, the CSV to QIF converter on this site is the usual route.
My bank shows purchases as positive numbers. What do I do?
Turn on Flip signs. OFX expects money out as a negative amount and money in as a positive one, and many credit card exports use the opposite convention.
Why were some rows left out?
A row is left out when its date is not a real calendar date, its amount is not a number, or both amount cells are empty, for example a "Pending" line or a running-balance row. The notice above the output lists each one with the reason.
What should I put in Bank ID and Closing balance?
Both are optional. Bank ID is your routing or sort code; it is written as 000000000 if left blank. The closing balance is written into the statement balance (LEDGERBAL); if you leave it blank it is written as 0.00, which most apps ignore on import.
Are my transactions uploaded?
No. The CSV is read and the OFX file is built in your browser. Your transactions are not sent to a server.