Using Calculations to Adjust Your Net Amount or Gross Amount
Occasionally, the Net Amount or Gross Amount in your sales file will need to be adjusted to apply a 3rd party commission or other change necessary to meet the terms of your agreements with your songwriters. We can apply these calculations on the calculation tab of a Template. In the example below, we will apply a commission to our income. 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 commission 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 a commission. If we want to apply a commission 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.