Capital One credit card statement to Excel
Drop a Capital One card statement and get a spreadsheet with the columns split the way the statement prints them. The file stays in your browser.
Drop your Capital One statement here
or click to choose a file · nothing is uploaded
Import straight into accounting software
A CSV leaves you at the door of QuickBooks or Quicken; these formats walk in, with each transaction carrying an id so a re-import can't duplicate it.
QuickBooks (.qbo)Quicken (.qfx)What a Capital One statement looks like
| Columns | Trans Date · Post Date · Description · Amount |
|---|---|
| Dates | Two — transaction date and posting date |
| Sections | Payments, Credits and Adjustments · Transactions |
Capital One prints both the transaction date and the posting date, in adjacent columns with a narrow gap between them. That gap is the tightest on any statement in this list, which is why the two dates are the thing most likely to end up merged into one cell.
What to check afterwards
Check that Trans Date and Post Date came out as two columns and not one. They differ by a day or two, so a merged cell reads as something like '07/18 07/19' — obvious once you look, easy to miss if you don't.
Card statements carry no running balance, so the arithmetic check that verifies a bank statement cannot run here —why that matters. On scans and how nothing is uploaded: read the details.