# How to Convert a CSV to QBO

_Canonical: https://qbomaker.com/blog/how-to-convert-csv-to-qbo.html_

Your bank gives you a spreadsheet, but QuickBooks wants a .QBO file. The fix is a quick conversion: take the CSV (or Excel) your bank exported and turn it into a QuickBooks Web Connect file you can import in a few clicks. This guide walks through the whole process step by step, from downloading the right export to importing cleanly without creating duplicate transactions.

## What a .QBO file is (and why CSV won't import directly)
A .QBO file is a QuickBooks Web Connect file: a small structured text file that holds your transactions in tags QuickBooks understands. QuickBooks Desktop only imports bank data through this Web Connect format, and in QuickBooks Online a proper .QBO is read as a bank statement rather than a row-by-row spreadsheet. A plain CSV, by contrast, is just rows of text with no fixed structure, so QuickBooks can't reliably tell which column is the date, which is the amount, or which transactions it has already seen.Converting bridges that gap. It wraps your spreadsheet rows in the right tags and assigns each transaction a unique ID so re-imports don't double up. If you want the full background, see what a .QBO file actually is. The short version: you need a .QBO, your bank gave you a CSV, and converting is how you get from one to the other.

## Step 1: Export the CSV from your bank
Log into online banking and download your transactions as CSV (some banks label it "Comma delimited," "Spreadsheet," or "Excel"). A few tips that save trouble later:Pick a clean date range. Export only the period you actually need to import, so you don't overlap with transactions already in QuickBooks.Grab the detailed export, not the summary. You want one row per transaction with a date, amount, and description, not a monthly rollup.Note your column layout. Some banks put money out and money in as a single signed Amount column; others split them into separate Debit and Credit columns. Both work, you just map them differently in the next step.If your bank only offers a PDF, a text-based PDF statement can be converted too, see turning a PDF bank statement into a QBO. (Scanned image PDFs aren't supported, since there's no OCR.) Stuck because your bank has no QuickBooks option at all? Find your institution under supported banks, including Chase, Bank of America, and Wells Fargo.

## Step 2: Convert the CSV with QBO Maker
Open the converter at qbomaker.com and drop in your CSV or Excel file. Everything runs in your browser, so the statement is never uploaded to a server. Then:Map your columns. Tell the tool which column is the Date, which is the Amount, and which is the Description (payee/memo). The tool auto-detects most layouts, but you can override any guess.Handle debit/credit splits. If your bank used separate Debit and Credit columns instead of one signed Amount, point the tool at both so withdrawals come through as negatives and deposits as positives.Check the date format. Confirm whether your file uses MM/DD/YYYY or DD/MM/YYYY so January 6 isn't read as June 1.Preview the transactions. Scan the parsed table to confirm amounts, signs, and descriptions look right before you download.Download your file. Choose .QBO for QuickBooks and save it.If you do this often, saved templates and batch conversion are part of Pro, so a recurring bank layout maps itself next time.

## Step 3: Choose QBO vs QFX vs OFX
QBO Maker can output several closely related formats, all built on the Open Financial Exchange standard. Pick by the software you're importing into:.QBO for QuickBooks, both Desktop and Online. This is your choice for QuickBooks..QFX for Quicken. See converting CSV to QFX..OFX the generic flavor many other accounting apps accept. See converting CSV to OFX.The data inside is nearly identical; the difference is which tags and identifiers each app expects. For a full side-by-side, read QBO vs QFX vs OFX. If your target is QuickBooks, choose .QBO and move on.

## Step 4: Import the .QBO into QuickBooks
With your .QBO downloaded, importing takes only a few minutes.QuickBooks Desktop: go to File → Utilities → Import → Web Connect Files, select your .qbo file, and pick (or create) the account to link it to. QuickBooks loads the transactions into Bank Feeds for review.QuickBooks Online: open Transactions → Bank transactions (sometimes labeled Banking), click Upload transactions, choose the account, and upload the file. For a detailed walkthrough with screenshots and gotchas, see importing bank data into QuickBooks Online. Web Connect import is also the standard way to bring in more than 90 days of history that a live bank feed usually won't let you pull.Want to confirm the file is well-formed before importing? Run it through the free OFX/QBO validator first to catch formatting issues early.

## Step 5: Avoid duplicates and reconcile
The most common worry after importing is doubled-up transactions. Two habits prevent it:Don't overlap date ranges. If you already imported through May 31, start your next export on June 1.Let the FITIDs work. Each transaction in a proper .QBO carries a unique ID, so QuickBooks recognizes entries it already imported and skips them. This is why a real .QBO beats a raw CSV import for staying clean.If duplicates do slip in, our guide on avoiding duplicate transactions in QuickBooks covers how to spot and clear them. Once everything is in, finish with a quick reconcile against your statement, see reconciling after importing, and you're done.

**Can QuickBooks import a CSV directly without converting to QBO?**
QuickBooks Online has a basic CSV upload, but it requires a specific column layout, offers no duplicate protection, and QuickBooks Desktop won't accept CSV for bank feeds at all. Converting to a proper .QBO gives you reliable formatting and the unique transaction IDs that prevent double entries, which is why most people convert rather than wrestle with raw CSV.

**Is my bank data uploaded anywhere during conversion?**
No. QBO Maker runs entirely in your browser. Your CSV is parsed and converted on your own device, and the statement is never sent to a server. There's also no signup required to convert and download a file.

**My bank splits withdrawals and deposits into two columns. Will that work?**
Yes. During mapping, point the converter at both your Debit and Credit columns instead of a single Amount column. The tool combines them into correctly signed transactions, negative for money out and positive for money in.

**Which format should I download for QuickBooks?**
Choose .QBO. It works for both QuickBooks Desktop and QuickBooks Online. Use .QFX only for Quicken and .OFX for other accounting apps. See our QBO vs QFX vs OFX comparison if you're unsure.

**Will re-importing the same file create duplicate transactions?**
Usually not. Each transaction in a valid .QBO carries a unique FITID that QuickBooks uses to recognize entries it has already imported, so accidental re-imports are typically skipped. To be safe, also avoid overlapping date ranges between exports.

---
Convert free at https://qbomaker.com/#tool, runs entirely in your browser.