QBO Format

CSV to QBO Converter FREE Online (QuickBooks Ready)

Convert CSV to QBO free and import CSV to QuickBooks the way it actually accepts — as a QuickBooks Web Connect file. QuickBooks Desktop has no CSV import at all; it never has, and the Intuit Community thread asking why has been running since 2018. Drop your CSV here: columns are detected automatically with no column mapping to fill in, amounts and dates are normalised, and the ampersands that trigger OL-222 are stripped before they reach QuickBooks.

Bank-grade security - Files processed securely and deleted immediately
Trouble converting a file? Tell us — we fix issues fast. Report it

Not the file you need?

Only have a PDF?
Same .qbo, straight from the statement
Got an OFX file?
Make it QuickBooks-ready in one click
Got a QFX file?
Switch a Quicken file over to QuickBooks

Why Use Our CSV to QBO Converter Tool?

No column mapping to fill in

Most CSV to QBO converters open with a column mapping screen asking which column is the date. Skip it — columns are detected from the data itself, including split debit/credit layouts and headers in other languages.

You set the currency, not us

A .qbo has to declare a currency. Tools that hardcode USD silently relabel every non-US account. If your file doesn't state one, we ask you — before the file is written, not after QuickBooks has imported it.

Free, with no trial ceiling on the file

The desktop alternatives run $69.99 one-time, or $549 and up for the pro editions, and their trials stop after ten transactions — enough to test, not to work. This is a CSV to QBO converter online: nothing to install, no signup, and the whole file converts.

How to convert CSV to QBO in three steps

1

Start with your bank's CSV

From your bank's portal, a fintech app, a payment processor, or a spreadsheet. Header row optional, and quoted fields with embedded commas are fine.

2

Upload the CSV

Drop the .csv above or click to browse, up to 10MB. Columns are detected for you — no mapping form, whatever order your bank uses.

3

Set the account details, download

A CSV states no account type or currency, so pick those first. Then download the .qbo and import it: Desktop via File → Utilities → Import.

Why QuickBooks won't take the CSV your bank gave you

QuickBooks Desktop has no CSV import at all

Not a formatting problem — the option does not exist. Web Connect accepts .qbo only. Users have been asking Intuit about this since 2018 and the answer has never changed: convert the file first.

OL-222, usually caused by a single character

The most-reported Web Connect failure. An unsupported character in a payee name — an ampersand is the classic — makes QuickBooks reject the whole file. The community fix is to open the .qbo in a text editor and delete them by hand.

QuickBooks Online's CSV rules are unforgiving

Files over 350 KB are refused. Only 3-column and 4-column layouts are accepted. Mixed date formats fail on the first row QuickBooks can't parse, and a bank that prints the weekday in the date cell breaks it outright.

A QuickBooks older than three years refuses .qbo entirely

Intuit retires Desktop versions on roughly a three-year cycle, and a retired version stops importing Web Connect files. Desktop 2023 reached that date on 31 May 2026; 2024 is the last non-Enterprise release.

Who ends up needing a .qbo

QuickBooks Desktop users

Desktop offers no CSV upload anywhere in the interface. Intuit's own answer to the question is "convert it to .qbo or IIF first." This is that step.

Banks that only export CSV

Plenty of credit unions, neobanks and business accounts dropped OFX/QFX downloads entirely. CSV is all they ship now, and QuickBooks can't read it.

Failed QuickBooks CSV imports

QuickBooks Online accepts CSV in theory — under 350 KB, in one of exactly two column layouts, with perfectly consistent dates. A .qbo sidesteps all of it.

Stripe, PayPal and payroll

Payment processors and payroll systems export CSV with their own column names. Convert once and import as a normal bank feed instead of retyping.

Bookkeepers with mixed layouts

Every client sends a different CSV layout — date in column 1 or column 7, one signed amount or split debit/credit. One CSV to QBO conversion workflow covers all of them.

Accounts not in US dollars

Converters that stamp every file USD quietly relabel your money. Set the real currency here before the .qbo is written.

