According to your own link US had an 8 Billion surplus with Canada. Your counting pass thru goods that are shipped thru Canadian ports for delivery to the US. Most of those goods are from China and should be counted as Chinese imports.
Canada sends over a million barrels of oil per day to the US at below world price. Without oil in the mix the US would have a 30 billion trade surplus with Canada
I’m going to get back to you later on a computer instead of a phone.