How to Upload Income Files

Now that your catalogue is complete, you are ready to start uploading your income data. Please watch our introduction to uploading income data to Curve in the video below. Further down this page, we have provided notes and further reading.

How to Upload Income Files

First, navigate to Income > Income. Then hit the +Create button in the top right of the page and select Bulk Upload.

1
Upload your Income File - On your Income page, hit the +Create button in the top-right of your page and select Bulk Upload. Drop as many income files as you wish to import. Once your upload is ready, you can hit Complete which will navigate you back to your income page. You will now see your files added to your Income page.

The structure of income files is generally different for each society or publishing administrator. As an answer to that, we have created Templates, which are instructions to Curve how to read income files from various different sources. If your income file is in a structure that is recognised by Curve, it will instantly start ingesting your income file. If Curve did not find a matching Template, Curve will add a yellow warning icon next to your income file and ask you to select or create a Template when entering your income file.

You may need to create your own Template or adjust an existing one from our library to make sure your income file is read correctly. For more information on this, please visit this chapter in our Getting Started Guide on how to make Templates.

2
Complete the sales file setup – When you click into your uploaded sales file, you will be welcomed by our Mapping Manager. The first thing you will be asked to complete in our Mapping Manager is your sales file setup. Here you can change the Name of your file, provide a Target Period and provide an Invoice Number. This setup tab will only be displayed the first time you enter your sales file on Curve.
Name – Pick a name that is clear, detailed and consistent with the rest of your sales files to make sure each sales file you upload is distinctive from another.
Target Period – This will make it clear for you to understand in which Period you need to include this sales file. The Target Period is optional to complete but recommended for your own convenience. You can name this freely, but make sure to pick a consistent format and stick to it. More info
Invoice No – You can provide an Invoice Number for your own reference. This is optional and does not affect your royalty accounting process.
3
Provide missing values in the Mapping Manager – It may be that Curve is currently not finding or recognising certain bits of data provided in the income file. If so, Curve will flag these via the Mapping Manager.
If not provided in the Income file itself, you will be asked to provide a Sale Date (the day the performance or copy happened), a Transaction Date (the day you were paid) and an Exchange Rate between the currency of the statement and the home currency established in your settings.
You may also be asked to map down certain values picked up from the statements, such as an unknown Territory, Channel, or Configuration. Optionally, you have the ability to normalise your Sub Sources by assigning a preferred spelling. You will only be asked to map these values once. Each of these values will be saved for all future uploads with this template.
When everything is mapped, hit  Revalidate and the file will remap the invalid income lines, using all the new associations you have just created.

4
Map unrecognised Identifiers via the Unmapped page - There are two places to map Works: you can use the Mapping Manager, or the Unmapped Page. To access the Unmapped Page, please head over to your Income > Unmapped page. Here you can map these Identifiers to the correct Work in your catalogue. Curve will store these identifiers as an Alias on your Work, making sure all revenue for this Identifier in this file and all other incoming files from this Source moving forward will be mapped to the correct Work in your catalogue. More info

5
Review your uploaded income file - Once you have completed mapping your income file, the Mapping Manager will no longer appear. At the top of the income file page, you have headline information to validate that your file has been imported properly. Check the number of units, revenue and number of lines match the file you uploaded. If the total matches your expected values, and the total number of Invalid Lines is zero, your job is done.

It may be, however, that your income file still has Invalid Lines even after you mapped all the unknown values in the Mapping Manager. This will be the case when data required by Curve is missing. To view these Invalid Lines, you can filter on all the lines with an Incomplete status. The missing data that causes your income line to be invalid will be highlighted in red. The cause of this data may range from a blank cell in the original income file, a total row at the bottom of the income file you didn’t actually want to import, or a Required Field not being picked up via the Template. These Invalid Lines can always be resolved by making an adjustment to your Template. Which changes to make to your Template is dependent on the error. More info

Once you have loaded all of your income files, you are ready to run your first Period.

Did this answer your question? Thanks for the feedback There was a problem submitting your feedback. Please try again later.

Related Articles