Hmmm, the last time I did an alternate-currency sale using this module it did the exchange correctly for me.

You may already have this correct, but I must ask: What exchange rates do you have set for CAD vs USD in your Admin?