Hi qubafactory, 

Thanks for reaching out. All reporting and financial statements in Sage 50 CA will be based in the home currency. KB 59737 confirms that "there is no sales report with only foreign currency or US $ only."

Something else to keep in mind if you're mainly inputting foreign currency based transactions is the need to adjust your bank balance. See KB 10623 for when due to exchange rate fluctuations, the foreign balance is correct, but the CAD balance is incorrect.

Hope this helps!

Warm Regards, 
Erzsi