Hi. This doesn't help if you're using the API, but I had the same question, and tried every version of Create Financial Reports - all suck as described above - no simple total of how much I received in my own currency, even though surely Apple has this in their database, since they paid it to me and can show me on the webpage.
Then I noticed the tiny little "box with down arrow" icon below paid-date. This at least gives me a csv with the same info shown on the page!!