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. The plain .ofx is the same file without the Intuit tag, for GnuCash, Moneydance and anything else that reads a bank feed.
QuickBooks (.qbo)Quicken (.qfx)Plain .ofxWhat 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.
How Capital One writes its transaction lines
Capital One prints the transaction date and the posting date in adjacent columns with the narrowest gap of any statement here. The two dates differ by a day or two, which means a merged cell reads as something like 07/18 07/19: obvious when you look, easy to miss when you do not.
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 and easy to miss if you don't.
Where to download your Capital One statement PDF
The card's Statements list after signing in. Capital One keeps card statements as one PDF per cycle and offers no CSV for older periods.
Several cycles to combine? Merge the converted files, then check for duplicates where they overlap. Moving the result into accounting software: the QuickBooks route.
Capital One statement questions
What is the difference between Trans Date and Post Date?
Trans Date is when you made the purchase; Post Date is when it hit the account. For bookkeeping you almost always want Trans Date. For reconciling against the statement's own totals you want Post Date, because that is what the cycle is cut on.
The two dates came out in one column. Can I split them?
Yes, with a text to columns split on the space, since both are fixed width. But it is worth reconverting first, because a merge that narrow usually means the column detection was off across the whole page.
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.