cancel
Showing results for 
Search instead for 
Did you mean: 
howardtm
Level 3

Download list of historical Exchange Rates

I am using QuickBooks online. Are there any ways to download a complete list of historical day-by-day Exchanges Rates for all currencies?

 

I am doing some expense analysis. I have exported a list of all expenses, then look up with the corresponding currency of the vendors. The problem is we paid many different currencies but the list of all expenses exported from QB does not show the reporting currency (which is USD), it only shows the original currency. 

Solved
Best answer October 17, 2020

Best Answers
LieraMarie_A
QuickBooks Team

Download list of historical Exchange Rates

I'm here to show you how to get the reporting currency added to your report, @howardtm!

 

The closest variation of your desired report achievable in QuickBooks Online is the Transaction List by Vendor report, which can be customized to show the foreign amount, exchange rate, and currency.

 

Here's how:

  1. Go to the Reports menu.
  2. Scroll down to the Expenses and Vendors section.
  3. Select the Transaction List by Vendor report.
  4. Click on the Customize button.
  5. Modify the reporting date.
  6. Under the Rows/Columns section, click Change columns.
  7. Select the Exchange RateForeign Amount, and Currency checkbox.
    Capture1.JPG
  8. Click Run report.
    Capture.JPG

 

You can check out this article to see the complete list of available reports for your QuickBooks Online version: Reports included in your QuickBooks Online subscription.

 

You can also export them to Excel to help give you the flexibility to use them. Simply click the Export icon and select Export to Excel

 

Please let me know if there's anything else that I can help with your reports. I'm always here to assist. Have a wonderful day.

View solution in original post

2 Comments
LieraMarie_A
QuickBooks Team

Download list of historical Exchange Rates

I'm here to show you how to get the reporting currency added to your report, @howardtm!

 

The closest variation of your desired report achievable in QuickBooks Online is the Transaction List by Vendor report, which can be customized to show the foreign amount, exchange rate, and currency.

 

Here's how:

  1. Go to the Reports menu.
  2. Scroll down to the Expenses and Vendors section.
  3. Select the Transaction List by Vendor report.
  4. Click on the Customize button.
  5. Modify the reporting date.
  6. Under the Rows/Columns section, click Change columns.
  7. Select the Exchange RateForeign Amount, and Currency checkbox.
    Capture1.JPG
  8. Click Run report.
    Capture.JPG

 

You can check out this article to see the complete list of available reports for your QuickBooks Online version: Reports included in your QuickBooks Online subscription.

 

You can also export them to Excel to help give you the flexibility to use them. Simply click the Export icon and select Export to Excel

 

Please let me know if there's anything else that I can help with your reports. I'm always here to assist. Have a wonderful day.

View solution in original post

howardtm
Level 3

Download list of historical Exchange Rates

Thanks Liera, that solved my problem. 

 

Just a a minor difference, in my QuickBooks version, it's under Expenses and suppliers section -> Transaction List by Supplier.

Need to get in touch?

Contact us
Sign in for the best experience
Ask questions, get answers, and join our large community of QuickBooks users.
Sign In / Sign Up