Thank you for your thoughts on this. I think you are right that having just one category with multiple expenses is easy and as you said you can always convert/query as needed. I think I had originally thought to do that but thought that if one commodity per expense account was being suggested that perhaps there was some alternative approach that would be preferable. I think that approach may make sense for certain ways of using Beancount but for the use case I described I think allowing multiple commodities makes sense.
On Tuesday, May 4, 2021 at 7:57:30 PM UTC+12 [email protected] wrote: > On Monday, May 3, 2021 at 1:37:47 PM UTC+7 [email protected] wrote: > >> Building on the example discussed, is it best to then have separate >> accounts for each currency you operate it? For example: >> >> Expenses:Restaurants:Canada CAN >> Expenses:Restaurants:US USD >> > > In general, with beancount, the way you want to structure accounts depends > on how you want to eventually query data from them. The bad part is that > you often don't know that for months/years after using beancount. The good > part is that restructuring your beancount file is (relatively) painless if > you decide you want things another way. > > Anyway, I just have Expenses:Restaurants. I have all my expenses in three > currencies. I've never seen any need to have my US spending, my Australian > spending, my Vietnamese spending ... oh and what about when I'm only > holiday and spend money in Hong Kong Dollars, Singapore Dollars, Euros, and > Thai Baht? Make separate sub-accounts for all of those? > > What's your use case for separating them into per-currency sub-accounts? > Why not just write a query of "select * where account ~ > Expenses:Restaurants and currency = USD" if, for some reason, you only > wanted the USD expenses? > > >> Then If you want to see total restaurant spending (say in USD) can you >> just write the appropriate query in BQL at the node "Expenses:Restaurants"? >> Will this automatically convert using the prices available or do you have >> to manually do that conversion? >> > > You have to manually do the conversion. There is a convert BQL method. > -- 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/b476e1ff-df10-4822-8413-34e0c9e5adbfn%40googlegroups.com.
