How to Convert a Chase Bank Statement to Excel

TL;DR: Chase gives you two kinds of data: monthly PDF statements and a downloadable activity export. If the period you need is still inside the activity download window, export a CSV and you're nearly done. If you need older months, or the official statement itself, convert the PDF with a statement converter, then prove the running balance before you use the numbers anywhere.

We get asked about Chase more than any other bank, which isn't surprising given how many personal and small business accounts it holds. The questions are always variations of the same one: "I have a pile of Chase PDFs, and I need them in Excel. What's the least painful way?"

This guide is our answer. We'll cover where the data lives, the three realistic ways to get it into a spreadsheet, how to check that nothing went missing, and the cleanup steps that make the result usable for bookkeeping, tax prep or a loan file.

Statements versus activity: know which one you need

Before touching a converter, it helps to understand that Chase (like most large US banks) shows your money in two different forms.

The monthly statement is the official PDF the bank generates at the end of each cycle. It has an opening balance, a closing balance, every posted transaction, fees, and for business accounts often a daily ending balance table. This is the document a lender, an auditor or a visa officer usually wants, because it's the bank's formal record.

The account activity view is the live list of transactions you see when you log in. Chase lets you download this activity in spreadsheet-friendly formats such as CSV, and in formats that accounting software reads. It's convenient, but it only reaches back a limited distance, and it isn't a statement. It won't show the statement's opening and closing balances in a tidy way, and it isn't what a third party will accept as proof.

So the first decision is simple:

• If you need recent transactions for your own analysis and the dates are within the download range, use the activity export.
• If you need older periods, need to match the official document exactly, or someone sent you PDFs (a client, a former partner, an estate executor), you need to convert the PDF.

We see bookkeepers lose an hour trying to stitch activity exports together when what the client actually needed was twelve official statements converted. Decide up front.

Where to find your Chase statements

Chase moves its menus around from time to time, so we won't pretend to give you a click-by-click path that will stay accurate. In general terms:

1. Sign in to chase.com or the Chase Mobile app.
2. Open the account you care about (checking, savings, or a credit card).
3. Look for an option along the lines of Statements & documents. That's where the monthly PDFs live.
4. Choose the year and month, then download each PDF.

Chase keeps several years of statements online, but the exact range can differ by account type and age. If a month you need isn't listed, it's worth calling the bank and asking for a copy; banks can usually produce older statements on request, sometimes for a fee.

A practical tip: rename each file as you download it. chase-checking-1234-2026-03.pdf is far easier to work with than six files all called something like statement.pdf. When you later convert twelve months at once, sorted file names save you from transposing March and May.

