RE: Updating Foreign Exchange Rates

Hi all,

Would anyone know how I can mass update foreign exchange rates in individual transactions?

What happened was transactions (bills, bank transactions, etc.) were brought in before the “currency exchange rates” page was updated (and eventually was hooked up to Thomson Reuters for automatic updates daily) so all the transactions are using a very old (and weird) system-generated foreign exchange rate, which is incorrect. I would need to update/ do some kind of a “refresh” so that it recognizes all those transactions actually have updated FX rates now and don’t use that old system one. Any idea how I can do this? As I really want to avoid having to go into every single transaction, seeing as how there are hundreds of them…

Thank you so much in advance!

Anna25 Rookie Asked on November 3, 2020 in Accounting.
Add Comment
1 Answers

as this will have financial impacts, are the Financial Periods still open?

what have you tried so far? I would start with triggering an update by CSV and the Internal ID of the transactions. Start with a small sample.

do you know the rate you want to have on each transaction? I would also then try mappingĀ  Internal ID and New Rate to the Currency Rate



Beginner Answered on November 4, 2020.

Hi, thanks for your reply. Yes, all periods are still open (we are in the process of migrating accounting system from QBO to NetSuite). What I had done so far was go into the individual transactions and just re-input the exact same date and then the rate would get updated to what it’s supposed to be (however there are too many to go into each individually). It’s weird, the transactions were using an old system rate from 1/1/1970 and it’s as if it didn’t recognize that I had updated the FX tables for recent rates (from 2017 onwards). So now I’m trying to figure out if there is something I can do to ensure all transactions (all there are many) would have the correct FX rates..

Thanks so much.

on November 20, 2020.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.