Publishing – How to Upload Income Files

Publishing – 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.

Uploading Sales Data Summary

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

1. Upload your Income FileOn 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.

If you are following along with our demo, please upload the 7.Curve Demo Sales.csv file.
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 income file setupWhen you click into your uploaded income file, you will be shown the Mapping Manager. The first thing you will be asked to complete in our Mapping Manager is your income 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 income file on Curve.

NamePick a name that is clear, detailed and consistent with the rest of your income files to make sure each income file you upload is distinctive from another.
Target PeriodThis will make it clear for you to understand in which Period you need to include this income 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.
Invoice NoYou 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 ManagerIt 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.. 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 – If you have any Invalid lines after completing your Mapping Manager still, these are likely due to unrecognised Identifiers in the income file, resulting in Curve not know which Works to map this revenue to. To resolve these, 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.

5. Review your uploaded sales fileOnce 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, but a few frequent causes and possible solutions are explained in this chapter in our documentation.

Now you have income ingested and mapped down, we can run our first period.