Customers Closed Charges Report
The Customers Closed Charges Report includes Charges (see Charges) that had gotten the Closed status during the selected period.
To create the Customers Closed Charges Report:
- Sign in to the Operator Control Panel.
- On the Navigation Bar go to Reports (see Navigation). The Sales Reports page is displayed.
- In the Customers Closed Charges Report group, in the From Date and To Date fields, set the period of the report.
- Click the Generate Report button. The report will be sent to your email in the MS Excel format.
The report includes the following information:
- Account ID — a unique identification number of the Account (see Managing Accounts), to which the Charge relates.
- Account Name — a name of the Account, to which the Charge relates.
- Account Class ID — a unique identification number of the Account Class (see Account Classes).
- Account Class Name — a name of the Account Class.
- Manager ID — a unique identification number of the Manager (see Staff management), to which the Account relates.
- Manager — a name of the Manager, to which the customer relates.
- Manager Email — an email of the Manager, to which the customer relates.
- Subscription ID — a unique identification number of the Subscription (see Managing Subscriptions), to which the Charge relates.
- Subscription Name — a name of the Subscription.
- Payment Model — Prepay or Postpay.
- Plan ID — a unique identification number of the Plan (see Managing Plans), to which the Charge relates.
- Plan — a name of the Plan, to which the Charge relates.
- Plan SKU (Offer ID) — the value from the SKU field on the Plan page in the Operator Control Panel.
- Plan Category — a name of the Plan Category, to which the Charge relates.
- Resource ID — a unique identification number of the Plan Resource (see Plan Resources), to which the Charge relates.
- Resource — a unique identification number of the Plan Resource (see Managing Plan Categories), to which the Charge relates.
SKU (Offer ID) ресурса — for Microsoft Subscriptions only.
- Microsoft Subscription ID — for Microsoft Subscriptions only.
- Microsoft Tenant ID — for Microsoft Subscriptions only.
- Billing period start date — start date of the Billing period, which is covered by the Charge.
- Billing period end date — end date of the Billing period, which is covered by the Charge.
- Order Type — one of the following types of Order, to which the Charge relates:
- Sales Order — a customer has ordered a new Subscription.
- Renewal Order — a customer has renewed an existing Subscription.
- Change Order — a customer has changed Resources amount.
- Switch Order — a customer has switched the Subscription Plan.
- Charge ID — a unique identification number of the Charge.
- Type — a type of the Charge (monthly, setup fee, etc).
- Operate from — a date from the operate_from attribute of a Charge for 1C.
- Operate to — a date from the operate_to attribute of a Charge for 1C.
- Quantity — a total quantity of the ordered services that are paid by the Charge.
- Unit Price — a price of the unit of the service excluding VAT.
- Discount — an amount of the discount.
- Discount ID — a unique identification number of the discount.
- Discount Name — a name of the discount.
- Promocode — a promo code, if it was used to get the discount (see Managing Promo Codes).
- Reseller amount — a total amount of money that the Reseller pays for the upstream Reseller for the Charge.
- Amount — an amount of the Charge.
- Charge close date — time and date of Charge closing.