QuickBooks Online bank upload: CSV or QBO?

Unlike QuickBooks Desktop, QuickBooks Online can upload bank files in several formats: .csv, .qbo, .qfx and .ofx (Transactions › Bank transactions › Link account › Upload from file). Intuit allows up to 1,000 lines per upload, so split very long files.

When a plain CSV is fine

If your bank's CSV is already in one of the layouts QuickBooks Online expects, you can upload it directly and map the columns:

• 3-column: Date, Description, Amount (money out negative)
• 4-column: Date, Description, Credit, Debit

Bank exports often break this with extra header lines above the table, summary rows at the bottom, a running balance, day-first dates, or "1.234,56" style numbers.

When QBO is easier

• The CSV has a messy layout, or the upload keeps failing with a mapping or date error.
• You want each transaction to carry a unique ID, so uploading overlapping date ranges is less likely to create duplicates.
• You also use QuickBooks Desktop or Quicken and want one workflow for all of them.

Fixing common upload errors

• Upload fails or finds no transactions: remove extra lines above the header, or convert to QBO, which ignores them.
• Dates in the wrong month: the file uses DD/MM/YYYY while QuickBooks expected MM/DD/YYYY. In the converter, pick the right date format and the output will be unambiguous.
• Amounts all positive: the bank uses separate debit/credit columns or a DR/CR column. Map those in the converter and it will produce signed amounts.
• Duplicates: don't upload files for accounts already connected to a live bank feed for the same dates. Intuit recommends uploading only for periods the feed doesn't cover.

Intuit's upload clicks and file rules are on Import a file into QuickBooks Online. Bank download notes are on Banks.