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.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.
| TRNTYPE | DTPOSTED | TRNAMT | NAME |
|---|---|---|---|
| DEBIT | 20260403 | -64.85 | CARD PURCHASE OFFICE SUPPLIES |
| CREDIT | 20260415 | 1250.00 | CLIENT PAYMENT INVOICE 1042 |
| DEBIT | 20260420 | -12.00 | MONTHLY SERVICE FEE |
Nothing is uploaded: this runs in your browser.
Press Select a CSV and choose the transactions file your bank exported; it is read on your device.
Check the preview: date, description and either one amount or debit and credit sit under the right heading.
Fix any column from the list above it, and type your bank code (INTU.BID) if QuickBooks Desktop asks for one.
Press Download .qbo, then in QuickBooks choose File, Utilities, Import, Web Connect Files and pick the file.
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.
| 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.
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.
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.
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.
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.
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.
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.
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.
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.
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.