Financial Documents

U.S. Bank Statement to Excel: CSV Limits, PDFs, Union Bank

U.S. Bank's help pages give 18 months or three years of transaction history; statements go back seven. Turn the PDFs, Union Bank's included, into Excel.

Published
Updated
Reading time
13 min
Topics:Financial DocumentsBank StatementsExcelU.S. BankUSPDF conversionUnion BankAccount AnalysisU.S. Bank statement to CSVU.S. Bank transaction history downloadU.S. Bank statements older than three years

U.S. Bank gives two different answers to how far back your transaction history goes, and both come from its own help pages. One says online banking downloads up to three years of transaction history, as a Spreadsheet (.CSV), Quicken (.QFX) or QuickBooks (.qbo) file, and that the mobile app offers no downloads at all. Another says the last 18 months of activity are shown online, and six months in the mobile app. E-statements reach much further: you can view up to seven years of them in digital banking.

Whichever download figure applies to your account, it stops years short of the statement archive. A statement older than the download window has no CSV behind it, so for those years the route from U.S. Bank statement to Excel runs through the PDF itself, one row per transaction.

Two things make that conversion specific to this bank. Analyzed business checking statements carry an Analysis Service Charge Detail section whose lines look like transactions but never posted to the account. And former MUFG Union Bank customers were moved to U.S. Bank in May 2023 with new account numbers, so a seven-year look-back for a business that banked with Union Bank runs across two banks' statements.

Three Years or 18 Months: What U.S. Bank's Own Help Pages Say About Downloads

The download itself lives in online banking on a computer. U.S. Bank's page How do I download my transaction history? lists three file types, Spreadsheet (.CSV), Quicken (.QFX) and QuickBooks (.qbo), and sets the reach plainly: "You can download up to three years of transaction history using online banking." It adds that "Transaction downloads aren't available in the U.S. Bank Mobile App", and for anything older it says: "For transactions more than three years old, view your account statements."

A second page, How long is transaction history available?, gives a shorter number. The bank makes "the last 18 months' worth of your transaction history available in your activity via online", or "six months if you're using mobile". Its instruction for older activity: "To obtain transaction history older than 18 months, use the Advance search option or view your statements."

Download page (KB0069323)History page (KB0069692)
Question it answersHow to download transaction historyHow long transaction history is available
Online bankingUp to three years, downloadableLast 18 months shown in activity
Mobile appNo downloadsSix months
For older historyView your account statementsAdvance search, or view your statements

The two pages may be describing different things, one the file a download produces and the other what the activity screen displays, but neither says so, and nothing on either page settles it. The working rule that holds under both: set the download to the date range you need and see what comes back. Whatever the file does not cover has to come from statements, which is where both pages send you anyway.

That makes the CSV the right tool for the recent part of the history: the current year into a spreadsheet, or a bank feed brought up to date. It does not reach the older history a prior-year return, an audit request or a catch-up tends to need. U.S. Bank is not unusual here. The same gap between a short download and a long statement archive shows up when converting Wells Fargo statements to Excel, and in PNC's download limits and statement conversion.

Seven Years of Statements, and What a Copy Costs

Statements outlast the download by a wide margin. "You can view up to seven years of e-statements on digital banking," U.S. Bank's e-statements help page says, and its page on older statements confirms the other edge: past seven years, statements are no longer available. For history older than 18 months (or three years, on the download page's figure) and younger than seven, both pages point to the monthly statement.

When a statement is missing from digital banking or a client's files, a copy can be ordered in digital banking under Accounts, then Statements, then "Order a copy". The statement copy page warns that "There may be a fee for statement copies" and shows the fee before the order goes through. For business accounts, the prices are published in U.S. Bank's Business Pricing Information, effective May 11, 2026, under Statement Services:

Statement servicePrice
Copy of Analyzed Statement$12.00 per statement
Snap Shot Statement$12.00 per statement
Service Analysis Statement$6.50 per statement
Copy of non-Analyzed Statement$6.50 per statement
Account Balance and Research$80.00 per hour, one-hour minimum

The amounts add up over a multi-year request. Copies of four years of monthly analyzed statements, 48 of them, come to $576 at $12.00 each, before any research time.

