CSV to OFX converter
Paste or open a CSV of bank transactions, match the date, description and amount columns, and download an OFX file that accounting software imports as a bank statement.
Runs in your browser. Your file is never uploaded.
2 · Match the columns
3 · Check and download
Paste a CSV to begin.
| Posted | Name | Amount | Type |
|---|
What bank CSVs throw at it
Banks don't agree on how to write an amount. The converter reads all of these without editing the file first:
| What you have | Looks like | What happens |
|---|---|---|
| Separate money-in and money-out columns | Debit 59.99 · Credit (blank) | Choose “Separate debit and credit columns”. Money out becomes a negative amount. |
| Negatives in brackets | (59.99) | Read as −59.99. |
| Trailing minus | 59.99- | Read as −59.99. |
| DR and CR suffixes | 100.00 DR | DR is money out, CR is money in. |
| Comma decimals | 1.234,56 | Read as 1234.56, the way many European exports write it. |
| Semicolon or tab separators | Date;Libellé;Montant | Detected from the header row. |
| Currency symbols | £1,200.00 | Ignored; pick the currency in the form. |
Dates like “03 SEP” with no year, or printed only on the first row of each day? Run the file through the statement date fixer first.
Questions
Is this CSV to OFX converter free?
Yes. It runs entirely in your browser: the CSV never leaves your computer, and there is no signup or limit.
Which software accepts the OFX file?
The file follows OFX 1.0.2, which QuickBooks Online, Xero, Sage, GnuCash, Moneydance, Banktivity and most accounting tools import as a bank statement.
My CSV has separate debit and credit columns. Does that work?
Yes. Choose "Separate debit and credit columns" and map both; debits become negative amounts in the OFX file.
Will importing the same file twice create duplicates?
Each transaction gets an ID (FITID) built from its date and amount, and accounting software uses that ID to skip transactions it has already imported.
Should I fill in the closing balance?
If your software shows a statement balance after import, yes: type the closing balance printed on the statement and it is written into the file. Leave it empty and the file carries transactions only.
I need a .qbo file for QuickBooks Desktop.
Use the CSV to QBO converter. It writes the same transactions with the Intuit fields QuickBooks Web Connect reads.
I only have a PDF statement, not a CSV.
Convert the PDF to CSV with BankConv first, then use this tool to make the OFX file.
More free tools
CSV → QBO
CSV to QBO converter
Turn a transaction CSV into a .qbo Web Connect file for QuickBooks.
OFX · QFX · QBO → Checks + CSV
OFX, QFX and QBO viewer
Open an OFX, QFX or QBO file, check it for import errors, and export it to CSV.
CSV → CSV
Statement date fixer
Rewrite the dates in a bank CSV into one format your software accepts, including "03 SEP" dates with no year.
PDF → PDF
PDF password remover
Remove the password from a bank statement PDF you can open, so you can upload or share an unlocked copy.