Skip to content
statement2sheets

How to import a bank CSV into QuickBooks Online

· 6 min read

Your bank lets you download transactions as a CSV, and QuickBooks Online has an Upload from file option. It sounds like it should just work, and then QuickBooks refuses the file, or the import finishes with amounts in the wrong place. Almost always the cause is the file's layout, not the transactions in it.

Here's what QuickBooks expects, the usual reasons a bank's CSV doesn't match, how to fix a file by hand in Excel, and a free tool that does the fixing for you.

What QuickBooks Online accepts

According to QuickBooks' own help, a CSV for Upload from file has to be in one of two layouts. The first has three columns, Date, Description and Amount, with money out as negative amounts. The second has four, Date, Description, Credit and Debit, with money in and money out in separate columns.

A few more rules come with it:

  • Every date in the same format. QuickBooks recommends dd/mm/yyyy.
  • No zeros in the amount columns. Cells that would hold 0 should be blank.
  • The Credit and Debit headings shouldn't include the word "amount".
  • No day of the week in the date column, as in "20/11/2025 THU".
  • At most 1,000 lines and 350 KB per upload, and the file has to be in English.

Why a bank's CSV usually doesn't fit

Banks design their exports for people reading them in a spreadsheet, not for QuickBooks. A typical export has a running balance column, a transaction type, a check number, and sometimes a few lines of account details above the headings. Any extra column means the file is no longer three or four columns wide.

Amounts cause the rest of the trouble. Some banks put money out in its own column as a positive number, some add currency symbols, some write negatives in parentheses, and credit card exports often show purchases as positive. QuickBooks notes that card CSVs can have amounts the other way round, and that's the one to watch: the import can succeed with every sign reversed.

Fixing the file in Excel

If you'd rather do it by hand, open the CSV in Excel and work through it in this order.

  1. Delete any rows above the column headings, and any totals or "balance carried forward" rows at the bottom.
  2. Delete every column except the date, the description and the amount (or the two money in and money out columns). The balance column has to go.
  3. Rename the headings to exactly Date, Description and Amount, or Date, Description, Credit and Debit.
  4. Make the amounts plain numbers. Remove currency symbols, and turn (45.00) into -45.00. In the three-column layout, money out must be negative.
  5. Clear the zeros. Use Find and Replace, find 0, leave Replace with empty, and tick Match entire cell contents so a 10 or a 100 is left alone.
  6. Format the Date column as a single date format, and use the same one when QuickBooks asks during the upload.
  7. Save as CSV. On a Mac, QuickBooks asks for the file to be saved as a Windows CSV (Excel calls it "Windows Comma Separated").

If the file has more than 1,000 transactions, split it into several files and upload them one after another.

Or let the free tool do it

The bank CSV to QuickBooks converter does all of the above in one step. Drop in the bank's CSV and it finds the table (even with account details above it), works out which column is the date, the description and the amount, and shows you a preview so you can correct anything, including flipping the signs on a credit card export. The file it writes has only the columns QuickBooks wants, one date format, no zeros, and Windows line endings. Files over 1,000 transactions or 350 KB come out as several parts.

It runs in your browser, so the CSV is never uploaded, and it's free with no account. It can also write Xero's CSV layout or an OFX file, which there's a separate page for.

Uploading it to QuickBooks

  1. Open Bank transactions. Depending on your QuickBooks menu, it's under Transactions or under Accounting.
  2. Open the Link account menu and choose Upload from file.
  3. Choose the CSV and the account the transactions belong to.
  4. Match the columns when asked, and pick the same date format the file uses. For a three-column file, choose the single amount column option.
  5. Review the transactions QuickBooks lists and finish the import. They appear under For review, ready to categorise.

If you only have PDF statements

Many banks only offer CSV downloads for recent months, and older history comes as PDF statements. The statement converter reads a PDF statement in your browser, checks that the transactions add up to the statement's closing balance, and exports a CSV or OFX file for QuickBooks. There's more on that in the guide to converting PDF statements.

More from the blog