Earnings - Store report in Partner Center

Appropriate roles: Marketplace/Store: Financial contributor

The Store report contains earnings, payment and associated reconciliation details for revenue generated through the Microsoft Store. Template includes store specific attributes only.

To get this report:

  1. Sign in to Partner Center and select Earnings.
  2. Select Download report > Earnings | Store, and follow the instructions to get the report. To learn more, see Get detailed earnings reports. The report contains the following attributes:

Schema

Attribute name Description
calculationDate Date the earning was calculated in the system
earningAmount Earning Amount in the original transaction currency
earningAmountInLastPaymentCurrency Earning amount in the last payment currency (Field is empty when no prior payments have been paid)
earningAmountUSD Earning amount in USD
earningDate Date of the earning
earningExchangeRate Exchange rate used to show the corresponding USD amount
earningId Unique identifier for each earning
earningParticipantId, earningParticipantName, and earningParticipantIdType Partner identity in the transact relationship
earningRate Incentives rate applied on transaction amount to generate an earning
earningType Indicates whether it's fee, rebate, co-op, sell, and so on
estimatedPaymentMonth Month in which the earning is likely to be paid. Determined based on transaction date.
exchangeRateDate Exchange rate date used to calculate EarningAmount USD
externalReferenceId Unique identifier for the program
externalReferenceIdLabel Unique identifier label
lastPaymentCurrency Last payment currency (Blank if no prior payment paid)
lever Indicates business rule for the earning
localProviderSeller Local provider/seller of record
Maturity month The estimated payment month
OrderId Relates to a customer's invoice
parentProductId Unique parent product identifier. If there isn't a parent product for the transaction, then Parent Product ID = Product ID.
parentProductName Name of the parent product. If there isn't a parent product for the transaction, then parentProductName = productName.
participantId The primary identity of the partner earning under the program
participantIdType Mostly program ID for incentive programs and Seller IF for Marketplaces
participantName Name of the earning partner
partnerAssociation Type of relationship partner has to a customer. Examples: reseller, PAL.Owner
partnerCountryCode Location/country/region of the earning partner
partNumber Always blank
paymentId Unique identifier correlates all transactions in the transaction report with a payment in the payment report
paymentStatus Payment status
paymentStatusDescription Friendly description of payment status
productId Unique product identifier
productName Product name linked to the transaction
productType Type of product, such as App, Add-on, or Game
Program Code String to map with the program name
programName Incentive/store program name
quantity Varies based on program. Indicates billed quantity for transactional programs
quantityType Indicates the type of quantity, for example, MAU (monthly active users), Seats.
reasonCode Reason for adjustments
storeFee The amount retained by Microsoft as a fee for making the app or add-on available in the Store
taxCity
taxCountry
taxRemitModel Party responsible for remitting taxes (sales, use, or VAT/GST taxes)
taxRemitted Amount of tax remitted (sales, use, or VAT/GST taxes)
taxState Customer's state
taxZipCode Customer's ZIP/postal code
tpan Indicates the third-party ad network
transactionAmount Transaction amount in the original transaction currency based on which earning is generated
transactionAmountUSD Transaction amount in USD
transactionCountryCode Country/region code in which the transaction happened
transactionCurrency Currency in which the original customer transaction occurred (which isn't partner location currency)
transactionDate Date of the transaction. Useful for programs where many transactions contribute to one earning
transactionExchangeRate Exchange rate data used to show the corresponding transaction USD amount
transactionId Unique identifier for the transaction
transactionPaymentMethod Customer payment instrument used for the transaction, such as Card, Mobile Carrier Billing, or PayPal
transactionType Type of transaction, such as purchase, refund, reversal, or chargeback
workload Name of the workload, service name, for example, spo (for Sharepoint), powerbistandalone (Power BI Standalone), Virtual Machines