Canadian currency tax reporting

[AaronBB]

I am trying to pull a report by region to show taxes collected for sales in British Columbia. Because most of my sales come from the US (even though I'm in Canada), my store currency is set to USD. But now my tax report is showing BC sales but in USD currency. To be clear, I've got multi-currency set up and Canadian buyers pay in Canadian dollars. That works fine, but the report comes up in US dollars.

Am I missing something? Thanks for your insight!