Foreign Exchange Account - proposed report

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?