How to Convert a Capital One PDF Statement to CSV or Excel
Every other major US bank documents an export. Capital One documents none at all, which makes the statements the whole story.
Capital One does not document an export at all
Every other major US bank tells you, somewhere, what you can download and how far back. Chase publishes four formats and a two-year limit. Wells Fargo publishes ninety days extending to eighteen months on some accounts. Bank of America is vaguer but at least names QuickBooks.
Capital One's consumer help centre documents viewing transactions. It does not document downloading them, in any format, for either consumer bank accounts or consumer credit cards. The credit card help index has no topic on statements, downloads or exports at all — every statement topic sits under checking and savings.
What Capital One does state, plainly, is where the history lives:
"Your past transactions list will show the past two years of account activity on the website." … "If you need information prior to the past two years, your statements will include the past seven years of transaction history."
That is the whole architecture: two years you can look at, seven years you can read as statements, and no documented way to get either out as a file.
You will find pages elsewhere confidently describing a Capital One download dialog with a custom date range and a twenty-five month cap. We could not verify any of it against a Capital One source, so we are not going to repeat it. If your account does offer an export, use it. If it does not, the statements do the job.
Quick answer: Capital One shows two years of transaction history online and keeps seven years of statements, with no documented consumer export. Download the statement PDFs from Statements & Documents and convert them to CSV.
What the statements actually contain
Capital One's own published 360 sample statement lays out the activity table as four columns:
| Activity | Date | Amount | Balance |
|---|---|---|---|
| Opening Balance | MM/DD/YYYY | blank | running balance |
| transaction description | MM/DD/YYYY | signed amount | running balance |
| Closing Balance | MM/DD/YYYY | blank | running balance |
Two things there matter more than they look.
One signed Amount column, not split debit and credit. That is good news, because it is the shape Xero's US bank import demands — Xero rejects files with separate debit and credit columns outright. QuickBooks Online accepts either, but caps an uploaded CSV at 1,000 rows and 350 KB, which a multi-year conversion will exceed, so split it by year.
Opening and Closing Balance sit inside the activity table as rows. They carry a Date and a Balance but no Amount. A parser that treats every row in the table as a transaction produces two phantom entries per statement, both with a blank amount, and a total that will not reconcile. They have to be recognised and lifted out as the control totals they are — which is convenient, because those two figures are exactly what you check the extraction against.
The dates on that sample carry the full year, which is more helpful than the bare MM/DD several US banks print. Do not rely on it across products, though: check the December and January rows of any converted statement, because a statement spanning the year boundary is where a missing year silently pushes transactions into the wrong tax year.
Converting the statements (4 steps)
- Open Statements & Documents
Sign in, open the account, and go to Statements & Documents. Statements are listed by period. Paperless enrolment is required for statements to appear online. - Download the statement PDFs
One per statement period. For a tax year that is twelve files, and it is worth collecting them in one sitting rather than returning month by month. - Upload them together
Go to reconcileiq.com/bank-statement-converter and drag the whole set into the PDF to CSV converter. They are returned as one continuous set of transactions. - Reconcile, then download
Each statement prints a beginning and ending balance. If the extracted rows carry you from one to the other, nothing was dropped. Then export the CSV.
What comes out
- Date — one normalized, sortable date column rather than two competing ones
- Description — merchant and reference, with wrapped descriptions rejoined into a single row
- Amount — one correctly signed column, debits negative and credits positive, with the split columns collapsed for you
- Balance — the running balance kept separate so it is never summed as a transaction
Interest charge summaries, rewards balances, minimum payment boxes and the fee tables Capital One prints on card statements are all discarded. They sit in table-shaped blocks that a naive extraction happily reads as transactions, which is the usual cause of a converted card statement that will not reconcile.
Convert Your Capital One Statement
Upload the PDF, check it against the statement's own opening and closing balance, download clean CSV. Your first statement of up to 10 pages converts free on a new account.
Convert your PDF now for freeFrequently Asked Questions
Capital One does not document a transaction export in any format for consumer bank accounts or consumer credit cards. Its help centre covers viewing transactions, not downloading them. Its commercial platform, Intellix, does offer exports including CSV, but that is a treasury product rather than anything a personal or small business customer is using. For consumer accounts the statements are the route to structured data.
Capital One states that the past transactions list shows the past two years of account activity on the website, and that if you need information prior to that, the statements include the past seven years of transaction history. Two years on screen, seven years in the statements.
Capital One states you can view up to seven years of statements online for active accounts. Paperless enrolment is required. Statements generate by around the sixth of the month, and savings accounts generate quarterly if there has been no activity.
Yes. Capital One 360 checking and savings, Spark business accounts, and Capital One credit card statements all convert. Cards are the most common case, because a full tax year of card activity sits outside the two years of on-screen history and there is no documented export to fall back on.
Your first statement of up to 10 pages converts free on a new account. Beyond that it runs on credits, with the cost shown before anything is processed. Files are uploaded and processed on our servers rather than in your browser, which is what allows scanned and photographed statements to work as well as native PDFs.