beancount-mercury
beancount-mercury provides an Importer for converting CSV exports Mercury checking transactions into Beancount v2 format.
Installation
pip install beancount-mercury
Usage
Add the Mercury importer to your account as follows:
import beancount_mercury
CONFIG = [
beancount_mercury.CheckingImporter(
'Assets:Checking:Mercury',
currency='USD',
account_patterns=[
# These are example patterns. You can add your own.
('GITHUB', 'Expenses:Cloud-Services:Source-Hosting:Github'),
('Fedex', 'Expenses:Postage:FedEx'),
]
),
]
The account_patterns
parameter is a list of (regex, account) pairs. For each line in your Mercury CSV, CheckingImporter
will attempt to create a matching posting on the transaction by matching the payee or narration to the regexes. The regexes are in priority order, with earlier patterns taking priority over later patterns.
Once this configuration is in place, you can use bean-extract
to convert a Mercury CSV export of transactions to beancount format:
bean-extract config.py mercury-transactions.csv
Resources
See awesome-beancount for other publicly available Beancount importers.