By default, the Charges and Usage report is broken down by the SKU, Google Entity, and Resource. When you set up your reports, you can choose these additional breakdowns:
By account: This adds Account Id and Insights Account Id columns to the report, which show a billing ID for the customer. You can use this ID to track metrics like churn or trial conversions. The Account Id isn't the customer's Google Cloud billing ID, but it is specific to the customer's Cloud Billing account. There are two forms of obscured account ID in the report because, for historical reasons, the two reports use different algorithms to obscure the actual account ID. For more information about matching disbursements to customers, see Determine the customer for a specific disbursement in this document.
By location: This adds a Location column to the report, which holds the country code for the customer's location. If the customer is in the US or Canada, the column includes the country and state code, separated by a
/
.
Determine the customer for a specific disbursement
To match a disbursement in the Charges and Usage report to the name of the customer for that disbursement, complete the following steps:
Turn on
by account
reporting.Set up Customer insights reports.
Find the value of the disbursement's
Insights Account Id
in this report.Find the row in the Customer insights report whose value for
external_account_id
matches theInsights Account Id
value that you found.
Report frequency
This report is generated by the tenth business day of every month in the
destination that you set up. It includes the details of usage and revenue for
the previous month. Its name uses the following format:
YYYYMMDD Charges and Usage
For example, a report named 20210401
means the report is for the usage that
happened in April 2021.
Report fields
The report contains the following content. For any questions about the report, contact your Partner Engineer.
SKU: The description of the Cloud Marketplace product.
Google Entity: The Google corporation that received the payment from customers. The payment to you originates from this corporation.
Resource: The resource for which the customer was charged. For virtual machine (VM) products, this depends on your product's pricing model. For software as a service (SaaS) and Kubernetes products, this is the usage metric.
Usage: The quantity of the resource used by deployments of the product.
Units: The unit in which the Usage column is measured, such as hours, core-hours, or gibibyte-hours, depending on your pricing model.
Currency: The currency in which the following three columns are measured.
Charges: The customer's costs for using your product. Starting with April 2021's report, if you are paid in a currency other than USD, this field uses your payment currency.
Trial Use: The cost that was covered by product trial credits, coupon-created credits, and product testing. Starting with April 2021's report, if you're paid in a currency other than USD, this field uses your payment currency.
Due Partner: Payment accrued for you, calculated as
(Charges - Trial Use + Prepay Credits + Postpay Credits) * revenue share
.Payment Type: The means by which you will receive the disbursement: If it is
old
, you receive payments from Google US or a regional Google entity to your US-based bank account. If it isnew
, you receive a single payment to your local bank account.Withheld: If a Google Cloud customer's Cloud Billing account is placed on probation for nonpayment, Google withholds disbursements until the account is back in good standing.
This column tells you how much we would have paid you if we had collected it from the customer.
When the billing account is back in good standing, we release the withheld funds in the next payment to you. If it never returns to good standing, we abandon the withheld funds.
Released: If Google had withheld funds, this column shows the total of the funds that are now released to you because the customer's billing account is back in good standing.
Abandoned: If Google had withheld funds, this column shows the total of the funds abandoned because we have terminated the billing account.
Probation Start: The first day that Google started withholding funds, in
YYYY-MM-DD
format. If we are releasing or abandoning funds, this may be in an earlier month. If the account is still on probation, this is the first day in the current month where we withheld funds (which may not be the very first day on which we withheld funds).Probation End: The last day that Google withheld funds, in
YYYY-MM-DD
format. The day after this, the account either returned to good standing, or we closed it. If this is blank, then the account is still on probation.Refund Start: The first day that Google refunded a customer's usage, in YYYY-MM-DD format.
Refund End: The last day that Google refunded a customer's usage, in YYYY-MM-DD format.
Refund Balance Deducted This Month: The amount of payout Google subtracted during the month related to a customer refund.
Refund Balance Outstanding: If the offset related to a customer's refund is greater than the month's payout, the remaining offset due to your future payout.
Refund Reason: The reason why a customer received the refund.
Postpay Credits: The amount by which
Charges
were reduced by credit purchased through a commitment-based private offer with a postpay payment schedule, before theDue Partner
amount was computed.
If you've enabled reselling of your products, these additional fields are present:
Reseller Margin: The amount by which the
Charges
were reduced before the payout was computed, to provide a discount to the reseller.Channel: This indicates the sales channel, and has a value of either
RESOLD
orDIRECT
.
If you create private offers, the following additional fields might be present:
Prepay Credits: The amount by which
Charges
were reduced by credit purchased through a commitment-based private offer with a prepay payment schedule, before theDue Partner
amount was computed.Billing frequency: Describes the recurring billing interval selected at the time of offer creation. Can have the value
monthly
,quarterly
,yearly
,pay_go
, orcustom
.Payment Schedule: For offers created before February 23, 2024, which used payment schedules instead of billing frequency, this indicates the offer's payment schedule. Has a value of
Prepay
if this is a prepaid installment charge, orPostpay
if it's a postpaid charge, or a charge that's covered by a credit purchased through a prepaid commitment charge.