Collections and disbursement dashboard

The collections and disbursements dashboard provides data about funds that AWS collected and disbursed to your bank accounts since the previous disbursement. It also provides a list of all invoices that are open and unpaid.

Disbursements include customer payments or refunds for a subscription to your product and some taxes collected or refunded to the customer. You don’t receive disbursement of funds until the full amount of funds on an invoice is collected from the customer. Refunds on the dashboard appear as negative amounts because the money is returned to your customer after you authorize a refund.

By using the collections and disbursements dashboard, you’ll receive more timely access to customer disbursements. Expect to save approximately 4 days compared to the legacy disbursement report, which is created 5 days after the disbursement is sent.

Note

Customers have different payment terms with AWS, so some funds in the uncollected age categories might not be due from the customer.

The collections and disbursements dashboard provides information for operational and financial processes. The dashboard refreshes daily. For more information, see the following topics.

Refresh frequency of the collections and disbursements dashboard

The collections and disbursements dashboard is updated on North American business days only. You can expect to see disbursed invoices within 1 day of receiving a deposit to your bank.

Section 1: Controls

This section of the dashboard provides filters to refine your dashboard data. For example, you can select a filter on a field from the notifications for AWS Marketplace events to confirm disbursement for a specific customer account ID, subscriber company name, or offer ID. You can also filter by disbursement status to understand all invoices paid to you or invoices open and unpaid. You can 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 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 that facilitated the transaction. Possible values include: AWS_INC: The identifier for AWS, Inc. (based in the United States). AWS_EUROPE: The identifier for Amazon Web Services EMEA SARL (based in Luxembourg). AWS_AUSTRALIA: The identifier for Amazon Web Services Australia Pty Ltd (AWS Australia) AWS_JAPAN: The identifier for Amazon Web Services Japan G.K.
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.
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.
Disburse bank trace ID	For disbursements, the trace ID is assigned by the bank. The bank trace ID can correlate seller bank-provided deposit notifications and reports to invoices in AWS Marketplace reports.

Section 2: Select date category

This section of the dashboard provides filters to refine records based on two different date dimensions and whether the date field value is before or after a specified date or within a date range. The date dimensions are payment due date or last disbursement date. The date category filter updates the data displayed in the metrics, trends, breakdowns, and granular data sections. The default date category is the last disbursement date and pulls data from the last six months.

Section 3: Metrics

This section of the dashboard displays a key performance indicator (KPI) to visualize a comparison between disbursed and undisbursed revenue figures. A KPI is displayed for gross revenue, net revenue, wholesale cost (if applicable), amount disbursed, and amount undisbursed for a specified date category and date range.

Section 4: Trends

This section of the dashboard provides a view of disbursement and past due trends for the specified date range. You can view the trends by a specified date aggregation, such as by day, month, quarter, or year, to gain insight into your AWS Marketplace collection health. Trend views include the following:

• Disbursement trends – Provides a snapshot of the average number of days to disburse and associated net revenue. The trend measures the number of days between invoice date and disbursement date to report collection efficiency. You can select a date range from the date aggregation filter.

• Age of disbursed payments – Provides a snapshot of net revenue and a count of disbursed invoices that is categorized by standard aging receivable buckets (such as not due, 1 to 30 days, and 31 to 60 days). The trend measures the days between payment due date and disbursement date to report if the disbursement was within the customer’s payment terms.

• Age of undisbursed payments – Provides a snapshot of net revenue and count of open and unpaid invoices, organized by past due buckets (such as not due, 1 to 30 days, and 31 to 60 days). Undisbursed funds might include amounts that aren't due yet. The trend measures days between today's date and the payment due date to display incoming receivables.

Section 5: Breakdowns

This section of the dashboard provides you with a view of receivables by offer ID, product title, payer company name, subscriber company name, reseller name (if they participate in channel partner private offers), payer geography, and subscriber geography. Use the breakdowns to measure disbursed receivables against undisbursed receivables for each category.

Section 6: Granular data

This section of the dashboard shows all disbursements and uncollected funds by product, customer, and offer details.

Note

Invoices created before April 1, 2021 might not have an associated agreement ID, offer ID, subscriber AWS account ID, or subscriber company name.

For 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 AWS invoice 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 marketplace operator for the sale (for example, AWS EMEA SARL) is required to charge the seller a VAT on the seller listing fee. For applicable transactions, the invoice ID for the VAT assessed on the listing fee is different than the software or product subscription invoice ID.
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 [e-mail], 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 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 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.
Agreement acceptance date	The date when the customer subscribed to the product, formatted as MM-DD-YYYY.
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 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 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.
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: AWS_INC: The identifier for AWS, Inc. (based in the United States) AWS_EUROPE: The identifier for Amazon Web Services EMEA SARL (based in Luxembourg) Amazon Web Services Australia Pty Ltd (AWS Australia) Amazon Web Services Japan G.K.
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.
Reseller company name	The name of the account that purchased a product or service at wholesale cost from an ISV to resell to a customer.
Reseller 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 company name	The name of the account that the charges are billed to.
Payer AWS account ID	The ID of the account that the charges are billed to.
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 [e-mail], 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.
Disbursed net revenue	The total amount for the transaction disbursed to seller.
Undisbursed net revenue	The total amount for the transaction not disbursed to seller
Disbursement period	The categories describing the receivables range in which the funds were collected (such as, not due, 1 to 30 days, and 31 to 60 days).