Convert Capital One statements to Excel and CSV
To convert a Capital One statement to Excel or CSV, upload the PDF, scan or photo to statement.work and export the transactions. Credit card statements come out with purchases, payments, interest and fees as separate dated rows you can total and categorize.
Not affiliated with Capital One. statement.work is an independent tool. Capital One is a trademark of its owner and is named here only to describe the statements this page is about.
About Capital One statements
Capital One, headquartered in McLean, Virginia, is one of the largest credit card issuers in the US and also offers checking and savings accounts. In practice, the Capital One statements that reach bookkeepers and accountants are very often credit card statements, which work differently from bank account statements.
What card statements typically contain
- A summary: previous balance, payments and credits, purchases, fees, interest and new balance.
- Payment information: minimum payment and due date.
- Transactions with dates, merchant descriptions and amounts, sometimes grouped by cardholder on accounts with several cards.
- Interest and fee details.
Bank account statements follow the more familiar pattern of opening balance, deposits, withdrawals and closing balance. Your own statements are the reference for exact layouts.
Common conversion problems
- No running balance. Card statements rarely show a balance after each transaction, so the check has to use the summary totals rather than a row-by-row chain.
- Signs. On a card, purchases increase what you owe and payments reduce it. Keep a consistent sign convention before combining card and bank data.
- Payments double-counted. The card payment shows on the card statement and as a withdrawal on the bank statement. Count it once, as a transfer.
- Several cardholders. Grouping by cardholder can split the transactions into blocks that need to be put back in date order.
- Fees and interest lines. Small, easy to miss, and worth flagging. See hidden fees.
How to convert it
- Download the statement PDF, or use a scan or photo.
- Upload it to statement.work.
- Review purchases, payments, fees and interest as dated rows.
- Export to Excel or CSV.
- Check the new balance using the summary formula above.
Categorizing card spend
Card statements are where most small business spending lives, so categories matter. Use the categorization guide to keep them consistent. For other card-heavy banks, see Chase and Citibank.
Questions
How do I check a converted credit card statement?
Use the statement summary. Previous balance plus purchases, fees and interest, minus payments and credits, should equal the new balance.
Should card payments count as expenses?
No. A payment to the card from a bank account is a transfer between accounts. The expenses are the individual purchases on the card.
Is statement.work affiliated with Capital One?
No. statement.work is independent and is not affiliated with or endorsed by Capital One.