# How to Download QBO File from US Bank

- Author: SimpleBankConvert (https://simplebankconvert.com)
- Published: 2026-10-17
- Category: Downloads from your bank
- Canonical: https://simplebankconvert.com/blog/how-to-download-qbo-file-from-us-bank

> How to download a QBO file from US Bank for QuickBooks: the export screen, picking QuickBooks rather than Quicken, and the date range to request.
To download a QBO file from U.S. Bank, sign in to online banking on a computer, open the account, find the option to download or export transactions, pick the QuickBooks format rather than Quicken, and enter a date range that starts the day after your last QuickBooks entry. Then upload that `.qbo` file into the matching QuickBooks account.

## Finding the export screen in U.S. Bank online banking

U.S. Bank's transaction export lives inside each account's activity view in online banking, normally behind a link or button labelled with a word like Download or Export. This post does not quote the bank's current menu text, because banks rename menus often. Go by what your own screen shows.

The general path, to check against your screen:

1. Sign in to U.S. Bank online banking in a desktop browser rather than the app.
2. Open the account you want: business checking, savings or a credit card.
3. On the account's activity page, look for the download or export control near the transaction list.
4. Choose the QuickBooks file type.
5. Enter the From and To dates.
6. Download, and save the `.qbo` file to a folder you use for bank files.

If you cannot see an export option at all, switch from the app to the full website first, since download controls are easiest to find there. If it is still missing, the bank's support team can tell you whether your account type offers a QuickBooks file.

## U.S. Bank QuickBooks or Quicken file: which one to choose?

Choose the QuickBooks option. It produces a `.qbo` file, also called a Web Connect file, which is the type both QuickBooks Online and QuickBooks Desktop read. The Quicken option produces a file for Quicken, and QuickBooks Desktop's Web Connect will not open it.

The two choices sit next to each other on most export screens, and they look alike, which is why this mix-up is so common. Before you download, read the label once more. The end of the saved file's name tells you what you got: `.qbo` is right for QuickBooks, `.qfx` is the Quicken type.

Intuit says on its [QuickBooks Desktop bank feeds page](https://quickbooks.intuit.com/learn-support/en-us/help-article/bank-feeds/download-bank-feed-transactions-quickbooks-desktop/L8o0Aw9VM_US_en_US) that Web Connect only works with `.qbo` files, so QFX and QIF downloads will not import there. QuickBooks Online is a little more forgiving. Its file upload takes CSV, TXT, QBO and OFX, but QBO is the one Intuit suggests because it needs no column matching.

What if you picked Quicken by mistake? Go back to the export screen and download the same dates again as QuickBooks. That takes a minute. Renaming a `.qfx` file to `.qbo` is not a reliable fix.

### When a spreadsheet export is the better pick

If U.S. Bank offers a spreadsheet or CSV choice, it suits two cases: you keep your books in Xero, or you want to open the data in Excel before importing. For plain QuickBooks imports the QBO file is quicker.

## The U.S. Bank date range to request for each QBO download

Ask for dates that start the day after the newest transaction QuickBooks already holds for that account, and end on the last day you want to bring in. For a brand-new QuickBooks account, start at the opening balance date instead. That one rule prevents both gaps and duplicates.

Intuit's page on [uploading transactions manually](https://quickbooks.intuit.com/learn-support/en-us/help-article/import-transactions/manually-upload-transactions-quickbooks-online/L0rE9OXBz_US_en_US) gives the same guidance: for an account that already has transactions, use the day after the last one, and for an account with none yet, match the opening balance date. It also limits a single upload to 1,000 lines and 350 KB.

### A worksheet for three common cases

The rows below use example dates to show how the rule plays out.

| Situation | Last date already in QuickBooks | From date to request | To date to request |
| --- | --- | --- | --- |
| Monthly catch-up | 2026-08-31 | 2026-09-01 | 2026-09-30 |
| New QuickBooks account, opening balance on 2026-01-01 | none | 2026-01-01 | today |
| Gap after a feed stopped | 2026-05-12 | 2026-05-13 | the day before the feed resumed |

The third row is the one people get wrong. If a bank feed broke and then reconnected, the feed may already hold lines from the day it came back. Stop your file the day before, or you will import that day twice.

Write the dates down before you sign in. Typing a range from memory at the bank's export screen is how a month gets skipped.

### Leave today out of a catch-up range

Transactions from the last day or two may still be pending at the bank, and a pending card charge can change amount or vanish before it posts. If you end the range on today's date, you may import a line that the bank later drops or alters. End the range a couple of days back, then pick up from there next time. The small delay costs nothing, and it keeps your QuickBooks register in step with what the bank finally posts.

## What if the U.S. Bank export stops short of your start date?

Every bank caps how far back an export reaches, and U.S. Bank sets its own window. If the earliest transaction in your file is later than the From date you typed, you have hit that cap. The months before it need to come from PDF statements, which the bank keeps separately.

You can find the cap quickly:

1. Request a range starting further back than you need.
2. Open the file in QuickBooks's review screen, or in a text editor without saving, and find the earliest date.
3. Note that date. It is the edge of the window for this account today.

The edge moves forward every day, so a month that is inside the window now may fall outside it in a few weeks. If you are catching up on old bookkeeping, download the oldest months first.

For the months beyond the window, download the monthly statements as PDFs from the statements section of online banking. QuickBooks Online's manual upload can also read a PDF statement for you to review. SimpleBankConvert is being built to turn those PDFs into a CSV or QBO file that QuickBooks Online accepts, and while accounts are not open yet you can [see a sample on the homepage](/).

## U.S. Bank card, savings and checking exports kept apart

Each U.S. Bank export covers one account. A business with checking, savings and a credit card makes three downloads and uploads each into its own QuickBooks account. Combining them in one QuickBooks account mixes card charges with checking withdrawals and wrecks both balances.

Card accounts need a little extra care. In QuickBooks, a credit card account counts charges as money you owe, not money you spent from the bank. Upload the card file into a QuickBooks account set up as a credit card, not a bank account. If the amounts come in with the wrong sign, QuickBooks Online's review screen offers a reverse-values option, which Intuit describes in its guide to uploading transactions manually.

A tidy naming scheme helps when there are several accounts:

- `usb-checking-2026-09.qbo`
- `usb-savings-2026-09.qbo`
- `usb-card-2026-09.qbo`

Upload them one at a time, and pick the QuickBooks account carefully on each upload screen. The dropdown remembers your last choice, which makes it easy to send the savings file into checking.

## Duplicate U.S. Bank lines after a second QBO upload

Duplicates come from uploading the same days twice: once from an earlier file, once from a new one whose range overlapped. QuickBooks may not catch every repeat, so a payment on the overlapping day can appear twice in For review. The fix is to exclude the extras before you accept them.

How to spot the problem before it reaches your reports:

- Sort the For review list by date and look for pairs with the same date, amount and description.
- Compare the total of a month's imported lines with that month's statement.
- Keep a log of the date range of every file you uploaded.

If duplicates were already accepted, you need to see what QuickBooks holds before you clean up. [Exporting bank transactions from QuickBooks Online](/blog/export-bank-transactions-from-quickbooks-online) shows how to get that list into a spreadsheet, where pairs stand out when you sort by amount.

A bank feed and a file upload into the same account can also double up. Choose one of them for each stretch of dates, not both.

### QuickBooks Desktop handles repeats differently

Desktop users meet a different version of this problem. Intuit's QuickBooks Desktop bank feeds page says you cannot download the same transactions into the same company file more than once, and it advises backing up the company file before a download. So keep every U.S. Bank file's range clear of the last one. Make the backup, keep the ranges clean, and the question never comes up.

## How PNC and TD Bank QBO exports differ from U.S. Bank's

The routine carries over: open the account, find the export, choose QuickBooks, set dates, upload. What differs is where the export control sits, what each bank names its formats and how much history each allows. Learn each bank's window by testing it rather than assuming U.S. Bank's applies.

If your business banks in more than one place:

- [Downloading a QBO file from PNC](/blog/how-to-download-qbo-file-from-pnc) walks through PNC's export screen.
- [Downloading a QBO file from TD Bank](/blog/how-to-download-qbo-file-from-td-bank) covers TD's version.

Whatever the bank, keep the same three checks: the file ends in `.qbo`, the first and last dates match what you asked for, and the month's totals match the statement.