Reporting Group FX Rate

I am running reports (Trial Balance, P&L) across my group of Xero accounts which consolidates into USD.
When running the reports for June, the exchange rate being used for GBP/USD is 1.22999. However, when running the Exchange Rates report (at 30 June), the GBP/USD rate is 1.23883.
These rates are usually aligned.

Are you aware of any issues or is there a way to overwrite the rates yet? The rates are fine for May and earlier months as I’ve never come across this issue before.


Hi @ben_uk

The rates used can be checked within DataDear using the Exchange Rates report. DataDear uses the last chosen day of the month so the rate may change if the report day is changed. You may overwrite the rate and this would involve getting the reports individually in different sheets and then merging them together.

Using the report provided by DataDear would be faster then merging individually.

The rate used for the group reports in June 2020 is different to that on the Exchange Rate report at 30 June 2020.
Could you run a test to see if the same happens to you?