Skip to the converter
StatementZap

Guides

How to convert a Wells Fargo CSV to QBO

Read a Wells Fargo activity CSV and download a QuickBooks Web Connect file.

  1. 1

    Download the activity CSV

    In Wells Fargo, export the account activity as CSV. The file is three columns, in this order: Date, Amount, Description. A file with those columns in another order is not this export.

  2. 2

    Upload it

    On the CSV to QBO page, drop the file. The header matches the Wells Fargo preset, so the date, amount, and description are already mapped. Withdrawals are negative and deposits are positive.

  3. 3

    Check a withdrawal

    A purchase or a payment out of the account should be money out. If the signs are reversed, flip them before you download.

  4. 4

    Download QBO

    QuickBooks Desktop imports the QBO file with File, Utilities, Import, Web Connect Files. QuickBooks Online does not import QBO. Download the 3-column CSV for Online instead.

Questions

Does this include Wells Fargo credit cards?

Use it for the three-column activity file. A card export with different headers is mapped from those headers, or with the bank preset that matches them.