Re: Reporting USD Trans in CAD for CRA

2021-08-17 Thread James Cook
On Sun, Aug 01, 2021 at 03:26:38PM -0700, Ben L wrote: > Thanks for all the suggestions. Using > https://hub.darcs.net/falsifian/misc-pub/browse/beancount_plugins/falsifian/parallel_average_cost.py > > as a starting point, I'm trying to write a plugin that will duplicate every > transaction in

Re: Reporting USD Trans in CAD for CRA

2021-08-01 Thread Ben L
Thanks for all the suggestions. Using https://hub.darcs.net/falsifian/misc-pub/browse/beancount_plugins/falsifian/parallel_average_cost.py as a starting point, I'm trying to write a plugin that will duplicate every transaction in a second currency. So for example: 2020-01-01 * "Buy"

Re: Reporting USD Trans in CAD for CRA

2021-07-20 Thread Alan H
I have written a plugin that allows me to split expenses across tax years and assign fractions of each expense to a tax reporting account as needed. (For example to recover home office expenses) As for dealing with reporting in the other (non-native) currency I do what Martin said - assuming I

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