Settlement Report

Partner Ecosystem Management generates a monthly report on settlements results (that is, the payout amount owed to Merchants). Merchants and Resellers (Service Providers) can see settlement results in a central and transparent location. In addition to processing settlements, Partner Ecosystem Management does the work of reporting for you. Note: Settlement payouts and disputes related to the settlements are handled directly between the Reseller (Service Provider) and the Merchant. Payouts are determined in the agreement between the Merchant and Reseller (Service Provider). When a Reseller creates an agreement and enables a settlement model, the Reseller chooses a settlement type for payouts. The available settlement types are:

Fixed Amount (flat fee)
Revenue Share (percentage)

The Reseller enters the flat fee or percentage the Merchant will receive in the agreement. The actual payments to the Merchant are the responsibility of the Reseller. Settlements are either based on monthly calculations of active subscriptions, or on monthly calculations of transactions (that is, new activations and renewals). This calculation depends on the product lifecycle the Merchant chose for the product, which can be Merchant-Managed or Platform-Managed.

Settlement Report File

Parent topic:Reports

Settlement Report File

The Settlement Report is a CSV file with this naming convention: MarketONE.Settlement.Report_<YYYYMMDDTHHMMSSZ>_<ORGCodeCSP or ORGCodeOTT>.CSV where:

<YYYYMMDDTHHMMSSZ>: The day and hour the report was generated.
<ORGCodeCSP>: The Reseller’s Organization Code.
<ORGCodeOTT>: The Merchant’s Organization Code.

The Settlement Report is generated every month based on the Reseller’s time zone. It contains data for the previous month. The Settlement Report has the following fields:

Field Name	Format	Description
Line Number	Decimal	The line item number. Each number is a whole number unless the settlement is volume-based. In that case, the number will have a decimal. For example: 3.1, 3.2, 3.3.
Billing Period Start Date	Date (yyyy/mm/dd)	The billing period start date, which is always the first day of the month.
Billing Period End Date	Date (yyyy/mm/dd)	The billing period end date, which is always the last day of the month.
Org Code CSP	Alphanumeric string	The Reseller’s (Service Provider’s) organization code.
Org Code OTT	Alphanumeric string	The Merchant’s organization code.
Org Name CSP	Alphanumeric string	The Reseller’s (Service Provider’s) organization name. For example: International Telco.
Org Name OTT	Alphanumeric string	The Merchant’s organization name. For example: Amazing Entertainment.
Product Code OTT	Alphanumeric string	The Merchant organization’s product code. For example: STREAMING_SERVICE.
Product Name OTT	Alphanumeric string	The Merchant organization’s product name. For example: Awesome Streaming Service.
Settlement Model	String	The settlement model used. Valid values are:- Fixed - Revenue Share Fixed stands for fixed amount. Revenue share is based on the price paid by the customer. The customer price is split based on a defined percentage for the Merchant.
Settlement Events	Integer	The total of settlement events used for settlement calculations, such as the total of active subscriptions or activations and renewals. This can be any numeric value greater than or equal to zero.
Total Quantity	Integer	If the product is a quantity product, this field provides the total quantity that is used with the fixed amount to determine the total settlement amount. If the product isn’t a quantity product, the field is empty.
Total Amount to Settle	Decimal	This field only applies to settlements with the Revenue Share model. This is the amount used in the equation to calculate the settlement amount for the Merchant. To get the settlement amount, the Total Amount to Settlevalue is multiplied by the Settlement Value.
Settlement Event Type	String	The settlement event type.Settlement event types include: - TRX Events: This a transaction (a new activation or renewal) for a Merchant-Managed product that has a fixed amount settlement model. - TRX Amount: This a transaction for a Merchant-Managed product that has a revenue share settlement model. - MAS Events: This is a monthly active subscription for a Platform-Managed product with a fixed amount settlement model. - MAS Amount: This is a monthly active subscription for a Platform-Managed product with a revenue share. - MAS Quantity Events: This is a monthly active subscription for a Platform-Managed and quantity-based product with a fixed amount settlement model.
Settlement Currency	ISO 4217	The currency code, if available. Example: USD.
Settlement Value	Decimal	The value used to calculate fixed amount or revenue share settlements. The value is defined in the agreement. A valid value can be one of the following: - An amount with two decimal places (for example: 20.45) - A percentage in decimal format (for example: 25% would be shown as 0.25)
Settlement Amount	Decimal	The settlement amount that is intended to be paid to the Merchant. It’s rounded up to 2 decimal places. This is a pre-tax or non-tax value. Example:3456.78.
Tax Amount	Decimal	The amount of tax if tax applies. This value is rounded up to 2 decimal places. This value is in the Settlement Report for accounting purposes when tax is present. Example: 46.96.
Entitlement Type	String	The product entitlement type.Possible values are: - Standard: For the standard entitlement type, customers on the Reseller’s storefront are buying a single entitlement to the product. - Quantity: The quantity entitlement type supports various use cases, including numbers of seat licenses.
Parent topic:Settlement Report

Home

Introduction

For Merchants

For Resellers

Partner Ecosystem Management

Commerce Engine

Storefront Experience

APIs

Settlement Report File

​Settlement Report File

Settlement Report File