Built for QuickBooks Online & Desktop

Convert CSV to QBO in seconds

Turn any bank or credit-card CSV export into a clean, balanced QuickBooks Web Connect (.qbo) file. Automatic column mapping, fixed date formats, no manual entry.

csv / xls / xlsx → .qbo
No file handy?

No account needed for your first conversions. We never store your bank login.

★★★★★ 4.8/5 from 600+ bookkeepers 1.2M+ transactions converted

Works with the exports your bank already gives you

Chase Bank of America Wells Fargo Citi Capital One Amex PNC HSBC Barclays
1.2M+
transactions converted
4.8/5
average rating
12 sec
average conversion
0
manual mapping screens

Skip the painful QuickBooks CSV mapping screen

QuickBooks only imports the proprietary .QBO Web Connect format, but your bank exports CSV. CSVQBO is the bridge: drop the file, get a file that imports clean on the first try.

Automatic field mapping

We detect your Date, Description, Amount, Payee and Check number columns automatically, even when the order is different for every bank. No drag-and-drop mapping, no guessing.

Date formats fixed for you

A wrong MM/DD versus DD/MM date silently mis-posts transactions. We detect the format and let you override it, so March 4 never becomes April 3.

Balanced and error-free

We generate valid OFX/QBO with the right account type, currency and Financial Institution ID, so you never hit an unknown FID or CREDITLINE error on import.

Split debit/credit handled

Separate Money In and Money Out columns? Signed amounts? We normalise them into correctly signed transactions automatically.

More than just QBO

Need QFX, OFX, QIF or IIF instead? Or a clean Excel copy for your records? Export the same parsed data to any of them.

Private by design

Your data is processed over an encrypted connection and the uploaded file is deleted automatically. We never ask for your bank login.

From spreadsheet to QuickBooks in three steps

1

Upload your CSV or Excel

Drag in the file your bank or card portal gave you, or pick one of our sample statements to try it instantly. CSV, XLS and XLSX all work.

2

We map and balance it

CSVQBO detects your columns, fixes the date format, normalises amounts, and sets the account type, currency and FID so the file reconciles.

3

Download and import

Download the .QBO and import it under Bank transactions, Upload from file in QuickBooks Online. No manual entry, no mapping screen.

Bookkeepers stopped retyping statements

★★★★★
“I manage 30 client books. Half their banks have no QuickBooks feed, so I was retyping CSVs by hand. CSVQBO turned that into a 10-second download. It paid for itself the first week.”
MD Maria Delgado Owner, Delgado Bookkeeping
★★★★★
“The date-format fix alone is worth it. We kept getting transactions posted to the wrong month from a UK client. One toggle and it imports perfectly now.”
TR Tom Reilly Staff accountant, Harbor CPA
★★★★★
“Our corporate card export used split debit and credit columns that QuickBooks choked on. CSVQBO normalised them and the .qbo reconciled on the first pass.”
PN Priya Nair Controller, Northwind Foods

What is a QBO file, and why won't QuickBooks just take your CSV?

A QBO file is a QuickBooks Web Connect file. It uses the Open Financial Exchange (OFX) format that Intuit built so that banks could deliver transactions directly into QuickBooks. When you download a .qbo file and open it, QuickBooks recognises every field it needs: the posting date, the amount, whether the transaction is a debit or a credit, a description, and a unique transaction ID so the same line is never imported twice. That is why a QBO file imports cleanly while a raw CSV almost never does.

The problem is simple. Banks and credit-card portals almost always export to CSV or Excel, because those are the universal spreadsheet formats. QuickBooks, on the other hand, treats CSV as a second-class citizen. QuickBooks Online does have a manual CSV importer, but it forces you through a brittle column-mapping screen where one wrong choice, a misread date, an unrecognised amount column, or a missing description, silently breaks the import or posts transactions to the wrong month. QuickBooks Desktop will not accept CSV bank data for the banking feed at all; it only ingests QBO Web Connect files. So whether you are on QuickBooks Online or Desktop, the cleanest path is to convert your CSV to QBO first, then import the QBO. That is the single job CSVQBO does, and it does it without you ever touching a mapping screen.

Converting CSV to QBO yourself by hand is genuinely hard. The OFX/QBO format is a strict SGML document with required headers, a signon block, a bank account block with the correct account type, a transaction list bracketed by start and end dates, and a ledger balance. Every transaction needs a correctly formatted timestamp (YYYYMMDD), a signed amount, a transaction type of DEBIT or CREDIT, and a unique FITID. Miss one element and QuickBooks rejects the whole file. CSVQBO assembles all of that for you from the columns in your spreadsheet, so the file is valid the first time.

How to convert a CSV to QBO (step by step)

