How to Export a US Bank Statement to Excel

You have a US Bank account. You need 18 months of history for a tax filing.

It downloads in 30 seconds. You open it in QuickBooks. The import takes another 30 seconds. You are done. This is the cleanest US Bank export path.

This page is the US Bank export guide. It covers the 2 download options for personal accounts (PDF and QFX), the separate business account path with OFX, the regional limitations, and how to convert the PDF if you need older history than the QFX covers.

US Bank gives you 24 months of monthly PDF statements and 18 months of combined QFX download. There is no CSV export and no OFX. The QFX is the right path for QuickBooks users. The PDF is the fallback for anything older than 18 months.

US Bank business accounts have a different export path. The “Download transactions” feature inside the business account page gives you 12 months of OFX in a single file. This is the cleanest US Bank export for businesses, and it is the path to use if you are a QuickBooks customer.

US Bank is a regional bank with the strongest presence in the Midwest and West. The export flow is consistent across regions, so this guide applies whether you bank in Minnesota, California, or Oregon.

What US Bank Actually Gives You

US Bank’s online portal at usbank.com gives personal account holders 2 export options. Both are useful in different situations.

What most guides miss about Excel conversion is that the quality depends on the mechanism, not on the tool. Two tools that look different on the surface often run the same 4-step process underneath: read, find, parse, verify. The difference is in how well each step handles edge cases (merged cells, missing balances, non-standard date formats, scanned vs digital input). Choosing between tools based on UI alone misses the actual quality lever.

• Monthly PDF Statements going back 24 months. One PDF per month per account. The PDF has the standard US Bank branding, the account summary, and the transaction list. This is the official statement you would send to a lender.
• Combined QFX Download going back 18 months. This is the cleanest export. The file is a single QFX with all transactions for the date range. It opens in QuickBooks and most accounting software. A converter that handles QFX can also turn it into an Excel file.

There is no CSV export. There is no OFX. The QFX is Intuit’s proprietary version of OFX. If you use QuickBooks, QFX is what you want. If you use a different accounting software (Xero, Sage, Wave), OFX is more compatible. US Bank does not offer OFX, so QFX users on non-QuickBooks software will need a converter.

There is no combined statement feature. Each account is downloaded separately. The 18-month QFX limit applies per account. This is one of 10 banks covered in our US bank export guide.

How to Download US Bank QFX Step by Step

The QFX export is the cleanest path. Here is the click-by-click flow for personal accounts.

1. Log into usbank.com with your Personal ID and Password.
2. Click on the account you want the statement for (e.g., “My Checking Account”).
3. Click “Accounts & Services” in the navigation.
4. Click “Download account activity” in the sub-navigation.
5. Set the date range. The maximum is 18 months.
6. Choose “Quicken (QFX)” from the format dropdown.
7. Click “Download”. The file saves to your default downloads folder.

The file is named something like activity_2024-07-15_to_2026-01-15.qfx. Open it in QuickBooks or convert it through a tool that handles QFX files.

I learned this the hard way the first time a US Bank client needed 18 months of history for an audit. I spent 20 minutes downloading monthly PDFs. Then I found the QFX download, which would have given me everything in one file. The lesson: always check the QFX first, fall back to PDF only when you need older history.

How to Download US Bank PDF Step by Step

The PDF export is in the “Statements & Documents” section. Here is the click-by-click flow.

1. Log into usbank.com.
2. Click on the account.
3. Click “Accounts & Services” in the navigation.
4. Click “Statements & Documents” in the sub-navigation.
5. You will see a list of monthly statements going back 24 months.
6. Click the statement you want. The PDF opens in your browser.
7. Save the PDF (Ctrl+S or File > Save).

The PDF is one file per month per account. For 24 months of history across 2 accounts, you are downloading 48 files. The PDF is well-formatted and a converter that handles US Bank’s standard layout will extract the transactions cleanly.

The 18-Month QFX Limit (and How to Work Around It)

US Bank’s QFX export is capped at 18 months. If you need 24 months, the extra 6 months need the PDF route. The workflow is:

1. Download the QFX for the last 18 months. Convert it. Save.
2. Download the PDFs for the 6 months before that. Convert each one. Save as separate sheets in the same workbook.
3. Combine in Excel or Google Sheets. The columns are the same across QFX and PDF conversions, so this is a simple append.

For most users, 18 months is enough. The 18-month limit is a US Bank portal limit. Older data exists in US Bank’s archives. Getting it requires the PDF route or a phone call to customer service.

US Bank Business Accounts: A Better Path

If you have a US Bank business account (Business Checking, Business Savings, Business Credit Card), the export flow is significantly better than personal accounts. The “Download transactions” feature inside the business account page gives you 12 months of OFX in a single download.

1. Log into usbank.com.
2. Click on the business account.
3. Click “Account services” in the navigation.
4. Click “Download transactions” in the sub-navigation.
5. Set the date range (up to 12 months).
6. Choose “Comma-delimited (CSV)” or “Money (OFX)” from the format dropdown.
7. Click “Download”.

