Unrecognized SKUs are created when you or the licensee upload sales to products that have not been added to RoyaltyZone. When a SKU is unrecognized, RoyaltyZone charges the highest royalty rate on the agreement, and does not apply any recoupable guarantee amount to the sales, which could cause your royalty report to be overstated. Reconciliation of your unrecognized SKUs is a MUST for accurate reporting.
Since unrecognized SKUs must be reconciled on the Royalty Report page, it is always best practice to reconcile them when they first appear. If not, you will need to reconcile each report that has unrecognized SKUs until they are all fixed. We recommend you start with your most current report first. Fixing these will fix any previous SKUs that are unrecognized and the process will be faster as you work backward through your reports.
When you upload sales, or when a licensee submits a report, Unrecognized SKUs (URS) will show on Step 4 of the reporting process. The report can be submitted, but not approved, until they are reconciled
![](https://media.screensteps.com/image_assets/assets/007/260/299/original/media_1471031098457.png)
If the licensee submits the report, you will see this when you open it.
![](https://media.screensteps.com/image_assets/assets/007/260/301/original/media_1471031263872.png)
If you upload the sales, your view looks like this
Directly above the URS table is information about all Invalid SKU types
![](https://media.screensteps.com/image_assets/assets/007/260/307/original/media_1471031527818.png)
If you are using RoyaltyZone Product Manager, Unrecognized is any SKU that is not in either RoyaltyZone for this agreement or for this licensee on other agreements, as a product or a pending product. If a SKU on a sales upload is in the approval process but not fully approved, it will appear on the table as "Pending"
Reviewing the Invalid SKU Table
![](https://media.screensteps.com/image_assets/assets/007/260/309/original/media_1471032081276.png)
- This is the invalid type. Invalid SKUs can be Unrecognized, Archived, Unlicensed or Pending. See other help documents for these types.
- SKU Number
- Total Net Sales. RoyaltyZone combines the total for all sales of the sku and presents in on one row. As you can see here, the sales upload has 5 rows for SKU 999999-1, each at 10,000 gross sales. RoyaltyZone shows that in one row, with 50,000 total net sales.
- Total Royalty Due pre-reconciliation. When a SKU is unrecognized, RoyaltyZone does charges the highest rate on the agreement and does not apply any guarantee
- If the licensee uploads sales, he must enter a comment for each row before he can submit the report to you
- Actions to reconcile individual SKUs
- When the SKU has been reconciled, the action taken will show here
As you can see in the sales table, RoyaltyZone is applying the highest of the two rates on the agreement, and is not applying any recoupment
Fixing Your Unrecognized SKUs Individually
You can fix URS individually by selecting one of 3 options:
- Add SKU - If you know the description, property and category of the SKU, you can add it manually. Select "Add SKU" and fill out the information in the form
- Fix Typo- use this if you know the SKU is a derivative of a SKU already on the Agreement. For example, SKU 07302014-1 of 07302014. To fix, select "Fix Typo" and from the dropdown of active SKUs on the agreement, select the SKU to map to. This mapping is saved in RoyaltyZone and next time a sale of this SKU is uploaded, the sales will show as the mapped to SKU
- Delete - If you know the sku is invalid, and if there are no sales (example: They forgot to check the box "my template has a header row" and the SKU is the column heading "SKU", you can select Delete to remove it
NOTE: Licensees do not have these options. They can only comment. it is helpful to instruct your licensees to add the description, property and category in the comment
Add SKU form
![](https://media.screensteps.com/image_assets/assets/007/260/313/original/media_1471033378957.png)
- Enter the correct description
- Select the category from the dropdown
- Select the property from the dropdown
- Select Continue
Fix Typo Form
![](https://media.screensteps.com/image_assets/assets/007/260/315/original/media_1471033323365.png)
- Select the SKU you want to map to
- Select Set SKU
Fixing your Unrecognized SKUs in Bulk
When you have several URS, you can fix them in bulk. to do that, first select "Export Unrecognized SKUs. This downloads a csv file of the URS.
- Columns A through G show: RZ ID, SKU number, Existing Description (which is equal to the SKU number, Agreement, Existing Property (Unrecognized) and Existing Category (Unrecognized) Open the csv file Do not make any changes to Columns A Through G
- Beginning in Column H, enter the correct Description, Column I the correct Property, and Column J the correct Category. You can leave column K blank, but do not delete
- When complete, save the csv file
* If you need a list of your available properties and categories, see directions at the end of this lesson
Uploading the Fixes
On the URS table, select "Upload Unrecognized SKU Fixes"
![](https://media.screensteps.com/image_assets/assets/007/260/323/original/media_1471034904799.png)
- Select "Choose File" and select the csv file with your updates
- Select "Upload Product File"
- Wait patiently for the file to upload and the fixes to complete.
This is a great time to go grab a cup of coffee!
When the upload completes, it will return you to Step 4, and the unrecognized SKUs will show as resolved
Step 4 - Validation
Scroll down to your sales table. You can now see all SKUs are valid, the correct royalty rate is applied, and all sales are recouped against advances paid
You can now submit and approve the report
Additional Options - Sometimes a licensee (or maybe you) will upload an incorrect file or choose to fix your sales file instead of fixing unrecognized SKUs. An example might be that there are zeroes in front of the SKU on the Sales Upload, but the Product in RoyaltyZone does not have the zero.
Example 1: You upload sales and some process fine, others are URS. The URS are just "bad" numbers, you want to delete, fix and reload, but do not want to delete all sales
- Select Export Invalid SKU Sales. This exports a csv file with the invalid skus and their sales
- Select Delete All Unrecognized SKU Sales. This will delete the URS AND all sales associated with them, so be careful!
- Open the downloaded file and enter the correct SKU number in SKU column
- Delete columns J and K (Type an Details
- Save the file
- Go back to step 3 of the reporting process and upload the saved file
This will upload the sales you deleted with the correct SKU Number
CREATING A LIST OF AVAILABLE PROPERTIES AND CATEGORIES
- Go to Step 2 - Manage Products
- Select Upload
![](https://media.screensteps.com/image_assets/assets/007/260/341/original/media_1458235371368.png)
3. Select "Export Available Properties and Categories
4. This will export a csv file of all properties and categories on your agreement
Confidentiality Notice
This document may contain information of a confidential, proprietary and/or sensitive nature. This document and the information in it may not be reproduced or disclosed to any unauthorized users without the prior written permission of FilmTrack, Inc (here-to-forth known as ‘The Company’). Any unauthorized reproduction or disclosure of this document or the information contained in it is strictly prohibited. All authorized reproductions (either in whole or in part) shall bear this confidentiality notice.
0 Comments
Add your comment