Capital One statement to Excel
Capital One customers usually hold two kinds of statement: a 360 Checking or savings statement, and a credit card statement. Both are PDFs you can download, both convert to spreadsheet rows in your browser, and they mean different things once converted. This guide covers both, and says which one a lender wants.
Convert Capital One statements
Downloading the PDF from Capital One
Sign in at capitalone.com, choose the account, and look for its statements section (Capital One labels it along the lines of "Statements" or "View Statements"). Pick the statement period and download the PDF. For a 360 Checking or savings account that is one file per month; for a credit card it is one file per billing cycle, which closes on the same day each month rather than at month end. The mobile app has the same documents under the account's menu. Download each account separately, and if you are preparing for a lender, start with the checking account, since that is where income shows up.
The bank's PDF, not a screenshot or a scan
The tool reads the text inside the PDF, so it needs the statement Capital One generated, which has a text layer. A scanned or photographed statement is an image and is reported as having no text layer; scanned statements are not supported yet. The transaction list on the website can be exported in other formats, but it is not a statement: it has no printed opening and closing balance, so there is nothing to check the rows against, and a lender will ask for the statement anyway.
What the tool extracts
360 Checking and savings. Account, period, opening and closing balance, and one row per transaction with the date, Capital One's description (debit card purchases with the merchant, direct deposits, Zelle and ACH transfers, interest, the occasional fee), a debit or a credit, and the running balance. Interest paid on a 360 savings account is a credit and is counted as income by the lender view unless you change its category; a lender would usually leave it in as well, since it is small, but it is worth knowing it is there.
Credit cards. A card statement has the same shape to the parser, but the meaning of the columns flips. Charges are debits: money you spent. Payments and credits are credits: your payments to the card, refunds from merchants, statement credits and rewards redeemed. There is no running balance in the checking sense, and the balance check described below was built for bank accounts, so on a card statement it may report nothing to check against; use the summary-box check under Export instead. Categories work exactly as for a checking account, which is what makes a converted card statement useful: a year of card spend sorted by merchant and category, with the subscriptions list picking out everything that charges you every month.
The parser reads layouts from column headings and amount positions rather than from a bank list, and has been checked against public sample PDFs from banks and synthetic statements, not against Capital One statements specifically. The check in the next section tells you whether yours was read completely.
Check the reconciliation line
Under the rows, the tool says how many statements add up: opening balance plus credits minus debits should give the closing balance printed on the statement. A card statement's new balance grows with charges, the opposite way round, so the line may report that a card statement has no balances to check; that is expected. A checking statement that does not add up is named; count its pages against the "page X of Y" first, because a missing page is the usual cause, then look for a row whose sign seems wrong. The rating buttons under the table send us the type of error and nothing else.
Export to Excel
Export Excel writes an .xlsx file; Export CSV writes a comma-separated file. Columns: Date, Description, Category, Debit, Credit, Balance, Statement, Page. For a card statement, a SUM of the Debit column is your spending for the cycle and a SUM of the Credit column is what you paid, so the two totals should match the summary box on the first page.
Questions
Can I mix checking and card statements in one drop? You can, and the Statement column keeps them apart in the export, but the charts and the lender view add everything together. For income, drop the checking statements on their own.
Should I use my card statement for a bank-statement loan? No. Lenders compute income from deposits into a bank account; card payments are not deposits. The card statement is useful to you for spending, not to the lender for income.
How many months at once? Up to 24 files in one drop, rows in date order across all of them.
Is the statement uploaded anywhere? No. Your browser reads the PDF and builds the Excel file on your computer. The privacy page lists the one content-free usage event (file count, row count, whether the balances added up) that is recorded. Password-protected PDFs are skipped until you save a copy without the password.
Other banks: Chase, Bank of America, Wells Fargo, American Express. The analyzer page explains the categories and the subscriptions list.