Omnikit
DevFilesMoneyAll toolsExams
Ctrl K
Dev toolsFile toolsMoney calculatorsAll toolsExams
HomeFile toolsCSV to QBO Converter

CSV to QBO Converter

files

Turn a bank CSV of transactions into a QuickBooks .qbo Web Connect file, in your browser

Processed in your browser. Nothing is uploaded. Checked against sources on 13 Nov 2026.
What this does
Turn a bank CSV of transactions into a QuickBooks .qbo Web Connect file, in your browser.
What it does not do
It does not upload your files or keep a copy of them. It does not need an account or a sign-in.
What leaves your browser
Nothing you type or open leaves your device. The page sends only a usage count: the tool’s name and the action, never the content.

Checked against the tool’s code on 18 November 2026. Figures read from their sources on 13 November 2026. What we collect

A CSV to QBO converter turns the transactions CSV your bank exports into a .qbo Web Connect file that QuickBooks imports. In the worked example the line dated 04/03/2026 for -64.85 becomes a DEBIT of -64.85 posted 20260403, all 3 balances add up, and the CSV is read in your browser, never uploaded.

Worked example: a 3-row bank CSV converted to QBO
TRNTYPEDTPOSTEDTRNAMTNAME
DEBIT20260403-64.85CARD PURCHASE OFFICE SUPPLIES
CREDIT202604151250.00CLIENT PAYMENT INVOICE 1042
DEBIT20260420-12.00MONTHLY SERVICE FEE
From a sample CSV with an opening balance of 2,140.00; all 3 balances add up. Computed by the converter itself.

Nothing is uploaded: this runs in your browser.

Next:
  • Bank Statement Converter Convert a bank statement PDF to Excel, CSV, Tally or QBO, with every balance checked
  • Open the CSV as Excel Turn CSV files into a tidy Excel workbook with real numbers
  • Data Converter Convert JSON, YAML, XML, CSV, TSV, TOML, INI and Excel into each other

How to convert a bank CSV to QBO

1

Press Select a CSV and choose the transactions file your bank exported; it is read on your device.

2

Check the preview: date, description and either one amount or debit and credit sit under the right heading.

3

Fix any column from the list above it, and type your bank code (INTU.BID) if QuickBooks Desktop asks for one.

4

Press Download .qbo, then in QuickBooks choose File, Utilities, Import, Web Connect Files and pick the file.

What the converter does

QuickBooks Desktop and QuickBooks Online read bank transactions from a .qbo file, which is OFX 1.02 with a QuickBooks bank tag. Most banks also let you download a CSV, but QuickBooks Desktop's Web Connect import takes a .qbo file, not a CSV. This page reads the CSV, names its columns from the headings (Date, Description, Amount, Debit, Credit, Balance and their usual variants), and writes one OFX entry per movement with a stable transaction ID, so importing the same file twice is recognised as a duplicate.

Facts at a glance

Question Answer
Input A CSV, TSV or semicolon-separated text file of bank transactions, up to 50 MB
Columns read One signed amount, or separate debit and credit, plus date, description, reference and balance
Amounts read 1,234.56, 1,00,000.00, 1.234,56 and 1 234,56, minus signs, (brackets), Dr / Cr
Dates read 04/15/2026 or 15/04/2026 (inferred, switchable), 2026-04-15, 15 Apr 2026
Output .qbo (QuickBooks Web Connect) or .ofx (Quicken, Xero, most accounting apps)
Balance check Every printed balance is compared with the running total; rows that do not add up are flagged
Privacy The CSV is read and the file written in your browser; nothing is uploaded

Checked on 13 November 2026 against the OFX documentation linked under Sources; last updated the same day.

Bank code (INTU.BID)

QuickBooks Desktop sometimes refuses a .qbo file whose bank is not in its list. Type your bank's code in the INTU.BID box if it asks; we never guess one. Without it the file still opens in most QuickBooks versions and in every OFX reader.

What it does not do

