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 can I send questions about my statement?
- Questions can be sent to VST-accountspayable@vitalsource.com.
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 when the order was generated |
BILLING_MODEL | Defines how the customer is transacting on the individual sale |
CODE | Unique order number for individual sale |
DISTRIBUTOR | Name of account that 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 | Type of content being distributed |
DURATION | If blank, the product has an unlimited licence; otherwise, it displays the number of days for a digital licence |
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_UNIT | Commission calculated per unit, based on Distributor's contract terms |
CA_GST | Goods and services tax paid to Canadian customers; blank for all others |
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 on which commission/compensation is due to be paid |