How to Convert a CSV to QBO for QuickBooks
QuickBooks Online dropped CSV for bank feeds. Turning the CSV your bank gives you into a QBO it accepts, including the three things that have to be right.
Plenty of banks export CSV and nothing else. QuickBooks wants a Web Connect file for bank feeds. So the CSV you have is not the file you need, and the gap is small but real.
What has to be right
A CSV is a grid of text. A QBO is a statement with structure. Three things have to survive the crossing, and all three are places converters go wrong.
A full date for every transaction. QuickBooks reads YYYYMMDD and nothing else. A CSV that dates its rows 04/10 with no year cannot be converted honestly — the year is not in the file and inventing one is worse than refusing.
A direction for every amount. Money out must be distinguishable from money in. Your CSV does this in one of two ways: separate Debit and Credit columns, or a single Amount column carrying a minus sign. Both work. What does not work is a single column of positive numbers with nothing to say which way they go.
A unique id per transaction. QuickBooks dedupes on it, and silently discards a repeat. Two identical amounts on the same day need to stay two transactions.
Doing it
- Export the CSV from your bank Take it as your bank produced it. Do not open and re-save it in Excel first — that is how dates get reformatted into something the converter then has to un-guess.
- Upload it to the converter CSV to QBO reads your columns wherever they are and whatever they are called. There is no mapping screen to fill in.
- Read the notes The preview tells you what it concluded — which columns it read as money out and money in, which decimal convention it used, and whether your dates were ambiguous. This is the ten seconds that catches a whole-file error.
- Check the preview table Look at one deposit and one withdrawal. If either is in the wrong column, stop — do not import a file whose direction is inverted.
- Download and import one month Then reconcile before doing the rest.
The thing worth checking in the notes
If your CSV states no currency anywhere — and most do not, because the bank knows what currency your account is in and sees no reason to repeat it — the QBO has to declare one anyway. The format has no way to say unknown.
USD is the usual default and it is still a guess. You will be told that it was made, which means you can correct it in QuickBooks after importing instead of discovering it at a reconciliation. The amounts themselves are exactly as your file had them; only the label is assumed.
If QuickBooks still refuses it
A CSV cannot supply a real bank id, because no CSV contains one. The converted file carries a generic identifier, which QuickBooks usually accepts and occasionally does not. If yours does not, and your bank offers any file from the OFX family, convert from that instead — it will have the real id inside it.
The other causes are covered in why QuickBooks rejects your QBO file.
Frequently asked questions
Does my CSV need specific column names?
No. Columns are worked out from what is underneath them as well as what they are called, so Money In and Money Out work as well as Credit and Debit.
What if my CSV has a title block above the headings?
That is normal for bank exports and is handled — the heading row is found rather than assumed to be row one.
My amounts use commas as decimal points.
European exports do this, and it is detected from the file rather than assumed. The conclusion is stated in the notes so you can check it.
Can I convert to QFX for Quicken instead?
Yes — CSV to QFX is the same conversion with the tags Quicken requires rather than the ones QuickBooks requires.
Convert a statement now
Convert a bank statement PDF to Excel, or see every format. More in the guides.