This query shows the balances of accounts which contain “Phone” in their
name, on each day a transaction was made on that account.
SELECT
date, account, position, balance
WHERE
account ~ 'Phone';
This is a list of example SQL queries for Beancount. It should be a reference and inspiration for users of beancount.
If you want to contribute and add your own query to this list please create an issue or submit a pull request.
For more information about the SQL-like query language for beancount visit the Beancount Query Language documentation.
This query shows the balances of accounts which contain “Phone” in their
name, on each day a transaction was made on that account.
SELECT
date, account, position, balance
WHERE
account ~ 'Phone';