You can upload royalties using your own file and map the data to the appropriate fields in RoyaltyZone. RoyaltyZone can accept any csv file.
Your file must be in columnar format in a spreadsheet-type software (such as Excel, Numbers, Google Spreadsheet)
First, prepare your sales file for upload
- Delete any rows above header row
- Delete any rows, including totals, below your last line of data
- You do not need to delete columns that will not be mapped, RoyaltyZone will ignore them
Save it as a .csv file
Depending on what spreadsheet program you are using, your 'Save As' window might look different
On the Sales Transactions Page (step 3 of report submittal) select "Upload Sales"
Select your file
- Select "Use my own data file" from the drop-down as your file type
- Select "Choose File" - Locate your file from its saved location
- Leave checked if your file has a header row, uncheck if it does not
- Select "Upload"
Map your data to RoyaltyZone!
You can map columns from your file to fields in RoyaltyZone
Or you can set a "Global Value" to accept data that is not accounted for in a column on your file
Select the appropriate column from your file for each field in RZ, or enter your "Global Value", then save your map to use in the future
- All RoyaltyZone fields
- Must have a corresponding column on your upload file, or
- A global value assigned.
- Select your data format - NOTE: Leave as-is for US formatting
- Name your Mapping
- Select "Create Map"
Once you select "Create Map" your report will begin the normal report submittal process
Once you have created a Column Map, you can reuse it by selecting it from the drop-down box during Step 3 of royalty reporting
RoyaltyZone will display the saved mapping and you can change any values as necessary
- You can rename and/or
- Resave new mapping
You can create multiple mappings to handle different report formats from different divisions within your company, then upload each report format before submitting
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.