How to Convert a U.S. Bank Statement to Excel

U.S. Bank statements are tidy on paper, but their layout is a little different from what many people expect: activity is often grouped by type rather than listed in one long date-ordered table. That matters when you want the transactions in a spreadsheet. This guide shows how to turn a U.S. Bank PDF statement into Excel (or CSV, JSON or XML), where to find the PDF, and how to handle the layout once the rows are in Excel.

The quick way

Download your U.S. Bank statement as a PDF (where to find it is below).
Upload it to statementconvert.ai: drag and drop the PDF.
Preview the extracted transactions and check whether the result agreed with the balances printed on the statement.
Download as Excel, CSV, JSON or XML.

No account is needed to preview: without one, the preview shows the first rows in full and the rest as date and amount. Signing in free with Google shows every row and unlocks the download, and the free plan covers up to 5 statement pages a month.

Where to download your U.S. Bank statement as a PDF

You need the PDF of the statement. In U.S. Bank online banking or the U.S. Bank Mobile App, open the account's statements area and download the PDF for the period. Labels vary by account and change over time, so this is the general flow rather than exact menu names:

Sign in to online banking or the app and open the account.
Open the account's statements area.
Choose the statement period.
Download the PDF, or share it from the app.

If you need several months, download each statement on its own. Paid plans accept up to 12 statements in one upload.

What a U.S. Bank statement looks like

Layouts vary by account and change over time, so this is a general guide rather than an exact specification.

U.S. Bank checking and savings statements often include:

A header with the statement period and a masked account number.
An account summary: beginning balance, deposits, withdrawals, checks and the ending balance.
Activity grouped into sections by type, for example customer deposits, other deposits, card withdrawals, other withdrawals and checks paid, each with its own subtotal.
On some statements, a balance summary listing the ending balance for each day, printed separately from the transaction lines.

U.S. Bank credit card statements (for example the Altitude or Cash+ cards) usually include:

An account summary with the previous balance, payments, credits, purchases, fees, interest and the new balance.
A payment information area with the minimum payment and due date.
A transactions list that may show a post date, a transaction date, a reference number, a description and an amount, with payments and credits in their own section. Some card statements mark credits with CR rather than a minus sign.

Two features can make these statements awkward for generic PDF-to-Excel tools: the section subtotals, which look like transactions but are not, and, where one is printed, the daily balance summary, which can get mixed in with real activity.

What you get in the Excel file

Each transaction becomes one row with these columns:

Column	What it holds
Date (DD/MM/YYYY)	The transaction date
Description	The merchant or transaction text
Amount	A signed amount
Balance	The balance printed next to the transaction, when there is one
Source File	The PDF the row came from
Page	The page the row came from

What this means for a U.S. Bank statement:

Rows may follow the statement's sections. Deposits can appear together, then card withdrawals, then checks. To get one chronological list, select the table in Excel and sort by Date (oldest to newest).
Balance may be empty. Statement layouts vary, and balances may be printed separately from transactions. The Balance column is filled when a balance is printed beside the transaction, so it is often empty for card statements and for checking statements that keep balances in a separate summary.
Signs. On checking and savings, money out is negative and money in is positive. On a credit card, purchases come out positive and payments negative. Lines marked CR are credits on the statement; the preview shows how they came through.
Reference numbers are not a column. The output keeps date, description, amount and balance; there is no separate reference-number column.

Converting your U.S. Bank statement with statementconvert.ai

statementconvert.ai reads U.S. Bank checking, savings and credit card statements, from digital PDFs and, often, from scans.

Upload your U.S. Bank PDF.
Preview the rows. Transactions are read by AI, which can make mistakes, so each result is checked against the balances and totals printed on the statement, where there are any, and tells you whether they matched. With a U.S. Bank checking statement, the beginning and ending balances in the account summary are what the rows are checked against.
Download:
- Excel (.xlsx) for sorting, filtering, pivot tables and formulas.
- CSV for Google Sheets or for importing into accounting software yourself; there is no direct integration with QuickBooks, Xero or other tools. The guide to importing a statement CSV into QuickBooks and Xero covers the mapping.
- JSON or XML for scripts and systems.

On privacy: we never store your statement. It travels over HTTPS, is processed in memory, its pages are read by our AI providers (OpenAI, and Anthropic for a second reading), and it is then discarded. The providers do not train on it and may keep request logs for up to 30 days; the privacy page has the details. There is no bank login and no connection to your U.S. Bank account. (More on this: Is it safe to upload your bank statement online?)

A quick check before you use the data

Balance result. Did the result say the rows agreed with the printed balances? A match means the extracted figures agree with the balances that were checked; it does not prove every row is right, because errors can offset. A mismatch means comparing the rows with the statement to find where they differ.
No subtotals. Section totals such as total deposits or total card withdrawals are not transactions and are not meant to appear as rows; the preview is where to spot one that slipped in.
No daily balance lines. Entries from a daily balance summary are not transactions either and are not meant to appear as rows; the preview is where to spot one that slipped in.
Checks. Check numbers and amounts match the checks-paid section.
Row count. Roughly the same number of rows as transactions on the statement.

Recurring charges on the same statement

Card withdrawals on a checking statement, and purchases on a card statement, are where monthly charges for streaming, software and memberships show up. statementconvert.ai also lists recurring charges it finds in the statements you upload. For the manual method, see how to find all your subscriptions from a bank statement.

Prefer to do it manually?

For a digital U.S. Bank PDF, Excel's Power Query may help: availability depends on the Excel version and platform, and where the From PDF connector exists it can extract each section's table. Those tables usually need cleanup: stitching the sections together, removing subtotals and dropping any daily balance table. The methods are compared in how to convert a PDF bank statement to Excel. Working from paper? See converting a scanned bank statement to Excel.

Other banks in the mix? There are walkthroughs for Citi, Capital One and Wells Fargo.

Convert your U.S. Bank statement now

Convert a bank statement to Excel: upload your U.S. Bank PDF, preview the transactions, then sign in free to see every row and download Excel, CSV, JSON or XML. Free for up to 5 statement pages a month; paid plans start at $7.99 a month. No account needed to preview.

Frequently asked questions

How do I convert a U.S. Bank statement to Excel? Download the statement as a PDF from U.S. Bank online banking or the U.S. Bank Mobile App, upload it to statementconvert.ai, preview the extracted transactions, and download as Excel, CSV, JSON or XML. It reads U.S. Bank checking, savings and credit card statements, and we never store your statement.

Where do I find my U.S. Bank statement as a PDF? In U.S. Bank online banking or the U.S. Bank Mobile App, open the account's statements area and download the PDF for the period. Labels vary by account and change over time, so the exact wording on screen may differ.

Why are my U.S. Bank transactions grouped by type instead of by date? U.S. Bank checking statements often list activity in sections, such as deposits, card withdrawals, other withdrawals and checks, rather than one date-ordered list. The converted file gives each row its date, so sorting by the Date column in Excel gives one chronological list.

Why is the Balance column empty for some rows? Statement layouts vary. The Balance column is filled when a balance is printed beside the transaction. On some U.S. Bank checking statements, balances are printed separately from the transactions, in a daily balance summary, and card statements generally print no running balance per row, so an empty Balance column is expected there.

Is it safe to upload my U.S. Bank statement? We never store your statement. It travels over HTTPS, is processed in memory, its pages are read by our AI providers (OpenAI, and Anthropic for a second reading) and it is then discarded. The providers do not train on it and may keep request logs for up to 30 days; the privacy page has the details.