Checking a download before it reaches the books
Convert first and read the CSV. Duplicated rows, a wrong date range or a missing week are far easier to spot in a sheet than after they have been posted and have to be unpicked.
QBO to CSV
Read a QuickBooks .qbo bank file as CSV in your browser, so you can see what is in it before anything is imported.
Maintained by Roshan · Page and browser-local behavior last reviewed August 31, 2026.
Browser-local QuickBooks export reader
Use QBO to CSV
Reads a QuickBooks QBO bank file in this tab and writes the transactions out as CSV, so you can inspect or archive them outside QuickBooks. Nothing leaves your device.
PDF and scanned statements are not supportedQBO is the Web Connect data file, not a printed statement. A PDF statement is a page layout, and reading transactions out of one needs layout analysis or OCR that this tool deliberately does not do. Note also that QuickBooks' own CSV import expects its own column names — you will be asked to map these columns on the import screen.
Checked with a Canadian savings-account download containing an Intuit routing block and a transfer entry. The declared currency reaches every row rather than being left blank for a spreadsheet to guess at, and the transfer stays one signed row instead of being expanded into a pair that would have doubled the reported movement.
More in this category
Explore developer and data tools tools
Find related browser-local tools for nearby tasks without starting another search.
Browse all developer and data tools toolsAbout QBO to CSV
A .qbo file is the bank download QuickBooks accepts through Web Connect. It is Open Financial Exchange underneath, carrying an Intuit routing identifier that QuickBooks checks before it will take the file at all — which is why a .qbo downloaded for one company file can be rejected by another, and why the format has a reputation for being awkward. The awkwardness is in the acceptance rules, not the data. The transactions inside are plainly structured and this page reads them in your browser, producing a CSV you can open anywhere. The most common reason to want that is not conversion at all but inspection: seeing exactly what a bank download contains before it goes into the books, or getting a period of transactions out of a file when the QuickBooks side has become the obstacle. Nothing is uploaded, no company file is touched, and no QuickBooks licence is involved.
Work through the input
- The Intuit routing identifier that QuickBooks uses to accept or reject the file is read past rather than enforced. This tool has no reason to refuse a file that QuickBooks would refuse, so a download rejected by the import screen still converts here.
- Transfers between accounts carry their own transaction type and are kept as a single signed row, rather than being expanded into a matched pair that would double the movement in the totals.
- Whichever account container the file uses, the account number is carried into its own column, which is what lets several downloads be combined into one sheet and separated again later.
- The currency declared for the statement is written onto every row, so a Canadian or Australian download is not silently read as if it were dollars of a different kind once it reaches a spreadsheet.
- Credits, debits and the net movement are totalled per currency and shown before the download, so the file can be checked against the balance the bank reported without opening the CSV first.
When qbo to csv is useful
A .qbo the import screen will not accept
Acceptance depends on the routing identifier matching what the company file expects. That check is not repeated here, so the transactions can still be read out and entered another way.
Check the output
- This is not a QuickBooks import. It produces a CSV for reading, checking or archiving. Nothing is written to a company file, no connection to QuickBooks Online exists here, and no accounting entry is created.
- The CSV will not import back into QuickBooks unmodified. QuickBooks' own CSV import expects its column names and its date conventions, so its mapping screen will ask which column is which.
- PDF statements are not readable here. Extracting rows from a printed layout needs OCR or layout analysis, and neither runs in this tool; the risk of confidently misreading a column boundary is exactly why.
- There is no bank feed. This reads a file you downloaded yourself. Nothing connects to an institution, and no banking credential is requested at any point.
- Bank-specific tags that have no column here are named in a warning rather than discarded quietly, so you can see what the file carried beyond the standard fields.
Questions about QBO to CSV
What actually is a .qbo file?
A bank statement in Open Financial Exchange format with an Intuit routing block attached. The transaction records inside follow the ordinary OFX grammar, which is what makes them readable without any Intuit software.
Why does QuickBooks reject a .qbo that opens fine here?
QuickBooks checks the routing identifier and the account it is being imported into before accepting the file. That is an acceptance rule, not a property of the data, and this converter has no reason to apply it.
Can I convert this CSV back into a .qbo?
Not with this tool. Only reading is offered for now. Writing a Web Connect file that QuickBooks will accept means reproducing identifiers that belong to a financial institution, which is a different problem from parsing.
Does anything here touch my QuickBooks account?
No. There is no sign-in, no API connection and no company file access. The tool reads a file from your device inside this browser tab and produces a CSV on the same device.
Related tools
OFX to CSV
Convert an OFX bank statement to CSV in your browser. No upload, no bank connection, no account. Transaction dates, payees, amounts and FITIDs come out as columns.
QFX to CSV
Convert a Quicken QFX file to CSV in your browser. Works without a Quicken subscription. No upload, no bank login, no account needed.
QIF to CSV
Convert a QIF file to CSV in your browser, with the day/month order made explicit instead of guessed. No upload, no account, no bank connection.
Local Reconciliation Suite
Reconcile bank, ledger, processor and marketplace exports in your browser. Write your own matching rules, review the exceptions, and export a full audit package. The files are not uploaded.
CSV to XLSX
Turn CSV into a real .xlsx workbook in your browser. Leading zeros and long numbers survive, unlike opening the CSV in Excel directly.