cancel
Showing results for 
Search instead for 
Did you mean: 

Sales & Income Tax calculation on commission amounts

Zufliqar_Maqboo
Explorer
0 Kudos
412

Hello Experts,

We have a requirement to calculate both sales tax and income tax on commission amounts, with varying percentages depending on the payees. Consequently, we need to maintain different tax percentages in the payee master record. After successfully running the pipeline, the results will include the commission amount, sales tax, and income tax. The net amount of these calculations will then be paid to the respective payees.

I would appreciate any assistance or guidance on how to achieve these results within SF Incentive Management.

Accepted Solutions (0)

Answers (1)

Answers (1)

mbroeker
Explorer

Hi @Zufliqar_Maqboo,

as you already mentioned, the first step is to maintain the different tax percentages in generic fields at the payee master record.

You can then configure different rule outputs for each result type. You could for example create 3 deposits, one with the acutal commission, one for the sales tax and one for the income tax. For the tax results you just need to multiply the commission amount with the respecitve field from the payee, that you have available in the formula editor. On deposit level you can use Earning Codes to label what kind of payment the deposit will be and Earning groups to group related deposits into one payment. 

If there are several groups of payees with the same tax percentages, you could also consider using Fixed Values and work with Variables to make individualizations on plan, title or position level.