Download FX Rate from iTunesConnect?

Question

I distribute several applications in the iOS App Store, in collaboration with different people. I need to pay one person for application X, another person for application Y, another person for application Z, etc.

The App Store Connect offers some APIs for downloading sales reports, but sales reports reflect income in foreign currencies that Apple will convert to my currency (USD) later when Apple pays me. On the “Payments” tab, in the “Payments and Financial Statements” section, the exchange rate is indicated in the “Currency exchange” column.

Can I download this table (I need a currency exchange rate) using the Apple AutoIngest tool or another Apple API?

(Without an accurate exchange rate on the day of payment, I cannot divide Apple USD payments to me by fair contributions to each application. Sales reports only say that application X earned a certain amount of US dollars and a certain amount of euros and a certain amount of pounds, but I don’t have enough information to decide exactly what part of my dollar I should pay to the author of application X, not knowing Apple’s exact rate for EUR / GBP / etc. on the day of payment.)

Answer 1

Just stumbled upon this problem myself. You can calculate the exact exchange rates used for any day of payment by following these steps:

• On the iTunes Connect website, go to the "Payments and Financial Reports" section.
• Select the payment period you want to calculate the exchange rate.
• Press download button (above the Estimated Revenue column).
• Open the financial_report.csv file, which was just generated in Numbers or Excel.
• On each row, separate the Outputs column with the Total Debt column.

You now have the exchange rate used for each currency on that payment day. I want this information to be simply provided by the generated reports, but for now it will not be a fairly simple way. Just do it once, then save the template and insert new data from each payment period.