I do most of my transactions in USD. However, the Canadian Revenue Agency (CRA) requires that I submit numbers in Canadan dollars, based on the exchange rate at the time of each transaction.
So, if I have two $100 expenses, I cannot just sum them ($200) and convert that USD to CAD and report that. Instead, I have to convert each transaction to CAD with the day's exchange rate and then sum that. The question is how best to do / handle this in beancount? I had a few thoughts on how to do this: 1) Do this all on the query side. Is there a sql query I can run that would do a convert for each transaction that matches some criteria and then sum that? Let's assume I've already input the USD/CAD exchange rate for all transaction dates into beancount. 2) Double-enter all transactions: (Maybe have a plugin do this behind the scenes) Any USD transaction would get mirrored as an additional CAD transaction with transaction date's exchange rate and I'd have both a expense:food and a expense:_food_CAD category that I could query directly in CAD. And Same for asset:bank asset:_bank_CAD (although for cash assets, I would need to convert the total balance, not sum the converted transactions). Other thoughts on how to best handle this? Thanks! Ben -- 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/0cbd2e73-2bcd-49db-b7d6-5a67a84111b0n%40googlegroups.com.
