If the licensee submits the report, you will see this when you open it.

If you upload the sales, your view looks like this

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"

1. This is the invalid type. Invalid SKUs can be Unrecognized, Archived, Unlicensed or Pending.  See other help documents for these types.
2. SKU Number
3. 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.
4. 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
5. If the licensee uploads sales, he must enter a comment for each row before he can submit the report to you
6. Actions to reconcile individual SKUs
7. 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

You can fix URS individually by selecting one of 3 options:

1. 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
2. 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
3. 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

1. Enter the correct description
2. Select the category from the dropdown
3. Select the property from the dropdown
4. Select Continue

1. Select the SKU you want to map to
2. Select Set SKU

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.

1. 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
2. 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
3. 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

On the URS table, select "Upload Unrecognized SKU Fixes"

1. Select "Choose File" and select the csv file with your updates
2. Select "Upload Product File"
3. 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

1.  Select "Recalculate Report" to pick up the changes

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

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

1. Select Export Invalid SKU Sales. This exports a csv file with the invalid skus and their sales
2. Select Delete All Unrecognized SKU Sales. This will delete the URS AND all sales associated with them, so be careful!

1. Open the downloaded file and enter the correct SKU number in SKU column
2. Delete columns J and K (Type an Details
3. Save the file
4. 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

1. Go to Step 2 - Manage Products
2. Select Upload

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.