Capital One statement: fields & CSV layout
Capital One card statements list purchases, payments and fees. Here are the fields they contain and the CSV layout that drops into a spreadsheet or accounting tool with correct signs.
Convert a credit card statement free →Fields extracted
| Field | Type | Description |
|---|---|---|
| date | date (ISO) | Transaction date, normalized to YYYY-MM-DD. |
| description | string | Merchant name and location. |
| amount | number (signed) | Consistent sign convention; payments and credits carry the opposite sign of purchases. |
| category | string | Spend category when inferable. |
Clean CSV layout
| date | description | amount | category |
|---|---|---|---|
| 2026-05-02 | NETFLIX.COM | 15.49 | subscriptions |
| 2026-05-04 | SHELL SERVICE STATION | 47.10 | fuel |
Sample rows are illustrative. ParseDoc outputs this exact column layout from your own document.
Conversion notes
›Capital One provides a CSV download for recent transactions; statement PDFs are the source for closed periods.
›Fees and interest charges appear as their own rows — keep them so your expense totals are complete.
›Keep payments as a separate signed row, not netted, so the statement balance reconciles.
FAQ
Can I get categories?
Categories are inferred from the merchant; verify a few, then your spreadsheet pivot by category is reliable.
Multiple cards?
If your statement covers several cards, keep a card-identifier column so per-card totals stay separable.
Convert your own Capital One credit card statement
Drop the PDF or a photo into the free converter — 10 pages/day, no signup, nothing stored. See also: the full guide.