Schema:

Data Sharing Usage

MARKETPLACE_LISTING_INVOICE_STATUS view¶

The MARKETPLACE_LISTING_INVOICE_STATUS view in the Data Sharing Usage schema lets providers of paid Snowflake Marketplace listings track each invoice’s full billing lifecycle: what was billed, collected, and disbursed. Rows are at line-item grain (one invoice can span multiple rows, for example installments), and the view is visible only to providers of paid listings, showing only their own data.

Use this view for the following tasks:

• Cash-flow forecasting: See whether each invoice is unpaid, collected but not yet disbursed, or disbursed, and when the payout was made.
• Collections and aging: Find open invoices by due date, and see the amount billed, the Marketplace Capacity Drawdown (MCD) amount applied, and the balance remaining after MCD.
• Payout reconciliation: Compare the expected payout with the amount disbursed, and tie disbursements to bank deposits by date.
• Invoice and offer details: Review subtotals, sales tax, fees, billing periods, installment numbers, and the offer name and type for each line item.
• Consumer and jurisdiction details: Get the consumer’s billing and shipping addresses, the additional recipients selected at checkout, and the billing email address on file, for example to confirm tax jurisdiction or contact a consumer about an overdue invoice.
• Revenue reporting: Summarize billed and disbursed amounts by month, listing, or consumer.

Columns¶

Usage Notes¶

• Latency for the view can be up to 24 hours.
• The data is retained for 7 years.

Examples¶

1. Open accounts receivable and aging¶

Retrieve unpaid invoices, oldest overdue first, with the consumer contacts to follow up with and the line-item balance after Marketplace Capacity Drawdown (MCD) is applied. days_overdue is negative for invoices that aren’t due yet. To see only past-due invoices, uncomment the optional filter.

balance_after_mcd reflects MCD only, at line-item grain. It isn’t a true outstanding balance, and it doesn’t account for payments that aren’t MCD or for partial payments.

SELECT
  invoice_number,
  invoice_status,
  due_date,
  DATEDIFF('day', due_date, CURRENT_DATE()) AS days_overdue,
  listing_display_name,
  installment_number,
  consumer_account_name,
  consumer_company_name,
  consumer_billing_email_address,
  purchaser_emails,
  subtotal_amount,
  total_billed_amount,
  mcd_applied_amount,
  balance_after_mcd
FROM snowflake.data_sharing_usage.marketplace_listing_invoice_status
WHERE invoice_status = 'open'
  -- Optional: uncomment to show only past-due invoices.
  -- AND due_date < CURRENT_DATE()
ORDER BY due_date;

2. Compare disbursed and open amounts¶

For each line item, open items first, see whether it has been disbursed to you, how much was disbursed and when, and how much is still open, meaning not yet disbursed.

SELECT
  invoice_number,
  invoice_date,
  due_date,
  listing_display_name,
  installment_number,
  consumer_account_name,
  invoice_status,
  IFF(disbursement_status = 'Disbursed', 'Disbursed', 'Open') AS payout_status,
  expected_payout_amount,
  IFF(disbursement_status = 'Disbursed', disbursement_amount, 0) AS disbursed_amount,
  IFF(disbursement_status = 'Disbursed', 0, expected_payout_amount) AS open_amount,
  disbursement_date
FROM snowflake.data_sharing_usage.marketplace_listing_invoice_status
WHERE invoice_status IN ('open', 'closed')
  -- Optional: uncomment and edit to limit results to a reporting period.
  -- AND invoice_date BETWEEN '2026-01-01' AND '2026-03-31'
ORDER BY payout_status DESC, invoice_number, installment_number;

3. Summarize monthly payouts¶

Retrieve the total amount disbursed in each month.

SELECT
  DATE_TRUNC('month', disbursement_date) AS disbursement_month,
  SUM(disbursement_amount) AS total_disbursed
FROM snowflake.data_sharing_usage.marketplace_listing_invoice_status
WHERE disbursement_status = 'Disbursed'
GROUP BY ALL
ORDER BY disbursement_month;

4. Forecast cash flow by payment stage¶

List each line item with its payment stage, based on whether the consumer has paid in full (consumer_paid_in_full_date) and whether you’ve been paid out (disbursement_status):

• Disbursed: Snowflake has paid you.
• Collected, not disbursed: the consumer paid in full, or MCD covered the full amount, but you haven’t been paid out yet.
• Billed, Partially paid: MCD covered part of the amount, so balance_after_mcd is less than total_billed_amount.
• Billed, not paid: the invoice is open and nothing has been paid.
• Closed, payment not applicable: the invoice was closed without any payment being due, for example because it was credited or written off.

Rows are sorted by stage, starting with billed but unpaid, with the dates that show where each line item is in the cycle. Voided and rebilled rows are excluded so that canceled invoices aren’t counted.

SELECT
  CASE
    WHEN disbursement_status = 'Disbursed' THEN 'Disbursed'
    WHEN consumer_paid_in_full_date IS NOT NULL OR balance_after_mcd = 0 THEN 'Collected, not disbursed'
    WHEN balance_after_mcd <> total_billed_amount THEN 'Billed, Partially paid'
    WHEN invoice_status = 'open' THEN 'Billed, not paid'
    ELSE 'Closed, payment not applicable'
  END AS payment_stage,
  invoice_number,
  listing_display_name,
  installment_number,
  consumer_account_name,
  invoice_date,
  due_date,
  consumer_paid_in_full_date,
  disbursement_date,
  total_billed_amount,
  balance_after_mcd,
  expected_payout_amount,
  disbursement_amount
FROM snowflake.data_sharing_usage.marketplace_listing_invoice_status
WHERE invoice_status IN ('open', 'closed')
ORDER BY
  CASE payment_stage
    WHEN 'Billed, not paid' THEN 1
    WHEN 'Billed, Partially paid' THEN 2
    WHEN 'Collected, not disbursed' THEN 3
    WHEN 'Disbursed' THEN 4
    ELSE 5
  END,
  due_date,
  invoice_number,
  installment_number;

5. Total each invoice across line items¶

Combine line items into one row per invoice, with the listings on the invoice, billed amount, sales tax, fees, MCD applied, and expected payout. Voided and rebilled rows are excluded so that canceled invoices aren’t counted.

SELECT
  invoice_number,
  ANY_VALUE(consumer_account_name) AS consumer_account_name,
  LISTAGG(DISTINCT listing_display_name, ', ') AS listings,
  MIN(due_date) AS first_due_date,
  SUM(subtotal_amount) AS subtotal,
  SUM(sales_tax_amount) AS sales_tax,
  SUM(fee) AS fee,
  SUM(total_billed_amount) AS total_billed,
  SUM(mcd_applied_amount) AS mcd_applied,
  SUM(expected_payout_amount) AS expected_payout
FROM snowflake.data_sharing_usage.marketplace_listing_invoice_status
WHERE invoice_status IN ('open', 'closed')
GROUP BY invoice_number
ORDER BY invoice_number;