Migrating Payments

Created by Victoria Crosby, Modified on Fri, 28 Apr 2023 at 02:45 PM by Victoria Crosby

--- 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