This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

Hi all! NetSuite Provides HSBC and Xignite for exchange rate providers, but our bank uses its own rates which are different. How do all of you reconcile these differences?

There's nothing stopping you from loading your own rates. If you can get a feed from your bank, it probably wouldn't be a huge lift to have an automation grab them and load them daily like what happens automatically with the native NS integration.

You'd just want to turn off the NS load obviously if you go down that path.

that's what we were doing, but our bank recently stopped offering that service so we'll need to handle it retroactively somehow

My question was more about the accounting end. What do you do when the bank statement exchange rate and the NS exchange rate differ? Is there a specific transaction or journal or something you do to fix it?