SELECT
MONTH(date) AS month,
SUM(COST(position)) AS balance
WHERE
account ~ 'Expenses:' AND
currency = 'USD' AND
YEAR(date) = 2015
GROUP BY 1
ORDER BY 1;
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.
SELECT
MONTH(date) AS month,
SUM(COST(position)) AS balance
WHERE
account ~ 'Expenses:' AND
currency = 'USD' AND
YEAR(date) = 2015
GROUP BY 1
ORDER BY 1;