Spent three hours yesterday trying to match up our subscription revenue between platforms.
The timing differences and currency conversions make everything a nightmare. Manual spreadsheet work is killing my productivity.
What tools are you using to automate this?
Try Baremetrics or ChartMogul. They connect to both and handle most of the matching automatically.
Use a reconciliation tool to save time.
I feel your pain. Dealt with this mess for two years running subscription apps.
What saved me was a simple reconciliation script that pulls data from both APIs daily. It matches transactions using user ID and timestamp (24-hour window for delays).
For currency conversion, I grab the exchange rate from the transaction date. Stripe and App Store use slightly different rates, but staying within 2-3% works fine for monthly reports.
Now it takes 30 minutes weekly instead of hours. Worth the setup time.