How to Convert CSV to QBO for QuickBooks Online (Free, Any Bank)

What is a QBO File?

A QBO file is a bank statement in OFX (Open Financial Exchange) SGML format that QuickBooks Online uses to import transactions. Most banks export transactions as CSV, but QuickBooks Online's bank feed accepts QBO format for direct upload — no manual entry required.

Why Convert CSV to QBO Instead of Importing CSV Directly?

QuickBooks Online does have a built-in CSV import, but it's unreliable: it often fails to detect columns, rejects date formats, and doesn't handle split debit/credit columns. The QBO (OFX) format is structured and unambiguous — imports work every time.

Converting your CSV to QBO first takes 30 seconds and eliminates all the mapping errors.

How to Convert CSV to QBO (Step by Step)

1. Export your bank statement as CSV — see bank-specific instructions below
2. Go to the [CSV to QBO Converter](/) — free, unlimited, no signup
3. Upload your CSV file — the tool auto-detects columns and delimiter
4. Map your columns:

- Date → your date column (Transaction Date, Posting Date, etc.)

- Description → payee or memo column

- Amount → single amount column, or separate Debit/Credit columns

1. Click Download QBO
2. In QuickBooks Online: Banking > Transactions > Upload transactions → select your .qbo file → choose your bank account → confirm

Bank-by-Bank CSV Download Instructions

Chase

1. Log in → select your checking or credit card account
2. Click Download account activity (top right of transactions list)
3. Choose Activity type: All transactions
4. Set your Date range
5. File type: CSV
6. Click Download

Chase CSV columns: Details, Posting Date, Description, Amount, Type, Balance, Check or Slip #

Map: Posting Date → Date, Description → Description, Amount → Amount

Bank of America

1. Log in → select account → Download
2. Choose date range
3. File format: Microsoft Excel (CSV)
4. Download

BoA CSV columns: Date, Description, Amount, Running Bal.

Map: Date → Date, Description → Description, Amount → Amount

Wells Fargo

1. Log in → select account → Download Account Activity
2. Set date range → File type: Comma-Delimited (CSV)
3. Download

Wells Fargo CSV columns: "Date","Amount","*","*","Description"

Map: Column 1 (Date) → Date, Column 5 (Description) → Description, Column 2 (Amount) → Amount. Note: Wells Fargo doesn't include headers — the converter will show column numbers.

Citi

1. Log in → select account → Download (top right)
2. Date range → Download Type: CSV
3. Download

Citi CSV columns: Date, Description, Debit, Credit

Map: Date → Date, Description → Description, then select Separate Debit/Credit columns — Debit → Debit, Credit → Credit.

Capital One

1. Log in → select account → Download Transactions
2. Date range → CSV

Capital One CSV columns: Transaction Date, Posted Date, Card No., Description, Category, Debit, Credit

Map: Transaction Date → Date, Description → Description, separate Debit/Credit columns.

US Bank

1. Log in → My Accounts → select account
2. Download → date range → Comma Separated Values (.csv)

US Bank CSV columns: Date, Transaction, Name, Memo, Amount

Map: Date → Date, Name → Description, Amount → Amount.

TD Bank

1. Log in → select account → Export
2. Date range → CSV (Excel)

TD Bank CSV columns: Date, Description, Debit, Credit, Balance

Map: Date → Date, Description → Description, separate Debit/Credit.

Column Mapping Tips

Single Amount column: Negative values = expenses (money out), positive = income (money in). This is the most common format.

Separate Debit/Credit columns: Some banks use two columns — Debit for money out, Credit for money in. Select "Separate debit/credit" in the converter and map each column independently.

Date formats supported:

• MM/DD/YYYY — US standard (Chase, BoA)
• YYYY-MM-DD — ISO format
• DD/MM/YYYY — European format
• MM/DD/YY — 2-digit year
• Most date formats with or without time component

Currency symbols and commas: If your Amount column contains $1,250.00, the converter strips the symbols automatically.

Importing the QBO File into QuickBooks Online

1. In QuickBooks Online, go to Banking (left sidebar)
2. Click Upload transactions (or Link account → Upload from file)
3. Click Browse and select your .qbo file
4. Choose the bank account you're importing into
5. Review the transaction list — QuickBooks shows a preview
6. Click Yes, I'm done or Continue to confirm

QuickBooks will match transactions to existing entries where possible and place unmatched ones in For Review.

Common Import Issues

"File type not supported" — Make sure you're uploading a .qbo file, not the original .csv. Download the converted file from step 5.

"No new transactions found" — The transactions you're importing have already been imported (QuickBooks matches by transaction ID). Try a different date range.

Transactions appear as duplicates — Your date range overlaps a previous import. Filter to only new transactions before converting.

Amounts are reversed (expenses showing as income) — Your bank uses positive numbers for expenses. Toggle Invert amounts in the converter.

Frequently Asked Questions

Is the converter free?

Yes — completely free, unlimited rows, no signup required.

Does my bank data get uploaded?

No. Conversion happens entirely in your browser. Your CSV file never leaves your device.

Can I import multiple months at once?

Yes — just export a wider date range from your bank and convert the whole file. QuickBooks will skip any transactions already in your account.

Does this work for credit cards?

Yes — the converter works for checking accounts, savings accounts, and credit cards. Make sure you're importing into the matching account type in QuickBooks.

What if I need QuickBooks Desktop instead?

QuickBooks Desktop uses IIF format, not QBO. Use the [CSV to IIF converter](/csv-to-iif) instead.