Input
QBO, QFX or OFX file (up to 20 MB)
Or paste the text instead
Institution block: not loaded yet.
Statement
CSV layout
Full: account, date, amount, type, name, memo, FITID
QuickBooks 3-column: Date, Description, Amount
QuickBooks 4-column: Date, Description, Credit, Debit
3-column plus Memo, Check Number, Transaction ID
Dates in the CSV
2024-03-31 (unambiguous)
03/31/2024 (month first)
31/03/2024 (day first)
Show only the last 4 characters of the account number
Keep original cell text exactly (may be unsafe in Excel)
Exports neutralise spreadsheet formulas by prefixing a quote to any cell that starts with = + - or @; plain amounts are left as numbers.
Convert to CSV
Start over
CSV result
Choose a file to begin.