Beancount

• Website
• Awesome beancount
• Issues
• Docs
  • Docs live on gdocs
• Debian packaged
• IRC: #beancount and #plaintextaccounting on Freenode
• Gitter: #gitter_beancount=2Ffava:matrix.org
• Someone from Germany?

Issues:

• How to track if i.e. recurring income is recieved on a regular base ?
• no virtual postings
• no easy net profit total in income report
• no settlement dates

Tools

• favagtk
  • No Arch package

Importers

• Importers/Germany
  • Beancount importer for Volksbank & GLS Bank
• beanborg Beanborg automatically imports financial transactions from external CSV files

Neovim plugins

• tree-sitter-beancount
• polarmutex/beancount.nvim Stil broken by a recent commit to telescope
• nathangrigg/vim-beancount
  • VimScript
  • Stale, last commit 2023-01
  • Doesn't Support non-ASCII characters in account names
  • Screws up formatting on save

LSP

• polarmutex/beancount-language-server
• beancount-language-server AUR package
  • old and lacking behind upstream releases
• mason registry

Issues:

• Completion issues: Only works if starting wit a lowercase letter

Linters / Formatters

• beancount-black

Journal Syntax

• Quickref
• Syntax

Plugins

• autobean.narration: Narrations for Postings

Exporting metrics / Grafana

• beancount google group: beancount > prometheus > grafana

bean-price

• beanprice
• YahooError: Status 401: Invalid Cookie When querying yahoo you need to pass a date, see example below

Examples:

bean-price -d $(date -u +%Y-%m-%dT%H:%M:%S) -e EUR:yahoo/btc-eur
bean-price -e EUR:coinbase/btc-eur

Prices from a Beancount Input File:

bean-price --inactive personal.beancount

Other tools

• beangrep grep-like filter for Beancount

Sorting transactions

beanhub-cli

• GitHub
• Docs
• Comment preserving: Can sort a journal file without dropping comments
• Based on beancount-black library (it's cli component is in maintenance mode and will get removed soon)
• No Arch/Manjaro package

Install:

pipx install beanhub-cli

Sort:

bh format accounts/personal/bargeld/bargeld.beancount

Issues

• Broken stdin-mode: Write debug messages to stderr instead of stdout

Sorting with native beancount

Beware: All beancount-native methods will strip comments, since the parser ignores comments. There's currently no way of sorting transactions while preserving the comments using native beancount.

Sort transactions in single file with bean-report:

bean-report input.beancount print >output.beancount

Sort transactions in multiple files: Use this script

beancount v3

• bean-query migrated to beanquery

Missing:

• Explain doesn't work: EXPLAIN SELECT * FROM year = 2014;