Billed revenue dashboard
The billed revenue dashboard provides information about all billed sales in AWS Marketplace. This report is expected to save time and is available approximately 45 days earlier than the legacy monthly billed revenue report. The legacy report delivers on the 15th day of each month, which delays visibility on billings of the prior month.
You can export and download data (as .csv or Microsoft Excel files) from any chart, graph, and table on the Amazon QuickSight dashboard. For more information, see Exporting data from visuals in the Amazon QuickSight User Guide.
For operational and financial processes, review the following topics.
Topics
Refresh frequency of the billed revenue dashboard
Dashboards are updated daily at 4 PM PST (midnight UTC). If an invoice is created on May 10 before 4 PM PST (midnight UTC), then the update on May 11 will display the invoice. If an invoice is created on May 10 after 4 PM PST (midnight UTC), then the update on May 12 will display the invoice. If the latest invoicing or disbursement data received from upstream systems is delayed, there might be a 1–2 day delay for the latest data to reflect on the dashboards.
If you don’t see an expected customer invoice, use the following procedure before contacting your AWS Marketplace business development contact.
To troubleshoot missing customer invoices for the billed revenue dashboard
-
Confirm that the offer was accepted by the customer using one or more of the following tools:
-
(For private offers) After you confirm that the customer accepted the offer, review the offer invoice schedule and amounts:
-
For private offers, check the AWS Marketplace Management Portal Offers tab.
-
For channel partner private offers, check the AWS Marketplace Management Portal Partners tab to view a custom payment schedule within the partner opportunity.
-
-
Consider if the transaction uses a usage pricing model, where customers are billed on the second and third day of each month for the previous month of usage.
Section 1: Controls
This section of the dashboard provides filters to refine your billed revenue dashboard data. For example, you can select a filter on a field from the notifications for AWS Marketplace events to confirm billing for a specific customer account ID, subscriber company name, or offer ID. You can also add a filter to an analysis, such as the range of dates that you want to include in visuals. The filters selected within the controls update the data that is displayed in the metrics, trends, breakdowns, and granular data sections.
For more information about filtering, see Filtering data on Amazon QuickSight in the Amazon QuickSight User Guide.
Control descriptions
| Control name | Description |
|---|---|
| Subscriber AWS account ID | The ID of the account that subscribed to the product. |
| Subscriber company name | The name of the account that subscribed to the product. |
| Product title | The title of the product. |
| Offer ID | The identifier for the offer that the buyer signed. |
| Offer visibility | Whether the offer is a public, private, or enterprise contract offer. |
| Agreement ID | A unique agreement data feed reference for the agreement signed between a proposer and an accepter to start using a product. |
| AWS seller of record | An identifier of the business entity which facilitated the transaction. Possible
values include:
|
| Payer AWS account ID | The ID of the account that the charges are billed to. |
| Payer company name | The business name of the account that the charges are billed to. |
| Reseller company |
The business name of the reseller account authorized to sell a software manufacturer's product. |
| Reseller AWS account ID | The ID of the account that purchased a product or service at wholesale from an ISV to resell to a customer. |
| Resale authorization ID | The unique identifier for a registered opportunity. |
| Resale authorization name | The unique name for a registered opportunity. |
| Subscriber country | The two-character country code associated with the account subscribed to the product. |
| Subscriber state or region | The billing address state or region associated with the account subscribed to the product. |
| Transaction reference ID | A unique identifier for the transaction that helps you correlate transactions across AWS Marketplace legacy reports. |
Section 2: Invoice date range
This section of the dashboard provides filters to refine records based on whether the billing date is before or after a specified date or within a date range. The filter selected within the invoice date range updates the data displayed in the metrics, trends, breakdowns, and granular data sections. The default invoice date range is set to pull data from the last six months.
Section 3: Metrics
This section of the dashboard displays a key performance indicator (KPI) to visualize a comparison of key billed revenue figures. A KPI is displayed for gross revenue, gross refund, listing fee, wholesale cost (if applicable), and seller net revenue for the specified invoice date range. You can update the date range by updating the date criteria in the invoice date range field.
Section 4: Trends
This section of the dashboard provides billed revenue trends for a specified date range. You can view the trends by a specified date aggregation—such as day, month-over-month, quarter-over-quarter, or year-over-year—to gain insight into billed revenue. Billed revenue trends information is available at an aggregate level or by offer visibility type:
-
Billing trends – Provides a snapshot of gross revenue, seller net revenue, wholesale cost (if applicable), and refunds over time for the selected date range from the date aggregation filter.
-
Billing trend by offer visibility – Provides a snapshot of offer count and gross revenue by offer visibility type over time across private offers, public offers (or self-service), and enterprise programs.
Section 5: Breakdowns
This section of the dashboard provides you with key metrics about your business across subscribers, seller of records, subscriber geography, and product title. You can filter by gross revenue, payer count, subscriber count, gross refund, listing fee, seller net revenue, and wholesale cost.
Section 6: Granular data
This section of the dashboard shows all billed sales, including the total amount that AWS bills to customers for hourly, annual, or monthly usage of your products. AWS bills customers using the following three frequencies:
-
Date of subscription acceptance (upfront billing)
-
Custom payment schedule (private offers built by flexible payment scheduler)
-
Metered usage on the second and third day of the month for the prior month’s usage
Note
Invoices created before April 1, 2021 might not have an associated agreement ID, offer ID, subscriber AWS account ID, or subscriber company name.
Customer charges display in this granular data section 24 hours after the customer has been billed. For example, if a customer was charged on November 3, then the dashboard reports this invoice on November 4. For more information about how to export and download data from a QuickSight table, see Exporting data from visuals in the Amazon QuickSight User Guide.
Granular data descriptions
| Column | Description |
|---|---|
| Invoice date | The date the customer was billed for the product subscription. |
| Payment due date | The payment due date in the format of YYYY-MM-DD. |
| Payment terms | The customer's AWSinvoice payment terms. |
| Invoice ID | The AWS ID assigned to the charges billed to the customer. |
| Listing fee invoice ID | When an AWS Marketplace subscription is transacted through AWS EMEA SARL, Japan or Australia legal entities (seller of record), the operator for the sale is required to charge the seller a value-added tax (VAT) on the seller listing fee and given a tax compliant invoice. For applicable transactions, the invoice ID for the VAT assessed on the listing fee is different than the software or product subscription invoice ID. Transactions from AWS, Inc. have a value of "Missing_listing_fee_invoice_id" because the listing fee invoice ID is not applicable. |
| Subscriber company name | The name of the account that subscribed to the product. |
| Subscriber AWS account ID | The ID of the account that subscribed to the product. |
| Subscriber email domain | The email domain associated with the account that subscribed to the product. For example, if the email address is liu-jie@example.com, the entry is example.com. |
| Subscriber city | The billing address city associated with the account that subscribed to the product. |
| Subscriber state or region | The billing address state associated with the account subscribed to the product. |
| Subscriber country | The billing address country associated with the account that subscribed to the product. |
| Subscriber postal code | The billing address postal code associated with the account that subscribed to the product. |
| Product title | The title of the product. |
| Offer name | The seller-defined name of the offer. |
| Offer ID | The identifier for the offer that the buyer signed. |
| Offer visibility | Whether the offer is a public, private, or enterprise contract offer. |
| Agreement ID | A unique agreement data feed reference for the agreement signed between a proposer and an accepter to start using a product. |
| Agreement start date | The date that the customer's product subscription starts, formatted as MM-DD-YYYY. This date could be different than acceptance date if this is a future dated agreement. |
| Agreement acceptance date | The date when the customer subscribed to the product, formatted as MM-DD-YYYY. |
| Agreement end date | The date when the contract expires, formatted as MM-DD-YYYY. For metered/pay-as-you-go subscriptions, this date is set to JAN-1-9999. |
| Usage period end date | The end date of the product usage period. |
| Usage period start date | The start date of the product usage period. |
| Disbursement status | A status associated with an invoice to confirm that AWS has collected and disbursed funds to your bank accounts since the previous disbursement. Disbursed funds for the associated invoice have been collected and disbursed. Not Disbursed funds for the associated invoice have not been collected and disbursed. |
| Disbursement date | The date AWS initiated disbursement to the seller’s bank. |
| Disburse bank trace ID | For disbursements, the trace ID is assigned by the bank. The disburse bank trace ID can be used to correlate seller bank-provided deposit notifications and reports to invoices in AWS Marketplace reports. |
| Gross revenue | The amount that is billed to the customer for the usage or monthly fees of the product. |
| Gross refund | The total amount of the subscription cost refunded to customers if any refunds were processed during the data coverage period. |
| Listing fee | The AWS Marketplace fee amount to be deducted from the billed amount. |
| Listing fee refund | The portion of the AWS Marketplace fee refunded if any refunds were processed during the data coverage period. |
| Listing fee percentage | The AWS Marketplace fee percentage to be deducted from the billed amount. |
| Seller tax share | The total amount of US sales and use tax billed for this transaction. |
| Seller tax share refund | The total amount of US sales and use tax refunded for this transaction if a refund was processed. |
| AWS tax share | The total amount of US sales and use tax billed for this transaction on behalf of the seller. |
| AWS tax share refund | The total amount of US sales and use tax refunded for this transaction if a refund was processed, when such taxes were collected on behalf of the seller. |
| Wholesale cost | For channel partner private offers only. The cost of goods to a reseller. For example, what a reseller pays a manufacturer when they sell a manufacturer's product. The wholesale cost is the list price multiplied by the discount percentage. |
| Wholesale cost refund | For channel partner private offers only. The refunded cost of goods from a reseller. |
| Seller net revenue | The total amount billed for the transaction, net of AWS Marketplace fees, refunds, and US sales and use tax. |
| Currency | The currency of the transaction. For example, if the transaction is in US dollars, the entry is USD. |
| Transaction reference ID | A unique identifier that represents the transaction, which you can use to correlate transactions across AWS Marketplace reports. |
| AWS seller of record |
An identifier of the business entity which facilitated the transaction. Possible values are as follows:
|
| Resale authorization ID |
The unique identifier for a registered opportunity. |
| Resale authorization name | The unique name for a registered opportunity. |
| Resale authorization description | The ISV-defined description for a registered opportunity. |
| Resale company name | The name of the account that purchased a product or service at wholesale cost from an ISV to resell to a customer. |
| Payer AWS account ID | The ID of the account that purchased a product or service at wholesale cost from an ISV to resell to a customer. |
| Payer email domain |
The email domain that is associated with the account that the charges are billed to. For example, if the email address is liu-jie@example.com, the entry is example.com. |
| Payer city | The billing address city associated with the account that charges are billed to. |
| Payer state or region | The billing address state associated with the account that the charges are billed to. |
| Payer country | The two-character country code associated with the account that the charges are billed to. |
| Payer postal code |
The billing address postal code associated with the account that the charges are billed to. |
| ISV account ID | The identifier of the product or service owner. |
| ISV company name | The business name of the product or service owner. |
| Product ID |
The friendly unique identifier for the software product. |
