Bank CSV to QBO converter

Clean, check and convert a bank CSV on your own device

🔒 Processed locally · never uploadedEXPERIMENTAL · free
Experimental: output is valid OFX, but import into QuickBooks Online has not been verified for every account type. If an import fails, tell us.
Privacy: your CSV is processed only in your browser and is not uploaded. This page sends this site only anonymous event counts (event names, no file content) and any feedback you choose to submit. No cookies, no third-party scripts or analytics; the site does not store IP addresses. Not affiliated with Intuit.

1 Your CSV

Load a synthetic sample (layouts modelled on public descriptions of bank exports; not real data):

2 Column mapping

Load a CSV to detect columns.
QuickBooks expects English files, so non-English descriptions may be rejected. Default: keep the ASCII part (accents removed); if nothing readable is left, "Transaction N" is used instead.

3 Parsed preview

Transactions–
Error rows–
Credits–
Debits–
Date range–

Transactions that will be exported

LineDateDescription (ASCII part only)Amount
Nothing loaded yet.

4 Export

Free

QuickBooks Online CSV (3 or 4 columns)

For QuickBooks Online's own CSV import. Auto-split into files of ≤ 1,000 rows and ≤ 350 KB.

Free Experimental

.qbo / .ofx (OFX 1.02, Web Connect)

4–22 letters/digits. Use a different ID for each account (“0000” is only a placeholder).
Balance after the last transaction. OFX requires a balance field: if you leave this empty, 0.00 is written and the balance is meaningless — ignore it after import. Credit card: an amount you owe is normally negative.
Must match your QuickBooks account's currency.
Advanced: export variants (for testing)

Not documented by Intuit. If an import fails, try another variant and tell us which one worked.

Want a paid version with batch & saved templates?

Just gauging interest — there is nothing to buy, no payment is connected, and no paid version exists yet. Clicking only registers a vote.

How it works

  1. Load your bank CSV: drop the file, paste the text, or try a synthetic sample. Nothing is uploaded; parsing happens in this page.
  2. Check the column mapping. The tool guesses the date, description and amount (or debit / credit) columns, the date format and the decimal mark. Change any of them, then look at the preview. Rows it cannot read are listed separately and are not exported.
  3. Export a QuickBooks Online CSV (3 or 4 columns, split automatically into files that stay within the limits) or an experimental .qbo / .ofx file.
  4. Upload the file in QuickBooks Online (see the FAQ below) and check the imported transactions before accepting them.

Frequently asked questions

Is my bank CSV uploaded anywhere?

No. The file is read, cleaned and converted in your browser. This site only counts anonymous events (for example "page viewed" or "file converted"; no file content) and stores feedback only if you choose to send it. There are no cookies and no third-party scripts.

Will the .qbo / .ofx file import into QuickBooks Online?

Not guaranteed. The file is valid OFX 1.02 and was checked with independent OFX parsers in our tests, but import into QuickBooks Online has not been verified for all account types. The CSV export follows the 3-column and 4-column layouts described in Intuit's help. If an import fails, please tell us through the feedback box on the page.

What are the 350 KB and 1,000-row limits?

Intuit's help currently says an upload can have up to 1,000 lines and must be 350 KB or less. The converter splits a long statement into several files of at most 1,000 rows and 350,000 bytes each (we do not know exactly how Intuit measures a KB, so we use a conservative figure). You can download the parts one by one or as a .zip.

Why do descriptions have to be in English?

Intuit's help says the upload file must be in English, and text in other languages may be rejected. By default the tool keeps the ASCII part of each description and removes accents; if nothing readable is left, it writes "Transaction N". You can choose to keep the original text as UTF-8, but then acceptance is up to QuickBooks. There is no translation or transliteration.

How do I upload the file to QuickBooks Online?

According to Intuit's help: open Accounting, then Bank transactions, choose the account tile if you see one, open the Link account menu and select Upload from file. Pick the file, choose the QuickBooks account, match the columns, select the transactions to import and confirm. Menu names change over time, so check Intuit's current help if yours differ.

What happens if I import the same transactions twice?

In .qbo / .ofx files every transaction gets an ID (FITID) built from the date, the amount in cents, a short hash of the original description and a counter for identical rows. The same input always produces the same IDs, and QuickBooks generally uses such IDs to recognise transactions it has already seen, but we have not verified this behaviour for every account. CSV files carry no transaction ID, so Intuit suggests starting the file after the oldest transaction already in the account. If two exports overlap and contain identical same-day rows in a different order, the counters may not line up.

Which bank CSV layouts and date formats are supported?

One signed amount column, or separate debit and credit columns; amounts such as $1,234.50, (45.10), 12.50- and 1.234,56 are understood, and you can flip the sign for card statements. Dates such as MM/DD/YYYY, DD/MM/YYYY, YYYY-MM-DD and "Oct 3, 2026" are detected, and if a file cannot tell day from month the page asks you to confirm. Zero-amount rows are skipped by default. Layouts are guessed from common formats, so always check the preview. XLS/XLSX and PDF are not supported.

Is it free, and is it affiliated with Intuit?

It is free, with no sign-up and no payment. It is an unofficial tool and is not affiliated with or endorsed by Intuit; "QuickBooks" and "Intuit" are trademarks of Intuit Inc.