Method 1: use the activity download (when it's enough)

If your date range is recent, the fastest option is the activity export:

1. Open the account's transaction list.
2. Look for a download icon or link near the activity.
3. Choose the date range and a spreadsheet format (CSV is the most universal).
4. Open the file in Excel.

The CSV will typically have columns for the posting date, a description, the amount (negative for money out, positive for money in), and a transaction type. Credit card exports often differ from checking exports, so don't assume the column order matches between your accounts.

What you won't get is a clean opening balance for the period. If you need to reconcile, write down the balance from the corresponding statement and add it as the first row yourself.

Method 2: copy and paste from the PDF (only for tiny jobs)

For a single page with fifteen transactions, copying from the PDF reader and pasting into Excel can work. It falls apart fast, though:

• Multi-line descriptions split into two rows.
• Amounts paste as text, sometimes with stray spaces or a trailing minus.
• Columns collapse into one cell, so you end up using Text to Columns and guessing the splits.
• Page headers and "continued on next page" lines land in the middle of your data.

We'd only recommend it when the job is genuinely small, and even then you must check the totals at the end. Most of the errors we've seen in hand-built spreadsheets trace back to a pasted row that quietly lost its minus sign.

Method 3: convert the PDF with a statement converter

For anything beyond a page or two, a converter built for bank statements is the right tool. A general PDF-to-Excel tool treats the statement like any table; a statement converter knows that there's an opening balance, a list of debits and credits, and a closing balance that must add up.

Here's the workflow we use with SheetStatement's PDF to Excel converter:

1. Upload the Chase PDF. Digital PDFs downloaded from chase.com work best, but scans and phone photos also work because the converter reads the page image.
2. Let the extraction run. Each transaction becomes one row with date, description, debit, credit and balance where the statement shows one.
3. Look at the balance check. The tool recalculates the running balance from the opening balance and flags any row where it doesn't match the statement.
4. Fix or confirm flagged rows in the review table.
5. Export to Excel, CSV, or an accounting format such as QBO for QuickBooks.

There's a dedicated page for Chase statement conversion that lists the account types we've tested, if you want the details.

Checking accounts vs. credit cards

Chase checking statements group transactions into sections such as deposits and additions, checks paid, electronic withdrawals and fees. When converted, you want all of these in one chronological list with a clear sign on each amount. Make sure your converter doesn't drop the section labels into the description field, or you'll be filtering junk later.

Chase credit card statements are laid out differently. They separate payments and credits from purchases, and they show interest charges in their own area. For a card, a "credit" reduces what you owe, which is the reverse of a checking account. Keep that in mind when you build formulas, and treat the card as a liability in your books. Our credit card statement converter handles the sign convention, but you should still sanity check that payments show as reductions.

Prove the numbers before you use them

This is the step people skip, and it's the one that matters most. A converted statement is only useful if it's complete. One missing row, and every downstream number is off.

The test is simple: start from the opening balance, add every credit, subtract every debit, and you must land exactly on the closing balance printed on the statement.

In Excel, assuming columns A to E are Date, Description, Debit, Credit, Balance:

1. In F1, enter the statement's opening balance.
2. In F2, enter =F1-C2+D2 and fill down.
3. In G2, enter =ROUND(E2-F2,2)=0 and fill down.
4. Any FALSE means a problem at or above that row.

If your statement doesn't print a running balance on every line (some Chase layouts only show daily balances), compare the final value in column F against the closing balance on page one instead. You can also run the file through our free statement balance checker, which does this math for you.

We wrote a longer guide on reconciling a bank statement in Excel if you need to go further and match against your books.

Clean the spreadsheet so it's actually useful

A raw conversion is rows of data. A useful spreadsheet has a few extra touches.

Make dates real dates

Chase statements often print dates without the year (for example, "03/14"). A good converter fills in the year from the statement period, but check the months that cross a year boundary. A December statement that runs into January is the classic place where dates end up a year off.

In Excel, select the date column and confirm it's right-aligned (a sign Excel sees real dates). If it's left-aligned, it's text. Use Data > Text to Columns > Date (MDY) to fix it.

Use one signed amount column

Two columns for debit and credit are great for reading, but a single signed amount is easier for formulas and pivot tables. Add a column with =D2-C2. Now money in is positive and money out is negative, and SUMIFS works without gymnastics.

Tidy the descriptions

Chase descriptions contain card numbers, dates, transaction IDs and city names jammed together. You don't need to fix all of it, but a helper column that trims the noise makes categorizing much faster. =TRIM(LEFT(B2,25)) is a crude but effective start. For more targeted rules, see our guide to Excel formulas for categorizing transactions.

Add a category column

Even a short list of categories (Payroll, Rent, Software, Meals, Transfers, Owner draws) turns a statement into something you can summarize. Filtering by description keywords and filling the category gets you most of the way. Then a pivot table gives you totals per month per category in seconds.

Converting a year of Chase statements at once

When we help someone catch up on bookkeeping, the job is rarely one statement. It's twelve, or thirty-six. A few habits keep that manageable:

• Convert in order. Work through months chronologically so each statement's opening balance can be checked against the previous month's closing balance. A gap between them means a missing statement.
• One sheet per month, then one combined sheet. Keep the monthly tabs for audit trail, and build a combined tab for analysis.
• Add a source column. Put the statement month or file name on every row. When a number looks wrong in September, you can find the original page in seconds.
• Watch the transfers. If you're converting both checking and savings, internal transfers show up twice, once on each side. Tag them so they don't inflate income or expenses.

Our article on catching up on months of bookkeeping goes deeper on the process.

Getting Chase data into QuickBooks or Xero

If Excel is only a stop on the way to your accounting software, skip a step and export directly to the format the software wants:

• QuickBooks Online or Desktop: a QBO (Web Connect) file usually gives the cleanest import, because it behaves like a bank feed. See our bank statement to QuickBooks page and the comparison of QBO, IIF and CSV.
• Xero: a Xero-formatted CSV maps straight onto Xero's statement import. Our bank statement to Xero page covers it.

Whichever you choose, import into the right bank account in your software and check the imported total against the statement before you start categorizing.

Common problems and how we fix them

"The converter missed a page." Usually this is a page with only one or two transactions near the bottom, or a summary page that the tool treated as non-transactional. The balance check catches it: the running balance will jump. Look at the statement around the jump and add the missing rows.

"Amounts are doubled." Some Chase layouts show a transaction and then a subtotal for its section. If your tool imported the subtotal as a transaction, delete those rows. Again, the balance check reveals this immediately.

"Dates are in the wrong year." See the year-boundary note above. Sort by date and look at the first and last rows.

"Excel shows ####." The column is too narrow. Double-click the column border.

"Negative numbers show in parentheses." That's just formatting. The value underneath is still negative. Change the number format if you prefer a minus sign.

"The PDF is password protected." Chase-downloaded PDFs normally aren't, but files forwarded by someone else sometimes are. You'll need the password to open it before any tool can read it.

Privacy and security

Bank statements carry account numbers, addresses and a detailed picture of someone's life. Treat them that way. Use tools that encrypt files in transit, delete uploads after processing, and don't train models on your data. Our security page explains exactly how we handle files. And whatever you use, don't email unencrypted statements around more than you need to.

Our take

For one recent month, the Chase activity download is fine. For anything official, older, or larger than a couple of pages, convert the PDF and verify the balance. The verification is the part that separates a spreadsheet you can rely on from one that looks right until somebody checks it.

If you want to try it on your own Chase statement, the free plan converts 3 pages a month with no card required.

A quick mini checklist

1. Every page of every statement in the period.
2. Each account in its own table.
3. One signed amount column.
4. Totals checked against the statement's beginning and ending balances.
5. Original PDFs kept unedited.

FAQ

Can I download Chase statements directly as Excel files?

Chase provides statements as PDFs. You can download recent account activity in spreadsheet-friendly formats like CSV, which Excel opens, but the official monthly statement itself is a PDF. To get a statement into Excel you need to convert it.

How far back can I get Chase statements online?

Chase keeps several years of statements available online, though the exact range can vary by account. For older periods, contact Chase to request copies; there may be a fee and a waiting period.

Does converting work for scanned Chase statements?

Yes, if the converter reads page images. Scans and phone photos convert well when the image is sharp and straight. Always run the balance check afterward, because low-quality scans are where misread digits creep in.

Will the converted file match the statement exactly?

It should, and you can prove it. Start from the opening balance, apply every transaction, and confirm you land on the closing balance. If it doesn't match, the flagged rows show you where to look.

Can I convert Chase credit card statements too?

Yes. Credit card statements use a different layout and sign convention, where payments reduce the balance owed. A converter that understands card statements will label payments and purchases correctly, but check a few rows to be sure.

Is it safe to upload Chase statements to an online converter?

It depends on the service. Look for encryption in transit and at rest, automatic deletion of uploaded files, and a clear policy against using your data for training. Avoid tools that don't explain what happens to your files.