Wells Fargo CSV to QBO Converter
Turn a Wells Fargo "Comma Delimited" account activity download into a QBO file for QuickBooks. The converter recognizes the Wells Fargo layout, which has no header row.
Drop your bank file here or choose a file
CSV, Excel, QBO, QFX, OFX or QIF · stays on your device
No signup. Your file never leaves your computer. Works in your browser.
How to convert a Wells Fargo CSV to QBO
- Download the account activity In Wells Fargo Online, use Download Account Activity and choose Comma Delimited (ASCII, Spreadsheet), as Wells Fargo's help describes.
- Drop the file into the converter The file has no column names, so the converter recognizes it by its five columns and shows "Wells Fargo" next to the file.
- Check the transactions Amounts are already signed (money out negative) in checking files. Check numbers are kept.
- Choose QBO and the account type Wells Fargo's own bank ID is the widely compatible option, so you can keep it. Pick checking, savings or credit card.
- Download the QBO file Click Download QBO file and import it into QuickBooks. The steps appear right after the download.
How to import the QBO file into QuickBooks
These steps follow Intuit's current help pages. Back up your company file first; Intuit notes that an import can't be undone.
QuickBooks Desktop for Windows
- Sign in to your Intuit account Intuit requires you to be signed in inside QuickBooks Desktop to import .qbo files.
- Open the import Choose Banking › Bank Feeds › Import Web Connect Files, select the .qbo file and click Open.
- Choose the account Choose Use an existing account if the account is already in QuickBooks, or Create a new QuickBooks account. Click Continue, then OK.
- Add the transactions Review them in the Bank Feeds Center and add them.
If the import fails, Intuit's fixes include switching to Classic Mode: Banking › Bank Feeds › Change Bank Feeds Mode.
QuickBooks Desktop for Mac
- Open the import Choose Banking › Downloaded Transactions › Import File.
- Pick the file Select the .qbo file.
- Choose the account If QuickBooks asks, pick the matching account under Store in the QuickBooks Account, then click Continue and OK.
QuickBooks Online
- Open Bank transactions Choose All apps › Accounting › Bank transactions. Older menus start at Banking or Transactions.
- Choose Upload from file Select the account's tile if you see one, open Link account and choose Upload from file.
- Pick the file and the account Select the .qbo file and click Continue. Choose the account in the QuickBooks account list and click Continue.
- Import Select the transactions to import, click Continue, then Yes and Done.
Intuit's limits for one upload: 350 KB per file and up to 1,000 lines.
Downloading account activity from Wells Fargo
Wells Fargo’s help page “How can I download my account history?” gives these steps:
- Sign on to Wells Fargo Online and choose the account.
- Under the Accounts tab, open Download Account Activity and fill in the form.
- Confirm the From and To dates. The default is the last 90 days; some account types allow up to 18 months.
- Select Comma Delimited (ASCII, Spreadsheet).
- Click Download and save the file. Use a different file name for each account.
The Wells Fargo CSV layout
The file has no header row. Each line has five quoted fields:
| Position | What it holds |
|---|---|
| 1 | Date, MM/DD/YYYY |
| 2 | Amount, signed (money out negative in checking files) |
| 3 | A status mark, * |
| 4 | Check number, usually empty |
| 5 | Description |
Because there are no column names, the converter checks the shape of the rows (a date first, an amount second and the status mark third) before it treats a file as a Wells Fargo download. Any other five-column file is read by its contents instead, and you can check the columns.
The bank ID
QuickBooks and Quicken check the bank ID in every QBO and QFX file. Wells Fargo’s ID, 03000, is in Intuit’s QuickBooks and Quicken lists for bank and card accounts, and it is the converter’s widely compatible option, so the file you download is labelled as Wells Fargo either way.
Supported banks and file layouts
Any bank's CSV or Excel file
The converter finds the header row (even below bank names and account summaries), matches columns by name and by content, and handles one signed amount column, separate debit and credit columns, or an amount with a DR/CR column. Dates like 01/05/2026, 2026-01-05 and Jan 5, 2026 and amounts like (1,234.56) or 1234.56- are all read.
Known layouts, picked automatically
- American Express card · Date, Description, Card Member, Account #, Amount, … 8 more
- Apple Card · Transaction Date, Clearing Date, Description, Merchant, Category, … 3 more
- Bank of America checking or savings · Date, Description, Amount, Running Bal.
- Bank of America credit card · Posted Date, Reference Number, Payee, Address, Amount
- Barclays credit card · Transaction Date, Description, Category, Amount
- Capital One 360 checking or savings · Account Number, Transaction Description, Transaction Date, Transaction Type, Transaction Amount, Balance
- Capital One credit card · Transaction Date, Posted Date, Card No., Description, Category, … 2 more
- Charles Schwab Bank checking · Date, Status, Type, CheckNumber, Description, … 3 more
- Charles Schwab Bank checking (older layout) · Date, Type, Check #, Description, Withdrawal (-), … 2 more
- Chase checking · Details, Posting Date, Description, Amount, Type, … 2 more
- Chase credit card · Transaction Date, Post Date, Description, Category, Type, … 2 more
- Citi credit card · Status, Date, Description, Debit, Credit
- Discover card · Trans. Date, Post Date, Description, Amount, Category
- Mercury transactions · Date (UTC), Description, Amount, Status, Source Account, … 9 more
- PayPal activity · Date, Time, TimeZone, Name, Type, … 11 more
- PNC checking or savings · Transaction Date, Transaction Description, Amount, Balance
- SoFi checking or savings · Date, Description, Type, Amount, Current balance, Status
- Square transactions · Date, Time, Time Zone, Gross Sales, Discounts, … 44 more
- Stripe balance report · balance_transaction_id, created_utc, available_on_utc, currency, gross, … 4 more
- USAA checking or savings · Date, Description, Original Description, Category, Amount, Status
- Venmo statement · ID, Datetime, Type, Status, Note, … 16 more
- Wells Fargo · 5 columns, no header row
Each layout was checked against the bank's own help pages or real sample files. If your bank changes its layout, the converter still reads the file by its column names.
Common problems and fixes
- The file shows "Column 1", "Column 2" and so on
- Wells Fargo's file has no header row. When the five columns match the Wells Fargo layout the converter names them for you; if they don't (for example after editing in Excel), choose the date, amount and description columns under Change columns.
- Card amounts have the wrong sign
- Wells Fargo card files have the same five columns, but which sign purchases carry isn't documented. Look at a purchase in the table; if it shows as a positive number, turn on Flip signs so a $50 purchase shows as −50.00.
- I need more than 90 days
- Wells Fargo's help says the download covers the last 90 days by default and up to 18 months for some account types. Change the From and To dates on the download form.
- Two accounts ended up in one file
- Download each account separately and give each file its own name, as Wells Fargo's help suggests.
Wells Fargo CSV vs QBO
| Wells Fargo CSV | QBO file | |
|---|---|---|
| Column names | None | Tagged fields (date, amount, name, ID) |
| Opens in Excel | Yes | No |
| Imported by QuickBooks Web Connect | No | Yes |
| Duplicate protection | None | A unique ID for every transaction |
Frequently asked questions
How do I convert a Wells Fargo CSV to QBO?
Download the account activity as Comma Delimited, drop the file into the converter above, check the transactions, keep QBO and download.
Why does the Wells Fargo CSV have no headings?
That is how Wells Fargo writes it, five quoted columns per line - date, amount, a status mark, check number and description - with no header row.
Which bank ID does the QBO file use?
Wells Fargo (03000) is in Intuit's bank lists for both QuickBooks and Quicken, and it is the converter's widely compatible option, so a Wells Fargo file keeps its own bank.
Are check numbers kept?
Yes. The fourth column holds the check number when there is one, and it goes into the QBO file's check number field.
Is my Wells Fargo file uploaded?
No. It is read and converted in your browser and never leaves your computer.
Related tools
Last updated · EmproIT