List of Expenses for this Month

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