CSV works for QuickBooks Online and Xero — Desktop is the one that wants .QBO

This is the question that decides which converter you should buy, and it is usually answered by people selling one. The short version: which file you need depends entirely on which accounting product you use, and for two of the three common ones a plain CSV is enough.

The three destinations

QuickBooks Online — CSV works

QuickBooks Online imports bank transactions from a CSV in either of two shapes: three columns of Date, Description and Amount, or four columns of Date, Description, Credit and Debit. If your statement has separate debit and credit columns you map both during import; if it has one signed amount column you map that. Either is accepted.

So for QuickBooks Online you do not need a specialised file format at all. A clean CSV, which this tool produces, is enough.

Xero — CSV works, with stricter rules

Xero also imports a CSV, but is fussier about the shape. Column headers have to match its expected names, dates have to be in the format for your region, and amounts cannot carry currency symbols or thousands separators. Xero provides a template file you can download from inside the product, which is the reliable way to get the columns right.

The practical consequence: expect to tidy the converted CSV before importing — strip symbols, rename headers to match the template. Ten minutes, once you know the shape.

QuickBooks Desktop — this is the one that needs .QBO

QuickBooks Desktop imports through Web Connect, which expects a .QBO file. A QBO is an OFX file carrying Intuit-specific headers, including a bank identifier, and QuickBooks checks that identifier against its own list of institutions before it will accept the transactions.

This tool does not produce .QBO files. Converters that do — DocuClipper, MoneyThumb, ProperSoft among them — handle the identifier as part of what you are paying for. If QuickBooks Desktop is your destination, buy one of those. It is the clearest case in this whole comparison where the more expensive tool is simply the right answer.

What OFX, QFX and QBO actually are

These names get used interchangeably and they are not the same thing:

• OFX — Open Financial Exchange, the underlying open format for financial transaction data.
• QFX — Intuit's variant used by Quicken.
• QBO — Intuit's variant used by QuickBooks Desktop via Web Connect, which is OFX plus Intuit headers including the institution identifier.
• CSV — a plain table of rows and columns, with no financial semantics at all, which is why both QuickBooks Online and Xero simply let you map the columns yourself.

The route that works with a CSV

1. Convert the statement with PDF to Excel and download as .csv.
2. Open it and confirm the amounts are real numbers — select the column and look for a Sum in the status bar, not just a Count.
3. Check that parenthesised amounts came through as negatives.
4. For Xero, rename the headers to match its template and strip any currency symbols.
5. Import through your accounting product's own bank transaction import.
6. Reconcile against the statement's closing balance before you accept the batch.

The step nobody selling a converter emphasises

Whatever produced the file, reconcile the imported total against the closing balance printed on the statement itself. Extraction errors are not loud. A missing row, a transposed figure, or a negative that came through positive all import perfectly happily and only surface later, in a number that is wrong by an amount nobody can trace.

This applies equally to expensive tools. Accuracy claims in this market are marketing figures, measured on the vendor's own sample of documents. The closing balance on your statement is the only check that is about your document.

Being clear about what this tool is

It finds tables on a page and writes them out as Excel or CSV, with amounts as real numbers carrying their original formatting. It does not produce .QBO files, categorise transactions, read scans in a single pass, or push data into an accounting product. For QuickBooks Online and Xero users doing modest volumes, that gap does not matter. For a QuickBooks Desktop user it matters completely.

FAQ

Can I import a converted bank statement into QuickBooks Online?

Yes. QuickBooks Online accepts a CSV in either three columns - Date, Description, Amount - or four columns with separate Credit and Debit. You map the columns during import. No special file format is needed.

Does this tool make a .QBO file?

No. It produces Excel and CSV. QuickBooks Desktop imports through Web Connect and expects a .QBO file, so if that is your destination you need a converter that makes one, such as DocuClipper, MoneyThumb or ProperSoft.

What is the difference between OFX, QFX and QBO?

OFX is the underlying open format. QFX is Intuit's variant for Quicken. QBO is Intuit's variant for QuickBooks Desktop - an OFX file plus Intuit headers including an institution identifier that QuickBooks validates before accepting the file.

Can I import a CSV into Xero?

Yes, but Xero is stricter than QuickBooks Online. Headers must match its expected names, dates must be in your region's format, and amounts cannot include currency symbols or thousands separators. Download Xero's own template to get the shape right.

Why does my CSV import fail in Xero?

Usually currency symbols or thousands separators left in the amount column, headers that do not match Xero's template, or dates in the wrong regional format. Fix those three and most failures clear.

Should I reconcile after importing?

Always, and against the closing balance printed on the statement itself. A missing row or a negative that came through positive imports without complaint and only shows up later as an unexplained difference.

Is a more expensive converter more accurate?

Sometimes, particularly on scanned statements and unusual bank layouts, where maintained templates and OCR help. Published accuracy figures are vendor-measured on vendor-chosen samples, so treat them as marketing and check your own document against its closing balance.

What happens to my statement?

It is processed and discarded the instant your download is ready - never stored, never queued, and never read by a person.