How to import a bank CSV into QuickBooks Online

QuickBooks Online can read a bank CSV directly, but only when the file is laid out the way it expects. Most upload failures come down to the file, not to QuickBooks.

What QuickBooks Online expects

The file needs a header row and one of two layouts:

• Three columns: Date, Description, Amount. Money leaving the account is a negative number.
• Four columns: Date, Description, Credit, Debit.

Bank exports rarely arrive like that. The usual problems are:

• title or summary lines above the header row, or totals below the last transaction;
• currency symbols or text such as "CR" inside the amount column;
• a day-of-week or time inside the date column;
• extra columns such as balance, category or card number;
• zeros or blanks where QuickBooks expects an amount.

Clean the file first

You can fix those by hand in a spreadsheet. The quicker way is to drop the bank file into the converter and choose Clean 3-column CSV as the output. It strips the extra lines and columns, normalises the dates and signs, and gives you a file in the three-column layout. Choosing QBO instead skips the column-matching step in QuickBooks altogether.

Upload it

1. In QuickBooks Online, go to Transactions → Bank transactions.
2. Open the menu next to Link account and choose Upload from file.
3. Select your file and choose the account the transactions belong to.
4. For a CSV, match the columns: say which holds the date, the description and the amount, and pick the date format used in the file. A QBO file skips this step.
5. Select the transactions to import and confirm.
6. Review them on the For review tab: categorise, match to existing entries, and add.

If the upload fails

• "Some info may be missing from your file" or a format error: there are stray lines above the header or below the data, or an amount cell holds text. Clean the file as described above.
• Dates are rejected or land in the wrong month: the date format chosen during column matching does not match the file. Check whether your file is day-first or month-first.
• Deposits appear as spending: the signs are reversed, which is common with credit card exports. Run the file through the converter, which corrects card files it recognises, or tick Reverse signs there.
• Duplicates appear: the date range overlaps one you imported before. CSV has no transaction IDs, so QuickBooks cannot always tell. Exclude the repeats on the For review tab, and consider using QBO files in future.

Questions and answers

Which CSV layouts does QuickBooks Online accept?

Two: three columns (date, description, amount, with money out as negative numbers) or four columns (date, description, credit, debit).

Is QBO better than CSV for QuickBooks Online?

Often, yes. A QBO file needs no column matching, and its transaction IDs help QuickBooks avoid importing the same transaction twice. QuickBooks Online accepts both.

Can I undo an upload?

Transactions you have not yet added can be excluded on the For review tab. Ones already added to the register have to be undone or deleted there.