Skip to content

How to Import U.S. Bank Transactions into QuickBooks (Bank Feed, QBO, CSV)

By ConvertQBO Team ·

U.S. Bank is one of the easier banks for QuickBooks: online banking offers a real QuickBooks (.qbo) download with up to 3 years of history, and the QuickBooks Online connection is free. The exception is SinglePoint (commercial) accounts. Here are the options.

Option 1: connect the account (bank feed)

QuickBooks Online: U.S. Bank says the connection comes “at no extra cost”. Go to Banking → Connect account, choose U.S. Bank, sign in with your online banking ID and select how far back to download. You need a personal or business checking account with online banking.

QuickBooks Desktop (Direct Connect): U.S. Bank offers Direct Connect with bill pay for Quicken and QuickBooks; you enroll by calling 800-987-7237, option 2. On its Quicken page, U.S. Bank lists the fee as $3.95 a month (first two months free) and says Web Connect is free. Confirm the QuickBooks price when you call.

SinglePoint (commercial): in QuickBooks Online, search for SinglePoint (U.S. Bank Commercial Internet Banking), not “U.S. Bank”. SinglePoint asks for a company ID as well as a user ID. Users in the QuickBooks Community report that the connection has been unreliable since SinglePoint added two-step sign-in, and that SinglePoint support said it doesn’t support QuickBooks Direct Connect. If it won’t connect, export a file from SinglePoint and use Option 3.

Option 2: download a QuickBooks (.qbo) file

  1. Sign in to U.S. Bank online banking on a computer (downloads aren’t available in the mobile app).
  2. Open the account and click the download icon at the top right of the Transactions tile.
  3. Choose the date range (up to 3 years) and QuickBooks (.qbo). The other choices are Quicken (.QFX) and Spreadsheet (.CSV).
  4. Import the file:
    • QuickBooks Desktop: File → Utilities → Import → Web Connect Files, then review in the Bank Feeds Center.
    • QuickBooks Online: Banking → Link account ▾ → Upload from file.

If QuickBooks Desktop refuses the file (“unable to verify the Financial Institution information”), Intuit’s steps are: download it again, switch Bank Feeds to Classic (Register) mode, and test the import in a new company file.

Option 3: CSV or QFX to QBO

Use this for a SinglePoint export, a file someone sent you, or a .qfx you already downloaded:

  • Quicken (.qfx): QFX to QBO keeps dates, payees and transaction IDs.
  • Spreadsheet (.csv): CSV to QBO. Check the preview: money out negative, money in positive. For a credit card, choose Credit card as the account type.

Then import the .qbo file as in Option 2.

QuickBooks Online errors 103 and 187

Both appear when QuickBooks can’t finish signing in to U.S. Bank:

  • Error 103 — the username or password QuickBooks has is wrong. Click the account’s Edit sign-in info in Banking and enter the current one.
  • Error 187 — a security question or one-time code wasn’t completed. Sign in to the U.S. Bank website first and finish any prompts there, then update the account in QuickBooks.

More codes: QuickBooks bank feed errors.

Tips

  • Start each download the day after the last transaction already in QuickBooks, so you don’t import duplicates.
  • Don’t import the same dates through both the bank feed and a file.
  • On QuickBooks Desktop 2023 or older, bank downloads stopped after May 31, 2026: Desktop bank feeds not working.

Sources

Read November 4, 2026: U.S. Bank QuickBooks, Quicken, download transactions; QuickBooks Community: U.S. Bank SinglePoint, errors 103 and 187; Intuit: fix Web Connect import errors.

Report a problem

Something does not convert or looks wrong? Tell us — we read every report. Please don’t paste real bank data.