How can I get a consolidated financial report by app in my currency?

I need to know the total amount of revenue by app in US dollars each month. I currently spend an hour downloading each country report, concatenating them into a single spreadsheet, adding the exchange rate for each country, converting everything to dollars, re-sorting on product and calculating sums for each product. Fun!

How can I reduce the time I spend on this monthly chore?

Thx!