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.
To display a list of Expenses for the current month, you can use the following query:
SELECT
account, sum(cost(position)) as total, month
WHERE
account ~ "Expenses:*" and year = YEAR(today()) and month = MONTH(today())
GROUP BY month, account
ORDER BY total, account DESC