Convert U.S. Bank statements to Excel and CSV
To convert a U.S. Bank statement to Excel or CSV, upload the PDF, scan or photo to statement.work. You get one row per transaction with date, description, amount and running balance, and ACH descriptions cleaned up enough to categorize.
Not affiliated with U.S. Bank. statement.work is an independent tool. U.S. Bank is a trademark of its owner and is named here only to describe the statements this page is about.
About U.S. Bank statements
U.S. Bank is the main banking subsidiary of U.S. Bancorp, headquartered in Minneapolis, with a large customer base across the Midwest and West. Many small businesses bank there, so its business checking statements are a regular part of bookkeeping work.
What the statements typically contain
- Account and statement period details at the top.
- A balance summary with beginning balance, deposits, withdrawals and ending balance.
- Transactions listed with dates (month/day), descriptions and amounts, often grouped as deposits, withdrawals and checks.
- Fee and interest information, and for business accounts, analysis or service charge details where they apply.
Your own statements are the reference; layouts change by account type and over time.
Common conversion problems
- ACH descriptions. Electronic payments carry long descriptions such as company name, entry description and an ID number. Accurate as a record, but unhelpful for grouping. statement.work cleans descriptions and assigns a category, while you keep the original detail for reference.
- Grouped deposits and withdrawals. Like many US statements, activity may be split by type. A single chronological table is easier to reconcile.
- Checks listed separately. Check images or check lists can follow the main transactions and need to be merged back in.
- Business service charges. Fees on business accounts can be summarized separately from the transaction list. Watch for them in the totals.
How to convert it
- Download the PDF statement from online banking, or use a scan or photo.
- Upload it to statement.work.
- Review the transactions and categories.
- Export to CSV or Excel.
- Confirm the ending balance agrees with the statement.
Make categories consistent
Payroll, vendor payments and tax payments via ACH are where good categories pay off. If you want your categories to match across banks and clients, use a fixed list. Our categorization guide has a sample. For neighboring banks, see Wells Fargo and PNC.
Questions
What are ACH transactions on a statement?
ACH transactions are electronic payments and deposits through the US Automated Clearing House network, such as payroll, direct debits and vendor payments. Their descriptions often include company names and reference IDs.
Can I convert U.S. Bank business statements?
Yes. Business and personal statements both convert, and the export uses the same columns either way.
Is statement.work affiliated with U.S. Bank?
No. statement.work is independent and is not affiliated with or endorsed by U.S. Bank or U.S. Bancorp.