Input
CSV file (up to 20 MB)
Or paste the text instead
Separator
Detect
Comma
Semicolon
Tab
Pipe
Lines up to and including the header
Date order
Detect (I will ask if unclear)
Month / day / year (03/04/2024 = 4 March)
Day / month / year (03/04/2024 = 3 April)
Year-month-day (2024-03-04)
Decimal mark in amounts
1,234.56 (period)
1.234,56 (comma)
Dates are checked once a file is loaded.
How amounts are laid out
One Amount column: negative = money out
One Amount column: positive = money out (many credit cards)
Separate Debit and Credit columns
Which column is which
Date
Description or payee
Amount
Memo (optional)
Debit (money out)
Credit (money in)
Check number (optional)
Your own transaction ID (optional)
OFX output
OFX version
2.x (XML, UTF-8)
1.x (SGML, Windows-1252)
Account type
Bank account
Credit card
Currency
Account number or label
Bank ID (up to 9 characters)
Bank account kind
Checking / chequing
Savings
Money market
Credit line
CD / term deposit
Institution name (optional)
Institution ID (optional)
Closing balance (optional)
Balance date (YYYY-MM-DD)
Skip rows I cannot read and convert the rest
Convert to OFX
Start over
OFX file
Choose a file to begin.
Show the OFX file text