Reporting API - Detailed Invoice Line Items

Reporting APIs can return detailed invoice line items. A comprehensive list of available Reporting API and functionalities can be found here:

APPXITE REPORTING APIs

Partners now have the flexibility to utilize a simplified view featuring consolidated invoice line items. However, when necessary, they can switch to a more detailed breakdown of invoice information. This allows for an easy understanding of charges across various subscriptions, while also providing access to specific details regarding pro-rated charges when needed.

Important to note: expanded invoice line items for Correction lines are available for invoices generated after December 1, 2022 and for other lines - for invoices generated after May 1, 2023.

Additionally, it should be noted that rolled-up invoice line items are aggregated and the total amount is rounded to two decimal places. Conversely, expanded invoice line items are presented without any rounding, preserving the precise number of digits as provided by the vendor. To illustrate this, below is an overview of a sample calculation.

Overview of consolidated invoice line items vs expanded invoice line items:

Microsoft example:

You bought 10 seats of the “Microsoft 365 Business Standard“ subscription on October 1st and added and removed seats several times until October 7th.

October has 31 days. Unit Price = 3. Number of days in the charge cycle 31; used/unused days = 27 (10/5 to 10/31), including 10/5.

Microsoft invoice lines:

Note: For change event on 6th of October Effective Unit Price = 3 / 31 * 26 = 2.51 (cut down to two decimal digits). Please note the Microsoft does not apply rounding as full Effective Unit Price = 3 / 31 * 26 = 2.516129032 and thus rounded number should be 2.52 EUR. 

Reporting API invoice lines:

Consolidated invoice line items:

In consolidated invoice line-item view AppXite platform will provided all invoice line items with charge type Correction = -29 + 20.3 - 19.6 + 33.6 – 32.4 + 27 - 26.1 + 18.27 – 17.57 + 12.55 = - 12.95 EUR

Expanded invoice line items: