Yes, any reservations completed for vehicles registered in Canada will be charged and paid out in CAD, even if you travel into the US from Canada.