How to Import Bank Statement CSV into QuickBooks (Free)

The Problem: Banks Give You CSV, QuickBooks Wants QBO

Every bank lets you export transactions as CSV (Excel-compatible). But QuickBooks Online doesn't import CSV directly — it prefers QBO (OFX) format for bank feeds.

This leaves you with two options:

1. Manual entry — tedious and error-prone
2. Convert CSV to QBO — takes about 30 seconds

This guide covers both QuickBooks Online and QuickBooks Desktop.

For QuickBooks Online: Convert CSV to QBO

Step 1: Export your bank statement as CSV

Log into your bank's website and look for:

• "Download transactions"
• "Export" or "Download statement"
• Choose CSV or Excel format
• Select the date range you need

Common bank CSV formats:

Step 2: Convert CSV to QBO

1. Go to the [CSV to QBO converter](/) on this site
2. Upload your bank CSV
3. Map the columns:

- Date → your date column

- Description → payee/memo column

- Amount → amount column (or separate debit/credit columns)

1. Click Download QBO

Step 3: Import into QuickBooks Online

1. In QuickBooks Online, go to Banking (left sidebar)
2. Click Upload transactions (or "Link account" → "Upload from file")
3. Select your downloaded .qbo file
4. Choose which bank account to import into
5. QuickBooks will show a preview — confirm and import

For QuickBooks Desktop: Convert CSV to IIF

QuickBooks Desktop (Pro, Premier, Enterprise) uses IIF format instead of QBO.

Step 1: Export CSV from your bank

Same as above — download your bank transactions as CSV.

Step 2: Convert CSV to IIF

1. Go to the [CSV to IIF converter](/csv-to-iif)
2. Upload your CSV and map columns
3. Download the .iif file

Step 3: Import into QuickBooks Desktop

1. Open QuickBooks Desktop
2. Go to File → Utilities → Import → IIF Files
3. Select your .iif file
4. Click OK

Transactions will appear in your register immediately.

Tips for Clean Imports

Handle split debit/credit columns: Some banks give separate "Debit" and "Credit" columns instead of a single Amount. In the converter, combine them: use the Credit column as positive, Debit as negative. Or select "separate debit/credit" in the column mapping.

Check for duplicate dates: If you're importing a range you've already imported, QuickBooks will flag duplicates. Always note the last date you imported and start your new import from the next day.

Date formats: Make sure your dates are consistent — MM/DD/YYYY works best. The converter handles most formats automatically.

Currency symbols: If your Amount column has $ signs or commas (like $1,250.00), the converter handles these automatically.

Which Format Do I Need?

Why Not Just Connect Your Bank Directly?

QuickBooks Online's bank feed feature connects to your bank automatically — but it only works if your bank is supported. If your bank isn't in QuickBooks' list, or if you need to import historical transactions from before you connected, the CSV → QBO method is the only option.