Re: Reporting USD Trans in CAD for CRA

2021-07-19 Thread Martin Michlmayr
* 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.

Re: Reporting USD Trans in CAD for CRA

2021-07-19 Thread Martin Blais
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

Re: Reporting USD Trans in CAD for CRA

2021-07-19 Thread Ben Blount
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,

Reporting USD Trans in CAD for CRA

2021-07-19 Thread Ben Luey
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