Need a list of the exact rates that auto populate in Quickbooks. Using this due to the inability of Quickbooks to update FX rates on imported invoices automatically.
The source of foreign exchange rates in QuickBooks Online (QBO) is Wall Street On Demand. You can visit their site through link to get the exchange rates list: http://online.wsj.com/mdc/public/page/2_3021-forex.html.
Additionally, QBO by default uses the current rate the day you recorded those invoices, which is why the rate can be different.
Don't hesitate to post here in the Community if there's anything else you need. Have a wonderful day!
Where can we find the historic rates from Wall Street on Demand? I looked everywhere and I cannot see it. Xero's foreign exchange rate comes from XE.com and it is so easy to find the historic rates by any date https://www.xe.com/currencytables/. Can someone from QB advise us please?
We're unable to get the information from our end. You can reach out to Wall Street on Demand Customer Care Team. They might be able to provide you with the steps.
Thanks for reaching out to us. Please don't hesitate ask if you have other questions or concerns.
Hi lynnphtr1. I appreciate you chiming in on this. QBO uses the exchange rates from Wall Street on Demand. You can also reference the link you sent above if you'd like to check out the exchange rates. Feel free to ask questions, I'm here to assist.
Hi michell1. Since the historical rates are handled through WSJ, you'd have to go through them. I can tell you're just as eager as I am to get to the bottom of this. Don't worry, I'll help steer you towards the right path. I'd encourage you to reach to WSJ using other contact methods which I've listed below:
You can also email them by going through the contact form using this link here. Feel free to keep me posted on how you make out.