U.S. Bank statement to Excel

A U.S. Bank checking statement is split into sections — Customer Deposits, Card Withdrawals, Other Withdrawals — each with Date, Description of Transaction, Ref Number and Amount, and a total at the end. The amounts carry no sign: the section says which way the money went. StatementEasy reads each section in the right direction, leaves the section totals out, puts every transaction in date order and checks that the totals lead from the beginning balance to the ending balance.

Download your U.S. Bank statement

1. Log in at usbank.com or in the U.S. Bank Mobile app.
2. Open the account and choose Statements.
3. Pick the statement and download the PDF.
4. Drop it here.

Sections, read the right way

Section on the statement	In your sheet
Customer Deposits	Money in
Card Withdrawals	Money out
Other Withdrawals	Money out
Total … lines	Not added as rows
Beginning / Ending Balance	Used to check the totals

One list in date order

On paper, all deposits come first and all withdrawals after them, so a single day is spread over several pages. In your sheet the transactions are put back in date order — the way you would see them in online banking — while keeping the description, including the Ref Number, of each one.

How the check works without a running balance

U.S. Bank does not print a balance after each transaction. Instead, StatementEasy adds up every deposit and every withdrawal it read and checks that beginning balance + deposits − withdrawals equals the ending balance on the statement. A missed or misread line would break that equation, so you know the file is complete.

For taxes and small business books

Convert the twelve statements of the year together and choose “All files combined”; duplicates from overlapping statements are removed. Export QBO for QuickBooks or CSV for other software, and use the Categories sheet to total expenses by type.

Last tested October 2026. StatementEasy is not affiliated with U.S. Bank National Association.