QuickBooks CSV Import and Export: Bank, Expenses, and Customers

QuickBooks Speaks CSV — With Strict Rules

QuickBooks Online (QBO) and QuickBooks Desktop both accept CSV for bank feeds, expenses, customers, vendors, and some list imports. The file must match the product’s template, not a generic spreadsheet you invented. Wrong date order, currency symbols in amount cells, or an extra header row are enough to reject an entire upload.

This guide covers the practical CSV path used by bookkeepers and small businesses in the United States, Canada, the United Kingdom, and Australia — where QuickBooks is common and regional date/amount formats often break imports.

Online vs Desktop: Which CSV Path?

Pick the workflow that matches your product before you reshape columns.

Step-by-Step: Import a Bank CSV into QuickBooks Online

Bank CSV is the most searched QuickBooks CSV task. Follow this sequence.

• Download transactions from your bank as CSV (or convert OFX/QFX/QIF/PDF to CSV first).
• Open the file in the Online CSV Editor and confirm one header row and consistent columns.
• Normalize dates to the format QuickBooks expects for your region (see date section below).
• Strip currency symbols and thousands separators from amount columns; keep plain decimals.
• Map debit and credit into one signed Amount column if your bank exports two columns.
• In QBO: Banking → Upload → browse to the CSV → map Date, Description, Amount.
• Review the preview; fix unmatched rows; then accept and categorize.

Date,Description,Amount
2026-05-03,AWS CLOUD,-42.18
2026-05-04,ACME CLIENT PAYMENT,1500.00
2026-05-06,OFFICE SUPPLIES,-27.45

Date,Description,Money In,Money Out
05/03/2026,AWS,,42.18
05/04/2026,CLIENT,1500.00,

Date,Description,Amount
05/03/2026,AWS,-42.18
05/04/2026,CLIENT,1500.00

Regional Date Formats That Break QuickBooks

Date ambiguity is the #1 cross-border QuickBooks CSV failure. 03/05/2026 means March 5 in the US and May 3 in the UK/Australia.

• Never mix US and UK date styles in one file.
• If QuickBooks rejects rows near month boundaries (days 1–12), your date order is probably wrong.
• Prefer exporting ISO dates from Excel (custom format yyyy-mm-dd) when QBO accepts them.

Amounts, Currency, and Locale

QuickBooks wants a plain number. Regional Excel habits often leave decoration in the cell.

• Remove $, £, CA$, A$, and € symbols from amount cells.
• Remove thousands separators (1,500.00 → 1500.00).
• Use a period as the decimal mark unless your specific importer documents otherwise.
• Do not put credits in parentheses like (42.18) unless you convert them to negative numbers first.
• Keep the QuickBooks company currency consistent; multi-currency setups need the product’s multi-currency fields, not ad-hoc CSV columns.

Customers, Vendors, and Expense CSVs

List and expense imports are stricter than bank feeds. Always download the official QuickBooks sample CSV for that import type.

When the Bank Gives You QFX, QIF, or IIF Instead

CSV is not always the download option. Convert specialty formats, review in a spreadsheet, then import — or feed QBO Web Connect when available.

• QFX / OFX → convert to CSV with the Finance File Converter for review, or import Web Connect where supported.
• QIF → QIF to CSV, then map columns.
• IIF (Desktop) → IIF to CSV to inspect lists/transactions before a Desktop IIF import.
• PDF statement only → PDF bank statement to CSV, then reconcile totals before QuickBooks.

Excel Prep Checklist for QuickBooks CSV

Most “QuickBooks won’t take my CSV” tickets start in Excel.

• One sheet; delete unused sheets before Save As CSV.
• Row 1 = headers only; no titles, logos, or blank rows above.
• No merged cells.
• Save as CSV UTF-8 (Comma delimited) when available — especially for Canadian French accents and UK supplier names.
• Re-open the CSV in a plain text editor or Online CSV Editor to confirm Excel did not destroy leading zeros or dates.
• Import a 5–10 row sample first; reconcile; then load the full file.

Common Mistakes

These failures repeat across US, UK, AU, and CA files.

• Uploading an Excel .xlsx renamed to .csv.
• Leaving a title row (“May 2026 Bank Export”) above the real headers.
• Mixing MM/DD and DD/MM dates after merging US and UK bank files.
• Including balance columns that shift the Amount mapping one column to the right.
• Using IIF column layouts in a QBO bank CSV upload.
• Assuming Desktop IIF and Online CSV templates are interchangeable.

Best Practices

Treat every QuickBooks CSV as a contract with the product version you run.

• Start from QuickBooks’ sample or an export from the same company file.
• Normalize dates and amounts in one cleanup pass before mapping.
• Keep a dated archive of each uploaded CSV for audit trails.
• Document whether the company file expects US or UK-style dates.
• Use browser-side cleanup so client bank data does not need a permanent upload to a third-party datastore.

Why Use Convert CSV Online?

Convert CSV Online is free, browser-based, and requires no account for everyday conversions. Clean bank tables in the Online CSV Editor, convert QFX/QIF/IIF via the Finance File Converter, and export Excel when stakeholders need XLSX. Client-side workflows work on Windows, macOS, and Linux browsers — useful for US, Canadian, UK, and Australian bookkeeping teams on mixed machines.

Conclusion

QuickBooks CSV success is mostly preparation: correct product template, unambiguous dates, plain amounts, and a one-row header. Convert specialty bank formats when needed, preview before import, and keep regional formats consistent across your team.