--- BEFORE STARTING ROYALTY RATES SHEET TAB ---
Navigate to the sheet tab at the bottom of the Excel sheet titled 'Royalty Rates.'
Please make sure there is a corresponding contract number for each royalty rate according to the contract number.
If a contract has different types of Royalty Rates with conditional logic, each Royalty Rate type and condition should be on a separate row/line.
Make sure to include the unique identifier for that royalty type to determine what royalty rate gets applied where (i.e. certain royalty rate for certain distribution channels).
Contract Number
The corresponding contract number that the royalty rate belongs to from the contracts sheet tab.
Royalty Rate
The royalty rate (% or currency amount).
For contracts with multiple royalty rates, each royalty rate has to have some unique identifier to know what condition should apply that rate.
For contracts with multiple royalty rates - add each separate royalty rate on a new row with the corresponding contract number it belongs to. *Important* - Each royalty rate must have a unique identifier to determine under which condition to apply each royalty rate.
Royalty Type (Net Sales, Gross Sales, Flat Fee per Unit, Cost)
The royalty rate type based on the options provided above
Rate Type (Standard, FOB)
Is it a standard royalty rate applied to sales in conventional distribution channels or a rate applied to FOB sales?
Please use the available options provided in the column header: Standard, FOB.
Condition Base (Units Sold, Net Amount Sold, Price, Calendar Year)
Is this royalty rate applied only if certain conditions are met i.e if the price of the product is higher than $20.00?
Please use available options provided in the column header: Units Sold, Net Amount Sold, Price, Calendar Year.
Condition (Equals, Is lower than, Is lower than or equal to, Is greater than, Is greater than or equal to)
Fill this only if you have a 'Condition Base.'
Please use available options provided in the column header: Equals, Is lower than, Is lower than or equal to, Is greater than, Is greater than or equal to
Condition Amount
Fill this only if you have a 'Condition Base.'
Categories
List of categories that the royalty rate applies to.
Leave this empty if the royalty rate applies to all categories in this contract.
The category names provided have to be an exact match to category names within Brainbase including the parent category name(s).
Category Tree: Parent category followed by Subcategories
Formatting: Parent Category + ">" + Subcategory + "," + Subcategory + ","
Example: "Apparel > Socks, Apparel > Headwear > Hats"
Territories, separated by commas
List of territories that the royalty rate applies to.
Leave this empty if the royalty rate applies to all territories in this contract
For territory names, please use ISO 3166-1 alpha-3 codes listed here: https://en.wikipedia.org/wiki/ISO_3166-1_alpha-3
Formatting: Separate each Distribution Channel by a comma
Distribution Channels, separated by commas
List of distribution channels that the royalty rate applies to
Leave this empty if the royalty rate applies to all territories in this contract
The distribution channel names provided have to be an exact match to distribution channel names within Brainbase including the parent channel name(s).
Formatting: Separate each Distribution Channel by a comma
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article