CSV to QBO converter: what to check before you use one

Your bank exports a spreadsheet. QuickBooks wants a bank file. A converter is the thing in between, and there are a lot of them. Here’s what one actually has to do, and the question worth asking before you hand yours a statement.

What the converter has to produce

QuickBooks won’t read a bank CSV the way your bank wrote it.

On QuickBooks Online you can upload a CSV, but only in a strict three or four column layout, and bank exports rarely match it. On QuickBooks Desktop there’s no CSV route at all. Web Connect only works with .qbo files, so a spreadsheet has nowhere to go.

A .QBO file solves both. It’s the same format a bank hands you directly when it offers a QuickBooks download. Both versions take it with no column matching.

It also has to cope with the file your bank actually wrote, not a tidy one. Real exports arrive with summary rows above the data and headers nobody standardized. Amounts come in brackets instead of minus signs, and an Excel file turns up when you expected a CSV. A converter that only reads a perfect three column sheet has moved the work rather than done it.

Good output carries one more thing: an id on every transaction. QuickBooks uses those ids to recognize lines it already has. Without them, importing an overlapping date range gives you every transaction twice.

The question the tool pages don’t answer

Nearly every converter in this market works the same way. You upload your bank statement to their server, it converts there, and you download the result.

That step deserves more thought than it usually gets. A bank statement lists every place you spent money, how much, and when. It’s one of the more revealing documents you own, and converting it is a few seconds of arithmetic on three columns.

None of that work needs a server. A browser can read the file, find the columns, write the QBO and hand it back without anything leaving the machine it was already on. Most converters upload anyway, because a server is the easier thing to build.

What to check before you use one

Where it converts. If the page says upload, the file leaves your computer. If it converts in the browser, it doesn’t. You can check this yourself: open your browser’s developer tools, convert a file, and look at the requests.

Whether it keeps transaction ids. No ids means duplicates the next time your date ranges overlap.

Whether you can see the result first. A converter that makes you pay before showing a single row is asking you to trust it twice.

Whether it reads your dates correctly. A bank writing 03/10 may mean March 10 or October 3. The converter needs to let you say which.

Whether it handles a credit card. Some card exports list purchases as positive numbers, which lands them in QuickBooks as deposits unless the converter can flip them.

Whether QuickBooks will take the file at all. A converter can write a perfectly valid looking .QBO that QuickBooks still refuses. Intuit lists the messages you might see. One of them says QuickBooks could not verify the financial institution. You find that out at the import screen, which is after you have paid.

The one we just launched

FileInto went live this month, and it’s built on the first item in that list. Its CSV to QBO converter runs inside your browser tab. There’s no upload step, so nothing from your statement reaches a server. The pages also refuse connections to any other site, so it can’t happen by accident. Once the page has loaded it works with the internet switched off.

It covers the rest of the list too. Every file names an institution QuickBooks accepts, so the import screen isn’t where you discover a problem. Every transaction gets an id built from its date, amount and description. Each file previews every row at no charge, with no account. You pick the date order, and a credit card setting flips purchases the right way.

Files up to 25 transactions download free. A free account raises that to three files a month. A Day Pass is 9 dollars for 24 hours, and Unlimited is 7 dollars a month.

The launch announcement has the full list of twenty converters, and once you have the file, getting it into Desktop takes four clicks.