The whole point of a CSV to QBO converter is that you should not need a manual. Here is the entire process with CSVQBO:

  1. Export the CSV from your bank. Log into your online banking or credit-card portal, open the account, and download the transactions as CSV or Excel for the date range you need. Most banks call this Download, Export, or Export to spreadsheet.
  2. Upload the file to CSVQBO. Drag the CSV or XLSX onto the converter at the top of this page. You do not need an account to try it. We read the file instantly in your browser session, detect the header row, and figure out which column is the date, which is the description, and which holds the amount, or the separate debit and credit columns.
  3. Check the preview. You will see your transactions parsed into a clean table. Confirm the bank name, the account type (checking, savings, or credit card), the currency, and the date format. If your bank uses DD/MM/YYYY, flip the date toggle once and every row corrects at the same time.
  4. Download the QBO. Click Download .QBO. You get a valid QuickBooks Web Connect file with correctly signed amounts, unique transaction IDs, and a balanced ledger.
  5. Import into QuickBooks. In QuickBooks Online go to Transactions, then Bank transactions, pick the account, choose Upload from file, and select your QBO. In QuickBooks Desktop use File, Utilities, Import, Web Connect Files. Review and accept the matched transactions.

That is it. No template to build, no mapping screen, no retyping. A statement that used to take twenty minutes of careful data entry becomes a ten-second download. If you convert the same bank every month, CSVQBO remembers the layout so the next file is even faster.

Import bank transactions into QuickBooks Online without the mapping screen

The reason people search for how to import bank transactions into QuickBooks Online is almost always the same: their bank has no direct feed, or the feed keeps disconnecting, so they are stuck uploading a file. QuickBooks Online supports two file paths. The first is the CSV importer, which is the one that causes most of the pain, because you have to tell QuickBooks which column is which every single time and it cannot handle split debit and credit columns gracefully. The second is the QBO Web Connect upload, which just works, because the file already contains everything QuickBooks needs.

By converting your CSV to QBO first, you switch from the fragile path to the reliable one. You upload a single .qbo file, QuickBooks reads the account type and the transactions, and it presents them in the For Review tab exactly as a live bank feed would. You categorise, you match, you accept. Because each transaction carries a unique FITID, QuickBooks will not double-import a line if you upload an overlapping date range later, which is one of the most common ways manual CSV imports create duplicate transactions.

CSVQBO also solves the smaller frustrations that derail a QuickBooks Online import: amounts written with thousands separators like 1,250.00, amounts wrapped in parentheses to show a negative, currency symbols in the amount column, trailing summary rows, and blank lines between transactions. We strip and normalise all of it so QuickBooks sees clean numbers.

Bank statements and credit-card statements both convert

CSVQBO handles ordinary bank statement exports and credit-card statement exports, and it knows the difference matters. When you import a credit-card export into QuickBooks as if it were a bank account, you can hit the dreaded CREDITLINE or wrong-account-type error, and the signs on your charges and payments can end up reversed. We let you mark the file as a credit-card account, which writes the correct account type into the QBO so charges post as charges and payments post as payments.

For checking and savings accounts, we read whichever shape your bank uses: a single signed Amount column where debits are negative, or separate Withdrawal and Deposit columns, or Money Out and Money In columns as many UK and international banks export. Whatever the layout, the QBO comes out with each transaction signed correctly so your running balance and your reconciliation tie out.

This makes CSVQBO a fit for the real monthly workflow of a bookkeeping practice. Convert each client's checking export, then their savings, then the business credit card, then the owner's card, each as its own QBO, and import them one after another. No account is too small and no bank is unsupported, because we work from the file your bank already gives you rather than a fragile direct connection.

Excel, QFX, OFX, QIF and IIF: every conversion in one place

Not every situation calls for a QBO. CSVQBO can take the same parsed transactions and write whichever format you actually need:

  • Excel to QBO and CSV to QBO are the core jobs: turn an .xlsx or .csv bank export into a QuickBooks Web Connect file.
  • QFX is the Quicken flavour of the Web Connect format. If you keep books in Quicken as well as QuickBooks, export a QFX from the same upload.
  • OFX is the open standard that many accounting tools beyond QuickBooks accept, including Xero and Sage in certain workflows.
  • QIF is the older Quicken Interchange Format, still required by some legacy desktop tools.
  • IIF is Intuit's tab-delimited format for bulk-loading lists and transactions into QuickBooks Desktop.

Because all of these are generated from the one clean pass over your file, you never have to re-map your columns to switch formats. Map once, export anywhere. That also means you can keep a tidy Excel copy of the parsed transactions for your own records at the same time you produce the QBO for QuickBooks.

A modern web tool, not a heavyweight desktop install

