Prorating Revenue Across Sales Lines with a Pro Rata Amount
Some sales files may only provide you with the number of units per track or release and a gross revenue figure for all sales without providing a specific monetary value for each sales line. In this case, you can prorate revenue across different tracks and releases in a sales file by using the Pro Rata Amount field. This field is available on the Setup page of the mapping manager when you first upload a file using a sales template without a Net Amount field assigned, or in the Default fields section on the Edit page of a sales file that has already been ingested.
The Pro Rata Amount will be divided among the sales lines in the file according to their proportional share of sales Units in the file.
For example, if a Pro Rata Amount of $100 is entered for a sales file with 10 lines that each have 10 units, each line will be allocated $10.
Sales Line Net Amount = Pro Rata Amount x Sales Line Units / Total Units
Make sure to re-ingest the file once the Pro Rata Amount has been entered to apply the change.
You can use the Standard Master Template to import custom sales files and prorate an amount across the tracks, releases, or contracts you enter in that file proportional to each line's share of the total units. You can also use an export of your contracts or exports of your tracks or releases in the "separated" format to prorate an amount across the contracts, tracks, or releases contained in those exports. These files can be imported using the Curve - Pro Rata templates in our library. These templates assign a unit value of 1 to each line via a calculation and will divide the revenue equally across the lines, but the templates will need to be edited to supply Channel, Configuration, Territory, Currency, and other required fields. You can also assign default values for each file on its Sales File Edit Page.