Hi @Alexfournier ,
You can do all of this within one store with Shopify Payments and on the Shopify Plan. If you need anything other than automatic currency conversion for USD ↔ CAD (e.g. you want to stabilize prices with your own FX rate, or even create fixed prices for each country) then you will need to be on the Advanced plan.
Getting paid out into separate accounts in each currency isn’t yet possible, but it is something we plan on having available later this year. It is true that Stripe offers this functionality, but it cannot be done with Shopify Payments yet (required to sell in multiple currencies).
Standard sales reports are all reported on in the base currency of your store, but there are sales reports by currency as well to give you an exact breakdown.