Import bank CSV transactions into QuickBooks Desktop
QuickBooks Desktop's bank feeds import Web Connect (.qbo) files. Convert the CSV to QBO below — free up to 150 transactions, nothing uploaded — then import it in four clicks.
Why the CSV won't import directly
QuickBooks Desktop's banking center is built around Web Connect (.qbo) files, the format banks offer for direct download. A plain CSV from your bank has no account identifiers or transaction IDs, so QuickBooks can't match it to an account or avoid duplicates. Converting it to QBO solves both.
Step by step
- Export a CSV from your online banking for the date range you need (or use an Excel export).
- Drop it into Bankfold above. Check that the date, description and amount (or debit/credit) columns are right. If there's a balance column you'll see a reconciliation badge.
- Under export settings pick the account type (checking, savings or credit card) and, optionally, the last digits of the account number so QuickBooks keeps it separate from other accounts.
- Download QBO.
- In QuickBooks Desktop choose File → Utilities → Import → Web Connect Files, select the .qbo, then pick an existing QuickBooks account or create a new one.
- Review the transactions in Banking → Bank Feeds → Bank Feeds Center and add or match them.
If QuickBooks says the bank isn't supported
Some QuickBooks versions check the Intuit bank ID inside the file. Bankfold lets you set it in the export settings; see fixes for common QBO import errors.
Converting a year of statements?
Free handles one file of up to 150 transactions at a time. Pro merges several months into one import with duplicates removed — a 7-day pass is $5.
FAQ
Can QuickBooks Desktop import a CSV into a bank account?
Not into the bank feed directly. QuickBooks Desktop bank feeds import Web Connect (.qbo) files, so convert the CSV to QBO first. Bankfold does that in your browser.
Will re-importing create duplicates?
No, as long as the transactions are the same. Bankfold gives each transaction a stable ID, so QuickBooks recognizes ones it has already imported.
Is it really private?
Yes. Your file is read and converted by JavaScript running in your browser tab. Its contents are never sent over the network. You can verify this in your browser's developer tools (Network tab), or disconnect from the internet after the page has loaded — conversion still works.
Which banks are supported?
Any bank or card that exports CSV, TXT or Excel — Chase, Bank of America, Wells Fargo, Capital One, Citi, American Express, RBC, TD, Barclays, HSBC, Monzo, Revolut, CommBank, Sparkasse and thousands more. Bankfold detects the columns automatically, and you can change any column with a dropdown; your choice is remembered for that layout.
Can it convert PDF statements?
Not directly — Bankfold converts CSV and spreadsheet exports. For PDF statements, use our sister tool TidyLedger, which also runs entirely in your browser.
Will QuickBooks import duplicates if I convert overlapping statements?
No, as long as the transactions are the same. Every transaction gets an ID based on its date, amount and description, so QuickBooks and Quicken recognize ones they've already imported.
Which file should I download?
QuickBooks Desktop or Online: QBO. Quicken: QFX. Xero, Sage, Wave, FreeAgent, GnuCash and most other apps: OFX. Older software: QIF. QuickBooks Online also accepts our 3- or 4-column CSV.
What's free?
Every format, one file at a time, up to 150 transactions per conversion. No account needed. Pro removes the limit and lets you merge several statements into one import with duplicates removed.