Frequently Asked Questions — CSV to QBO Converter

QCan I import a CSV into QuickBooks Desktop directly?

No. There is no CSV upload in QuickBooks Desktop — Web Connect accepts .qbo files only. Intuit's own guidance is to convert to .qbo or IIF first. QuickBooks Online is different: it does accept CSV, but under strict rules.

QWhat is the best CSV to QBO converter?

It depends on whether you convert occasionally or daily. The paid desktop tools — Bank2QBO at $69.99, MoneyThumb's 2qbo Convert Pro at $549 and up — are built for high-volume repeat work with saved column mappings, and their trials stop at ten transactions. Web tools like this one and DocuClipper, at $39 a month, need no install. If you convert a few statements a month, a free online CSV to QBO converter does the same job.

QHow do I import CSV to QuickBooks Desktop?

Convert the CSV to a .qbo Web Connect file first, then go to File → Utilities → Import → Web Connect Files and pick the account. There is no route that imports CSV to QuickBooks Desktop directly, which is why a CSV to QuickBooks converter is needed at all. In QuickBooks Online you upload CSV to QuickBooks under Banking → Transactions → Upload from file, and the same .qbo works there too.

QCan I import CSV to QuickBooks Online without converting it?

Yes, but only if the file already fits Intuit's rules: under 350 KB, in either the 3-column layout (date, description, amount) or the 4-column layout (date, description, credit, debit), with one consistent date format and no symbols in the amounts. Converting to QBO sidesteps every one of those constraints.

QWhy does my import fail with error OL-222?

OL-222 means QuickBooks could not read the file as valid Web Connect data. The usual cause is an unsupported character in a transaction description — ampersands are the common one. We strip those while writing the .qbo, so the file lands clean.

QWhat columns does my CSV need?

Date, description, and amount, in any order and under any header names. Split debit/credit columns work too — they're merged into one signed amount. If there's no header row at all, columns are inferred from the data.

QWill QuickBooks think the file came from my bank?

QuickBooks reads the institution from an identifier inside the file, and we set a known-good one so the import isn't rejected. It may show "Wells Fargo" during import — that label is cosmetic. You choose your real account on the next screen.

QMy account isn't in US dollars. Will the amounts be labelled wrong?

Not here. A CSV rarely states its currency, so we ask you before writing the file. Converters that skip this step stamp every .qbo as USD, which silently relabels a GBP or EUR account.

QDoes this work with QuickBooks Online as well as Desktop?

Yes. Online accepts .qbo via Banking → Transactions → Upload from file. Many people use it there specifically to dodge the 350 KB cap and the strict column and date rules on Online's CSV import.

QWhich QuickBooks versions can import the file?

Any version still inside Intuit's support window — they retire Desktop releases about every three years, and a retired version stops accepting Web Connect files. Desktop 2023 hit that date on 31 May 2026.

QIs there a limit on how many transactions I can convert?

There's no ten-transaction trial wall like the paid desktop converters use. Free accounts have a monthly allowance shown on the pricing page; the file itself isn't truncated.

QMy CSV uses European number formats. Will the amounts survive?

Yes. 1.234,56 and 1,234.56 both come out as 1234.56. Swiss apostrophe thousands and Indian lakh grouping are handled too, and currency symbols are stripped rather than breaking the row.

QIs my CSV uploaded to your servers?

The file is parsed in your browser. Only the rows go to our AI for column detection, and nothing is stored afterwards.

Other Conversion Formats

PDF to QIF Converter

Convert to QIF

CSV to QIF Converter

Convert to QIF

CSV to OFX Converter

Convert to OFX

CSV to QFX Converter

Convert to QFX

CSV to IIF Converter

Convert to IIF

CSV to Tally XML Converter

Convert to Tally XML

Convert CSV to QBO and QuickBooks opens it first try

Your bank sends CSV. QuickBooks Desktop reads QuickBooks Web Connect files and nothing else. Convert CSV to QBO here in about ten seconds and import CSV to QuickBooks without retyping a single row. Free to get started, no signup.