Using Calculations to Adjust Your Net Amount, Gross Amount or Per Unit Rate

Occasionally, the Net Amount, Gross Amount, or Per Unit Rate in your sales file will need to be adjusted to apply a distribution fee or other change necessary to meet the terms of your agreements with your artists. We can apply these calculations on the calculation tab of a sales template. In the example below, we will apply a distribution fee to our sales. We can create a new calculation by clicking the blue +Calculation button. In the Conditions section of the calculation, we can establish the conditions under which the calculations should be applied. The calculation can be applied "Always," when "Any of the Below" specified conditions apply, or when "All of the Below" conditions apply.

In the Calculation & Output section, we can establish exactly what calculation should occur. In the Output Field drop-down list, we can select the Output Field we would like our calculation to produce. If we are looking to apply a distribution fee to a Gross Amount and store this as our Net Amount, we should select "Net Amount" here. Next, we specify the Calculation we would like to use to apply our distribution fee. If we want to apply a distribution fee of 1.5% to our Gross Amount, we should Multiply this amount by the Value 0.985. This calculation will take the number that we have designated as the Gross Amount for each line and multiply it by .985, then apply the resulting output as our Net Amount.

We can use calculations to apply all sorts of manipulations to our sales data on a line-by-line basis.  This is just one example of the many calculations we can perform to edit our sales data upon ingestion.