I have uploaded 2 CSV tables, for each site, but on my CA site CSV data converts from USD to CA USD
20$ (for each region)
But on my site it becomes 25,78$(CA USD)
Kindly follow below link. We have used the same with same scenario.
It may help you!
Hi @ussorawayf4404 ,
If you are using multi currency website and you are facing rate issue due to amount getting converted from csv that you have imported then its because of base and display currency settings.
You can add different csv for table rates for different website.
So, I suggest to add different rate in CA CSV.
Example: For CA all region you can add 15.51 rate in CSV which will convert on front-end and customer can see 20 shipping rate for CA as well.
Hope it helps!
Please update the website-based currency rate of the CA site to the CA currency and the US website to USD currency based on this configuration your issue gets solved.
If my answer is helpful full then please set the accept solution flag and kudos flag so other members can take the same reference.