--- BEFORE STARTING PAYMENTS SHEET TAB ---
Navigate to the sheet tab at the bottom of the excel titled "Payments"
Please make sure there is a corresponding contract number for each payment
The payment start date and end date is used to set the recouping period for that payment
Contract Number
The corresponding contract number that the payment belongs to from the contracts sheet tab.
Payment Name
The unique identifier for this payment
If the payment has multiple installments then enter the same name for each installment to link them together.
Payment Type (Advance, Guarantee, Flat Fee)
Choose the payment from the options above: Advance, Guarantee, Flat Fee
Payment Amount
What is the payment amount?
Example formatting: "25,000.00."
Amount Due Date
What is the due date for the payment (mm/dd/yyyy)?
Formatting: (mm/dd/yyyy)
Is Recoupable? (Yes/No)
Enter either option: Yes/No
Is the Advance or Guarantee payment credited towards future royalty rate payments?
Leave this empty is Flat Fee is selected as payment type
Start Date
What is the recouping start date for Advance or Guarantee payment (mm/dd/yyyy)?
Leave this empty if the Advance or Guarantee is recoupable throughout the whole contract duration
End Date
What is the recouping end date for Advance or Guarantee payment (mm/dd/yyyy)?
Leave this empty if the Advance or Guarantee is recoupable throughout the whole contract duration
Categories
List of categories that the payment applies to
Leave this empty if the payment 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 a comma
List of territories that the payment applies to
Leave this empty if the payment 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: Separated by commas with no spaces
Example: "USA,CAN,DEN,SWE"
Distribution Channels, separated by a comma
List of distribution channels that the payment applies to
Leave this empty if the payment 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)
Example: "Online, Retail."
Payment Comment
Payment comment in a free form text
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