Tomorrowish

Turn a bank CSV into an OFX file

Your bank only offers CSV, or the CSV has the months you need, and your money app wants OFX. Convert it in your browser, with ids that keep re-imports clean.

Steps

  1. Download the transactions as CSV from your bank (on its website, usually under Download or Export).
  2. Open the Bank File Converter, press Make a file my money app can import and drop the CSV in.
  3. Check the column guess shown under the file (date, amount or debit + credit, payee). Change any of them, flip the sign if charges are plus amounts in your file, pick day-first dates for UK and European files, and say whether it is a bank account or a credit card.
  4. Pick OFX 2 (or OFX 1 for older apps such as Microsoft Money, or QIF), optionally type the account number or a nickname and the ending balance, and press Download.
  5. Import it with your app's OFX (or QIF) import.

Why the line ids matter

Every OFX line has an id (FITID). Money apps remember the ids they have imported and skip them next time, which is what stops the same month landing twice. A CSV has no ids, so the converter makes each one from the line's date, amount and payee plus a counter for identical lines (two $4.75 coffees on one day stay two lines). The same CSV always gives the same ids, and a new line elsewhere in the file never changes the others:

<STMTTRN>
<TRNTYPE>DEBIT</TRNTYPE>
<DTPOSTED>20261002</DTPOSTED>
<TRNAMT>-4.75</TRNAMT>
<FITID>20261002-b04519f5-1</FITID>
<NAME>CORNER BEAN CAFE</NAME>
</STMTTRN>

A CSV that came from this converter keeps the bank's own ids in its "Bank line id" column, and they go back into the OFX unchanged.

Which apps take the result

GnuCash, HomeBank, KMyMoney, YNAB, Banktivity and MoneyMoney list OFX and QIF among their imports, and QuickBooks Online lists OFX and CSV uploads. Quicken and QuickBooks Desktop take QFX / QBO only as Web Connect downloads carrying a participating bank's ID, which this tool does not write. Each app's own words, with links: QFX vs OFX vs QIF.

Private by design

The conversion runs in your browser tab; the page cannot connect anywhere, so the file is never uploaded. Privacy.

Open the Bank File Converter

Keeping a register on Windows? Stubbook opens these files by double-click (on the Microsoft Store). Tracking bills? Paid Up.