Guide · Capital One
Convert Capital One statements to Excel, CSV or QuickBooks®
Download your Capital One statements, drop them into Pennyrow, and get every transaction as a clean spreadsheet, with a check that each statement adds up. Free. Your statements are read inside your browser; we never upload, receive, see or store them.
Step 1: download your statements from Capital One
- Sign in at capitalone.com.
- Click the account.
- Click View statements.
- Open a statement to view or save the PDF.
- Sign in to the Capital One Mobile app.
- Tap the account.
- Scroll to the bottom and tap Statements.
- Tap a statement to open it.
Checking and savings: up to 7 years. Credit cards: at least 18 months.
Transaction downloads
Capital One also lets you download transactions as a file. Pennyrow reads CSV, OFX and QFX files:
- Transaction download: Open the account and look for Download Transactions near the transaction list. Capital One's help pages don't list the formats.
PDF statements are usually the better choice for catching up a year: each one has opening and closing balances, so Pennyrow can check every month adds up.
Good to know
- Bank statements only show online if the account is set to paperless statements.
- 360 accounts are combined into one statement.
- Discover accounts are moving onto the Capital One website and app.
Checked October 13, 2026 against Capital One's help pages: www.capitalone.com/help-center/checking-savings/online-statements, www.capitalone.com/help-center/checking-savings/transaction-history, www.capitalone.com/digital/credit-cards-paperless-terms-conditions. Banks move menus around; if a step has changed, the help page has the current one.
Step 2: drop them into Pennyrow
- Open Pennyrow and choose your files, or drag them in. A whole year at once is fine, and you can mix Capital One with your other banks and cards.
- Each statement gets a balance check: opening balance plus money in, minus money out, should equal the closing balance. You see "✓ Balanced", or which row is off and by how much.
- Catch-up checks look across all your files: missing months, statements that don't follow on from the last one, the same transaction in two files, and transfers between your own accounts (including card payments) so they aren't counted twice.
- Export: Excel (.xlsx), CSV, a QuickBooks Online bank CSV, a QuickBooks Desktop .iif file, or OFX.
If a Capital One statement doesn't read right
- Pennyrow reads statement layouts with general rules, not a Capital One-specific template, and it hasn't been tried on every Capital One layout. The balance check is how you know: if a statement doesn't balance, Pennyrow shows the row that's off so you can fix it.
- Scanned or photographed statements can't be read (there's no OCR). Download the PDF from Capital One's site instead of scanning a paper copy.
- Password-protected PDFs open with your own password, used only in that tab.
- If a layout keeps failing, tell @minsoesantun which Capital One account type it was. Please don't send the statement itself.
Questions
Is it free?
Yes. Converting statements, the catch-up checks and every export are free.
Does my Capital One statement get uploaded?
No. The converter page is locked so it can't make network requests, and it works with Wi-Fi off once it's open. Here's how to check that yourself.
Do I need to sign in to Capital One through Pennyrow?
No, and you never should. You download the statements yourself; Pennyrow never asks for a bank login.
Does it make a .qbo (Web Connect) file?
Not yet. For QuickBooks Online use the bank CSV export; for QuickBooks Desktop use the .iif export.
Other banks and cards
Any bank or card with text PDF, CSV, OFX or QFX statements can work; these guides cover where to download them.