Capital One statement to Excel or CSV
Capital One keeps up to seven years of bank statements online, but there are two quirks that catch people out: you only see them if the account is on paperless statements, and some accounts arrive combined or quarterly. Here's how to get your PDFs and turn them into a spreadsheet you can trust.
How to download a Capital One bank statement
From Capital One's help center (Capital One):
On the website 1. Sign in to capitalone.com. 2. Click the account you want statements for. 3. Click View statements.
In the Capital One Mobile app 1. Sign in and tap the account. 2. Scroll to the bottom of the page and tap Statements.
Things to know before you look
- You must be enrolled in paperless statements to view statements online. To switch: open any account, then Account Services & Settings > Paperless (a valid email address is required) (Capital One).
- Up to 7 years of statements are available online for active accounts.
- Timing: bank statements are typically generated online by the 6th of each month.
- Savings accounts may be quarterly: if there's no activity to prompt a monthly statement, savings statements are generated quarterly.
- Direct accounts are automatically combined into one statement.
Statement copies downloaded or printed through online banking are free on 360 Checking, per Capital One's fee schedule (Capital One 360 Checking fees PDF).
What to expect inside
Capital One's own guide to reading a statement lists the contents: name and address, account number, statement period with beginning and end dates, starting and ending balances, deposits, withdrawals, electronic fund transfers, credits, debits, fees, interest earned and bank contact information (Capital One). The two quirks above are what matter most for conversion:
- A combined statement has more than one account in a single PDF, each with its own starting and ending balance.
- A quarterly savings statement covers three months in one document.
Common pitfalls converting Capital One statements
- Combining accounts into one table. Split the combined statement by account and reconcile each one separately: each account's starting balance + its deposits − its withdrawals = its ending balance. Mixing them produces totals that never match.
- Transfers between your own Capital One accounts show as money out of one and money in to the other. Correct per account; just don't double count them in a household-level analysis.
- Missing months that aren't missing. A savings account on quarterly statements will have gaps in the monthly list.
- Checking vs credit card statements. Card statements work in reverse (purchases increase the balance owed), so don't reconcile a card PDF with checking logic.
- Interest lines. Small interest credits are easy to drop in a manual copy, and the ending balance won't match without them.
Converting a Capital One statement with Footed
Footed opens the PDF in your browser and sends only the extracted text for parsing; it's processed in memory and not stored. Footed reconciles starting balance + extracted transactions = ending balance, checks against the running balance where the statement prints one, and highlights any row that doesn't agree, which is how a combined statement or a dropped interest line gets caught before it reaches your books. Download Excel, CSV or OFX.
FAQ
Why can't I see my Capital One statements online? The account needs to be enrolled in paperless statements (Capital One).
How far back do Capital One statements go online? Up to 7 years for active accounts.
When does my Capital One statement become available? Typically by the 6th of each month.
Can I import a Capital One statement into QuickBooks or Xero? Yes: convert to CSV or OFX, then follow the QuickBooks or Xero guide.
Convert your Capital One statement. Footed keeps the PDF in your browser and reconciles every account on the statement against its own balances. Free for 5 pages a day.
Published 2026-10-07.