CSV to QBO Converter
Turn a plain bank CSV export — from any bank, in any column order — into QBO, OFX, IIF or a clean Excel file for QuickBooks. Free, no signup, no file size limit.
.csv and .txt accepted
Why a "simple" CSV still needs a converter
Every bank's CSV export uses different column names, a different column order, and — this is the part that silently corrupts data — a different date and number convention. This tool auto-detects the columns (by header text or, if there is no header, by looking at the content) and normalizes three things that break naive imports:
- Ambiguous dates.
03/04/2024is March 4th in the US and April 3rd almost everywhere else. This converter scans the whole date column — if any row has a first number over 12 it must be day/month; if any row has a second number over 12 it must be month/day. Only when every date in the file is ≤12/≤12 is the format truly ambiguous, and it defaults to US month/day with a warning shown on screen. - Two decimal conventions.
1,234.56(US/UK) and1.234,56(most of Europe) are both accepted, decided per amount by which separator appears last. - Debit/credit split columns, parentheses negatives, and currency symbols
(
$,€,£) are all normalized to a single signed amount.
What you get
Frequently asked questions
Is my CSV file uploaded to a server?
No. There is no server component and no upload endpoint. The file is read and converted entirely by JavaScript in your own browser. Open your browser's network tab while converting and you will see no requests. The page also works offline once loaded.
QuickBooks says the .qbo file's bank isn't recognized — what do I do?
QuickBooks Desktop's Web Connect import checks the file's INTU.BID (bank
identifier) against its own list of registered banks. A CSV export has no such identifier, so this
converter fills in a placeholder — which QuickBooks may reject with "this bank isn't set up for
download." If that happens, use the OFX download instead: it is the same data without
the QuickBooks-specific bank check, and Quicken, QuickBooks Online (via the OFX/QFX import), and most
accounting software accept it directly. The IIF download is the most reliable route
specifically for QuickBooks Desktop, since IIF has no bank-identifier requirement at all.
Which CSV files work?
Any bank or card CSV export that has at least a date and an amount (or separate debit and credit columns) in some column, in some order. Header row is optional — if the file has no header, the columns are inferred from the data itself. Multi-currency and multi-account files are supported; each row keeps its own currency, and the account name can be set for the whole file before downloading.
What happens to rows that can't be parsed?
A row is skipped only if neither a date nor an amount can be extracted from it (for example a totals or disclaimer line at the end of the file). Every skipped row and every ambiguous date decision is listed as a warning above the preview table so you can double-check the source file if something looks off.