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.

Reply via email to