How to Import a U.S. Bank Statement into QuickBooks (and Xero)

You have a U.S. Bank PDF statement and you need it inside QuickBooks. Maybe it's a business checking account with a heavy ePayments section. Maybe the statement has a long Itemized Service Charges block at the back and you don't want to retype $0.12 cents at a time. Maybe you're onboarding a year of history for a client. The PDF is structured but dense, and QuickBooks doesn't accept it directly.

This is the workflow. Four steps. The same flow handles Xero - you just swap the export format.

Want to use this guide on your blog? Copy this embed code:

---

Why You Can't Just Upload the U.S. Bank PDF

QuickBooks Online accepts file uploads in .qbo, .ofx, .qfx, and .csv. It does not accept PDF directly for bank imports - the bank-feed PDF upload feature is for occasional gap-filling on connected accounts and silently degrades to OCR with mixed results.

Xero supports .ofx, .csv, .qbo, .qfx, and .qif. Same constraint: no PDF.

The workflow starts with a format conversion. For format details, see our QBO vs CSV vs OFX guide.

---

Step 1: Download the U.S. Bank PDF

1. Sign in at usbank.com
2. Open the account you need
3. Click My Accounts -> Statements & Documents
4. Pick the statement period
5. Click View / Download PDF

U.S. Bank keeps up to 7 years of statements available this way. If you opted into Image Statements (check images embedded in the PDF), the file may be 5-10 MB instead of the 200 KB a textual statement would be - download both formats if you need them.

---

Step 2: Upload to PDFSub

Open PDFSub's Bank Statement Converter. Drag the U.S. Bank PDF into the drop zone or click to browse.

PDFSub recognizes the U.S. Bank template automatically. The extraction runs server-side and the file is not persisted.

U.S. Bank-specific handling that PDFSub does automatically:

• Paired Withdrawals and Deposits columns are mapped to a single signed amount (negative for withdrawals)
• The ePayments section is treated the same as Other Withdrawals - both feed into the unified transaction list
• The Itemized Service Charges section at the end of the statement is imported as transactions (each fee posts as a separate line, not lumped into a single "Bank Fees" total)
• Image Statements (PDFs with embedded check images) are handled - check images are skipped during parsing, but the corresponding check transactions are kept
• Daily ending balance lines are excluded from the transaction list
• Date format MM/DD with no year is reconciled against the statement period

---

Step 3: Choose the Right Export Format

Once the data is extracted, pick the format that matches where the data is going:

Destination	Format	Why
QuickBooks Online	.qbo	Native format, no column mapping, automatic duplicate detection
QuickBooks Desktop	.qbo or .iif	QBO via Web Connect, IIF for batch imports
Xero	.ofx	Preferred over CSV - includes account metadata and duplicate IDs
Sage	.csv or .ofx	OFX preferred when supported
Wave	.csv or .ofx	Either works; OFX gets you duplicate detection
FreshBooks	.csv	Only supported import format
Quicken	.qfx or .qif	QFX for modern Quicken, QIF for older versions

For the rest of this guide, we'll use .qbo and .ofx. Click Download in PDFSub and save the file.

---

Step 4a: Import the .QBO into QuickBooks Online

1. In QuickBooks, go to Banking (or Transactions -> Bank transactions)
2. Click Link account in the top right
3. Choose Upload from file at the bottom of the dialog
4. Drag the .qbo file in
5. Select the QuickBooks account this statement belongs to
6. Confirm the date range and click Next
7. Review the parsed transactions in the For Review tab

The .qbo file includes FITID transaction IDs, so QuickBooks skips duplicates on re-import automatically.

File limits: QuickBooks Online caps uploads at 350 KB per file and 1,000 transactions per import. For high-volume business checking, split by month.

---

Step 4b: Import the .OFX into Xero (Same Flow)

1. Go back to PDFSub and export as .ofx instead of .qbo
2. In Xero, navigate to Accounting -> Bank accounts
3. Click on the relevant bank account
4. Click Manage account -> Import a statement
5. Drag in the .ofx file
6. Xero detects the format and parses the transactions
7. Review and confirm

---

Common Errors and Fixes

"File could not be processed" in QuickBooks. Over 350 KB or more than 1,000 transactions. Split by month and re-import.

Service charges missing or lumped together. U.S. Bank itemizes service charges (Monthly Maintenance Fee, Returned Item Fee, Overdraft Fee, Stop Payment Fee, etc.) in a dedicated section at the end of the statement. PDFSub posts each fee as its own transaction with the original descriptor preserved, so they show up individually in QuickBooks - not as a single "Bank Fees" lump.

Image Statement PDF takes forever to upload. Image Statements include embedded check images and can run 5-10 MB. PDFSub parses these without rendering the check images, so processing time stays in the same range as text-only statements. The output QBO file is the same size as it would be for a plain statement.

ePayments mismatched with Other Withdrawals. U.S. Bank breaks digital payments into the ePayments section, separate from checks and ATM withdrawals. PDFSub merges these into a single signed amount column on export, which matches what QuickBooks expects. If you need to preserve the ePayments-vs-checks distinction for reporting, the original section header is captured as a memo field on each transaction.

Different bank than U.S. Bank? PDFSub recognizes 20,000+ bank templates. For a software-agnostic primer on bank statement imports into QuickBooks, see How to Import Bank Statements into QuickBooks Online.

---

When You Already Have U.S. Bank's Native CSV (Limited History)

U.S. Bank offers CSV export from Online Banking -> Transactions -> Download. Catches:

• Only the last ~24 months
• A silent 1,500-transaction cap on the download
• Transaction feed only - no opening balance, no closing balance, no Itemized Service Charges section, no daily balance table

For audit, tax prep, or historical onboarding, the PDF -> PDFSub -> QBO workflow above is the right path.

---

Summary

1. Download the U.S. Bank PDF from usbank.com (up to 7 years; Image Statements include check images)
2. Upload it to PDFSub's Bank Statement Converter
3. Export as .qbo (QuickBooks) or .ofx (Xero, Sage, Wave) - paired Withdrawals/Deposits merged, itemized fees preserved
4. Banking -> Upload from file -> done. No column mapping, automatic duplicate detection

For full U.S. Bank per-section layout (ePayments section, paired columns, itemized service charges, Image Statements), see the U.S. Bank statement explained deep-dive.