We have a EUR entity however our group consolidation is reported in GBP. When we run the Profit and Loss report on the group level could you confirm if the average or the end of the month exchange rate is used to convert the P&L into GBP?
DataDear extracts the rate from an external service (openexchange) and uses the spot rate as at end of month/period selected in the parameters window of the report:
- Month to date would be the end of the month
- YTD - end of the year
- Quarter - end of the quarter
You can also a currency report (which you can find under the reports drop-down) where you can download your own exchange rates for a day or for the month.