Capital One bank statement to Excel
Upload a Capital One checking or savings statement PDF and download every transaction as Excel or CSV, checked against the opening and closing balance printed on it. Converting a Capital One credit card statement? Use this page.
Several statements? Combine monthly PDFs into one workbook.
Kit Rx keeps no copy of your file. Anthropic, the AI provider that reads it, receives the PDF and may keep API inputs for a limited period under its own policy. How your file is handled.
Get your Capital One statement as a PDF
On capitalone.com
- Sign in and click the account.
- Click view statements and choose the month.
In the Capital One Mobile app
- Sign in and tap the account.
- Scroll to the bottom of the page and tap statements.
If no statements show
- Viewing statements online needs paperless enrollment: click any open account, then Account Services & Settings > Paperless. A valid email address must be on file.
Capital One's help center says you can view up to 7 years of statements online for active accounts. Bank statements are typically generated online by the 6th of each month; savings accounts with no activity that month get a quarterly statement instead.
Transaction history vs statements, and when this converter helps
On the website, Capital One's past transactions list covers the last two years. For anything earlier, Capital One points you to the statements, which include seven years of transaction history. Its help pages on statements and transaction history do not describe a spreadsheet export.
To get a month as a spreadsheet, download the statement PDF for that month, convert it here to Excel, CSV, QuickBooks Online CSV, or Xero CSV, and check the rows against that statement's balances.
Tips for Capital One statements
- Capital One says Direct accounts are automatically combined into one statement. If a PDF covers more than one account, save each account's pages as their own PDF so each gets a clean balance check.
- A quiet savings account may have only four statements a year, since Capital One generates them quarterly when there is no activity. Each converts the same way as a monthly one.
What you get
- One row per transaction: date, full description, signed amount, running balance where printed, and the page it came from.
- Deposits as money in; withdrawals, checks, card purchases, and fees as money out.
- A balance check: opening balance plus deposits minus withdrawals must equal the closing balance. Rows that don't fit are highlighted.
- Downloads for Excel, CSV, QuickBooks Online, and Xero.
Capital One statement questions
How far back can I see Capital One bank statements?
Up to 7 years online for active accounts, according to Capital One's help center. You need to be enrolled in paperless statements to view them online.
When is my Capital One bank statement ready?
Capital One says bank statements are typically generated online by the 6th of each month. Savings statements are quarterly when there is no activity to prompt a monthly one.
Is it safe to upload my Capital One statement?
Your Capital One statement is processed in memory and is not stored by Kit Rx. It is read by Anthropic's Claude model through its commercial API, and Anthropic may keep API inputs for a limited period under its own policy. The result goes straight back to your browser. Details are on the privacy page.
Is Kit Rx affiliated with Capital One?
No. Kit Rx is independent and is not affiliated with or endorsed by Capital One. The name is used only to say which statements the converter reads.
Menu names, export options, and time limits above come from Capital One's own help pages, checked 2026-11-15: Capital One Help: Online bank statements; Capital One Help: Transaction history; Capital One Help: Get paperless statements. Menus change; if yours look different, those pages have the current wording.