The cheaper source is usually already in hand: every e-statement inside the seven-year window can be saved from digital banking as a PDF without ordering a copy, and many businesses and their accountants already keep them filed by month. Ordered copies are for the gaps. One timing point matters for anyone planning a look-back: the window moves forward every month, so a statement that crosses the seven-year line drops out of digital banking and can no longer be downloaded. Pull the oldest months first.


Analyzed Business Statements Carry a Fee Section That Is Not Transactions

A U.S. Bank business checking account on account analysis gets a statement with two kinds of rows in it, and only one kind belongs on a transaction sheet. The bank's Business Pricing Information describes the arrangement in a footnote: "Account analysis is the method of fee processing and reporting for business checking accounts. Analyzed accounts use account analysis to detail fees. Fees are charged to the account once per month."

The detail sits in its own part of the statement. Another footnote in the same pricing document, on ordering a copy of the Service Analysis Statement details, says the section "can be found in your periodic statement under 'Analysis Service Charge Detail'", and that in this section "you can find information such as (but not limited to) wire fees, statement fees and/or transaction fees."

For conversion, the distinction is between what posted and what explains the posting:

  • The monthly analysis charge is a single debit in the account's transaction list. It moved money, so it is a ledger row.
  • The Analysis Service Charge Detail lines itemize how that charge was built, service by service. None of them posted to the account on its own.

Put both into one sheet and the month's fees are counted twice, once as the posted debit and again as the sum of the detail lines. The sheet then no longer ties to the statement's ending balance, and the bookkeeping shows bank charges the client never paid.

The transaction sheet keeps the posted monthly charge and leaves the detail section out. The detail is still worth extracting when the client wants to know what its banking costs: which services drive the charge, and how the mix changes month over month. That goes in a separate file of its own, one row per service per month. For the fee lines themselves and how to read them, see the guide to reading an account analysis statement and its fee lines.

Former Union Bank Accounts: Two Account Numbers in One Look-Back

Some U.S. Bank accounts in the West began life at another bank. The Federal Reserve's 2022 order approving the Union Bank acquisition, dated October 14, 2022, put U.S. Bancorp's consolidated assets at $591.4 billion, the eighth-largest insured depository organization in the United States, and MUFG Union Bank's total assets at about $124.7 billion, the 34th-largest insured depository institution, with operations in Arizona, California, Oregon and Washington (figures as of June 30, 2022). The combined company would become the seventh-largest, and Union Bank was to be merged into U.S. Bank in the second quarter of 2023.

The accounts moved over Memorial Day weekend 2023. U.S. Bank's transition guide for Union Bank consumer customers gives May 27 to 30 for deposit accounts; the letters to business customers gave May 27 to 29. Three points in the guide and the business letters shape any multi-year file built today:

  • The account numbers changed. "It is necessary for U.S. Bank to renumber all deposit accounts when they transition to U.S. Bank." The business letters added that new account numbers would be confirmed by mail.
  • The old statements moved, with a caveat. Past Union Bank e-statements transfer to U.S. Bank online and mobile banking, "however, there may be a delay", and the bank recommended that customers "print past Union Bank statements, on or before May 27, for your records."
  • May 2023 is split in two. Each customer received a final paper Union Bank statement covering activity from the most recent statement through May 26. U.S. Bank statements begin with the activity of May 27.

For a business that banked with Union Bank, a seven-year look-back from 2026 therefore covers two account numbers, two statement layouts, and a changeover month spread across a short final Union Bank statement and the first U.S. Bank one. No download helps with the earlier part. Eighteen months or three years back from today both land after May 2023, so every pre-conversion transaction comes from a statement. Comerica accounts moved to Fifth Third in September 2026 have a newer version of the same split, set out in combining Comerica and Fifth Third statements in one Excel sheet.

Start by checking whether the client's Union Bank statements appear in U.S. Bank online banking; where they do not, the printed or saved copies the bank told customers to keep are the source. Record the old and new account numbers side by side in the working papers. That pairing is what lets two runs of statements, in two designs, read as one account's history. Accounts that started at BB&T or SunTrust before those banks became Truist leave a similar mix of legacy PDFs, as the guide to converting Truist, BB&T and SunTrust statements to Excel shows. Former People's United accounts now at M&T are another case, set out in turning M&T and People's United PDF statements into Excel.


Converting U.S. Bank and Union Bank PDFs Into One Transaction Sheet

