How to Create Reports for your Income & Calculations
With the Reports feature you can export your income data in a customised format.
- 1
-
Choose your Report Type
To create a new report, please go to Data > Reports and hit the +Create button at the top right of the screen. Then you'd need to select creating a Custom or a Fixed Report ✪.
Our Fixed Reports ✪ would be most suitable if you are looking to export your data in a standardised format designed by Curve. Currently two fixed reports are available:
- Unreported Sales Report. This report provides greater detail on Unreported Income per Contract. Using our Fixed Reports for Unreported Sales, you will be able to review any unreported sales lines per Contract within a period, even if that same sales line was successfully reported to at least one other Contract.
- Audit Report: This Report allows users to export all updates captured within the History Tab, in a CSV format. Using our Audit Fixed Report you will be able to review any changes made on your Curve Platform within a given date range, in a standardised format designed by Curve.
- 2
-
Name Your Report & Choose a Dataset
Here you give your report a name and select which Dataset to use as a source for your report. You can either export your Income Data or the Royalties you reported to your songwriters.
Income Data: This is data from the income files, including files that have not been processed for royalties.
Royalties: This draws data from the table of income data created when royalty calculations have been applied. It will only include lines that contribute to the Net Payable value of a contract’s Closing Balance. If a royalty calculation has not run against a royalty line, it will not have created a line in this table. So any incomplete or unreported lines are not available here.
CSV Format: This allows you to select a US/UK Decimal Point format, or a EU Decimal Comma format. The UK/US Decimal Point will display a value as 123.45 whereas a EU Decimal Comma format will display that same value as 123,45
Please note that in a Royalties report, each royalty line will be displayed per time that it was reported in a statement. Imagine we have $100 worth of revenue for a Work on which Composer A has earned a 20% royalty and Composer B has earned a 30% royalty. In a Sales Output report, this line will be displayed twice, once as part of Composer A's royalty and once as part of Composer B's royalty. It is therefore important that, in a Royalty report, you don't look at the totals of the Gross Amount, Net Amount or Units field as this may include duplicate royalty lines. In our below example, we should not take the assumption that there was a total Net Amount of $200. Instead, if you wish to look at your total Gross Amount, Net Amount or Units; you should select an Income report instead.
| Artist | Net Amount | Royalty Rate | Net Payable |
| Artist A | $100 | 20% | $20 |
| Artist B | $100 | 30% | $30 |
- 3
-
Filter Which Data Segment You Would Like to Report
The filter area allows you to select which segments of data you would like to generate a report for. If you leave the filter area blank, Curve will automatically report all income data currently on your database.
AND Filters
When using an AND filter, only those income lines that match all the conditions will be displayed in your Report. In the below example, only Premium Streams in Italy will be displayed.
OR Filters
When using an OR filter, all the income that match at least one of the conditions will be displayed in your Report. In the below example, income that are either a Premium Stream or income in Italy will be displayed. So in contrast with our AND filter in the example above, also Premium Streams in Greece or Downloads in Italy will be displayed.
- 4
-
Select Which Fields to Display in Your Report
Once you have selected your dataset and filters, you can select the fields to pull data from. Each field you select here will represent a column in your Report export. Looking for a breakdown of your Net Amount per Work? Select fields for Net Amount, Identifier and Work Title. Looking for a breakdown of your number of Units per Territory? Select fields for Units and Territory. You can add as many fields as you like and you can give the fields your own custom name by amending the entry in the Header line. You can reorganize the columns of your Report by dragging and dropping your fields in a different order.
Once you have selected your preferred fields, you can hit the Display button to view your data. You can hit the Export button to download your data in an Excel format.
English
Nederlands