Turn any bank CSV into a file QuickBooks will actually accept
Upload your CSV. QBOKit figures out the columns, fixes the dates, encoding and amount signs, and gives you a .QBO Web Connect file or a clean import-ready CSV.
🔒 Conversion happens entirely in your browser. Your transactions are never uploaded anywhere.
1. Drop your CSV
Drag a CSV here, or
Also accepts tab- and semicolon-separated exports.
2. Check the columns
QBOKit guessed these from your file. Change anything that looks wrong.
3. Pick your output
QuickBooks institution settings (open this if your import gets refused)
QuickBooks checks these before it will read the file. 3000 works for most imports. If QuickBooks says it cannot verify the financial institution, try your bank's real FID, or a different value here.
4. Preview
Doing this for a dozen clients every month?
QBOKit Pro is being built for bookkeepers and accounting firms:
- Saved column mappings — map each bank's export once, reuse it every month in one click.
- Batch conversion — drop 30 files, get 30 QBO files back.
- Verified bank presets — the right FID and INTU.BID per institution, so imports stop getting refused.
- Duplicate-safe IDs — stable FITIDs so re-imports don't double up transactions.
One email when it is ready. Nothing else, no sharing.
Common questions
Why won't QuickBooks accept my bank's CSV?
QuickBooks Online is strict about the shape of a CSV: it wants a date, a description and an amount, dates in one consistent format, UTF-8 encoding, no blank rows, no currency symbols, and any comma inside a description wrapped in quotes. Bank exports break at least one of these rules almost every time. QBOKit rewrites the file so it passes. The full list is in CSV format requirements, and if you are seeing "Some info may be missing from your file" that page covers the eight usual causes.
What is a .QBO file?
A QBO file is Intuit's Web Connect format — Open Financial Exchange data with an extra header naming the bank. QuickBooks Desktop imports it directly, which is why converting to QBO is the usual fix when a CSV keeps failing. See how to convert a CSV to QBO.
Why does QuickBooks say it cannot verify the financial institution?
That error comes from the FID and INTU.BID tags in the file header. QuickBooks matches them against its own list of institutions. Open the institution settings above and try a different value — 3000 is the most widely accepted.
Is my bank data safe?
Yes. The converter is JavaScript running in your own browser. Your file is read locally and the result is generated locally. Nothing is sent to our server, so there is nothing for us to store or leak.