As far as I can see the exch rate is fine. I do not believe that there is an option to filter by currency.

For some reason I cannot paste here.. Prior to the transaction in Feb 2022 to transfer 1M from our USD account to our CDN account (our base is CDN), when I run the BSheet with foreign currency, the foreign and the Home currency amounts for the CDN bank account are the same, as they should be. After that transfer the…

Typically we would transfer from the USD account to our CDN (base) account.

Hi, so are you saying that it is correct for my CDN dollar bank account to show exchange in the foreign currency column if transferring funds into it from my US Account?