Home › Guides › Capital One

Capital One statement PDF to CSV or QBO

How to get Capital One statements out as PDFs, what Capital One already exports natively, and how to turn the PDF into a CSV or QuickBooks .qbo file that's checked against the statement's own balances.

Statement history online

up to 7 years of statements online for active accounts (paperless enrollment required)

Native CSV/QFX/QBO download

Website transaction list covers 2 years. Capital One doesn't publish a native QBO/CSV export on the pages we checked

Best use of a PDF converter

Capital One's US help pages describe a 2-year web transaction list and 7 years of statements. For anything older than 2 years, the statement PDF is the record. (Capital One Canada lists CSV/QFX/QBO downloads, but that's a different bank site.)

What Capital One says

• Capital One says you can view up to 7 years of statements online for active accounts, via Sign in → account → “view statements”, and that viewing them requires enrollment in paperless statements. [source]
• Capital One's transaction-history help says the website shows the past two years of account activity, and that statements include the past seven years. [source]
• Savings statements may be quarterly when there's no activity, and statements are typically generated by the 6th of each month (same page). [source]

Convert a Capital One PDF statement to CSV or QBO

1. Download the statement PDF from Capital One online banking (see above). Use the downloaded PDF, not a scan or a phone photo.
2. Open StatementHaul and drop the PDF in. It's read in your browser with pdf.js.
3. Look at the result: Reconciled means opening + credits − debits equals the printed closing balance. If it doesn't, the first row that breaks is highlighted.
4. Download the CSV or the .qbo file.

Importing into QuickBooks

QuickBooks Online's CSV upload accepts a 3-column (Date, Description, Amount) or 4-column (Date, Description, Credit, Debit) layout. [Intuit] StatementHaul's CSV has more columns (Date, Description, Amount, Debit, Credit, Balance, Page), so delete the extra columns first or map them in the upload step. The .qbo file is OFX 1.02 Web Connect with a generic bank ID. QuickBooks Online imports it under Banking › Upload transactions. QuickBooks Desktop is stricter about bank IDs and may refuse it, in which case use CSV.

StatementHaul's parser is generic: it reads standard text-based PDF statements by column position. We have not tested it on Capital One statements specifically. As of October 2026 it has been tested on 11 public sample statements (a US bank, two US credit unions and open-source test sets) plus 4 synthetic ones. Scanned or image-only PDFs are not supported. The balance check tells you on screen whether the rows add up to the printed closing balance, and a statement that fails to parse isn't counted against your free statements.

Sources

1. Capital One Help: Online bank statements (checked 2026-10-23)
2. Capital One Help: How to view transaction history (checked 2026-10-23)
3. Intuit: Format CSV files to get bank transactions into QuickBooks (checked 2026-10-23)
4. Intuit: Manually upload transactions into QuickBooks Online (checked 2026-10-23)