Skip to content
stmtai

Convert Capital One card statement PDFs to Excel, QuickBooks and CSV.
QuickBooks Online, Excel files from the PDF.

Capital One does not password-protect its statement PDFs, card or 360. From the same "Statements & documents" menu you can "Download transactions" as CSV, and for some account types OFX or QFX.

Drop your Capital One card statement here

PDF, scan or photo. Up to 12 files at a time.

Not ready to upload your own? See a sample result

5 pages free, no account. Amounts stay in USD.

Last updated

How to download a Capital One card statement as a PDF

  1. Sign in at capitalone.com and click the card or 360 account you want.
  2. Choose "View Statements" (on cards it sits under the "Statements & documents" menu).
  3. Pick the statement period from the list. Active accounts show up to seven years.
  4. Click the download or PDF icon next to that period and save the file.
  5. In the Capital One Mobile app: tap the account, scroll to the bottom of the page and tap "Statements", then pick the month and use the share/save button.

Then drop the file above; several months of Capital One statements at once come back as one workbook.

Is the Capital One PDF password-protected?

Capital One does not password-protect its statement PDFs, card or 360. The file opens as downloaded.

What Capital One statements look like

Credit card statements list Transactions and Payments/Credits in separate sections with a "Trans Date" and "Post Date" column; 360 Checking statements use a single running-balance table.

Card statements run three to five pages and open with a Payment Information box, then an Account Summary that lays out Previous Balance, Payments, Other Credits, Transactions, Fees, Interest Charged and New Balance. The transaction table has two date columns, "Trans Date" and "Post Date", both in MMM DD form, so a purchase made on the 30th can post in the next cycle. Payments and credits appear in their own block above purchases rather than mixed in. 360 Checking statements are a different animal: one running-balance table, MM/DD dates, and if you hold several 360 products they are combined into one PDF with a section per account. Savings accounts with no activity only get a quarterly statement, which surprises people looking for twelve files.

Why not use Capital One's own export?

From the same "Statements & documents" menu you can "Download transactions" as CSV, and for some account types OFX or QFX. The card CSV has Transaction Date, Posted Date, Card No., Description, Category and separate Debit and Credit columns, which is more than most issuers give you. What it lacks is any balance: there is no opening figure, no running balance and no closing figure, so you cannot prove the file is complete. For a single month of a card you already reconcile from bank feeds the CSV is fine; for a year of back-work, or when someone hands you PDFs, converting the statement gets you the totals to check against.

Where Capital One statements trip up converters

  • Two dates per row on card statements; we use the posting date so balances tie out.
  • Card statements reconcile to "Previous balance + purchases + fees + interest − payments − credits = New balance".

Which software Capital One customers import into

Capital One customers most often import into QuickBooks Online, Excel.

Capital One questions

Which of the two dates on a Capital One card statement should I book against?

The posting date. Capital One totals the statement on posted amounts, so a charge with a Trans Date of the 31st and a Post Date of the 2nd belongs to the later statement and the later month. Booking on the transaction date makes the New Balance impossible to tie out. The converter uses Post Date for exactly that reason and keeps Trans Date in the description.

My 360 statement has checking and savings in one PDF. Does that matter?

It does for the balance check. Each section on the PDF has its own beginning and ending balance, and a transfer between the two shows on both. Save the checking pages and the savings pages as separate PDFs (Print to PDF with a page range) and convert each on its own, so each ending balance is checked against its own rows.

Can I get statements for a card I closed?

Online access is quoted as up to seven years for active accounts. Once a card is closed you may lose the "View Statements" list even though the account still appears, and older periods then become a request through the Help Center or by phone. Download the range you need before closing anything.

How do I convert a Capital One card statement PDF to Excel?

Download it from Capital One using the steps above, drop it here, and in about 10 to 40 seconds you get the table, the balance check and the Excel, CSV, QuickBooks, Xero and Tally XML downloads. The first 5 pages are free with no account.

How many Capital One statements can I convert at once?

Up to 12 files at a time, 60 pages each. A year of monthly statements comes back as one Excel workbook with an Overview sheet showing which months balanced, a sheet per month with a Category column, and a Categories sheet totalling the year by category.

Other banks in United States

Comparing converters for Capital One statements? 17 tools that name Capital One or its market, side by side, checked October 2026.

All banks and formats · See a sample result