beancount-capitalone provides an Importer for converting CSV exports Capital One bank transactions into Beancount v2 format.
pip install beancount-capitaloneAdd the Capital One Credit card importer to your account as follows:
import beancount_capitalone
CONFIG = [
beancount_capitalone.CreditImporter(
'Liabilities:Credit-Cards:CapitalOne',
currency='USD',
lastfour='1234', # Replace with last four digits of your account
account_patterns=[
# These are example patterns. You can add your own.
('GITHUB', 'Expenses:Cloud-Services:Source-Hosting:Github'),
('Fedex', 'Expenses:Postage:FedEx'),
]
),
]Once this configuration is in place, you can use bean-extract to convert a CapitalOne CSV export of transactions to beancount format:
bean-extract config.py 2023-03-10_transaction_download.csvThe account_patterns parameter is a list of (regex, account) pairs. For each line in your CSV, the CapitalOne importer will attempt to create a matching posting on the transaction by matching the payee, narration, or the concatenated pair to the regexes.
The regexes are in priority order, with earlier patterns taking priority over later patterns.
See awesome-beancount for other publicly available Beancount importers.