Wells Fargo statement to Excel
Wells Fargo statements print a balance only once a day, on the last transaction of each date, in an "Ending daily balance" column. This converter checks your statement day by day: all of a day's deposits and withdrawals must lead to that day's printed balance.
Convert your Wells Fargo statement
Private by design: your PDF is read by your own browser. It is never uploaded, and nothing is stored on a server. The password, if you type one, is used once to open the file and then forgotten.
Text-based PDF, up to 25 MB and 300 pages. On a computer you can also drop the file here.
Reading…
Always compare the converted file with your original statement before using it for tax filing, loans or audits. The converted file is not an official bank document.
How to download your Wells Fargo statement
Wells Fargo's online statements FAQ explains where statements are and how long they are kept.
- Sign on to Wells Fargo Online from the official site.
- Go to Statements & Documents and choose the account and statement.
- When you select a statement, your device or browser may download it. If you are asked for a name, give it a .pdf ending.
- Wells Fargo says it keeps statement copies for up to seven years for most checking accounts.
Convert the downloaded PDF as it is; there is no need to print it first.
How we read a Wells Fargo statement
The transaction history in a typical Wells Fargo statement has these columns:
| Column in the PDF | Column in your spreadsheet |
|---|---|
| Date (M/D) | Date |
| Check Number | Reference |
| Description | Description |
| Deposits/Additions | Credit |
| Withdrawals/Subtractions | Debit |
| Ending daily balance | Balance (last row of each day) |
- Dates have no year; it comes from the statement period on page 1.
- Only the last row of each day has a balance. Earlier rows that day are marked "Checked via daily balance" when the day adds up.
- Check numbers stay in the Reference column and are never read as amounts.
- A "Totals" line under the history is compared with the sum of your deposits and withdrawals.
Common problems
Most Balance cells are empty
That's how the PDF is printed: one balance per day. Fill it in Excel if you need a balance on every row.
A whole day is marked as not matching
When a day's total is off, all rows of that day are flagged, because any of them could be the cause. Compare that day's lines with your PDF.
The year is wrong for January rows
The statement period line on page 1 sets the year. Make sure the PDF includes the first page.
Check images are missing
Images of checks are not part of the conversion; only the transaction lines are exported.
FAQ
How is a statement checked if not every row has a balance?
By day: the previous day's balance plus that day's deposits minus withdrawals must equal the printed ending daily balance.
Can I use it for Wells Fargo business accounts?
If the PDF has the same columns, yes. Other layouts may need the Generic option.
Does Wells Fargo endorse StatementKit?
No. StatementKit is not affiliated with any bank.
StatementKit is not affiliated with or endorsed by Wells Fargo. Bank names are used only to describe compatibility.
Other banks
Main statement converter (any bank)