Hello everyone, I am using the latest beanquery from PyPI (v0.1.dev0) and I'm pretty new to SQL and beanquery's SQL-like syntax. I am trying to produce a report where I can see all of my expenses for a certain period, something like what my bank statement would show but grouped by my expense categories. I found this in the examples in the docs and it's pretty close to what I want but I'm not sure how to grab the 'transfers' from my asset account. For example when I make a payment towards my credit card or when I transfer into my savings.
FROM OPEN ON 2024-09-12 CLOSE ON 2024-09-26 SELECT account, SUM(position) WHERE account~"Income|Expenses" GROUP BY 1 ORDER BY 1 The above query produces something like the following: ----------------------------------- ------------ account SUM(position Expenses:Auto:Fuel 50.00 USD Expenses:Auto:Insurance 140.00 USD Expenses:Clothes 20.00 USD Expenses:Debt:Interest 83.00 USD Expenses:Food:Dining 100.00 USD Expenses:Food:Groceries 140.00 USD Expenses:Home:Utilities:Electricity 80.00 USD Expenses:Home:Utilities:Water 70.00 USD Income:Salary -3000.00 USD Where I would really like something like this ----------------------------------- ------------ account SUM(position Expenses:Auto:Fuel 50.00 USD Expenses:Auto:Insurance 140.00 USD Expenses:Clothes 20.00 USD Expenses:Debt:Interest 83.00 USD Expenses:Food:Dining 100.00 USD Expenses:Food:Groceries 140.00 USD Expenses:Home:Utilities:Electricity 80.00 USD Expenses:Home:Utilities:Water 70.00 USD Income:Salary -3000.00 USD Liabilities:CreditCard 100.00 USD Assets:Savings 300.00 USD Which would essentially show everything my 'paycheck' was spent on for the period selected. Is this possible using beanquery? Thanks! Oscar & Ale [email protected] -- You received this message because you are subscribed to the Google Groups "Beancount" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/beancount/ab4b949a2c34859d816728bb8a2c565143560715%40aleyoscar.com.
