Hi, is there a way to generate a report that will expose the exchange rates used on each month?

sure, go to Lists > Accounting > consolidated Exchange Rates and download the rates