StatementHarborHow to import a CSV into QuickBooks Online
A statement CSV converts cleanly — then QuickBooks rejects it. This guide covers what QBO's file upload actually accepts, so your import works the first time.
Reviewed by the StatementHarbor team · September 2026 · Applies to QuickBooks Online (not Desktop)
What columns does QuickBooks Online accept?
QBO's file upload takes CSV or Excel files with either of these layouts:
| Layout | Columns | Best for |
|---|---|---|
| 3-column | Date · Description · Amount | Single signed amount column — what most converters output |
| 4-column | Date · Description · Credit · Debit | Banks that split debits and credits into separate columns |
StatementHarbor's CSV exports the 3-column layout plus a Balance column. QuickBooks ignores the extra Balance column during mapping, so the same file works for both.
The import steps
- In QuickBooks Online, go to Transactions → Banking.
- Click Link account ▾ (the dropdown, not the button), then Import transactions (older versions: File upload).
- Choose CSV, then select your converted statement file.
- Pick the bank account the statement belongs to (create one if needed).
- Map the columns: Date, Description, Amount — or Date, Description, Credit, Debit.
- Set the date format to match your file (this is the #1 silent failure).
- Upload, then review rows under Review → For review before categorizing.
Why does my import show 0 transactions?
QBO rarely explains failures. In order of how often we see them:
- Date format mismatch. If your CSV says 01/02/2025 and QBO expects DD/MM/YYYY (or the reverse), rows get skipped silently. Match the format during mapping.
- Currency symbols and thousands separators.
1,234.56or$45.00can fail parsing. StatementHarbor exports clean numbers for this reason. - No header row. If the first row is data, QBO may map garbage. Keep the header.
- Wrong account type. Uploading bank rows into a credit card ledger confuses sign conventions.
QBO file vs CSV: which should you import?
If the statement came from a converter, you have two routes. QBO (Web Connect) files import in one click and carry the bank/account identity, so QuickBooks files them under the right account automatically — see what a QBO file is. CSV gives you a review screen where you can see every row before it lands, which many bookkeepers prefer for client work. Same data, different ceremony: pick the workflow you trust.
Frequently asked questions
How do I import a CSV into QuickBooks Online?
Go to Transactions, choose Banking, click the dropdown on Link account, and select Import transactions (or File upload). Choose your CSV, map the Date, Description, and Amount columns, pick the date format, and upload. Rows appear in the Review section for categorization.
Why does my QuickBooks CSV import show 0 transactions?
The usual causes are a date format QuickBooks cannot parse, amounts containing currency symbols or commas, or the file having no header row. Clean dates to YYYY-MM-DD or MM/DD/YYYY, remove symbols, and make sure the first row is the column header before re-uploading.
Next step: get a clean CSV
Convert your statement first with the StatementHarbor converter — it outputs import-ready numbers, and the file never leaves your machine. For bank-specific steps, start with Chase statement to CSV.