Creating a Billing Information Report of Google Workspace Subscriptions

A new report template is available, which allows you to obtain billing information reports of Google subscriptions.

Adding the Custom Report Template to CloudBlue Connect

Before creating the report, it is necessary to add the repository containing the Google report template to CloudBlue Connect. To do this, complete the following steps:

1. In the Distributor portal, go to Home > Account > Reports.

2. Click the Repositories tab, click Add Repository and enter the following GitHub repository URL containing the report template: https://github.com/cloudblue/google-workspace-connect-report

3. Select the tag corresponding to the latest version.

Creating a Billing Information Report of Google Workspace Subscriptions

Once you have added the custom report template to CloudBlue Connect, you will be able to create a report based on such template. To do this, complete these steps:

1. Go to Reports > Directory in the Distributor portal and click Create Report.

2. Select the Google Billing Information report template. A description of the report is displayed, including information about the available configuration. Read the description carefully and click Next.

3. Select a subscription creation date range: A maximum of two months can be selected. Click Next.

4. Select the transaction type (test or production). Click Next.

5. Select the marketplace. Click Next.

6. Select the Google Workspace product (PRD-550-104-278).

7. Select the output format: XLSX, JSON or CSV. Once the report file is created, it will not be possible to change the output format. Click Next.

8. Enter the report name and, optionally, a description. Then, click Create.

Right after completing the wizard steps, you will see the report listed in the reports directory with the Deploying status. Once the status changes to Ready, you will be able to download the report. To do that, just click the report name and download the report file.

Notes:
- CloudBlue Connect also allows you create scheduled reports. For additional information, refer to the CloudBlue Connect documentation.

The report includes all the billing details for the subscriptions in the selected period

Below you can find a brief description of the possible values in the Charge Type column:

Charge Type	Description
New Subscription	The customer bought the subscription.
Renewal	The subscription renewed.
Change	The subscription licenses were changed before the first renewal.
Renewal Change	The subscription licenses were changed after the first renewal.
Cancel	The subscription is stopped.
Transfer	It is a transferred subscription.

In the Charge Date column you can see the date when the charge was effective.