People shopping for CSV to QBO converter software or a bank statement converter for QuickBooks usually run into two kinds of product: expensive desktop applications that you download, license, and update, and per-page OCR tools built for scanned PDFs that bill you for pages you are not even using. CSVQBO is neither. It runs in your browser, so there is nothing to install and nothing to keep up to date, and it is purpose-built for structured CSV and Excel data, so there is no per-page OCR cost and no accuracy guessing.

That focus is the advantage. A general document tool has to be cautious because it is reading pixels. A CSV is already structured data, so CSVQBO can be exact: it reads your real values, applies real accounting rules, and produces a deterministic, repeatable QBO. The same input always gives the same output, which is exactly what you want when you are going to reconcile against it.

CSVQBO compared to MoneyThumb, ProperSoft, DocuClipper and SaasAnt

If you have been searching for a MoneyThumb alternative, a ProperSoft alternative, a DocuClipper alternative, or a SaasAnt Transactions alternative, here is the honest landscape. MoneyThumb and ProperSoft are capable desktop products, but they are downloads with hundreds of dollars of one-time license cost and a dated install-and-update workflow. DocuClipper is strong at OCR for scanned PDF statements, but it prices per page and gates QBO export to higher tiers, which is expensive overkill when your data is already a clean CSV. SaasAnt connects directly to QuickBooks Online and imports rather than producing a portable QBO file, which ties you to its credit model and to an always-on connection.

CSVQBO sits deliberately in the gap: a focused, browser-based CSV and Excel to QBO converter that costs a fraction of a desktop license, never charges per page, and gives you a real .qbo file you own and can import into any QuickBooks company. You can try it right now, on this page, with no account and no credit card, which none of the desktop tools let you do.

The import errors CSVQBO prevents

Most of the frustration around QuickBooks imports comes down to a handful of specific failures, and CSVQBO is built to prevent each one:

  • QuickBooks CSV import date format errors. When a file uses DD/MM/YYYY and QuickBooks assumes MM/DD/YYYY, the 4th of March becomes the 3rd of April and your transactions land in the wrong period. We detect the format and let you lock it, so dates are always right.
  • QuickBooks Web Connect import error and unknown FID. If the Financial Institution ID is missing or unrecognised, the Web Connect import fails. We let you set a bank name and FID so the file is accepted.
  • QBO file not importing into QuickBooks. An invalid header, an unbalanced ledger, or a malformed transaction will make QuickBooks reject the whole file. We always generate valid, balanced OFX/QBO.
  • Duplicate transactions. Every line gets a unique FITID, so re-importing an overlapping range does not double up your books.

Convert your first CSV to QBO at the top of this page and see the difference on your own statement. No account needed to start.

Start free, upgrade when you scale

Convert your first files free with no account. Sign up free for more, and upgrade to Starter, Plus or Pro for unlimited conversions, batch processing and every export format.

Questions, answered

Everything bookkeepers ask before their first conversion.

No. You can drop a CSV or Excel file at the top of this page and download a working QBO right away, with no account and no credit card. Create a free account when you want to convert larger files and more of them, and upgrade only when you need unlimited conversions, batch processing or extra export formats.
Yes. Your file is uploaded over an encrypted 256-bit connection, processed, and then deleted automatically. We never ask for your online banking username or password, and we never connect to your bank. You stay in control of your own data.
Any bank or credit-card company that lets you export transactions to CSV or Excel works, because we read the file rather than connecting to the bank. That includes Chase, Bank of America, Wells Fargo, Citi, Capital One, US Bank, PNC, American Express, plus international banks like HSBC, Barclays, RBC, TD and Scotiabank, and thousands of smaller banks and credit unions.
Both. The file we generate is a standard QuickBooks Web Connect (.qbo) file. In QuickBooks Online use Transactions, Bank transactions, Upload from file. In QuickBooks Desktop use File, Utilities, Import, Web Connect Files. The transactions appear ready to review, categorise and accept.
No. We detect the date format automatically and you can lock it to MM/DD/YYYY, DD/MM/YYYY or YYYY-MM-DD with one click. That prevents the most common import problem, where a wrong date format silently posts transactions to the wrong month.
Yes. Mark the file as a credit-card account and we write the correct account type so charges and payments post correctly without the CREDITLINE error. If your export uses separate debit and credit columns, or Money In and Money Out columns, we normalise them into correctly signed transactions automatically.
On paid plans you can export the same parsed transactions as QFX, OFX, QIF or IIF, plus a clean Excel or CSV copy for your own records. You map your columns once and export to any format you need.
Open the preview before you download and you will see exactly how every row was parsed. If a column was read wrong you can adjust the settings and regenerate. If you are on a paid plan and still get stuck, our support team will look at your specific bank layout and help.

Convert your first CSV to QBO now

No account required to start. Drop a file and download a balanced QuickBooks file in seconds.

Convert to QBO