Capital One statement to QuickBooks, Xero or CSV: step by step

There are two ways to get Capital One data out: a transaction download for recent activity, and PDF statements for everything older or anything that must match the bank's printed balances.

1. Recent activity: use Capital One's download

In your account, open transactions and choose Download Transactions, then select the date range and format (CSV, QFX or QBO where available). Formats usually offered: CSV and, for many accounts, QuickBooks (QBO/Web Connect) or Quicken (QFX). If QuickBooks Web Connect (.qbo) is offered, use it: it imports without column mapping. The date range on offer is shown in the download dialog, and it is usually much shorter than the statement archive.

2. Older months: download the PDF statements

Find Statements on the account page and download each statement PDF. Save one PDF per month, and name each file with the account's last 4 digits and the statement period (e.g. 4821_2025-03.pdf) so nothing gets skipped.

3. Convert and tie out each month

1. Extract date, description, signed amount and (if printed) running balance.
2. Check: opening balance + all amounts = closing balance on the statement.
3. Chain the months: each closing balance must equal the next month's opening balance.

Capital One-specific things to watch

• Capital One card CSVs use separate Debit and Credit columns, which match QuickBooks's 4-column layout.
• The download dates can be posted dates rather than transaction dates. Use one convention consistently so the months tie.
• Checking (360) statements and card statements have different layouts, so convert them as separate accounts.
• Using Xero instead? See Capital One to Xero.

Importing the result into QuickBooks Online

1. In QuickBooks Online go to Transactions → Bank transactions, open Link account ▾ → Upload from file.
2. Choose the .qbo, .qfx or CSV file. Intuit's limits are 350 KB and 1,000 lines per file, so split long periods.
3. Pick the matching QuickBooks account, map columns (CSV only), then review everything in For review.
4. If the account is already connected to a bank feed, upload only dates before the feed started, or you will create duplicates.

Then reconcile each month against its statement. If QuickBooks says the beginning balance is off, see fixing a beginning balance discrepancy.

Bank menus change; labels here were accurate to our knowledge in Oct 2026, so check your bank's help pages if something differs.