Showing results for 
Search instead for 
Did you mean: 
Active Member

Past exchange rate data

I need to access the daily USD/AUD exchange rates that Quickbooks has used for our accounts since the start of 2017.

Where can I find these data?


1 Comment
QuickBooks Team

Re: Past exchange rate data

Hi there, RUSCOL.


QuickBooks Online (QBO) downloads the exchange rates nightly from WSoD (Wall Street on Demand). You can check their historical data in 2017 for your reference.


You can also run a Transaction List by Date report for the year 2017and add an Exchange Rate column in QBO.


Here’s how:


  1. Go to the Reports tab.
  2. Search Transaction List by Date
  3. On the report, click the Customize button. 
  4. Click Rows/Columns and choose Change columns.
  5. Select Exchange Rate.
  6. Manually change the Report period to 2017.
  7. Click Run Report.

Visit the Community again if you need anything else. I'm here to help.