Skip to content

CSV to QBO converter

Turn a bank CSV into a QBO file QuickBooks can import, without uploading your transactions.

Drop your bank statements here

PDF statements or CSV downloads; several months at once is fine. They're read in this tab and never uploaded.

How to use CSV to QBO converter

  1. Drop your bank or card CSV files. Drag one or more .csv exports up to 15 MB onto Drop your bank statements here, or click Choose statements to open them locally.
  2. Verify transaction dates and signs. Check Dates in the statement to confirm Day first (25/03) or Month first (03/25), and tick Swap money in and out if credit card charges appear as money in.
  3. Configure Web Connect account fields. Keep QBO (QuickBooks Web Connect) selected under Save as, choose Account and Currency, and enter the last four digits under Account number plus your Intuit bank ID (3000 works for most banks).
  4. Export and import into QuickBooks. Click Convert transactions to download the .qbo file, then open it via QuickBooks Web Connect import.

Everything you type stays in this browser on your device. Nothing is uploaded, and your saved details are never sent anywhere.

Turning bank CSV downloads into QuickBooks Web Connect files

When direct bank feeds expire or a regional bank only offers spreadsheet exports, QuickBooks Desktop users cannot import raw CSV files natively without third-party add-ons. Converting your bank CSV into a .qbo Web Connect file locally bridges that gap without uploading financial statements to cloud converters.

Reading bank CSV headings, delimiters, and date order

The parser handles comma, semicolon, and tab-delimited spreadsheets up to 15 MB per file following IETF RFC 4180 CSV Format Specification quoting rules. It automatically skips account summary lines placed above the table header until it detects a recognized date column.

If your bank only provides .xlsx or .xls workbooks instead of plain text spreadsheets, save Excel .xlsx bank exports as CSV first before dropping them here. When Dates in the statement stays on Work it out, the parser checks values above 12 to separate DD/MM/YYYY from MM/DD/YYYY.

Preparing multi-month statements and checking running balances

You can drop several monthly CSV downloads together to merge them into one chronological .qbo file. While the browser preview renders the first 300 rows to keep scrolling responsive, every dated row exports into the final download.

If your CSV includes a Balance or Running Balance column, the sidebar reports how many rows match the printed running balance and flags any mismatches in the table before you import. Checking those highlighted rows early catches missing lines, reversed signs, or truncated exports from your online banking portal before they enter QuickBooks.

Mapping date formats and ambiguous numeric days

Bank downloads vary widely between YYYY-MM-DD, DD/MM/YYYY, and MM/DD/YYYY formats, especially when exporting across regional offices. Switching Dates in the statement from Work it out to Day first (25/03) or Month first (03/25) ensures every <DTPOSTED> timestamp matches your ledger’s calendar.

Why does QuickBooks Desktop require an Intuit bank ID in QBO files?

QuickBooks Desktop validates every .qbo Web Connect file against an internal directory of participating financial institutions before allowing Bank Feeds import. It reads the <INTU.BID> tag inside <SONRS> and rejects files carrying an unrecognized bank ID with an error stating it cannot verify the financial institution.

How INTU.BID 3000 resolves unrecognized bank errors

Under the OFX 1.0.2 SGML Specification, a .qbo file follows the exact OFXHEADER:100 / DATA:OFXSGML / VERSION:102 structure used by OFX, adding <INTU.BID> for Intuit software. Setting Intuit bank ID to 3000 (the converter’s default) supplies a widely accepted directory code so QuickBooks Desktop imports transactions from unsupported or non-US banks cleanly.

If you are importing statements into Xero, Quicken, Sage, or GnuCash rather than QuickBooks Desktop, switch to the CSV to OFX converter for Xero and Quicken, which omits the Intuit-specific bank tag.

Preventing duplicate entries with deterministic FITID hashes

Re-uploading overlapping statement weeks is safe because each <STMTTRN> receives a deterministic 32-bit FNV-1a <FITID> derived from the transaction date, description, signed amount, and same-day sequence number. QuickBooks compares incoming <FITID> strings against its register and skips duplicates automatically.

QBO vs OFX and QuickBooks Desktop vs Online compatibility

