Subscriptions settlement report

The purpose of this report is to allow the retailer to allocate the subscription amount received to the central merchant account (HQ), to the stores where the usage has been over the subscription period.

The report only concluded subscription periods for a member (subscriber) will be present i.e. 30 days after the payment date. For a member, there can be multiple rows if usage across multiple stores. If the member has only used the subscription at one store there will be only one row for this member. If the member has not used the subscription at all in the subscription period there will be one row and the store is the member`s local/home store. The report auto-allocates the entire subscription amount to the local/home store if there is no usage. For members with usage across multiple stores, the allocation amount is pro-rata based on usage.

Parameter	Description	Data type
Customer #	Unique id for the user	String
Payment date	Local time of the subscription payment	String
Payment ref.	Payment reference id from the payment provider	String
Subscription Amount	Total paid for the subscription period	Number
Total Usage	Total number of usage made by user on this subscription period	Integer
Value/Usage	Value per usage (Subscription amount / Total usage)	Number
Store	Store in which the usage have been made	String
# Usage/Store	Number of usage in the store	Integer
Allocation Amount	Amount of money to be allocated per store (Value/usage * # Usage/store)	Number
Upselling Amount	Amount of money from upselling, to be allocated to the correct store of usage. Upselling amount is disaggregated to show each upsell transaction on individual rows with Payment Ref, Payment Date, Store, Upselling Amount and Tax Amount.	Number
Total Amount	Allocation amount + Upselling amount	Number
Allocation Amount Before Tax	Amount of money to be allocated per store (Value/usage * # Usage/store) excluding Tax	Number
Upselling Amount Before Tax	Amount of money from upselling, to be allocated to the correct store excluding Tax	Number
Total Amount Before Tax	Allocation amount + Upselling amount excluding Tax	Number
Tax Amount	The tax amount paid by customer, tax part of total amount	Number
Tax Details	Breakdown of the tax amount on different tax rates	String