It does not log in to your bank or QuickBooks, and it does not categorise transactions: QuickBooks matches and categorises them after import. A PDF statement needs the Bank Statement Converter first, which writes the same .qbo directly from the PDF.

Frequently asked questions

How do I convert a CSV to QBO for free?

Choose the CSV on this page, check that date, description and the amount columns are named correctly in the preview, and press Download .qbo. The file is written in a second, with one entry per transaction. It is free, needs no account, and the CSV is read in your own browser rather than uploaded.

How do I import a QBO file into QuickBooks Desktop?

Open the company, choose File, Utilities, Import, Web Connect Files, and pick the .qbo file; QuickBooks then asks which bank account to add the transactions to. If it says the bank is not supported, type your bank's INTU.BID code on this page and download the file again.

Can QuickBooks Online use the QBO file?

Yes. In QuickBooks Online open Banking (or Transactions), choose Upload transactions, pick the .qbo file and the account, and review the rows it shows. QuickBooks Online also takes CSV directly, but a .qbo keeps debits and credits apart and carries stable IDs, so a second import of the same rows is spotted.

My CSV has separate debit and credit columns. Does that work?

Yes. Debit and credit columns are read as money out and money in; one signed Amount column works too, with a minus, brackets or a Dr marker meaning money out. Each column has a list above it in the preview, so a heading the converter did not recognise can be set by hand.

What about a CSV with 1.234,56 amounts and semicolons?

Both are read. A semicolon, tab or pipe separator is detected from the file, and a comma decimal such as 1.234,56 is recognised from the amounts themselves; you can switch the decimal mark under More options. The .qbo always writes plain amounts like 1234.56, which is what OFX requires.

Is it safe to convert bank transactions online?

Nothing leaves your device on this page: the CSV is opened, read and turned into a .qbo by your browser, and no file, account number or amount is sent to a server. You can check by turning off the network after the page has loaded; the conversion still works the same way.

Sources

  • Financial Data Exchange, OFX Work Group (OFX specifications)OFX 1.0.2 SGML statement format the .qbo and .ofx files are written in

Last verified 13 November 2026.

Rates and rules change; check the source before you rely on a figure.

Still stuck? Ask about CSV to QBO Converter and anybody who knows can answer. No account needed.

On the related tools: Convert Any File – Photos, documents, spreadsheets, archives: drop it and see what is possible · Markdown File to HTML – Turn a .md file into the HTML behind it.

Related tools

All file tools
Excel to CSVSave any sheet of an Excel workbook as CSV, with clean datesCSV to ExcelTurn CSV files into a tidy Excel workbook with real numbersConvert AnythingDrop any file and we name it, then offer the one thing you probably came forDocument ConverterTurn a document into another format, with the cost stated firstPPT to WordPull the text out of a PowerPoint deck into an editable Word fileWord to PPTMake a slide deck from the headings in a Word documentWord to ExcelLift the tables out of a .docx and into a spreadsheet you can sortExcel to WordPut a spreadsheet into a Word document as a table you can edit
Was this tool helpful?
Omnikit

Small jobs, done in your browser. Free, fast and private. Files are never uploaded.

Files

  • Compress Image
  • Image to PDF
  • Merge PDF
  • Compress PDF
  • PDF to Word
  • Word to PDF

Dev

  • JSON Formatter & Validator
  • Base64 Encode & Decode
  • JWT Decoder, Verifier & Encoder
  • Password Generator
  • UUID Generator
  • Unix Timestamp Converter

Money

  • SIP Calculator
  • EMI Calculator
  • GST Calculator
  • FD Calculator
  • PPF Calculator
  • Lumpsum Calculator

Site map: Files · Dev · Money

GuidesQuestionsAboutHow we checkLaw library (beta)PrivacyTermsDisclosureContactMore: Exam practice (UGC NET, MH-SET, PhD entrance, CSIR NET)Runs in your browser. Nothing is uploaded. © 2026 Omnikit (theomnikit.com)