Hi,
Our finance team is trying to reconcile the financial reports we receive from Apple and the IAP subscription state (App Store service state).
Specifically, for each IAP subscription, we'd like to reconcile the records in the financial reports and the records in the App Store service state.
To reconcile these records, we would need a common identifier in these two data sets, so that we can say: "this subscription in the financial reports corresponds to this subscription in the App Store service state."
We haven't been able to identify such an identifier.
As far as we can tell, the relevant finance report is the "subscriber report". The only possibly relevant identifer in this report is the "subscriber id". The documentation for this reports describes that field like so:
"""The randomly generated Subscriber ID that's unique to each customer and developer. This field will be null when a customer requests a refund after the 180-day countdown described in Subscriber ID Reset."""
See: https://developer.apple.com/help/app-store-connect/reference/subscriber-report
The relevant App Store service request is "Get All Subscription Statuses"
https://developer.apple.com/documentation/appstoreserverapi/get_all_subscription_statuses
It's response includes the "transaction" and "renewal info":
https://developer.apple.com/documentation/appstoreserverapi/jwstransactiondecodedpayload https://developer.apple.com/documentation/appstoreserverapi/jwsrenewalinfodecodedpayload
The only relevant identifier in these data structures are the "originalTransactionId" and the "appAccountToken". Neither of those correspond to the "subscriber id in the finance report (above).
How can our finance team reconcile these two data sets?
Thanks, Matthew