# 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

Processed locally in your browser.

[Open converter](https://beancount.io/tools/csv-to-beancount/capital-one#converter) [Export instructions](https://beancount.io/tools/csv-to-beancount/capital-one#export-guide)

## Saved mappings

Profiles live only in this browser. Your transactions never leave it.

No saved mappings yet. Paste a CSV, set the columns, then save the setup here to reuse it later.

### Import profiles from a file

Choose a .json file exported from this converter. Nothing is saved or applied until you choose.

## Beancount output

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

## How to export your Capital One transactions

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

2. Choose View Statements, then Download Transactions.

3. Pick a date range and select CSV as the format.

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.

## 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 or app?](https://beancount.io/tools/csv-to-beancount)

## 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→](https://beancount.io/sign-up/?next=%2Fledger%2F)

## Where to look next

- [Sitemap](https://beancount.io/sitemap.xml) - all pages with hreflang alternates
- [LLMs index](https://beancount.io/llms.txt) - curated links for AI agents (also /llms-full.txt for full docs)
- [Documentation](https://beancount.io/docs) - every doc is also available as text/markdown via .md suffix or Accept negotiation
- [REST API reference](https://beancount.io/docs/api-reference) - interactive endpoints, schemas, authentication, and code samples
- [OpenAPI spec](https://beancount.io/openapi.json) - OpenAPI 3.1 spec for this website's public content endpoints; the product contract for ledger operations is at https://beancount.io/api-gateway/v1/openapi.json
- [GraphQL](https://beancount.io/graphql) - public, read-only content API over the blog and research logs (no credentials, no ledger data): 12 query fields over 23 types
- [MCP server](https://beancount.io/mcp) - Model Context Protocol at https://beancount.io/api-gateway/mcp
