I would like to suggest a new report, by which you can select any date and then get a summary of your foreign currency exposure as per that date.
It would be very convenient at "end of year’ reporting, but could also be useful at other times throughout the year.
I envision this as an analysis of all balance sheet accounts after which the report will list exposure in some consolidated view, for example (below assuming base currency is EUR):
USD Exposure:
Account Code / Account Name / USD amount / Exchange rate / EUR amount
(below list the various accounts that has USD balance as per the selected date)
SGD Exposure:
Account Code / Account Name / SGD amount / Exchange rate / EUR amount
(below list the various accounts that has SGD balance as per the selected date)
and so on and so forth…
Comments are appreciated…