Upload your bank statement
Drop file here or click to upload
PDF, JPG, PNG, BMP, HEIC, TIFF, MT940
Uploading...
Capital One only hands you a spreadsheet for recent activity. On capitalone.com, the desktop Download transactions screen exports posted transactions as CSV for roughly the last 90 days, and there is no export at all in the mobile app. Statements and Documents keeps monthly PDF statements for up to seven years. So anything older than that short download window exists only as a PDF, and converting the PDF is the only way to get those months into Excel with the running balance attached.
Upload a Capital One PDF above and you get Date, Description, Reference, Debit, Credit and Balance columns as XLSX or CSV, usually in under a minute per statement.
Before you convert anything, it is worth knowing which door gives you what. The three Capital One channels are not equivalent, and the one with the longest history is the one that does not produce a spreadsheet.
| Where you get it | Format | How far back | Running balance |
|---|---|---|---|
| capitalone.com desktop, Download transactions | CSV (some accounts also offer OFX or QFX) | Roughly the last 90 days | No |
| Capital One mobile app or mobile web | No transaction export | Not applicable | Not applicable |
| Statements and Documents | PDF statement per month | Up to 7 years | Yes, printed on the statement |
| This converter, from those PDFs | XLSX or CSV | As far back as your PDFs go | Yes, carried into a column |
Capital One does not publish a fixed export limit and the window can differ between a 360 deposit account and a card account. Roughly 90 days is what account holders consistently report on the deposit side, so treat it as a practical ceiling rather than a documented rule, and check your own Download transactions screen before you plan a year end pull.
A point of confusion worth clearing up: Eno is Capital One's assistant for alerts, spending notifications and virtual card numbers. It is not a checking account and it does not export anything. The consumer deposit product is 360 Checking, the savings product is 360 Performance Savings, and business customers are on Capital One business checking, which carried the Spark Business name for years and still shows up under that label in older paperwork.
Copying a Capital One PDF into a spreadsheet by hand fails in the same four places every time:
None of that is sloppiness on Capital One's part. A card statement is a billing document and a checking statement is a ledger, and they are typeset for different jobs. The problem only appears when you try to force both into the same spreadsheet.
Capital One sits across consumer deposits, business deposits and a large card book, and a single customer often holds several of those at once. A typical month means separate PDFs for:
Reconciling a business month means putting all of those into the same shape. That is the actual work, and it is what this converter is for.
If you use Eno virtual card numbers, the descriptor on the statement is the merchant that processed the charge, which is often not the storefront name you remember. Getting those lines into Excel is the fastest way to match them against receipts in bulk instead of one at a time.
360 Checking, 360 Performance Savings, business checking and Capital One card statements are each read on their own layout, so you do not have to convert them separately or fix columns afterwards.
Every file lands as Date, Description, Reference, Debit, Credit and Balance. Wrapped descriptions are rejoined onto one row, and the running balance is carried across where the statement prints one.
Statements that came back as scans or photos, common with older mailed months and loan files, go through OCR rather than being rejected.
The single most common reason people land here. The books are six or twelve months behind, the CSV download only reaches back a quarter, and the rest of the year is sitting in Statements and Documents as PDFs.
Business accounts carry wires, deposited item detail and fee lines that a short CSV window drops. Converting the statement keeps the full description text your reconciliation actually depends on.
Underwriters ask for statements, not exports, because a statement shows beginning and ending balances. Converting the same PDFs you submitted gives you a spreadsheet that ties to the document on file.
Sign in on a desktop browser, open the account, then Statements and Documents. Save every month you need. This is the archive that reaches back years, not the short Download transactions window.
Drop one file or a batch into the converter at the top of this page. Deposit and card statements can go in together, since each is read on its own layout.
Compare the first and last rows and the ending balance with the PDF. Thirty seconds here is what makes the rest of the reconciliation trustworthy.
Take XLSX if the file is going to a person and CSV if it is going into accounting software. Both carry the same columns.
Two routes, depending on age. For the last 90 days or so, sign in on a desktop browser, open the account, choose Download transactions and pick CSV, then open it in Excel. For anything older, download the monthly PDF from Statements and Documents and convert it with the tool at the top of this page, which also brings the running balance across.
Capital One does not offer an Excel file directly. The download screen produces CSV, which Excel opens, and the statement itself is only ever a PDF. To end up with a real XLSX workbook that keeps dates, descriptions, debits, credits and balances in separate columns, convert the statement PDF instead of exporting.
Not as an Excel file. Statements download as PDFs and transaction exports download as CSV, and only from the desktop site. Converting the PDF is what turns a statement into a spreadsheet, and it is the only option once the month falls outside the short export window.
Take them one month at a time from Statements and Documents, where Capital One keeps up to seven years of PDFs, then convert the batch in one pass. Trying to do it through Download transactions fails for older months, because that screen only reaches back about 90 days and does not follow statement periods.
Because the export is a transaction list, not a statement. Capital One's CSV gives you date, description and amount, with no beginning balance, ending balance or running total. If your reconciliation ties to a balance, you need the statement, which means converting the PDF rather than exporting.
360 Checking, 360 Performance Savings, Capital One business checking and Capital One card statements including Quicksilver, Venture, Savor and Spark.
Yes, wherever the statement prints one. Deposit statements carry a running balance into its own column. Card statements do not print one, so no balance column is invented for them.
As far back as you hold PDFs. Capital One keeps up to seven years in Statements and Documents, so a full multi year history is usually recoverable even though the CSV export is not.
Yes. Every conversion can be taken as XLSX or CSV with the same columns, so the same file works for a colleague and for an accounting import.
Yes. Scans and phone photos go through OCR. Accuracy depends on the scan, so check the preview against the statement before you rely on it.
Yes. Upload a batch and each statement is read separately, which is the usual way people rebuild a year of books that the 90 day export cannot reach.
Not from the statement screen. Some Capital One accounts offer OFX or QFX on the download page, but availability varies by product, and neither reaches older months.
No. The mobile app and mobile web do not offer a transaction export. You need a desktop browser for CSV, or the PDF statement plus this converter for anything else.
Converting statements from more than one bank? The bank statement converter reads every US bank format from one upload. If you only need the spreadsheet, the PDF bank statement to Excel converter produces a clean XLSX with the same columns, and the PDF bank statement to CSV converter covers any accounting import. For a Capital One credit card, use the Capital One credit card statement to Excel converter. If the converted rows still need coding before they hit the ledger, categorize transactions from a bank statement covers that step, and QuickBooks Desktop users can see what the bank statement QBO format requires. For the native download screens, see can I export Capital One transactions to CSV or Excel.
Cancel anytime from your account settings · refund policy
Get started converting bank statements to spreadsheets.
USD
per month
per month
$288 charged today
Choose speed vs accuracy when extracting
| Base AI Faster | 2,500 pages |
| Pro AI Best accuracy | 500 pages |
Scale statement conversion across your team with automation.
USD
per month
per month
$888 charged today
Choose speed vs accuracy when extracting
| Base AI Faster | 10,000 pages |
| Pro AI Best accuracy | 2,000 pages |
Enterprise-grade bank statement conversion and controls.
USD
per month
per month
$ charged today
Choose speed vs accuracy when extracting
| Base AI Faster | pages |
| Pro AI Best accuracy | pages |
Try it once, free: sign up and convert up to 15 pages (5 per statement) with no credit card. The demo does not renew.
