Home › Bank statement formats › Capital One
Capital One statement formats: CSV, QFX, QBO and PDF
Capital One says the past-transactions list on its website shows two years of history, and statements cover seven years. When a period is outside that window, or you only have the PDF, CSVLedger converts the Capital One PDF statement to Excel, CSV, QBO or Xero CSV in your browser and checks the totals against the printed balances.
Updated October 29, 2026
Sourced from Capital One's own help pages, checked October 29, 2026. Anything we could not confirm on an official page is marked "not verified".
What Capital One offers
| Item | Capital One |
|---|---|
| Native download formats | Not stated on the US help page we checked |
| How far back (transaction download) | Two years of past transactions on the website |
| PDF statements online | Statements include seven years of history |
| Mobile app | Not verified |
Official sources (checked October 29, 2026):
Not verified
- Which download formats US Capital One accounts offer. (Capital One Canada lists CSV, QIF, QFX, QBO and OFX, but that page is for Canadian cards only.)
What a Capital One PDF statement contains
Checking and savings statements must show, under the CFPB's Regulation E (12 CFR 1005.9(b)): the amount and date of each electronic transfer, its type, the account number, fees, and the balance at the beginning and close of the period. Those opening and closing balances are what CSVLedger reconciles against.
Credit card statements must show, under Regulation Z (12 CFR 1026.7): the previous balance, each transaction, credits, fees and interest, the closing date of the billing cycle and the new balance. On a card, purchases increase the balance and payments reduce it, the opposite of a checking account.
These are legal minimums, not a description of this bank's exact layout. We have not verified the layout against real statements from this bank.
Common pitfalls
- Anything older than the two-year transaction list has to come from PDF statements.
- Statements downloaded from online banking are text PDFs and convert directly. Scanned or photographed paper statements have no text layer and are not supported yet.
Convert a Capital One PDF statement with CSVLedger
- Download the statement PDF from Capital One online banking.
- Open the converter for the format you need: Excel, CSV, QBO, Xero CSV or credit card to Excel.
- Drop the PDF. It is read in your browser and not uploaded.
- Check the badge: Reconciled means opening balance + credits − debits equals the printed closing balance (method).
- Download, then import (QuickBooks Online, Xero).
CSVLedger has no per-bank template and we have not tested every Capital One layout; the reconciliation check is what tells you whether a particular statement was read correctly. See all banks in the US bank statement format guide.
Frequently asked questions
Can I download Capital One transactions as CSV or QBO?
Not stated on the US help page we checked. Source: Capital One: transaction history help (https://www.capitalone.com/help-center/checking-savings/transaction-history/), checked October 29, 2026.
How far back can I download Capital One transactions?
Two years of past transactions on the website. For older periods use the PDF statements (statements include seven years of history).
How do I convert a Capital One PDF statement to Excel?
Download the PDF from Capital One online banking and drop it into CSVLedger. It is converted in your browser, reconciled against the opening and closing balances, and exported as Excel, CSV, QBO or Xero CSV.