The CSV option is the cleanest. The file opens directly in Excel with Date, Description, Amount, and Balance as separate columns. The OFX option works in QuickBooks and most accounting software.

For business credit cards, the export flow goes through US Bank’s “Access Online” portal, which is a separate login for business credit card customers. The export options there are CSV (24 months) and OFX (24 months). The CSV is clean and works directly in Excel.

If you are a US Bank business customer, use the business account path. It is dramatically cleaner than the personal account path.

US Bank Credit Card Statements

US Bank credit cards (Cash Plus, Altitude Connect, Altitude Reserve) are managed through the same site as personal banking. The export flow is the same as for personal checking: PDF (24 months) and QFX (18 months).

For credit cards, the QFX file includes merchant category codes (MCC, a 4-digit number) and the card member name (if you have multiple cards on the same account). The PDF includes the same data plus any reward point information.

For business credit cards, the Access Online portal gives you 24 months of CSV or OFX. This is the cleanest path for business credit card statements.

US Bank Regional Coverage

US Bank is a regional bank with the strongest presence in the Midwest and West. The states with the most branches are California, Minnesota, Colorado, Oregon, Washington, and Wisconsin. The export flow is consistent across regions, so this guide applies whether you bank in Minneapolis, Denver, Portland, or San Francisco.

For customers in regions where US Bank has fewer branches (Northeast, Southeast), the online portal is the only access point. The export options are the same as in the bank’s strong regions. There is no regional difference in the export flow.

US Bank acquired MUFG Union Bank in 2022. Former Union Bank customers were transitioned to US Bank accounts. The export flow for these accounts is the same as for native US Bank accounts.

How to Convert US Bank QFX to Excel

QFX is a structured data file (Intuit’s proprietary version of OFX). A converter that handles QFX will read the file and produce a clean Excel file with the transactions.

The output has Date, Description, Amount, and Balance as separate columns. For credit cards, there is an additional column for the merchant category code. The date format is YYYY-MM-DD. The amount format is positive for deposits, negative for withdrawals.

The conversion takes 5 to 10 seconds per file. The output is clean. You can open it in Excel or Google Sheets and start working with the data immediately. For QuickBooks users, the QFX is the cleanest path. Our QuickBooks conversion guide covers the import dance.

How to Convert US Bank PDF to Excel

PDF is harder. The transactions are in a 4-column table inside the PDF. A converter needs to recognize that table, extract the rows, and write them as a spreadsheet.

US Bank’s PDF layout is standard. Most modern converters handle it. The 2am test: if the converter does not produce a clean Excel file on the first try, try a different one. A good converter should handle US Bank’s PDF on the first try. For the broader workflow, our general PDF-to-Excel conversion guide covers the 5-point validation check.

The output for a PDF conversion has the same columns as the QFX output: Date, Description, Amount, Balance. The date format may be MM/DD/YYYY instead of YYYY-MM-DD. Check the format and convert it in Excel if needed.

The 2am Test for US Bank Conversions

If you are converting US Bank statements at 2am, here is the flow that works.

1. Open usbank.com. Log in.
2. Click the account. Click “Accounts & Services”. Click “Download account activity”.
3. Set the date range. Choose QFX. Click Download.
4. If you need more than 18 months, click “Statements & Documents” instead. Download PDFs for the older months.
5. Open the QFX file in a converter. Save the output as one sheet.
6. Open each PDF in a converter. Save the output as separate sheets in the same workbook.
7. Combine the sheets in Excel or Google Sheets.

If the converter gives you a file with merged cells, broken dates, or chopped descriptions, the converter is not handling US Bank’s format correctly. Try a different converter. The QFX format is standard, not custom. A good converter should produce clean output every time.

A common failure mode bookkeepers report is treating this as a single operation rather than a chain of dependent steps. The temptation is to find a tool that ‘just works’ and stop investigating the mechanism. The result is a wrong-fix cycle: the tool gives partial output, the bookkeeper spends 30+ minutes troubleshooting, the fix is for the wrong step, and the same error recurs on the next statement. The fix: identify which step failed and apply the right intervention to that step.

What to Do With Multiple US Bank Accounts

If you have multiple US Bank accounts (checking, savings, money market) and need them all in one file, the workflow is the same as for a single account: download the QFX for each, convert each, combine in Excel.

For business customers, the OFX download in the business account gives you the same data in a single file per account. The CSV option gives you a clean file that opens directly in Excel. Our batch conversion guide shows the desktop converter setup that handles 100+ statements at once.

US Bank does not offer a combined statement feature. Each account is downloaded separately. The 18-month QFX limit applies per account.

For a deeper look at the conversion step, see our general guide to converting bank statements to Excel. For QuickBooks users, see our QuickBooks-specific conversion guide. If you have multiple banks to convert at once, see our batch conversion guide. For the full map of which bank gives what, see our US bank export guide. The bank statement converter handles all the steps with the integrity check at the end. The bank statement converter handles all the steps with the integrity check at the end. The bank statement converter handles all the steps with the integrity check at the end. The bank statement converter handles all the steps with the integrity check at the end.