QuickBooks Online CSV import not working? Check the file first

If QuickBooks Online refuses a bank transactions CSV or reads it incorrectly, check these file-format details. This page goes through the format rules in Intuit's own instructions for bank CSV uploads, a few further checks of our own, and what to change in the file.

It is help with the file format only. It is not accounting or tax advice, and it cannot tell you whether the transactions belong in your books.

Not yet tested in QuickBooks. These rules come from Intuit's published instructions (Format CSV files in Excel to get bank transactions into QuickBooks, last updated August 2026). Nobody on our team has run a QuickBooks Online import yet. Try one small month first and check it before importing more.

PaperRows is independent and is not connected with Intuit or QuickBooks. We name QuickBooks only so you know which format this page is about.

The rules a bank CSV has to meet

Intuit's instructions list these. Check your file against each one.

  1. One of two layouts. Intuit describes a three-column layout, Date, Description, Amount, and a four-column layout, Date, Description, Credit, Debit.
  2. One date format all the way down. Intuit recommends dd/mm/yyyy and keeping the date format consistent.
  3. No day of the week in the date. Some banks write dates like 20/11/2018 TUE. Remove the day so the cell holds only the date.
  4. In a four-column file, blank cells instead of zeros. Leave an amount cell you are not using blank rather than filling it with 0.
  5. Headers that say Credit and Debit, not Credit amount or Debit amount. Intuit says to remove the word "amount" from those two headers.
  6. Descriptions that read as text. Intuit says to correct transactions that show numbers in the Description column. If a description shows only a long number, or something like 1.23E+15, compare it with the original download.
  7. On a Mac, save as a Windows CSV. Intuit says Mac users must save the file in the Windows CSV format.

Our own suggestions, not from Intuit's list

These are not in Intuit's instructions and have not been tested in QuickBooks yet.

  • Remove extra columns. Bank downloads often add a balance, a reference, a category or a check number column. Deleting them so the file matches one of the two layouts above keeps it in the shape Intuit describes.
  • Check the date format at the mapping step. QuickBooks asks how the dates in your file are written. Pick the option that matches your file. The step-by-step QuickBooks Online import guide shows where this happens.
  • A comma inside a description has to sit inside double quotes, like "HARDWARE STORE, SPRINGFIELD". This is a general CSV rule. Without the quotes, the comma starts a new column and every column after it shifts by one.
  • One header row at the top, then only transactions. Account names, statement periods, totals and blank lines above or below the transactions are not transactions. Delete them.

Possible file-format causes to check

What you see Likely cause in the file What to change
QuickBooks will not take the file at all Extra columns, extra lines above the header, or the file is not really a CSV (for example an .xlsx renamed to .csv) Keep only the three or four columns, start the file at the header row, and save it again as CSV
Days and months swapped, or dates in the wrong year The date format picked at the mapping step does not match the file, or the file mixes formats Make every date the same format and pick that format when mapping
Every amount is money in, or every one is money out A one-column file was mapped as two columns, or the other way round Map it again: one column for a signed Amount, two columns for Credit and Debit
Amounts land in the wrong column, or descriptions are cut in half A comma inside a description that is not in double quotes Put double quotes round any description with a comma in it
Deposits on a credit card show as negative Card statements show amounts from the card's side, so a payment lowers the balance Upload the file into the credit card account, not a bank account, as Intuit's instructions say

Before you change anything

  • Keep the original file. Edit a copy, so you can start again if a save goes wrong.
  • Re-saving in a spreadsheet can cause new problems. Some spreadsheets change dates or long numbers when they save a CSV. After saving, open the file in a plain text editor and check a few dates and amounts.
  • Already have a bank feed on this account? Uploading dates the feed already brought in can create duplicates. Upload only the months the feed does not have.

If all you have is a PDF statement

The CSV upload needs a CSV. If your bank only gives you older months as PDF statements, you need to turn the PDF into rows first. PaperRows does that in your browser for the US banks and layouts on the banks page. The statement is read on your device and never uploaded.

Its QuickBooks CSV is written to meet the rules above: three columns (Date, Description, Amount), MM/DD/YYYY dates with the year filled in, one signed amount with money out negative, no dollar signs or thousands separators, descriptions with commas in double quotes, and nothing above or below the transactions. The QuickBooks CSV format page has a made-up sample statement and the exact file PaperRows makes from it. The free preview checks the rows against the statement's own totals before you pay anything.