U.S. Bank CSV to QBO

How to export a CSV from U.S. Bank

1. Sign in at usbank.com and open the account. Above the transaction list there is a download or export control.

   Screenshot: us-bank-export-1

2. Choose the date range or the statement you need. U.S. Bank keeps a limited window of online activity, so export sooner rather than later if you are catching up.
3. Select CSV — listed as "Spreadsheet" or "Comma delimited" depending on the account — and download.

   Screenshot: us-bank-export-2

4. Drop the file into the converter on this page; the U.S. Bank preset is already selected.
5. Check the preview, especially that the payee names look right rather than showing transaction types.
6. Download the .qbo file and upload it in QuickBooks Online.

Online banking screens change; if a label has moved, look for a download or export control above the transaction list.

Known quirks of the U.S. Bank export

Import the .qbo file into QuickBooks

1. Open the upload screen. In QuickBooks Online, go to Transactions, then Bank transactions, and choose Upload from file (on older layouts: Banking, then the arrow next to Update, then File upload).
2. Pick the .qbo file. Drag the .qbo file the converter produced into the drop area and select Continue.
3. Choose the QuickBooks account. Select the bank or credit card account the transactions belong to, or add it first. The account type has to match the one used when converting: a card statement belongs to a credit card account.
4. Let QuickBooks read the file. Web Connect files carry their own column layout, so there is no column-mapping screen — QuickBooks reads the dates, amounts, payees and memos straight from the file.
5. Review and accept. The transactions land in the For review tab. Categorise or match them there; nothing hits the books until you accept them.

QuickBooks Online accepts up to 1,000 transactions per upload. Larger statements are split automatically into numbered files by the converter. Import errors are covered in the import error guide.

Name, not Description

The U.S. Bank export is one of the cleaner ones, with a single quirk that matters: the payee sits in a column called Name. Importers that scan for "description" or "payee" either miss it or fall back to the Transaction column, which contains nothing but the words DEBIT and CREDIT. The result is a register in which every transaction is called DEBIT — technically imported, practically useless.

The preset maps Name to the payee and keeps Memo as the memo, so the check number or the reference the bank recorded stays attached to the transaction without overwriting the merchant.

Check numbers and transfers

Cheque payments arrive with the number in the memo rather than in a dedicated column. If you reconcile by cheque number, use the column mapper to point the check number field at Memo before converting; QuickBooks then shows it in its own column, which makes matching outstanding cheques much quicker.

Export while the window is open

U.S. Bank shows a limited period of online activity for most account types. That is a common reason a catch-up job stalls halfway: the CSV simply does not go back far enough. If you are converting historic months, export the oldest period first and work forward, and keep the raw CSVs — they are your source documents, and re-downloading them later may not be possible.