* Ben Luey [2021-07-19 08:14]:
> 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.
I just left Canada it was much easier to deal with.
On Mon, Jul 19, 2021 at 12:40 PM Ben Blount 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
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,
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