How to Convert a Wells Fargo PDF Statement to CSV or Excel
The download box is pre-filled with ninety days. Almost nobody changes it, and almost nobody realizes they can.
Ninety days is a default, not a limit
Wells Fargo Online has a Download Account Activity option on the account activity screen, and it works well. It offers CSV among other formats, and for keeping a bookkeeping system topped up month to month it is entirely sufficient.
The friction is subtler than an outright restriction. The date selector arrives pre-filled with the last ninety days. It is a sensible default and most people take it, download the file, and form a lasting impression that ninety days is all Wells Fargo will give them. It is not. The range can be widened, and depending on the account type it commonly extends to somewhere around eighteen months.
So the first thing worth doing, before assuming you need to convert anything, is going back and changing the range. If it covers the period you need, you are done and you do not need this page.
Wells Fargo states it directly: "By default, the download will capture the last 90 days of transactions. However, for certain types of accounts up to 18 months of account activity may be available by choosing the time frame you want."
The unhelpful part: Wells Fargo never says which accounts get the eighteen months. The reliable test is the selector itself. If the start date you want will not be accepted, that period has aged out of the structured download and the PDF statement is what remains.
Two other limits worth knowing, because they are easy to mistake for the download limit. Viewing transactions on screen runs to about 18 months on checking and savings, but credit cards are held to roughly 90 days or 300 transactions, whichever comes first. And on personal accounts the download offers exactly two formats, a comma-delimited spreadsheet file and Quicken Web Connect. QuickBooks Web Connect is a business-account option, not a personal one.
How long the statements last
Statement retention is published per product, and the spread is wide enough to plan around:
| Account type | Statements kept online |
|---|---|
| Deposit accounts, home mortgage, trust and managed investment | Up to 7 years |
| Credit cards, home equity lines, personal loans and lines | Up to 2 years |
| Auto loans | Up to 12 months |
| Closed accounts, any type | About 90 days after closure |
That last row is the one that catches people. Close a Wells Fargo account and you have roughly three months to retrieve anything before it goes. If you are closing a business account, pull every statement first — the IRS keeps an interest in those records for three years as standard, six where income is understated by more than 25%, and seven for a bad-debt claim.
Quick answer: widen the date range in Download Account Activity first. If the period you need falls outside what the selector allows, download the PDF statements instead and convert them. Statement archives run far longer than the activity download.
When converting is the right call
Three situations account for most of it, and none of them are unusual.
Rebuilding a closed year. Extended returns, late filings and catch-up bookkeeping all concern a period that has, by definition, been sitting untouched for a while. By the time anyone gets to it, the download window has usually moved past it.
Someone else is asking. Underwriters, the IRS, a due diligence request or a divorce attorney will ask for two or three years, and will want the statements as issued rather than a spreadsheet you exported. You end up holding the PDFs anyway; converting them costs nothing extra and saves re-keying.
Volume. A structured download of a busy account across a long range is where row caps and timeouts appear. Statement-by-statement conversion sidesteps that, because each statement is a bounded document that either reconciles or does not.
Converting the statements (4 steps)
- Try the activity download first
Open the account, choose Download Account Activity, and widen the date range beyond the default ninety days. If it covers your period, take the CSV and stop here. - Otherwise, get the PDF statements
Open the statements and documents area, select the account, and download one PDF per statement period. - Upload them together
Go to reconcileiq.com/bank-statement-converter and drag the whole set into the PDF to CSV converter. They come back as one continuous set of transactions rather than one file per statement. - Reconcile, then download
Every statement carries a beginning and ending balance. If the extracted rows carry you from one to the other, nothing was missed. Then export the CSV.
What comes out
- Date — normalized from Wells Fargo's MM/DD convention into a consistently sortable format
- Description — merchant and reference, with wrapped descriptions rejoined into one row
- Amount — correctly signed, deposits positive and withdrawals negative, whether the statement used one column or two
- Balance — the daily running balance kept separate so it is never summed as a transaction
Wells Fargo splits activity into separate sections — deposits and interest, checks, other withdrawals — each with its own positive Amount column rather than one signed column across the whole statement. Getting the sign right therefore depends on reading which section a row sits in, not just the number. There is also a daily balance summary table towards the end that is structurally identical to transaction data and is the usual cause of inflated totals in a careless extraction. It is discarded, along with page furniture and repeated headers.
The year that is not on the row
Wells Fargo prints transaction dates on the detail rows as bare MM/DD. The year appears once, in the statement header.
Extract the rows without reading the header and every transaction gets stamped with whatever year the software assumed. For eleven statements a year that assumption is right and nothing goes wrong. On the December-to-January statement it is wrong, and that is exactly the statement straddling your fiscal year end. Transactions land in the wrong tax year, the year-end reconciliation is out by precisely those rows, and nothing in the CSV looks suspicious because every date is perfectly well formed.
The converter reads the year from the statement header and rolls it over correctly at the boundary. If you are checking a converted file from any tool, the December and January rows are the first place to look.
One more Wells Fargo quirk in the same spirit: the checks section marks missing check numbers with a gap indicator. That is genuine information — a gap in the sequence usually means a check that has not cleared, or one written outside the period — and it belongs in your reconciliation notes rather than being silently dropped.
Convert Your Wells Fargo Statement
Upload the PDF, verify the balances on screen, download clean CSV. Your first statement of up to 10 pages converts free on a new account.
Convert your PDF now for freeFrequently Asked Questions
Yes, from the account activity screen using Download Account Activity. The date selector defaults to the last 90 days. Depending on account type it can be extended, commonly to somewhere around 18 months, though the exact ceiling varies by product. Older periods are available only as PDF statements.
Because 90 days is the default in the date selector, not the maximum. Most people accept the pre-filled range without noticing it can be widened. Change the range before downloading. If the dates you want will not be accepted, that period has aged past the download and the PDF statement is the remaining source.
Statements are issued as PDF, so there is no direct Excel export for a statement. Download the PDFs for the months you need and convert them. The CSV opens directly in Excel and imports into QuickBooks and Xero.
Yes. Business checking, personal checking and savings, and Wells Fargo credit card statements all convert. Business accounts are the common case, because a business rebuilding a period almost always needs more history than the activity download reaches.
Your first statement of up to 10 pages converts free on a new account. Beyond that it runs on credits, with the cost shown before anything is processed. Files are uploaded and processed on our servers rather than in your browser, which is what allows scanned and photographed statements to work as well as native PDFs.