Would it be possible to implement a “Foreign Exchange Gain/Loss” report that basically let the user select date range (From / To) and then the report will show a summary of the automatically calculated “Foreign Exchange gain (loss)” account split per currency…?
For example (assuming my base currency is SGD), I could a period from 1 Jan to 31 Dec 2019 and then I may see that I have a gain(loss) of lets say -500 SGD spilt as;
- Against USD: 100 SGD
- Against EUR: - 350 SGD
- Against xyz: - 250 SGD
From what I understand, all the data is in the system, so it should just be a question of extracting and presenting this in a summary format?