PDF2TEXT
Try a statement free

Convert Capital One statements to Excel

Capital One's website lists two years of past transactions, but statements go back seven years once you're enrolled in paperless statements. For anything older than the transaction list, or anything a lender or accountant wants as an official record, the statement PDF is the source. This page covers what's specific to Capital One bank statements and how they come out after conversion.

Page 1 free, no sign-up to see it; just an email to download. The whole document is one payment: $9 up to 25 pages, priced by page count above that. No subscription.

See pricing

98% of numbers correct on 82 hand-checked pages How we measure

How to get your Capital One statement into Excel

  1. Download the PDF statement from Capital One online banking

    • Sign in to Capital One online or the Capital One Mobile app.
    • Online, click the account, then 'view statements'; in the app, tap the account, scroll to the bottom of the page, and tap 'statements'.
    • Open the statement for the period you need.
    • Save the statement for the period you need as a PDF.
    Go to Capital One Online Banking

  2. Upload it here

    Scans and phone photos work too.

  3. Download Excel, CSV, or QuickBooks and Xero CSV

    Check the rows against the statement, then export.

Sample result

Your Capital One statement in Excel

Made-up sample rows, not a real statement.

sample-statement-2026-01.xlsx Jan 2026 · USD
Sample bank statement rows with made-up data, amounts in USD
Date Debit Credit Balance
2026-01-02 Salary - Example Employer Ltd 2,500.00 3,500.00
2026-01-05 Card payment - Sample Grocery Co 120.00 3,380.00
2026-01-09 Rent - Placeholder Properties 1,200.00 2,180.00
2026-01-14 Transfer from savings 300.00 2,480.00
2026-01-20 Utility bill - Demo Energy Co 80.00 2,400.00
2026-01-27 Card payment - Fictional Coffee Co 15.00 2,385.00

Statement notes

What to know about Capital One statements

Dates that skip the year

Capital One prints transaction dates without the year and leaves it to the statement period. The converter reads that period and completes each date, including on statements that cross from December into January, then writes them as YYYY-MM-DD.

Several accounts, one statement

Capital One combines Direct accounts into one statement on its own, so a single PDF can hold more than one account's activity. Check which account each section belongs to before importing, and post each to its own bank account in your books.

When statements arrive

Bank statements are typically generated online by the 6th of each month, and a savings account with no activity may only get a quarterly one. That's fine for conversion. What matters is that each statement starts where the previous one ended, which is exactly what the period check looks at.

Not every check has an image

Check images usually appear online within a business day, but some never do, such as bill pay checks and checks converted to electronic payments. When you're ticking off checks against the converted rows, match those by amount and date instead.

Output and review

From Capital One PDF to your books

Accounting tip

When you upload a CSV to QuickBooks Online or Xero, you tell it which column holds the date, description and amount; the ready-made file for each makes that a quick confirmation. Code savings interest apart from transfers so the year's interest is easy to pull.

  • Checked before export

    Opening balance plus transactions is checked against the closing balance. Duplicate or missing periods are flagged.

  • Export formats

    Excel, CSV, JSON, or QuickBooks and Xero CSV.

    Files for QuickBooks Online

    Files for Xero

  • Private workspace

    HTTPS uploads, kept private until you ask support to delete them.

FAQ

Capital One statement questions

Can I convert a Capital One credit card statement?
Yes. Rewards and cash back credits can sit among the transactions on a card statement. They come out as credits, the same direction as a payment, so give them their own category when you import or your payments total will look higher than what you actually paid.
Why can't I see seven years of statements?
Capital One shows up to seven years of bank account statements online once you're enrolled in paperless statements. If you see fewer, check your statement delivery setting. The website's transaction list is a separate thing and only covers two years.
Can I import converted Capital One rows into QuickBooks or Xero?
Yes. Review the rows, then export a QuickBooks or Xero CSV.

Convert your Capital One statement to Excel

Page 1 free, no sign-up to see it; just an email to download. The whole document is one payment: $9 up to 25 pages, priced by page count above that. No subscription.

More Bank Statement Converters

View all 98 bank pages

United States

Next steps

pdf2text is independent and not affiliated with or endorsed by Capital One.