Convert a U.S. Bank statement PDF to Excel

How to convert a U.S. Bank statement PDF to Excel

1. Download the PDF in U.S. Bank online banking: My accounts → My documents → Statements, pick the account type, then the statement date. In the U.S. Bank Mobile App: select the account, tap Account options, then View statements docs. Use the downloaded PDF, not a scan of a paper statement: scans don't work yet.
2. Upload it above. Utilly reads every transaction section on every page and checks Beginning Balance + transactions = Ending Balance. The preview shows Balanced ✓, or exactly how far off it is, before you pay anything.
3. Download the CSV and open it in Excel. Dates and amounts come in as real dates and numbers, in the statement's order, section by section.
4. Sort by Date if you want the month day by day, and save as .xlsx (File → Save As → Excel Workbook) to keep formulas or formatting.

What we read on a U.S. Bank statement

A U.S. Bank checking statement starts with an Account Summary (Beginning Balance, a count and total for each kind of transaction, Ending Balance), then lists the transactions in sections by type: Customer Deposits, Other Deposits, Card Withdrawals, Other Withdrawals and Checks Presented Conventionally. Personal statements use the same idea with headings like Deposits / Credits. Each section has its own Total line, and a Balance Summary comes last.

What this is based on: test statements built in the U.S. Bank business and personal checking layouts above, with made-up names and transactions, plus two older U.S. Bank business checking statements that their owners posted publicly online, which read 14 of 14 and 15 of 15 rows and balance. We don't link to those because they contain people's details. We haven't run every U.S. Bank statement style through it: savings, money market and U.S. Bank credit card statements haven't been tested yet, and a paper statement that lists several accounts may not read. That's why the balance check runs on every file: if yours doesn't balance, you see the difference before paying.

What the Excel file looks like

Date,Description,Amount,Balance
2026-09-15,Customer Deposit 91200001,3400.00,
2026-09-11,Mobile Banking Transfer From Account 104700000001,500.00,
2026-09-05,Zelle Instant PMT To ALEX RIVERA On 09/05/26 PMT ID=USBab12CdEfGh,-1200.00,
2026-09-16,Analysis Service Charge 1600000000,-15.00,
2026-09-08,Check 2041,-325.00,

Want money in and money out in two columns? Use =MAX(C2,0) and =MAX(-C2,0). Want a running balance? Sort by Date, put the Beginning Balance in D1, then =D1+C2 in D2 and fill down; the last row should equal the Ending Balance.

How far back U.S. Bank statements go

Sources: U.S. Bank: Online bank statements (paperless documents FAQ) (seven years, Aug. 13, 2017, where to find statements, one e-statement per account, closed accounts), U.S. Bank: How do I download my transaction history? (three years, CSV, Quicken .QFX and QuickBooks .qbo, not in the mobile app). Checked Oct 25, 2026.

QuickBooks and Quicken files for U.S. Bank

U.S. Bank's own transaction download (the download icon on the account's Transactions tile) offers a spreadsheet (.CSV), Quicken (.QFX) and QuickBooks (.qbo) file for up to three years of history (U.S. Bank help). If that reaches back far enough, use it. For older months, or when all you have is the statements a client sent you, start from the statement PDF. The same Utilly conversion that gives you Excel also includes:

One credit covers every format of that statement. If a bank feed or an earlier download already brought in some of the same dates, start the PDF months where that stopped so nothing comes in twice.

Common problems

Catching up on months of statements? See catch-up bookkeeping from bank statements, and check any statement's totals with the free bank statement balance checker. Other banks: bank statement PDF to Excel, Chase statement to Excel, Bank of America statement to Excel, Wells Fargo statement to Excel, or Capital One statement to Excel.