Capital One Statement CSV: Columns, Dates, and Reconciling
You can end up with a Capital One CSV two ways: Capital One's own transaction download, or a PDF statement converted to CSV. They hold different columns and cover different date ranges, and mixing them up is the usual reason totals refuse to match. This article covers what each file contains, which date to use, and how to reconcile 360 accounts and cards together.
Only need to get the file? See how to download a Capital One statement as CSV or Excel, including what Capital One's own transaction export covers and when you still need the PDF.
Related Articles
TL;DR - Capital One CSV Files
Two kinds of file: Capital One's transaction export covers dates you choose; a converted PDF statement covers exactly one statement period.
Card export columns: Transaction Date, Posted Date, Card No., Description, Category, Debit, Credit. No statement balance.
Reconciling: Use posted dates and the converted statement, so the rows tie to the balance printed on the PDF.
Transfers: A card payment from 360 Checking is a transfer between your own accounts, not an expense.
Cost: Free for 1 conversion per 24 hours (2 with a free account); Professional is $49/month for 1,000 pages.
Capital One's CSV Export vs a Converted PDF Statement
| Capital One transaction CSV | Converted PDF statement | |
|---|---|---|
| Where you get it | Account page, then Download Transactions | Statements & Documents, download the PDF, then convert it |
| Date range | The range you pick, within the history Capital One offers | One full statement period per file, for any statement you can download |
| Columns (credit cards) | Transaction Date, Posted Date, Card No., Description, Category, Debit, Credit | Date, Description, Amount, plus a running balance when the statement prints one |
| Statement balance and closing date | Not included | Printed on the statement, so you can check the rows against it |
| Best for | Budgeting recent spending | Reconciliation, loan files, your accountant, and older months |
The two files also treat signs differently. The card export splits money into Debit and Credit columns, while a converted card statement gives one Amount column where purchases and payments carry opposite signs. Check which convention your budgeting or accounting software expects before you import, and don't combine rows from both files for the same month, or you will count transactions twice.
Can I download a CSV from Capital One without converting a PDF?
For credit cards, yes. The Capital One site offers a transaction download with columns for Transaction Date, Posted Date, Card No., Description, Category, Debit, and Credit. It covers posted activity rather than statement periods, though, so it won't show the statement balance or the closing date. For a closed month you need to reconcile, or one older than the download covers, convert the PDF statement instead.
Should I use the transaction date or the posted date?
Capital One card statements show both. A statement cycle is built from posted dates, so use the posted date when you need the totals to tie to the statement balance. The transaction date is the day you made the purchase, which is more useful for expense reports and for matching receipts. Keep both columns in your file and pick the one that suits the task.
Why does my Capital One file have separate Debit and Credit columns?
Capital One's card export splits charges and payments into two columns instead of a single signed amount. When you import into QuickBooks Online, choose the two-column option on the mapping screen so charges and payments land on the right side. If your software only accepts one amount column, combine them with a formula that subtracts credits from debits.
Reconciling Capital One cards and 360 accounts in one set of books
- Set up one register per account: each card, each 360 Checking, and each 360 Performance Savings account, matching the last four digits on the statement.
- Convert the monthly statements for all of them for the same month so the transfers between them line up.
- Match card payments to checking withdrawals. A payment from 360 Checking to a Venture card is a transfer, not an expense, and should be recorded only once.
- Record rewards redemptions separately. A statement credit for cash back reduces the card balance. Most bookkeepers book it as a reduction of expenses or as other income, so decide which and stay consistent.
- Reconcile each register to its statement ending balance, then file the PDF alongside the reconciliation report.
Watch the statement closing date on cards
Capital One card statements close on a date that rarely matches the end of the calendar month. If you close your books monthly, a card statement can span two accounting periods. Reconcile the card to its own statement date in your software, and accept that some charges for the end of the month will show up on the next statement. Trying to force the card into calendar months creates reconciling items that never clear.
Frequently Asked Questions
Convert a Capital One Statement
360 accounts and credit cards, converted to CSV or Excel, with totals checked against your statement balances.
Start Free Conversion