# Wells Fargo Statement to Excel: Download and Convert

- Author: FastBankConvert (https://www.fastbankconvert.com)
- Published: 2026-10-08
- Updated: 2026-10-08
- Category: Bank statements to Excel and CSV
- Canonical: https://www.fastbankconvert.com/blog/wells-fargo-statement-to-excel

> Turn a Wells Fargo statement to Excel: find the PDF statement online, read its deposits and withdrawals columns, and check the daily balance.
A Wells Fargo statement goes to Excel in three moves: save the monthly PDF from Statements & documents in Wells Fargo Online, convert its deposits and withdrawals columns into one signed amount per row, then test your running total against each ending daily balance the statement prints. When every printed balance agrees, no line is missing.

## Finding Wells Fargo statements in Statements & documents

Wells Fargo keeps its statement PDFs in a section of Wells Fargo Online called Statements & documents, as the bank's own [Wells Fargo online statements page](https://www.wellsfargo.com/online-banking/statements/) puts it. Sign on, open that section, choose the account and the statement month, and save the PDF to your computer or phone.

### Save the PDF, not a printout

When the statement opens in your browser, use the download button in the PDF viewer rather than the print button. A download keeps the file the bank produced. A printed copy, even one printed to PDF, passes through your browser's page settings, which can shrink the page or cut a column at the margin. Neither problem is common, but there is no reason to risk it.

### One account per file

If you bank with Wells Fargo for both checking and savings, each account has its own statements. Pick the account first, save its month, then move to the next account. Keeping accounts in separate files matters later, because each account has its own beginning and ending balance, and a balance check only works on one account at a time.

### Check the file opens as text

Before converting, open the saved PDF and try to select a single word in a transaction line. If you can highlight just that word, the PDF holds real text and will convert accurately. If the whole page lights up as one block, the file is an image, perhaps because it was scanned somewhere along the way, and the digits will need to be recognised from pixels.

## How far back do Wells Fargo statements go online?

For a checking or savings account, up to seven years. Wells Fargo's statements page lists seven years for deposit accounts, home mortgage accounts, and trust and managed investment accounts. Shorter windows apply elsewhere: two years for credit cards, home equity lines and personal loans or lines of credit, and twelve months for auto loans.

### What the windows mean in practice

The seven-year window covers most reasons someone wants an old checking statement in a spreadsheet: a tax question, a loan application, a dispute over a payment. The two-year window for cards is the one that catches people out. If you need card statements older than that, download what you can now, and plan to ask the bank for the rest.

### Save while you can

The window moves every month. A statement that is inside the window today drops out of it later. If you are building a multi-year spreadsheet, download every month you need in one sitting and keep the PDFs alongside the workbook. The PDFs are the evidence; the spreadsheet is your working copy.

## Wells Fargo deposits and withdrawals columns on one line

If your Wells Fargo checking statement prints its transaction history as one list with separate columns for deposits or credits and for withdrawals or debits, each line has its amount in exactly one of those two columns. Combine them into a single signed amount: the deposit as a positive number, the withdrawal as a negative one.

### Why one signed column helps

Two amount columns copy into Excel faithfully, and you could keep them. But most of what you will do next is easier with one column. A SUM gives the net change for the month. A filter for negative values lists every payment. A pivot table by description totals spending by payee in one step. And the running balance formula needs only one cell per row.

### The helper formula

With deposits in column C and withdrawals in column D, put this in the first data row of a new column F:

`=N(C2)-N(D2)`

The N function turns an empty cell into zero, so the formula works whether the line was a deposit or a withdrawal. Fill it down. Then check one thing: the withdrawals column should hold positive numbers on the PDF, so the result for a withdrawal comes out negative. If the converter or a copy and paste already put minus signs in the withdrawals column, the formula would flip them positive, so look at a few rows before you trust the totals.

### Text that looks like a number

Amounts copied from a PDF sometimes arrive as text, with a stray space or a thousands comma Excel did not expect. Text amounts align to the left of the cell and are skipped by SUM without any warning. Select the column and look at the status bar: if Excel shows a count but no sum, the values are text. Converting them back to numbers before the balance check saves a confusing mismatch later.

## Is a blank Wells Fargo balance cell a missing value?

Usually not. A statement that prints an ending daily balance shows it once per day, on the last line of that day. Every earlier line on the same date has an empty balance cell. That blank is by design, so your conversion should keep it blank, not fill it with zero or copy the balance down.

### Why it matters for the check

If a blank is turned into zero, your check will report a huge gap on that row. If the converter instead copies the day's closing balance onto every line of the day, the check will fail on all but the last of them, because the running total part-way through the day is different. Either way you get false alarms that hide the one real problem, if there is one.

### Telling a real gap from a by-design blank

A by-design blank sits on a line followed by another line with the same date. A real missing balance sits on the last line of a date, where the PDF shows a figure. When you are unsure, look at the PDF for that day. One glance tells you whether the bank printed a number there.

## Checking each Wells Fargo ending daily balance in Excel

Build a running total next to the signed amounts, then compare it with the printed balance only on the rows where one is printed. Every comparison should come out at zero. The first row that does not tells you the day the problem started, and the size of the gap is the amount to look for.

### A worked example

The lines below are made-up examples. The beginning balance, 1,200.00, sits in cell J1. Column E holds the ending daily balance exactly as printed, blank where the PDF is blank.

| A: Date | B: Description | C: Deposits | D: Withdrawals | E: Ending daily balance |
| --- | --- | --- | --- | --- |
| 2026-09-03 | Example payroll deposit | 900.00 | | |
| 2026-09-03 | Card purchase, example pharmacy | | 45.20 | 2,054.80 |
| 2026-09-09 | Example rent payment | | 310.00 | |
| 2026-09-09 | Example streaming service | | 12.99 | |
| 2026-09-09 | Example refund | 60.00 | | 1,791.81 |
| 2026-09-15 | Transfer to example savings | | 500.00 | 1,291.81 |

Add three helper columns:

1. **F, amount:** `=N(C2)-N(D2)`, filled down.
2. **G, running balance:** in G2, `=$J$1+F2`; in G3 and below, `=G2+F3`.
3. **H, check:** `=IF(E2="","",ROUND(G2-E2,2))`, filled down.

Column G reads 2,100.00, 2,054.80, 1,744.80, 1,731.81, 1,791.81 and 1,291.81. Column H is empty on the three lines with no printed balance and shows 0 on the other three. The last running figure, 1,291.81, should also equal the ending balance in the statement summary.

The running balance step follows the same pattern as Microsoft's guide to [calculating a running balance in Excel](https://support.microsoft.com/en-US/excel/calculate-a-running-balance), which adds each row's deposit and subtracts its withdrawal from the balance above.

### When the check shows a number

Suppose H6, the 09/09 row, showed 12.99. Your running total is higher than the bank's by exactly the streaming charge, so that line was dropped. A gap equal to a line on a page boundary is the usual pattern. A gap that matches no single line may be two lines, or a sign error, where a withdrawal was counted as a deposit and the gap is twice its amount.

FastBankConvert is built to tell you before you download if a statement's balances do not add up. It is getting ready to open, and the [FastBankConvert home page](/) explains what it will do. For a fuller picture of what any statement converter does with a PDF, see [how a bank statement converter reads your file](/blog/bank-statement-converter).

## Wells Fargo accounts that need a different sheet

Checking and savings statements fit the method above. Card, auto loan and mortgage statements do not. A credit card statement lists charges and payments with no daily balance, and a loan statement tracks principal, interest and escrow rather than money in and out. Give each its own sheet with its own columns.

### Credit cards

On a card statement, purchases raise the balance and payments lower it, the reverse of a checking account. If you merge card rows into a checking sheet, the signs fight each other. Keep a separate sheet, and check it at the statement level: previous balance, plus purchases, fees and interest, minus payments and credits, equals the new balance.

### Loans and mortgages

A mortgage statement is mostly a summary of one payment split into parts. There is little to convert, and a small table typed by hand is often faster than a conversion. Keep the PDF for your records either way.

### Mac users and other banks

If you open the converted file in Apple Numbers instead of Excel, the formulas above work there too, and [exporting a Numbers sheet to Excel](/blog/export-numbers-to-excel) covers how to hand it on as an XLSX file. If you also have accounts elsewhere, [converting a Capital One statement to Excel](/blog/capital-one-statement-to-excel) and [getting a Citibank statement into Excel](/blog/citibank-statement-to-excel) walk through those banks' layouts with the same end goal: one row per transaction and a balance that ties.