There are some other Canadians on the list who have posted previously and developed some plugins to help with a variant of solution 2.
See https://groups.google.com/g/beancount/c/UcEqxDKtqB8/m/BJe_XFSlDAAJ and if you search teh mailing list you may find some additional threads. On Mon, Jul 19, 2021 at 8:14 AM Ben Luey <[email protected]> wrote: > > 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 > <https://groups.google.com/d/msgid/beancount/0cbd2e73-2bcd-49db-b7d6-5a67a84111b0n%40googlegroups.com?utm_medium=email&utm_source=footer> > . > -- 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/CACGEkZvOFb4nry1-3z_8%2BiUPXnk4-WFuGNc%3DYHN8Gzt_MVarOg%40mail.gmail.com.
