How to Import US Bank Transactions into QuickBooks (QBO, CSV)

There are three ways to import U.S. Bank transactions into QuickBooks: connect the live bank feed, download a QBO (Web Connect) file and upload it, or convert the PDF statement to QBO or CSV. The feed and the QBO download cover recent activity, roughly the last 90 days to 18 months. For anything older, a closed account, or a statement you only have as a PDF, converting the statement is the route that works.

Here is how each method works, when to use it, and the limits that decide the choice.

How do I import US Bank transactions into QuickBooks Online?

Pick one of three paths based on how far back you need to go. For the current period, connect U.S. Bank as a live feed or upload a QBO file downloaded from usbank.com. For older history or closed accounts, convert the PDF statement to a QBO or CSV file and upload that. QuickBooks Online never reads a PDF directly, so a statement always has to become a QBO or CSV file first.

Method 1: Connect the US Bank feed

In QuickBooks Online, go to Transactions, then Bank transactions, and select Link account. Search for U.S. Bank, sign in with your online banking credentials, and choose the accounts to connect. The feed pulls about 90 days of history to start and then updates daily. This is the easiest option for keeping current, but it will not reach back further than roughly 90 days on the first connect, so it is not the tool for a prior-year cleanup.

Method 2: Download a QBO file from US Bank

Sign in at usbank.com, open the account, and use the download or export option. Choose the QuickBooks (Web Connect) file type and a date range within the roughly 18-month window U.S. Bank keeps online. Then in QuickBooks Online go to Transactions, Bank transactions, and under the Link account dropdown pick Upload from file. Select the .qbo file, confirm the account, and the transactions land in the For review tab. In QuickBooks Desktop, use File, Utilities, Import, Web Connect Files instead.

This is a clean route when the activity you need is inside the last 18 months. Past that window, the download stops offering the transactions, and you move to the statement.

Method 3: Convert the PDF statement to QBO or CSV

When the history is older than about 18 months, sits in a closed account, or only exists as a PDF someone emailed you, convert the statement. U.S. Bank keeps online statements as PDFs for years, well past what the activity export reaches. Upload the PDF to a converter that outputs a QBO file, then import it exactly like a bank download. The US Bank statement to QBO converter reads each transaction, signs debits and credits correctly, and writes the Web Connect file QuickBooks expects, so the register reconciles to the statement balance without hand fixes. If you would rather work in a spreadsheet first, the same upload also produces a clean US Bank Excel or CSV file.

This is the method bookkeepers rely on for catch-up work, because it is the only one that reaches history the feed and the online download have already dropped.

QBO or CSV: which should I import?

Prefer QBO. A Web Connect file carries the account, dates, and signed amounts already mapped, and QuickBooks uses it for duplicate detection, so there is nothing to configure. CSV is the fallback when you want to review or edit the rows first, or when a large period would exceed the QBO import cap. QuickBooks Online limits any single upload to 1,000 transactions and 350 KB, so a very heavy account may need to be split into batches by date range. A general-purpose bank statement to QuickBooks converter handles the same PDF-to-QBO workflow when the books also pull in statements from other banks.

Why won't QuickBooks pull my older US Bank transactions?

Because the live feed only backfills about 90 days and the online download reaches about 18 months. Neither is designed to load years of history. QuickBooks is not broken and the account is not misconfigured; the limit is on how far back U.S. Bank hands data to the feed and the export. The fix is to work from statements for the older periods, which is standard practice for cleanups, migrations, and audits.

Frequently asked questions

Short answers to the questions that come up most when loading U.S. Bank activity into QuickBooks.

Does US Bank work with QuickBooks?

Yes. U.S. Bank supports a live QuickBooks bank feed and a QuickBooks (Web Connect) file download for recent activity. For history older than about 18 months or for closed accounts, you convert the PDF statement to a QBO or CSV file and import that.

How far back can I import US Bank transactions into QuickBooks?

The live feed backfills about 90 days and the online download reaches about 18 months. Beyond that, there is no time limit through statement conversion: U.S. Bank keeps online statements as PDFs for years, and each one converts to a QBO or CSV file you can import.

Can QuickBooks import a US Bank PDF statement directly?

No. QuickBooks accepts QBO, QFX, and OFX in the bank feed, with CSV as a manual fallback, but it cannot read a PDF. Convert the U.S. Bank PDF to a QBO or CSV file first, then upload it the same way you would a bank download.

Why does the US Bank feed only show 90 days in QuickBooks?

Because a newly connected feed backfills roughly 90 days and then stays current. It does not pull years of history on connect. To load the earlier months, download the QBO file for what is still online and convert the PDF statements for anything older.