Hi everyone, I'm an accountant but new to Beancount, so apologies if these are easy questions or have been discussed before.
My only plugin is "beancount.plugins.implicit_prices". *Two Daily Commodity Prices* Having an electric car, it's useful to track energy usage over time, which is in KWH. I have a script that imports my daily usage and creates the following journals: *2021-08-09 * "Energy Provider" "Daily energy" Expenses:Property:Utilities:Electricity:Standing 0.2381 GBP Expenses:Property:Utilities:Electricity:Offpeak 0.551 KWH @ 0.0476 GBP Expenses:Property:Utilities:Electricity:Peak 3.156 KWH @ 0.1485 GBP Assets:Debtors:Electricity* (For those wondering about the accounting, my standing order also goes to Assets:Debtors:Electricity and each month I check that the balance of that account agrees to the statement.) As you can see, there is a standing charge in GBP, and then daily peak and off-peak (between midnight and 4am) prices. When I run reports, these convert all KWH to GBP using the Peak price, and ignore the Offpeak price. I believe this is a feature. However, is there a way to ensure that the correct conversion happens? I could use a different commodity code for peak vs offpeak, but I still want to track how many KWH we use in aggregate for each month etc. *Posting level tags/metadata* I am also keen to specifically track the amount of electricity cost that relates to the cost. My script identifies and tags energy usage relating to the car, giving a posting like: *2022-01-01 * "Energy Provider" "Daily energy" Expenses:Property:Utilities:Electricity:Standing 0.2381 GBP Expenses:Property:Utilities:Electricity:Offpeak 0.528 KWH @ 0.0476 GBP Expenses:Property:Utilities:Electricity:Peak 7.055 KWH @ 0.1485 GBP Expenses:Property:Utilities:Electricity:Peak 9.755 KWH @ 0.1485 GBP car: "Tesla" Assets:Debtors:Electricity* You can see I've added the 'car: "Tesla"' metadata to the posting. I would like to be able to filter expenses for all costs relating to the Tesla (not just energy), but cannot see a way to do this in Fava (whereas tags and payee you can). Have I missed something, or do I need to do it manually in the Query page? The other option would be to use Tags, but I believe these apply to the whole transaction rather than the individual posting - is there a plan to change this? In general, I use tags/metadata a lot (effectively gives multiple dimensions to analyse data), and I'm trying to work out what the best practice is, so any thoughts welcome! Thank you for any help. It is a brilliant - and very powerful - system. Many thanks, Michael -- 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/e18f5e28-3924-41da-9736-46fd711119a8n%40googlegroups.com.
