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