How to export statements from Wells Fargo (PDF and CSV)

Wells Fargo is unusually precise about what it keeps and for how long — and unusually verbose on the statement lines themselves. The split is the standard American one: official statements are PDFs in one place, and a separate Download Account Activity feature produces the spreadsheet files, with history caps that vary a lot by product.

The official PDF statement

1. Sign on to Wells Fargo Online.
2. Open Statements and Documents for the account you need.
3. Select a statement — you can only open one at a time.
4. Save it with a .pdf extension. Wells Fargo notes you may need a computer rather than the app to print.

The activity download (CSV and Quicken)

Download Account Activity offers Comma Delimited files — effectively CSV, and what Excel wants — plus Quicken Web Connect. Business Online adds QuickBooks Web Connect. There's no native OFX-labelled or .xlsx option in the personal flow; the comma-delimited file is the spreadsheet path, and its history reach is capped per product, far shorter than the statement archive. Older months exist only as PDFs.

Reading Wells Fargo's statement lines

Wells Fargo writes some of the longest descriptors of any major bank, and three habits cause most of the confusion:

• Two dates per line. Debit card purchases read PURCHASE AUTHORIZED ON MM/DD followed by the merchant, location, a long authorization reference and the card's last digits. That embedded date is the authorization date and frequently differs from the posting date in the date column — the classic reason a reconciliation refuses to line up.
• Recurring charges get their own prefix. RECURRING PAYMENT AUTHORIZED ON — so the same merchant appears under two different descriptor patterns depending on how it charged you. Anything watching for repeat charges needs to know both forms. (Our subscription-hunting guide leans on exactly this.)
• Reference codes live mid-line. S- and P-prefixed strings are embedded inside the description rather than in their own column, which is why naive column-splitting scatters them.

Getting a clean spreadsheet

Inside the activity window, download the comma-delimited file — it's exact. Beyond it, the PDF statement is the only native source, and that's where the Wells Fargo statement converter earns its keep: it reads the PDF's own text, splits the authorization dates and reference codes out of those long descriptors, reconciles every line against the statement's printed balances, and outputs CSV, Excel, QIF or OFX with merchants named.