Skip to main content
Beancount.io LogoBeancount.io
219
Capital One → Beancount

Capital One CSV to Beancount

Convert a Capital One card export into balanced double-entry Beancount transactions — its split Debit and Credit columns are mapped for you, no sign guessing.

Column mapping verified against a real Capital One export

How to export your Capital One transactions

  1. 1

    Sign in at capitalone.com and open the account you want to export.

  2. 2

    Choose View Statements, then Download Transactions.

  3. 3

    Pick a date range and select CSV as the format.

  4. 4

    Open the downloaded file, copy everything including the header row, and paste it below.

Capital One splits money in and money out across two columns

Instead of one signed Amount column, Capital One writes a Debit column and a Credit column, and leaves the other one blank on every row. A purchase fills Debit; a payment or refund fills Credit. The preset maps both, so no sign convention has to be guessed. Dates are already ISO (YYYY-MM-DD), which means there is no month-versus-day ambiguity to resolve.

Beancount output

Your transactions will appear here as soon as you paste a CSV.

Capital One export questions

Which date does the converter use — transaction or posted?

The Posted Date, because that is what your statement balance reconciles against. The export carries both; a purchase made on a Friday often posts the following Monday.

Can I keep Capital One's categories?

Not automatically. The export has a Category column, but Beancount's account tree is a better home for that distinction than a text label, so the converter puts every counter-posting in one uncategorized account for you to split. Doing it in your ledger means the categories survive your next bank change.

Does this work for Capital One 360 checking as well as cards?

The card export is the format mapped here. Capital One's 360 bank accounts export a different layout, so check the column order against the preview below before trusting the output — if it differs, use the generic converter and map the columns yourself.

Converting an export from another bank?

Keep the ledger you just converted

Beancount.io hosts your plain-text ledger, imports future statements for you, and keeps every number auditable.

Start Free→