QBO or CSV?
QBO is the easiest: QuickBooks reads the dates, amounts and account details without asking you to map columns, and each transaction carries an ID so QuickBooks skips duplicates. Use the CSV if your QuickBooks version refuses the QBO's bank ID, or when you want to review rows in a spreadsheet first.
Importing into QuickBooks Online
In QuickBooks Online open Banking (or Transactions → Bank transactions), choose Upload from file, pick the .qbo or .csv, choose the account, and confirm. Converted dates use YYYY-MM-DD in the CSV; QuickBooks accepts this on the mapping screen.
- Convert one account per QBO file — each file carries a single account
- Statements for several months can be merged into one QBO for the same account
- If the statement shows a balance mismatch, fix it before importing so your reconciliation starts clean