Using Calculations to Adjust Your Net Amount or Gross Amount

Occasionally, the Net Amount or Gross Amount in your income 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 an Income Template. In the example below, we will apply a commission to our income. We can create a new calculation by clicking the + 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 One 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, choose "Multiplied By" and enter 0.985 as the Value. This calculation will take the number that we have designated as the Gross Amount for each line and multiply it by 0.985, then apply the resulting output as our Net Amount.

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

Did this answer your question? Thanks for the feedback There was a problem submitting your feedback. Please try again later.

Still need help? Contact Us Contact Us