Understanding which file format your QuickBooks edition expects avoids failed imports and duplicate account creation during Bank Feeds setup.

Format or account setting QuickBooks Desktop QuickBooks Online Key structural detail
QBO (.qbo Web Connect) Supported (Import > Web Connect Files) Supported (Upload from file) OFX 1.0.2 SGML with <INTU.BID> (default 3000)
OFX (.ofx standard) Not accepted Supported (Upload from file) Standard OFX 1.0.2 without <INTU.BID>
CSV for QuickBooks Requires IIF / third-party tool Supported (3-column or 4-column) Plain CSV mapped via QuickBooks column picker
Credit card (CREDITCARD) Maps to Credit Card register Maps to Credit Card feed Uses <CREDITCARDMSGSRSV1> and <CCACCTFROM>
Checking / Savings Maps to Bank register Maps to Bank feed Uses <BANKMSGSRSV1> and <BANKACCTFROM>

To keep SGML parsers from choking on accented UTF-8 merchant names, text passes through NFKD normalization as defined in Unicode Standard Annex #15 Normalization Forms, stripping combining marks into CP1252 ASCII. <NAME> caps at 32 characters while <MEMO> preserves up to 255 characters.

For European corporate accounts exporting SWIFT .sta or .mt940 files, you can convert European SWIFT MT940 statements without manual reformatting straight into QBO.

Credit card sign flips, local privacy, and bookkeeping scope

Verifying transaction polarity and keeping clean reconciliation trails protects both monthly closes and tax audit readiness.

Reversing positive credit card charges with Swap money in and out

Many credit card portals export purchases as positive numbers and repayments as negative numbers. If the preview places purchases under Money in, tick Swap money in and out before exporting so charges write as negative <TRNAMT> debits in QuickBooks.

In-browser Web Worker privacy and bookkeeping recordkeeping

All 10 supported currencies (USD, GBP, EUR, CAD, AUD, NZD, CHF, SEK, NOK, DKK) and file conversions execute inside your browser’s Web Worker with zero server transmission. As outlined in IRS Small Business Recordkeeping Guidelines, retaining accurate bank statement imports alongside supporting sales records substantiates business income and deductions.

Tip: Enter only the last four digits under Account number (such as 9104) and keep a copy of the original bank CSV alongside your QuickBooks reconciliation archive.

Once your bank feeds are reconciled, you can also export saved browser invoices and credit notes to Excel or CSV to match deposits against issued bills. This converter formats Web Connect files for operational convenience rather than certified accounting or tax advice.

Questions

Does QuickBooks Online accept QBO files or only CSV?

QuickBooks Online accepts both .qbo Web Connect files and formatted CSV or Excel spreadsheets under Bank transactions > Upload from file. QuickBooks Desktop, by contrast, requires a .qbo Web Connect file containing a recognized Intuit Bank ID.

Will re-importing the same QBO file create duplicate entries?

No. Each transaction receives a deterministic 32-bit FNV-1a FITID built from its date, description, amount, and occurrence index, so QuickBooks recognizes previously imported transactions and skips duplicates when overlapping date ranges are uploaded.

How do I fix credit card charges showing as payments in QuickBooks?

Some credit card portals export purchases as positive numbers instead of negative debits. Tick Swap money in and out before clicking Convert transactions so charges export as negative TRNAMT values and refunds or repayments export as positive credits.

What bank CSV columns and date formats are supported?

The parser reads Date, Transaction Date, or Posted Date alongside Description or Payee and either a single signed Amount column or paired Debit and Credit columns. ISO YYYY-MM-DD, slash/dash numeric dates, and named months like 14 Oct 2026 are supported automatically.

What should I enter if QuickBooks Desktop rejects bank ID 3000?

Intuit Bank ID 3000 works for most QuickBooks Desktop imports when a local or international bank is absent from Intuit's directory. If QuickBooks Desktop still rejects the file, look up a participating US bank's INTU.BID code or export as CSV for QuickBooks instead.

Are my bank CSV files uploaded to an external server?

No. Every CSV file is parsed, validated, and serialized into QBO Web Connect format inside a local Web Worker in your browser tab, so your bank balances and merchant histories never leave your device.

Updated