Automated Commission Statements FAQs

Automated Commission Statements FAQs

What are Commission Statement files?

  • Commission statements are Excel reports that show all content invoiced in a calendar month, in which compensation is owed to the school.

How frequently are Commission statements sent?

  • Commission statements are sent monthly, typically in the first week of the following month, e.g., orders invoiced in November will be sent in early December.

Who are Commission statements sent to? How do I update who they are sent to?

  • Commission statements are sent to all email addresses associated with the school’s Oracle Supplier account.
     
  • If an email address needs to be added or removed, please contact your Customer Success Manager or email VST-accountspayable@vitalsource.com.

Where do I send questions about my statement?

How do I read the Commission file?
 

  • Please reference the table below which contains the column, column header, and definition in the Commission Excel file.
Column Header Definition
TRANSACTION_DATE Date order was generated
BILLING_MODEL Defines how customer is transacting on the individual sale
CODE Unique order number for individual sale
DISTRIBUTOR Name of account the individual sale occurred under
PUBLISHER Content owner/publisher name
SKU SKU in which billing activity was created against
CUSTOM_ISBN Custom ISBN assigned to applicable titles; specific to a Distributor/title
TITLE Title of content
CONTENT_TYPE Kind of content being distributed
DURATION If blank, product has an unlimited license; otherwise it displays the number of days for a digital license
QUANTITY Quantity of sale or refund per transaction
LIST_PRICE Distributor's price per unit
TOTAL_LIST_PRICE List price x Qty
LIST_PRICE_CURRENCY Currency in which the Distributor transacts   

COMMISSION_RATE

Displays the rate associated with your commission structure. For example, if you earn 10%, this column will show 10 or 10.00.

COMMISSION_BASIS

Indicates what your commission is based on: NET (net sales), GROSS (gross sales), or FIXED (a fixed fee).

COMMISSIONABLE_AMT

Shows the actual dollar amount your commission is calculated from.

COMMISSION_UNIT Commission calculated per unit, based on Distributors contract terms
COMMISSION_TOTAL Commission per unit x Qty
COMMISSION_CURRENCY Currency in which the Distributor transacts and is paid
AP_INVOICE_NUM Internal VST invoice number
COMP_DUE_DATE Date in which commission/compensation is due to be paid
Was this article helpful?