cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
mtk2012
Level 1

Where does Quickbooks get there foreign exchange rates from? Looking for a list with daily rates for 2017.

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. 

11 Comments 11
IntuitGiefril
Level 3

Where does Quickbooks get there foreign exchange rates from? Looking for a list with daily rates for 2017.

Hi shakoorarham,

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!

p-ahimah
Level 1

Where does Quickbooks get there foreign exchange rates from? Looking for a list with daily rates for 2017.

I checked and didn't see any historical data of the rates for the previous years. how can i do this?
BlueZango
Level 2

Where does Quickbooks get there foreign exchange rates from? Looking for a list with daily rates for 2017.

I too need to see the Historical Rates being used by QBO, but cannot see them in the Wall Street Journal site. Please advise where the thousands of users can SEE THE SOURCE RATES.
michell1
Level 2

Where does Quickbooks get there foreign exchange rates from? Looking for a list with daily rates for 2017.

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?

RenjolynC
QuickBooks Team

Where does Quickbooks get there foreign exchange rates from? Looking for a list with daily rates for 2017.

Hi michell1,

 

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. 

 

 

 

 

lynnphtr1
Level 1

Where does Quickbooks get there foreign exchange rates from? Looking for a list with daily rates for 2017.

Hi,

 

I just want to verify that exchange rate from QBO still fetching from https://www.wsj.com/market-data/currencies/exchangerates

 

Thanks.

JamesM4
QuickBooks Team

Where does Quickbooks get there foreign exchange rates from? Looking for a list with daily rates for 2017.

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. 

michell1
Level 2

Where does Quickbooks get there foreign exchange rates from? Looking for a list with daily rates for 2017.

I had contact WSJ and not reply on how to get the historical currency exchange rate.

Can someone from QB help us to get the correct link for historical values?

JamesM4
QuickBooks Team

Where does Quickbooks get there foreign exchange rates from? Looking for a list with daily rates for 2017.

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: 

  • 1-800-JOURNAL (1-800-568-7625)
  • Toll: 1-609-627-1351
  • Monday - Friday: 7am to 8pm EST
  • Saturday: 7am to 3pm EST

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. 

Benjamin09
Level 1

Where does Quickbooks get there foreign exchange rates from? Looking for a list with daily rates for 2017.

Hello QBO,

 

Is there any update about the daily FX rate history ? Cannot get it from Wall street on demand...

a CSV file would be awesome... and well if QBO can release a new report for that purpose, I guess a lot of customers would be very happy :)

 

Jen_D
Moderator

Where does Quickbooks get there foreign exchange rates from? Looking for a list with daily rates for 2017.

Thanks for joining this thread, Benjamin.

 

Joining in to share some insights about this foreign exchange rate concern.

 

At the moment, QuickBooks is unable to provide this information or file. The system uses the most current foreign exchange rates on transactions and only keep a record of it for reporting purposes. However, keeping the history of daily exchange rates isn't part of our program processes. This is why we're unable to generate a file for it.

 

For now, what you can do in QuickBooks is to run reports of previously entered transactions and filter it by exchange rates. 

 

If you'd like to see the raw data based on the currency billed for a foreign client, you can use the A/R Aging Detail or a Transaction List by Customer Report. Here are the steps to do that:

 

  1. Go to the Reports menu and type Transaction List by Customer on the search field. You can also find this under Sales and customers.
  2. From there, click the Customise button.
  3. Tap the blue Change columns link to expand the options.
  4. Update the Report period.
  5. Mark the boxes for Foreign AmountForeign Net AmountCurrencyExchange RateDue Date and A/R Paid.
  6. Press Run report when you're done.

 

Post here anytime if you have other questions or concerns in the program. Me and my colleagues are ready to help you out. Have a good one!

 

Need to get in touch?

Contact us