I just left Canada it was much easier to deal with.
On Mon, Jul 19, 2021 at 12:40 PM Ben Blount <[email protected]> wrote: > 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 > <https://groups.google.com/d/msgid/beancount/CACGEkZvOFb4nry1-3z_8%2BiUPXnk4-WFuGNc%3DYHN8Gzt_MVarOg%40mail.gmail.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/CAK21%2BhMpq6HqAi4GQ6APYWxkqB1MAmKS38W%3DP%3Diu1WG%3D3EVGJA%40mail.gmail.com.
