Overview

Currently there are two Billing Data Export components in the Ingram Micro Cloud Marketplace platform:

  1. Billing Data Export, i.e. COGS – available in Classic Reseller Control Panel.
  2. Rated Data Export, RDE – available in Unified Reseller Control Panel.

The new Billing Data Export allows you to generate reports in both short and full views:

  • Short view. Reports generated in this view are same as the reports generated by the old Billing Data Export component in structure, column names, and order.
  • Full view. A detailed report, containing all billing data.

Process

  1. Login to your Ingram Micro Cloud Marketplace.
  2. Click on the CONTROL PANEL button, you will be redirected to the Unified Reseller Control Panel.
  3. Now navigate and click on Account > Billing Data Export.

mceclip0.png

The below table shows the differences between a short report generated by the new Billing Data Export and a (COGS) report generated by the Old Billing Data Export.

Old Billing Data Export

Example value

 New Billing Data Export  (short view)

Example value

Difference in reports

Column description

Reseller ID

1000105104

Reseller ID

1000105104

No

Reseller account ID.

Reseller Company Name

CloudSoft LTD

Reseller Company Name

CloudSoft LTD

No

The company name of a reseller account.

Customer Account ID

1000105107

Customer Account ID

1000105107

No

Customer account ID.

End Customer Name

Helen’s Company

End Customer Name

Helent’s

Company

No

The company name of an end customer account.

Subscription ID

1173522

Subscription ID

1173522

No

Subscription ID.

Subscription Name

Microsoft 365 Business (Monthly Pre-Paid)

Subscription Name

Microsoft 365 Business (Monthly Pre-Paid)

No

Subscription name. By default, it matches the plan name.

Subscription Expiration Date

2022-04-01

Subscription Expiration Date

2022-04-01

No

Subscription expiration date.

Plan ID

119458

Plan ID

119458

No

The ID of an end customer’s plan.

Source Delegated Plan ID

67021

Source Delegated Plan ID

67021

No

The ID of an Ingram Micro Cloud (IMC) plan. It is used to identify which IMC plans were sold to end customers.

Source Delegated Resource ID

33215

Source Delegated Resource ID

33215

No

The ID of an IMC resource. It is used to identify which IMC resources were sold to end customers.

Detail Type

Plan Recurring

Detail Type

Plan Recurring

No

Order detail type.

Description

Subscription #1173522: Microsoft 365 Business (Monthly Pre-Paid) Recurring

Description

Subscription #1173522: Microsoft 365 Business (Monthly Pre-Paid) Recurring

No

Description for an order detail.

Order Number

SO000001

Order Number

SO000001

No

The number of an end customer’s order.

Order Type

Sales Order

Order Type

SO

Yes

The type of an end customer’s order. If it is a new billing data export, an order type abbreviation is used instead of a full name:

·         SO – sales order

·         BO – billing order

·         CH – change order

·         CL – cancellation order

·         RN – renewal order

 

Extended Price

54.54

Extended Price

54.54

No

The total cost of a plan or resource for a reseller.

Unit Price

18.18

Unit Price

18.18

No

The per-unit cost of a plan or resource for a reseller.

Quantity

3

Quantity

3

No

The quantity of purchased resources.  

Duration

1

Duration

1

No

The reseller’s charge duration.

Contract Period

1 years(s)

Contract Period

1

Yes

Subscription period. In the new billing data export, the component contract period column is split into two separate columns:

·         Contract Period – period length (1, 2, 12, 8);

·         Contract Period Type - period type (MONTHS, YEARS)

 

Contract Period Type

YEARS

Billing Period

1 month(s)

Billing Period

1

Yes

Subscription billing period. In the new billing data export component, the contract period field is split into two separate columns:

·         Billing Period – period length (1, 2, 12, 8);

·         Billing Period Type – period type (MONTHS, YEARS)

Billing Period Type

MONTHS

Invoice Date

2019-04-02

Invoice Date

2019-04-02

No

The date that a reseller’s invoice was issued by IMC.

Purchase Date

2019-04-01

Purchase Date

2019-04-01

No

The date that a subscription was purchased.

Start Date

2019-04-01

Start Date

2019-04-01

No

The reseller’s charge start date.

End Date

2019-05-01

End Date

2019-05-01

No

The reseller’s charge end date.

Last Billing Date

2019-04-01

Last Billing Date

2019-04-01

No

The most recent date that a subscription was billed.

Next Billing Date

2019-05-01

Next Billing Date

2019-05-01

No

The date that a subscription will be billed next.

End Customer Unit Price

24.21

End Customer Unit Price

24.21

No

The reseller’s sales amount of a resource or plan, per unit.

End Customer Extended Price

72.63

 

End Customer Extended Price

72.63

 

No

The total sales amount of a plan or resource per order detail.

SKU

2b3b8d2d-10aa-4be4-b5fd-7f2feb0c3092

SKU

2b3b8d2d-10aa-4be4-b5fd-7f2feb0c3092

No

SKU ID.

Custom Account ID

CUST-001

Custom Account ID

CUST-001

No

External Account ID. Can be used for integration with external systems.

Purchase Order Number

PO-4352

Purchase Order Number

PO-4352

No

Purchase Order number information. Can be used for integration with external systems.

 

RDE limitations

  1. Customizing reports is only possible through the API.
  2. Emailing reports is not supported. You can only download reports from the user interface.

FAQs

Where can I find reporting in the new Control Panel?

Go to Account > Billing Data Export. When creating a report, there are two report views: Full and Short. The “short” view will generate a report containing the same columns as the COGS report from the Classic Panel. The “full” view will generate a report with all the available columns.

Will I have access to previously generated COGS reports?

No. The Billing Data Export menu item will be removed from the Classic panel. However, you will be able to generate a report for any period in the past in the new control panel, Account > Reporting and Data Export.

Will I still receive scheduled COGS reports?

No. You will need to configure new scheduled reports in the new control panel, Account > Reporting and Data Export. For help on scheduling reports,  go to https://ingrammicro-assist.freshdesk.com/en/support/solutions/articles/66000396564-10-how-to-generate-and-download-the-billing-data-export-report-from-the-control-panel

Previously I received reports by email. How will I get reports from the Reporting and Data Export?

Instead of a report file, you will receive a download link that is valid for up to 48 hours after report generation. Use the download link to download reports. In addition, you may download reports directly from the new control panel, Account > Reporting and Data Export. Reports in the control panel, Account > Reporting and Data Export, are available 90 days after report generation.

 

Please note that only the person who scheduled the report creation will receive the email notification with the download link. If several people need to receive the email notification, you may use a distribution list as the user's email address. There are two ways to change email address for notifications:

Is it possible to configure additional reports (views) in the new control panel?

No. Configuration of additional reports is not possible at this time. If you require additional reports, please provide feedback using the smiley face icon located in the left bottom corner of the Billing Data Export (Reporting and Data Export) screen.

mceclip1.png


“Modifying Privileges”