CSV to QBO Converter: Convert CSV to QBO for QuickBooks

Last updated August 2026.

A CSV to QBO converter turns a spreadsheet of bank transactions into a .qbo Web Connect file that QuickBooks will import as a bank feed. You need one because QuickBooks Desktop does not accept CSV for bank activity at all, and QuickBooks Online only accepts a CSV that has been reshaped into its exact three or four column layout. The main paid options are ProperSoft (subscription, from $19.99 a month, Windows and Mac) and MoneyThumb (one time lifetime license, Windows for the OCR module). If you also hold the PDF statement, converting the PDF instead skips the column mapping entirely.

That is the short version. The longer answer is worth reading before you buy anything, because which tool is right depends less on price than on what your source file actually looks like and which QuickBooks you run.

Why QuickBooks needs QBO in the first place

QBO is not the abbreviation for QuickBooks Online, confusingly. A .qbo file is Intuit's Web Connect flavor of OFX, the open financial exchange format banks use to publish account activity. It carries a bank ID, an account ID, an account type and a list of transactions, each with a date, an amount, a type and a unique transaction ID. QuickBooks trusts that structure, which is why importing a .qbo drops transactions straight into the bank feed for matching, complete with duplicate detection based on those transaction IDs.

A CSV carries none of that. It is a grid of text with no account identity and no transaction IDs, so QuickBooks either refuses it outright or, on QuickBooks Online, asks you to declare what each column means and then imports it with weaker duplicate protection. Converting to QBO is really about handing QuickBooks a file it already understands.

What each QuickBooks version will and will not accept

The row that surprises people is the first one. There is no hidden setting, no add on and no toolkit that gives QuickBooks Desktop a CSV bank import. Intuit's free QuickBooks Import Excel and CSV Toolkit is often downloaded in the belief that it does, but it only covers list imports: customers, vendors, items and the chart of accounts.

The CSV to QBO converters worth comparing

Read that honestly and one thing stands out. If you genuinely have a clean CSV and nothing else, a desktop converter at $19.99 a month is the cheaper answer and we are not going to pretend otherwise. Our tool costs more and reads a different input. The reason it exists is that the CSV is usually not clean, and very often it is not the only file available.

Why the PDF route is usually less work than the CSV route

Nearly every bank that offers a CSV download also offers the PDF statement for the same period, and most people download both without thinking about it. The difference shows up in what you have to do next.

A CSV has no closing balance to check against. You map the columns, convert, import, and find out at reconciliation whether anything went missing. A PDF statement carries the opening balance, the closing balance and the transaction list on the same page, so extraction can be checked against a number the bank itself published. When the extracted total does not reconcile, you know before the data reaches QuickBooks rather than three weeks later.

Column mapping is the other cost. Bank CSVs disagree about almost everything: some split debits and credits into two columns, some include a running balance that converters mistake for the amount, some wrap negatives in parentheses, some use two date columns for posted and transaction dates, and a few change their header row without warning when the bank updates its portal. Each of those is a five minute fix the first time and a recurring annoyance every month afterwards.

How to convert CSV to QBO with a desktop converter

The workflow is the same across ProperSoft and MoneyThumb. Download the CSV from your bank, open it in the converter, and map the columns to date, description and amount. Set the account type, checking, savings or credit card, because QuickBooks refuses a .qbo whose account type does not match the register you import it into. Enter the routing or bank ID and the account number if the tool asks, then export the .qbo and import it in QuickBooks.

Two settings decide whether the import goes smoothly. The date format has to match what is actually in the file rather than what your regional settings assume, and the amount sign convention has to be right: money leaving the account should be negative in a single signed column. Get either wrong and QuickBooks will accept the file and post everything backwards, which is far more work to unwind than a rejected import.

How to import the QBO file once you have it

In QuickBooks Desktop, go to Banking, then Bank Feeds, then Import Web Connect Files, choose the .qbo, and pick the account it belongs to. QuickBooks will offer to create a new account if it does not recognize the bank ID, which is almost never what you want on an existing file. In QuickBooks Online, open Transactions, then Bank transactions, select the account, use Link account or the upload option, and choose the .qbo. Both platforms land the rows in the review queue rather than posting them, so nothing hits your books until you accept or match each line.

If QuickBooks rejects the file, the cause is nearly always the header rather than the transactions. A mismatched account type, a bank ID QuickBooks does not accept, or a date range that overlaps an existing import are the three usual culprits, and we walk through each in why QuickBooks will not import a QBO file.

When a converter is the wrong purchase

Some data never belongs in a bank feed. Invoices, bills, journal entries and payroll are not bank transactions, and pushing them in as a .qbo creates duplicates the moment the real payment clears. Those belong in a connected importer such as Transaction Pro or SaaSAnt, which write records directly into QuickBooks rather than into the bank feed. We compared the pricing on both in the Transaction Pro Importer pricing guide and the SaaSAnt alternative comparison.

Source data can also arrive in shapes no converter expects. Payment processors and marketplaces often send settlement summaries by email rather than publishing a download, and getting those figures into a usable spreadsheet is a job for an email parser that extracts message data to CSV before any of this conversion work starts.

Frequently asked questions

How do I convert a CSV to QBO?

Open the CSV in a converter such as ProperSoft CSV2QBO or MoneyThumb 2qbo Convert Pro, map your date, description and amount columns, set the account type to checking, savings or credit card, then export the .qbo. Import it in QuickBooks Desktop through Banking, Bank Feeds, Import Web Connect Files, or in QuickBooks Online through the Banking upload option.

Can QuickBooks Desktop import a CSV of bank transactions?

No. QuickBooks Desktop accepts bank and credit card activity only as a .qbo Web Connect file. CSV import in Desktop is limited to lists, meaning customers, vendors, items and the chart of accounts, through the guided Excel and CSV wizard. Any spreadsheet of transactions has to become a .qbo first.

What is the best CSV to QBO converter?

For a clean CSV you already download every month, ProperSoft is the cheapest capable option at $19.99 a month and runs on both Windows and Mac. For high volume desktop work, MoneyThumb's one time license costs more upfront and less over several years. If your starting point is a PDF statement rather than a CSV, a browser based PDF to QBO converter removes the mapping step altogether.

Is there a free CSV to QBO converter?

QuickBooks Online's built in CSV upload is included with your subscription and is genuinely free, provided you reshape the file into its Date, Description, Amount layout yourself and stay under 1,000 rows. Free standalone converters exist but tend to cap transactions, omit the bank ID header QuickBooks checks, or process your financial data on servers with no stated retention policy.

Can I convert Excel to QBO?

Yes, though most converters want a CSV. Save the worksheet as CSV first, keeping a single header row and removing subtotals, blank rows and any running balance column. ProperSoft and MoneyThumb both read Excel directly, which saves that step, but a plain CSV maps more predictably.

Why does my QBO import post transactions backwards?

The amount sign convention was set wrong during conversion. Money leaving the account must be negative in a single signed column. If your bank splits debits and credits into separate columns, the converter has to be told which is which, and getting it inverted produces a file QuickBooks accepts happily while reversing every line.

How many transactions can I put in one QBO file?

There is no published ceiling for a .qbo import in QuickBooks Desktop, but large files import slowly and are painful to unwind if anything is wrong. QuickBooks Online caps a bank upload at 1,000 rows and 350 KB. Splitting by statement period is the practical answer on both, because each import then reconciles against a closing balance you can verify.

Do I need a converter if my bank offers Web Connect?

No. If your bank publishes a .qbo download or supports Direct Connect, take the file straight from the bank. Converters exist for the accounts where that option is missing, has been switched off, or only reaches back 90 days when you need two years of history.

If your statements arrive as PDFs rather than spreadsheets, upload one in the converter at the top of this page. The first three are free with no card, which is enough to check the extraction against your own closing balance before deciding anything. For more on the file formats QuickBooks accepts, see the guide to QuickBooks bank import file formats, the breakdown of what a QBO file is, and the PDF to QBO converter.