Wells Fargo CSV to QBO

Wells Fargo’s comma delimited export has no header row at all, which is why so many importers choke on it; the converter below recognises it by column shape and writes a QuickBooks .qbo file locally.

Drop a CSV or Excel statement here

.csv, .txt, .xlsx and .xls — or choose a file

Your file never leaves your browser.

The Wells Fargo Checking preset is selected for you. Exported a different Wells Fargo account? Switch the Format dropdown to Wells Fargo (Comma Delimited, no header row) once your file is loaded.

How to export a CSV from Wells Fargo

  1. Sign in at wellsfargo.com and open the account. Above the transaction list there is a Download Account Activity link.
    Screenshot: wells-fargo-export-1
    The account activity page with the download link above the transaction table.
  2. Choose the date range. Wells Fargo lets you download by statement period or by custom range; the custom range is the one to use when you are catching up several months.
  3. Under file format, pick "Comma Delimited" — this is the CSV. "Quicken" and "QuickBooks" options exist on some accounts but are tied to a desktop product and a current connection.
    Screenshot: wells-fargo-export-2
    The file format list, with Comma Delimited selected.
  4. Download the file. Open it once in a text editor if you are curious: there is no header row, just data from line one.
  5. Drop it into the converter on this page. The headerless layout is detected from the column shape, so you do not have to add a header row yourself.
  6. Check the preview — especially the first row, which importers often eat — then download the .qbo.

Online banking screens change; if a label has moved, look for a download or export control above the transaction list.

Known quirks of the Wells Fargo export

Wells Fargo Checking

  • This preset covers the case where a header row exists: a file you exported from a spreadsheet, or one you labelled yourself with Date, Amount and Description. The raw bank download is handled by the headerless preset below.
  • The header-row preset only claims a file that has exactly three columns, so a wider spreadsheet is read by generic column detection instead of being forced into the Wells Fargo layout.
  • The file is written with the generic Intuit bank id 3000 for Wells Fargo. It has not been verified against a live QuickBooks Online import; if the upload is refused, try a different id in the account settings.

Wells Fargo (Comma Delimited, no header row)

  • The comma delimited download has no header row and a fixed column order: date, amount, a status marker that is usually an asterisk, an empty column, then the description. The converter names those columns by position so the rest of the pipeline can work normally.
  • Because the column names are inferred rather than read, the headerless layout is only applied when the file has exactly five columns and the first one parses as a date. Anything else falls back to the manual column mapper — which is the safe outcome, not a failure.
  • The headerless preset also uses Intuit bank id 03000, the Wells Fargo Bank Web Connect entry in Intuit's financial institution directory.

Import the .qbo file into QuickBooks

  1. Open the upload screen. In QuickBooks Online, go to Transactions, then Bank transactions, and choose Upload from file (on older layouts: Banking, then the arrow next to Update, then File upload).
  2. Pick the .qbo file. Drag the .qbo file the converter produced into the drop area and select Continue.
  3. Choose the QuickBooks account. Select the bank or credit card account the transactions belong to, or add it first. The account type has to match the one used when converting: a card statement belongs to a credit card account.
  4. Let QuickBooks read the file. Web Connect files carry their own column layout, so there is no column-mapping screen — QuickBooks reads the dates, amounts, payees and memos straight from the file.
  5. Review and accept. The transactions land in the For review tab. Categorise or match them there; nothing hits the books until you accept them.

QuickBooks Online accepts up to 1,000 transactions per upload. Larger statements are split automatically into numbered files by the converter. Import errors are covered in the import error guide.

A download with no header row

Almost every importer in existence assumes line one of a CSV names the columns. The Wells Fargo comma delimited export does not: it starts with data, in a fixed order that has been stable for years — date, amount, a status marker, an empty field, then the description. Feed that to a tool expecting a header and it will either import one transaction fewer than you have, or use your first purchase as a set of column names.

The converter checks the shape instead. Five columns, first field parses as a date, no header: that is the Wells Fargo layout, and the columns are named by position so everything downstream behaves as though the file had been labelled properly. When the shape does not match, nothing is guessed — the column mapper opens and you pick.

Watch the empty column

The fourth field is blank in every row of a normal download. That is expected. If your file has content there, it is probably not the comma delimited export — some Wells Fargo account types offer a wider CSV — and the mapper is the right tool: map date, description and amount by hand once and convert.

Amount conventions

Withdrawals are negative and deposits positive in the raw download, which matches what QuickBooks expects for a checking register, so no sign flipping happens by default. On a credit card export, set the account type to credit card before downloading the .qbo: that changes the structure of the file, not just a label.

Frequently asked questions

Why does my Wells Fargo download open as one long column of numbers?
Because there is no header row, spreadsheet software sometimes guesses the delimiter wrongly. Nothing is broken; the converter reads the raw text itself and does not care what Excel made of it.
Should I add a header row before converting?
You do not need to. The five-column comma delimited layout is recognised as it is. If you have already added a header row with Date, Amount and Description, that works too.
What is the asterisk column?
It is a status marker Wells Fargo includes in the download. It is not imported — it carries no information QuickBooks can use.
Can I use the Quicken download instead?
A .qfx download is a Quicken Web Connect file, and QuickBooks Online will not accept it directly. Converting the CSV is usually faster than working around the format mismatch.
Does the file leave my computer?
No. Parsing and conversion happen in this browser tab, so account numbers and payee names are never transmitted.

Related banks

Other formats: QFX to QBO · Bank statement to QBO

Last updated .