Please let me know if there's anything else that I can help with your reports. Simply click the Export icon and select Export to Excel. You can also export them to Excel to help give you the flexibility to use them. 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.

Select the Exchange Rate, Foreign Amount, and Currency checkbox.

Under the Rows/Columns section, click Change columns.

Select the Transaction List by Vendor report.

Scroll down to the Expenses and Vendors section.

If I misunderstand your needs or you still have problems on it, please feel free to let me know.I'm here to show you how to get the reporting currency added to your report, 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. If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let me know. Īlso, attached the sample pbix file as reference.

For how to set scheduled refresh, you may refer to Data refresh in Power BI - Power BI | Microsoft Docs. To update the conversion rate and the result of conversion, you need to arrange daily data refresh for your dataset. Then, you need to create a Calculated column to do the conversion for you. The GBP/TRY exchange rate is seen trading at 29.4832 and EUR/TRY is 25.2946. When everything is ready, close and apply the transformation in Power Query, and this conversion rate will be imported into your model. At the time of writing, the US Dollar to Lira (USD/TRY) exchange rate is quoted at 23.4517, 0.22 percent lower on the day. Īfter connecting to the data source with Web connector, you need transform the data retrieved to extract the specific conversion rate between USD and CAD in Power Query. In my sample, I get this data from this website.

Hi as tomfox said, if you would like to get the fluctuating conversion rate of current day, you need to detch it from a website.

Download us to s exchange rate