►License Based Report (Report of all Customers/Organizations)

All customers and sellers have access to the reporting section enabling tracking billings data over time. Reports can be accessed from the “Reports” section.

a1.png

The window will be opened in a new window. 

01r.png

a. Billing date can be filtred.

b. One or several Customers can be filtered, selected customer's data view will be displayed. 

c. Vendors by name can be filtered. 

d. Subscriptions by name can be filtered. 

e. Offers by name can be filtered. 

f. Subscription start date can be modified, by selecting the exact date.

Filters that can be used affecting all visuals. Note!  selecting certain data elements, such as the month in one visual, also filters other visuals.

g. When selecting the info icon, the current message will display "This report shows billing data for the last 14  months. dates are grouped by billing period end date, which is different from the invoice date. Please see the knowledge base article for more information".

h. link directs to knowledge base article link.

i. the button resets the filter reports.

The underlying datasets can be exported to a spreadsheet. To do that, select on the three dots (i.1) on the top right corner, select Export data, (i.2) and follow instructions in the next window.

export.png

The seller can see the custom offer properties column for offers and subscriptions when exporting data:

Offer details; Subscription details;

Note! Customers cannot see this column.

License Based Report

The License Based Report shows data based on license based billings from the platform.

The report shows all subscriptions that are billed per purchased license. The data is grouped based on the billing period end date.

Please see the section Reports and Invoices data comparison below for information on how the data in this report relate to the invoice data.

lic_rep.png

Reports and Invoices data comparison

It is important to note that the Invoices and Billings data cannot be compared for the same exact period because a single billing record can be covered across multiple invoices.

The "Invoices" section contains data for which discrepancy analysis has been performed. The "Invoices" section is intended for customer billing. The "Reports" section is intended to give daily updates on performance.

"Invoices" section:

Invoices are generated based on Platform billings that consist of License based billings and Usage-based billings.

Usage-based billings are Platform generated based on synced usage records from the vendor (e.g. Microsoft Partner Center – Resource Utilization API).

License-based billings are being calculated based on subscription events that are synced from the vendor (e.g. Microsoft Partner Center).

"Reports" section:

In "Reports" usage-based page shows data calculated based on billings from Platform divided by aggregated usage that is synced from the vendor. This is done to calculate the cost per resource per day.

In "Reports" license based page shows data based on license based billings from the platform.

Please note that the "Reports" section is based on billing date i.e. report for January will contain data for 1/12/2019 – 1/31/2019 as in the "Invoices" section corresponding invoice will have been generated on 1/1/2020.

Below are listed most common differences between the "Invoices" section and "Reports" section:

  1. Usage-Based: "Reports" section is calculated based on Platform billings divided by aggregated usage records. The "Invoices" section is calculated based on Platform billings. As there is this additional calculation performed in the "Reports" section to obtain per day per resource amounts there can be small rounding discrepancies between both sections.
  2. License based (Subscription Suspension): In a scenario where a license based subscription is suspended during the billing period.

Your billing date is the 1st of each month. On April 10 you purchase a new subscription with one license for $4/month and select monthly billing. The May 1st license-based "Invoices" section and "Reports" section will contain the following information:

 

Charge Start Date

Charge End Date

Charge Type

Unit Price

Quantity

Amount

Invoices Section

10/4/2020

9/5/2020

Purchase Fee

4.00

1

4.00

Reports Section

10/4/2020

9/5/2020

Purchase Fee

4.00

1

4.00

The June 1st license-based "Invoices" section and "Reports" section will contain the following information:

 

Charge  Start Date

Charge End Date

Charge Type

Unit Price

Quantity

Amount

Invoices Section

10/5/2020

9/6/2020

Purchase Fee

 4.00

 1

 4.00

Reports Section

10/5/2020

9/6/2020

Purchase Fee

 4.00

 1

 4.00

On June 2 you suspend your license. As you have suspended your licenses during the current charge period, then the correction line will be issued within the next invoice (prorated for days after suspension). The July 1 license-based "Invoices" section will contain correction for 8 days while the "Reports" section will have already recalculated billings in June as suspension of license was done within the Subscription cycle ending in June (10/5/2020 – 9/6/2020).

The July 1st license-based "Invoices" section will contain the following information:

 

Charge Start Date

Charge End Date

Charge Type

Unit Price

Quantity

Amount

Invoices Section

15/6/2020

9/7/2020

Correction

-1.07

1

-1.07

Reports Section

 

 

 

 

 

0

The monthly price is 4.00 and there are 30 days in the service period 10/5/2020 – 9/6/2020. This equates to a daily price of 0.133 (4/30). In July invoice Platform will calculate the correction to prorate license subscription suspension days. -4.00/8*12 = -1.07 EUR.

Unit price = days in service period x daily price x number of licenses.

There are 8 days in the cancellation period: 10/5/2020 – 9/6/2020.

Therefore, the unit price = -1.07 (8 x 0.133 x (-1)).

  1. License-based (billing error): In a scenario where an error has been identified in March that relates to January then added correction will affect the March invoice (as verified invoices are never changed) but will be visible in January in the "Reports" section based on charge date.
  2. Data Presentation: The "Reports" section is split into two parts license-based and usage-based while the "Invoices" section has one aggregate amount.

In Seller view,  License-based and User-based (Report of all Customers) available, that has been purchased through the platform.→ "Reports" tab.

NOTE! In order to have access to the Seller report, please submit a request in the Knowledgebase.   

Was this article helpful?

0 out of 0 found this helpful

Add comment

Please sign in to leave a comment.