Different Rounding of final salaries to be pulled in Compensation Statement

[RRKUMAR]

Hi

We are using a Total Compensation template in SF to configure Annual Merit and Bonus Review.

We have different rounding rules for pay components belonging to various countries. This has been achieved in EC using Precision and Threshold configuration.

As the SF Compensation and Variable pay is integrated with EC in our case, the Annual Salaries for the eligible population is being pulled from EC into the Total Compensation template. This is the rounded value which is stored in EC.

When we make various Merit, Lumpsum and Promotion recommendation via the worksheets, the final values in the worksheet need to be rounded before being pulled into the Compensation statement to meet the rounding requirements.

If we do not round anything in the template and publish the values as is to EC, the EC rounding rules will kick in a soon as the new salaries are brought back into EC and correctly store the amounts in various pay components/pay component group in Compensation Information.

The challenge is to pull the final rounded amounts into the Compensation statement.

We have different rounding rules applied across various countries. All Pay components/Pay component groups belonging to one country will be rounded in the same manner.

For eg. For Country 1: 50,782.499 EUR needs to be rounded to 50,782.5 EUR. If the Pay frequency is 12, then we will divide this new salary by 12 to get the monthly amount which will be published back to EC and then the rounding will kick in EC.

For Country 2: 50,782.765 CZK needs to be rounded to 50,800 CZK and so on and so forth for other countries.

I would like understand from the experts if the following approach is optimal:

1. * Create a Lookup table containing the list of all countries.

2. * For all money fields such as Final Annual Salary, create a corresponding custom field in the template and apply different rounding formulae such as Lookup(“Custom Country”,if if(customCountry='NLD', round (“up”,(CustomfinSalary/12)*100)/100 etc based on different countries in the Lookup table. The formula will be long as the list of countries is big. Is there any other way to achieve this?

3. * Let the unrounded figures be published back to EC for these to get rounded in EC as rounding rules with Precision and Threshold are already set up in EC.

4. * Pull these final rounded values(matching the rounded values in EC) from the custom fields set up in the template into the Compensation statement.

Essentially, we want the Compensation Statement to display the salaries and Bonus amounts which are 100% in sync with the rounded values in EC post publishing to EC.

Thanks in advance.

Ritesh

[pmacgovern]

In the past, I have created a lookup that has two inputs: the country and the frequency. There are two outputs: the method and the precision. Then the formula becomes:

round(lookup("rounding_table",customCountry,customFrequency,1),finalSalary*toNumber(lookup("rounding_table",customCountry,customFrequency,2)))/toNumber(lookup("rounding_table",customCountry,customFrequency,2))

Or something like that...

You could throw the frequency in there as a divisor if you want.

[xavierlegarrec]

Great discussion, added it as a reference to the blog about Roundings. Someone pinged me on a similar topics related to number formats with Total Compensation templates at SuccessConnect (different than this particular one however).

[RRKUMAR]

Thanks very much Philip. Makes sense. I suppose we can also add the third output dimension called "Threshold" in the lookup table to make it more comprehensive and in sync with what has been configured in EC for various pay components.