How to Convert a Capital One PDF Statement to CSV or Excel
Every other major US bank documents an export. Capital One documents none, which makes the statements the dependable route.
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 documented 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.
In practice, many customers do find a Download Transactions option when signed in on the website (on a card account it sits under Statements & documents), and third-party guides such as Tiller's report CSV among its formats. What we could not verify against any Capital One source is its reach: pages describing a custom date range with a twenty-five month cap cite nothing, so we are not repeating it. If your account offers the download, use it for recent months. It cannot reach past the two years the website holds, and for anything older the statements do the job.
Quick answer: Capital One shows two years of transaction history online and keeps seven years of statements, and its help centre documents no 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 wants income and spending in one signed Amount column rather than separate debit and credit columns. QuickBooks Online accepts either, but caps an uploaded file at 350 KB, which a multi-year conversion can 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
Register free at reconcileiq.com/bank-statement-converter, open MatchIQ, then open the PDF converter and drag the whole set in. 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.
If the next job is coding those rows in QuickBooks or Xero, CodeIQ reads the same statements and codes each line against your own chart of accounts and history, then posts the approved result back.
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's help centre does not document a transaction export in any format for consumer bank accounts or consumer credit cards; it covers viewing transactions, not downloading them. Many customers do see a Download Transactions option when signed in on the website, but Capital One publishes no format list or date range for it, and it cannot reach past the two years of history the website shows. Its commercial platform, Intellix, offers exports including CSV, but that is a treasury product rather than anything a personal or small business customer is using. For anything older than two years, 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 older card activity sits outside the two years of on-screen history, which is as far back as any download can reach.
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.