Skip to content

Convert CSV to QBO for QuickBooks Desktop

QuickBooks Online can map a CSV, but QuickBooks Desktop (Pro, Premier, Enterprise) imports bank transactions as Web Connect (.qbo) files. Convert your bank's CSV or Excel download to QBO here and import it through File > Utilities > Import > Web Connect Files.

Columns (only if we guess wrong)

Column numbers in your CSV or Excel file, counting the first column as 1.

No sign-up. Files are deleted after 24 hours. Credits never expire. Download a sample file to try it.

How it works

  1. Step 1

    Upload

    The CSV or Excel download from online banking, or a PDF statement.

  2. Step 2

    Check

    Free preview of every transaction as QuickBooks will read it: date, payee, signed amount.

  3. Step 3

    Import

    QuickBooks Online: Banking > Upload transactions. Desktop: File > Utilities > Import > Web Connect Files.

What you get

Your bank's CSV
Date,Description,Amount
03/04/2026,STAPLES 00123,-45.10
QBO (Web Connect) transaction
<INTU.BID>3000
<STMTTRN>
<TRNTYPE>DEBIT
<DTPOSTED>20260304
<TRNAMT>-45.10
<NAME>STAPLES 00123
</STMTTRN>

Why Desktop rejects some QBO files

  • "QuickBooks is unable to verify the Financial Institution information": Desktop checks the bank ID (INTU.BID) inside the file against Intuit's list. Our files use a bank ID Desktop accepts (3000) by default.
  • Account type: a credit card file has to go into a credit card account. Choose the account type before you download.
  • Duplicate IDs: Desktop skips transactions whose ID it has already seen. Every row gets a unique, stable ID, so re-importing the same file never doubles anything.

Importing into QuickBooks Desktop

  1. File > Utilities > Import > Web Connect Files and pick the .qbo file.
  2. Choose Use an existing QuickBooks account and pick the bank or card account, the first time only.
  3. Review the transactions in the Bank Feeds center and add them to the register.

Pricing

Preview every file free: see the transactions exactly as QuickBooks will read them before you pay. Credits never expire. No subscription needed. Prices are in US dollars; sales tax or VAT is added at checkout where it applies.

  • 1 file

    $9 per file

    $9

  • 10 filesBest value

    $2.90 per file

    $29

  • Unlimited files every month

    $0.08 per file, billed monthly, cancel any time, fair use 500 files a month

    $39/mo

Deleted after 24 hours

Your upload and the result are removed automatically.

Never used for training

Files are processed only to make your result.

Refund if it is wrong

If a result is unusable, we fix it or refund you.

Privacy policy · Refund policy

Questions

Which versions of QuickBooks Desktop does it work with?

Pro, Premier, Enterprise and Accountant on Windows, and QuickBooks Desktop for Mac, as long as the version is still supported by Intuit for bank feeds.

Can I use the same file in QuickBooks Online?

Yes. Upload the .qbo file under Banking > Upload transactions.

Is my statement kept?

No. Files are deleted automatically 24 hours after upload and never used to train AI.

How much does it cost?

The preview is free. $9 per file, $29 for 10 files, or $39 a month for unlimited files.

Does it work with QuickBooks Online and QuickBooks Desktop?

Yes. The same QBO (Web Connect) file imports in both. QFX for Quicken and OFX for Xero download from the same conversion.

Is this made by Intuit or my bank?

No. This is an independent tool. QuickBooks and Quicken are trademarks of Intuit Inc.; bank names are used only to describe their files.