How to convert a CSV to QBO for QuickBooks
QuickBooks Desktop imports .QBO (Web Connect) files, but your bank only gives you CSV or Excel. Here's how to bridge that gap in about a minute — without uploading your bank data anywhere.
A .QBO file is QuickBooks' Web Connect format — essentially an OFX file with an Intuit bank identifier inside. QuickBooks Desktop happily imports it, but banks almost never let you download one directly. What you can download is a CSV or Excel export of your transactions. Ledgerfeed converts that CSV into a valid .QBO for you.
Steps
- Download your transactions from online banking as CSV (or Excel).
- Open the free converter and drop the file in. Ledgerfeed auto-detects the date, description and amount columns — adjust the mapping if needed.
- Check the preview, then click .QBO to download.
- In QuickBooks Desktop: File → Utilities → Import → Web Connect Files, and select your .QBO.
If QuickBooks rejects the .QBO
Desktop can complain about the bank identifier (INTU.BID). In the converter, open Advanced (QBO import settings) and try a different Intuit bank ID. Everything is generated on your device, so you can re-download as many times as you need.
Prefer QuickBooks Online? It doesn't use .QBO — it wants a specific CSV layout instead. See the QuickBooks Online CSV format guide. Not sure which format you need? Read QBO vs OFX vs QIF.
FAQ
Is my bank data uploaded?
No. Ledgerfeed runs entirely in your browser — the file is read and converted on your own device. You can disconnect from the internet and it still works.
Does this work on Mac and Windows?
Yes. It runs in any modern browser, so the operating system doesn't matter.
What if my bank uses DD/MM dates or comma decimals?
Ledgerfeed detects MM/DD and DD/MM dates and European decimal commas (1.234,56) automatically, and you can override the date format if needed.