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 |