Download list of historical Exchange Rates

howardtm · ‎October 17, 2020

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.

LieraMarie_A · ‎October 17, 2020

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:

Go to the Reports menu.
Scroll down to the Expenses and Vendors section.
Select the Transaction List by Vendor report.
Click on the Customize button.
Modify the reporting date.
Under the Rows/Columns section, click Change columns.
Select the Exchange Rate, Foreign Amount, and Currency checkbox.
Click Run report.

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

LieraMarie_A · ‎October 17, 2020

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:

Go to the Reports menu.
Scroll down to the Expenses and Vendors section.
Select the Transaction List by Vendor report.
Click on the Customize button.
Modify the reporting date.
Under the Rows/Columns section, click Change columns.
Select the Exchange Rate, Foreign Amount, and Currency checkbox.
Click Run report.

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.

howardtm · ‎October 18, 2020

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.

Topics

Training

Community

Resources

Download list of historical Exchange Rates