Take a common case: a Los Angeles business that banked with Union Bank until 2023 needs its 2020 to 2025 transactions in one sheet, to rebuild books that fell behind before a lender's review. That is six years of monthly statements, about 73 PDFs once the May 2023 stub is counted, in two statement designs under two account numbers. The work is the same as any tax-season catch-up bookkeeping from a client's statements, with two extra demands: both banks' rows have to land in the same columns, and every row has to say which account it came from.

You can convert a batch of U.S. Bank PDF statements to Excel in one task, Union Bank's and U.S. Bank's mixed, with up to 6,000 files per task, scans included alongside the PDFs saved from online banking. Our AI reads each layout for itself, so the two banks' designs need no separate setup. What it needs is a prompt describing the sheet you want, for example:

I'm doing catch-up bookkeeping from these bank statements. One row per transaction: Bank, Account Number (last four digits), Statement Period, Date (YYYY-MM-DD), Description, Amount, Balance. Show debits as negative. Leave out the Analysis Service Charge Detail section, but keep the monthly analysis charge that posts to the account. Skip summary pages.

Around the changeover, the rows come out like this (illustrative figures):

BankAccount NumberStatement PeriodDateDescriptionAmountBalance
Union Bank44172023-05-01 to 2023-05-262023-05-24ACH deposit, customer payment3,850.0041,206.18
Union Bank44172023-05-01 to 2023-05-262023-05-26Check 2214-1,120.0040,086.18
U.S. Bank88032023-05-27 to 2023-06-302023-05-30Card purchase, office supplies-212.4739,873.71
U.S. Bank88032023-05-27 to 2023-06-302023-06-15ACH deposit, customer payment5,200.0045,073.71
U.S. Bank88032023-05-27 to 2023-06-302023-06-30Analysis service charge-86.4044,987.31

The Bank and Account Number columns carry the conversion: a filter on either splits the history back into its two accounts, and sorted by Date the sheet reads as one continuous history. The analysis charge appears once, as the debit that posted. If the client also wants a fee review, a second task with its own prompt, such as "From the Analysis Service Charge Detail section only, one row per service per statement: Statement Period, Service, Charge", puts the itemized lines in a file of their own.

Every row also carries the file and page it came from, and a value or a row the panel of AI agents cannot agree on is flagged as Review Needed, with what to check. In the results viewer, clicking the file name on a row opens the page it came from beside it, so each flagged row, and a spot-check sample of the others, can be compared with the statement itself. The tie-out is yours to run: each statement's beginning balance plus its rows should equal its ending balance, and the final Union Bank statement's ending balance should match the opening balance of the first U.S. Bank statement, as it does above, where the first U.S. Bank row runs on from 40,086.18.

The download comes as Excel, CSV or JSON. In Excel, amounts come through as numbers and dates as dates, so formulas and pivot tables work straight away; the CSV is the version to keep for an import.

SinglePoint, QuickBooks and History Older Than the Feed

Small-business online banking at U.S. Bank uses the same transaction download as personal accounts, with the same CSV, QFX and QBO choices. Businesses on SinglePoint have more statement tools. SinglePoint Essentials lets users "Download statements for U.S. Bank accounts in PDF and other formats", and the next-generation SinglePoint that U.S. Bank rolled out on October 27, 2025 added "custom account groupings, new statement types, extended retention and bulk downloads". The announcement gives no figure for how long the extended retention runs, so check it in the platform rather than assuming it beats seven years. Where bulk statement downloads are available, they are the quickest way to gather a multi-year run of PDFs.

For QuickBooks Online, U.S. Bank offers a direct connection for eligible business checking and savings accounts "at no extra cost", and the setup lets you "Select how far back you want to download transactions". The feed can only bring in what the bank serves, though, so a company file that needs earlier years, or a client switching to QuickBooks with history to load, gets it from the statements. The converted sheet comes back as CSV or Excel rather than a .qbo file, and QuickBooks Online takes it through its bank-file upload; the steps and column mapping are covered in importing converted bank statements into QuickBooks. Load the converted history only up to the date the feed begins, so the two do not overlap and duplicate transactions.

Extract invoice data to Excel with AI

Upload your invoices, say what you need in plain words, and download the spreadsheet.

  • A panel of AI agents has to agree on every value
  • What the panel cannot agree on is flagged as Review Needed
  • 50 free pages every month, no subscription
  • Any layout, any language, scans and phone photos
  • Numbers come through as numbers and dates as dates
  • Files encrypted and deleted within 48 hours