# Chase Bank Statement to Excel: From PDF to Clean Rows

- Author: FastBankConvert (https://fastbankconvert.com)
- Published: 2026-10-17
- Category: Bank statements to Excel and CSV
- Canonical: https://fastbankconvert.com/blog/chase-bank-statement-to-excel

> Get a Chase bank statement to Excel: where the PDF statement lives online, how its layout splits deposits and withdrawals, and a balance check.
To move a Chase bank statement to Excel, save the monthly PDF from Statements & documents in Chase online banking, convert it so every deposit, withdrawal and check becomes one dated row with a signed amount, then compare your sheet with the balances the statement prints. A match proves the spreadsheet holds every transaction.

## Where the Chase statement PDF lives online

On chase.com the statement PDF sits under Statements & documents in the main menu, where you choose the account and open or save each month. According to [Chase's paperless statements page](https://www.chase.com/online-banking/paperless), you can reach up to seven years of statements, depending on the account type.

### Desktop route

Sign in on a computer, open the main menu in the top left of the dashboard, and choose Statements & documents. Choose the account first, because a household with a checking account, a savings account and a card will see a separate list for each one. Then pick the year. Each statement has an icon to open it and another to save it. Use save. A file opened in a browser tab and then printed to PDF usually still converts, but the saved original is the copy the bank built, with nothing added by your browser's print settings.

### Phone route

The same page says the Chase Mobile app keeps statements under Profile & Settings, then Document manager, then Statements & documents. The statement opens as a PDF on the phone. From there you can share it to your files app or to email. If your goal is a spreadsheet, it is easier to save it to files and convert from there than to email it to yourself and lose track of which copy is which.

### Name the file before you forget

Chase names its downloads in its own way, and a folder of twelve of them is hard to read. Rename each one as you save it, with the account and the month, such as chase-checking-2026-08.pdf. When you later stack months in one workbook, the file name tells you which statement each block of rows came from.

## Chase PDF statement or the Chase activity download?

Convert the PDF statement. Chase online banking also lets you look at recent account activity on screen, and many banks offer that activity as a download, but the monthly statement is the fixed record: it has an opening balance, a closing balance and only posted items. The on-screen activity list moves as pending items settle.

### What the activity view is good for

The activity screen is handy when you need last week's transactions, before any statement covers them. It is a poor source for a month you want to reconcile. Pending card holds can appear and then change, a transfer can show on one date and post on the next, and there is no printed closing balance at the bottom to check against. You end up with a list you cannot prove.

### What the statement gives you

The statement PDF gives you three things the activity list does not. It covers a fixed period with a start date and an end date. It prints a beginning balance and an ending balance. And many checking statements print a balance at the end of each day with activity. Those numbers are what make a balance check possible later in this post.

If you have both files for the same month, keep the PDF as the source of record and use the activity list only to look up a line you do not recognise.

## Chase statement sections that split deposits and withdrawals

Many checking statements do not print one running list of transactions. They group lines by type, so check your Chase statement for this layout. A section of money coming in sits apart from a section of money going out, and checks may get a section of their own. Each section has its own subtotal and its own date order.

### Reading the layout on your own statement

Open your statement and scroll past the summary on the first page. Look for the headings that sit above each block of lines. On a typical checking statement you will see some version of:

- A block of deposits and other money in, such as payroll, transfers from savings and refunds.
- A block of electronic withdrawals, such as card purchases, bill payments and transfers out.
- A block of checks paid, listed by check number with the date each one cleared.
- A block of fees, if any were charged that month.
- A table of daily ending balances near the end.

The exact wording of the headings has changed over the years, and a savings statement is simpler than a checking one. What matters is the pattern: the same month is cut into several lists, and every list is in date order on its own.

### Why sections matter for Excel

A spreadsheet wants one list, in date order, with one amount column. A copy and paste of a sectioned statement gives you the opposite: four short lists stacked on top of each other, with amounts that are all positive because the section heading, not a minus sign, told the reader which way the money went. If you sum that column you get a number that means nothing.

The fix is to carry the meaning of each section into the rows before you lose the headings. The next section shows how.

## Merging Chase sections into one Excel transaction list

To merge Chase sections, give every line a sign from its section: lines from money-in sections stay positive, lines from withdrawals, checks and fees become negative. Then sort the whole list by date. The result is one signed list that adds up to the month's net change.

### A worked example

The lines below are made-up examples, laid out the way a sectioned checking statement prints them. The beginning balance for the period is 2,400.00.

| Section on the PDF | Date | Description | Printed amount |
| --- | --- | --- | --- |
| Deposits | 08/01 | Payroll from example employer | 1,850.00 |
| Deposits | 08/19 | Transfer from savings | 300.00 |
| Electronic withdrawals | 08/04 | Card purchase, example grocer | 96.40 |
| Electronic withdrawals | 08/19 | Online payment, example utility | 142.75 |
| Checks paid | 08/12 | Check 1047 | 650.00 |

After signing and sorting, the Excel rows look like this:

| Date | Description | Amount | Source section |
| --- | --- | --- | --- |
| 2026-08-01 | Payroll from example employer | 1850.00 | Deposits |
| 2026-08-04 | Card purchase, example grocer | -96.40 | Withdrawals |
| 2026-08-12 | Check 1047 | -650.00 | Checks |
| 2026-08-19 | Transfer from savings | 300.00 | Deposits |
| 2026-08-19 | Online payment, example utility | -142.75 | Withdrawals |

The net change is 1,850.00 + 300.00 - 96.40 - 142.75 - 650.00 = 1,260.85. Added to the beginning balance of 2,400.00, that gives 3,660.85, which should equal the ending balance on the statement.

### Keep the section as a column

The Source section column looks redundant once the signs are in, but keep it. It lets you filter to checks only when you are hunting for a check number, and it shows you at a glance if a line landed in the wrong place. A converter that reads the layout, rather than the raw text, should give you the sign for each line without the manual step. FastBankConvert is built for that kind of statement and is getting ready to open; you can [join from the get started page](/get-started) to hear when trial conversions begin.

### Same-day lines and sort order

Two lines on the same date, like the 08/19 transfer and payment above, have no natural order once the sections are merged. Excel will keep whatever order the rows were in. That is fine for totals, but it can make a balance column look wrong on that one day. The daily balance check below works around it by comparing end-of-day figures, not line-by-line ones.

### Percentages and rates in the summary

The first page of a Chase savings statement may print an interest rate or an annual percentage yield. If that figure comes into Excel as a number, check how Excel stored it. A rate printed as 0.01% can arrive as text or be shown as 1%. [Fixing percentages after a PDF to Excel conversion](/blog/percentages-after-pdf-to-excel) covers how to tell and how to repair it.

## Does the Chase daily ending balance match your sheet?

It should match on every date the statement lists. The daily ending balance table gives the balance at the close of each day with activity. Add up your signed amounts through each of those dates, add the beginning balance, and the figures must agree to the cent. A day that does not agree tells you where to look.

### Build the check in three columns

Put the beginning balance in a cell of its own, say G1. Then build a small table beside your transactions:

1. In column I, list each date from the statement's daily balance table.
2. In column J, type the balance the statement prints for that date.
3. In column K, compute your own figure with `=$G$1+SUMIFS(C:C,A:A,"<="&I2)`, where column C holds amounts, column A holds dates and I2 holds the date on that row.

Using the example above, the daily table and the check would read:

| Date | Printed ending balance | Computed from sheet | Match |
| --- | --- | --- | --- |
| 2026-08-01 | 4,250.00 | 4,250.00 | Yes |
| 2026-08-04 | 4,153.60 | 4,153.60 | Yes |
| 2026-08-12 | 3,503.60 | 3,503.60 | Yes |
| 2026-08-19 | 3,660.85 | 3,660.85 | Yes |

### Reading a gap

Say the computed figure for 08/12 came out at 4,153.60 instead of 3,503.60. The gap is 650.00, and it opened between 08/04 and 08/12. On the PDF, the only item of that size in those dates is check 1047, so the check section was skipped. That is the most common miss with sectioned statements: a short section at the bottom of a page, or one that starts on a new page, gets left out entirely.

The opposite gap, where your figure is lower than the printed one by the amount of a line, usually means the line was counted twice, often because a section heading repeated at the top of the next page with a carried-over line under it.

### When there is no daily table

Savings statements and some account types print only the beginning and ending balances. The check still works for the whole month: beginning balance plus the sum of the amount column equals ending balance. You just cannot point to the day where a gap opened, so count the lines in each section on the PDF and compare them with a filtered count in Excel.

## When a Chase statement needs a closer look than a converter gives

Some Chase files convert badly with any tool. A statement saved as a screenshot, a photo of a paper copy, a PDF with pages missing, or a file that holds a year of months in one document all need extra handling. Spot them before you convert, not after an hour on a sheet that cannot balance.

### Files that cause trouble

- **Screenshots of the app.** A picture of the activity screen has no text layer and no balances. Save the statement PDF instead.
- **Printed and rescanned copies.** These hold pixels, not characters, so every digit has to be read by optical character recognition. Expect to check amounts by hand.
- **Statements with a missing last page.** Without the final page you lose the ending balance and often the daily balance table, which removes the check.
- **Combined documents.** If you have merged twelve monthly PDFs into one file for convenience, the beginning and ending balances repeat every few pages. [Converting a large PDF of many statements](/blog/convert-large-pdf-to-excel) explains when to split such a file and how to stitch the months back together.

### Accounts that are not checking

A Chase credit card statement is a different document with its own layout and a reversed sign convention, since a charge raises what you owe. Treat it as a card statement, not a checking one, and do not mix its rows with checking rows in one balance check.

### Comparing with other banks

If you hold accounts at more than one bank, the same steps apply with different section names. The guide to [converting a Bank of America statement to Excel](/blog/bank-of-america-statement-to-excel) covers that bank's layout, and the one on [getting a Wells Fargo statement to Excel](/blog/wells-fargo-statement-to-excel) covers Wells Fargo's. Keep one sheet per account and one balance check per statement, and the months will line up when you combine them.