How To Create Reports
With the Reports feature you can export your sales data in a customised format. Think of it as your pivot table in the sky, where you can slice and interrogate your revenue data.
To create a new report, please go to Data > Reports and hit the +Create button at the top right of the screen.
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 Sales or (if available) Costs data.
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 sales data that has been reported to you via Curve by this label or publisher.
When using an AND filter, only those sales lines that match all the conditions will be displayed in your Report. In the below example, only Premium Streams in Italy will be displayed.
When using an OR filter, all the sales that match at least one of the conditions will be displayed in your Report. In the below example, sales that are either a Premium Stream or a sale 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.
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 Payable per Release? Select fields for Net Payable, Cat No and Release 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.
Below, we provide a glossary of some of the main fields you may want to include in your Report.
Sale Date – When the track was downloaded, streamed or performed
Source / Sub Source – These columns describe the platform & the commissioner of the revenue
Territory – The country of sale
Track Title / Release Title / Work Title – The particular track, release (for label sales) or work (for publisher income) to which the transaction relates
Configuration – The format of the sale
Units – The number of sales, plays, performances
Net Amount – The total revenue that your record label or distributor received for the transaction. So this is the total before your participation rate is taken into account. If you only have one track or one feature on a release, or don't have a full writer's share on a work, this amount is still the total revenue for the complete album or compilation showing up here.
Calculation Type – This describes the base used to calculate your royalties – Net Receipts, Gross Receipts, PPD, Unit Rate or Unit Price
Calculation Input – This is the base value used to calculate your royalties
Participation Rate – Your percentage share on the track, release or work. For example, 100 would mean you are the sole beneficiary for this sales revenue, 50 would mean you split the share equally with another participant
Mechanical Deduction – Any deductions for mechanicals are recorded here. This would be the absolute amount. Mechanicals are a fee set aside to remunerate songwriters
Deduction – If your label or publisher has deducted part of your royalty, this would show up here. This would be the absolute amount
Royalty Rate – This is the percentage of the revenue to be shared with you as your royalty
Reduction – If there are royalty reductions in your contract, a reduction rate can show up here. A value of 90 would mean you receive 90% of the royalty
Net Payable – After taking into account all the previous input & rates, this is the Net Payable to you for each line. The total of this column will be the same as the total income on your PDF statement
Reserve – A reserve is a term typically used for physical sales. When a physical copy is sold, a record label may hold part of the due royalty as an insurance against any unsold units that might be returned by retailers. This reserve should then be released in a future royalty period.