Input
Bank 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)
Account and institution
Account type
Bank account
Credit card
Currency
Institution name (ORG)
Institution FID
Bank ID (routing or transit)
Account number
Bank account kind
Checking / chequing
Savings
Money market
Credit line
Closing balance (optional)
Closing balance date (YYYY-MM-DD, needed with a balance)
Skip rows I cannot read and convert the rest
Convert to QBO
Start over
QBO file
Choose a file to begin.
Show the QBO file text