Concept: Retro and Pay Balances
You can configure pay balances to:
- Include all retro differences in the current balance period regardless of the period earned.
- Only include the retro differences that fall within the pay balance period.
- Exclude all retro differences for pay components that you don't calculate in retro.
Workday recommends that you don't change existing pay balances that you process in retro. Instead, create pay balances with a new effective date. This practice helps ensure accurate retro pay calculations.
Retro Calculation Examples
The balance period is January through December. Susan receives an ongoing monthly bonus of 100. In March of the current balance period, you enter:
- A 50 retro bonus for December in the previous year.
- A 25 retro bonus for January.
- Include All Retro Values in Current Gross to Net
- Workday includes the bonuses regardless of the source period. The pay balance in March is:100 (January ongoing bonus) + 100 (February ongoing bonus) + 100 (March ongoing bonus) + 50 (December bonus) + 25 (January bonus) = 375
- Include All Retro Values Based on Earned Period
- Because Susan earned the 50 bonus before the current balance period, Workday excludes it. The pay balance in March is:100 (January ongoing bonus) + 100 (February ongoing bonus) + 100 (March ongoing bonus) + 25 (January bonus) = 325
- Exclude Values from Current Gross to Net During CalculationandInclude All Retro Values Based on Earned Period
- Workday:
- Excludes the current period ongoing bonus.
- Excludes the December bonus because Susan earned it before the current balance period.
- Includes the January bonus because it's paid in the current balance period.
The March pay balance is:100 (January ongoing bonus) + 100 (February ongoing bonus) + 25 (January bonus) = 225
If you have a pay component that references a pay balance and is set to recalculate during retro, Workday recommends specifying
Include All Retro Values Based on Earned Period
on the pay balance rather than Include All Retro Values in Current Gross to Net
to ensure that any retro amounts in your related calculations calculate correctly.Exclude Retro Values Examples
- Exclude Retro Values from Balances for Pay Components that Calculate in Retro
- To configure a pay balance to exclude retro amounts, select theInclude All Retro Values Based on Earned Periodoption and select aBalance PeriodofCurrent Period.This exclusion only works when the pay component that uses the pay balance is configured to calculate in retro.
- Exclude Retro Values from Balances for Pay Components that don’t Calculate in Retro
- To exclude all retro values, create an arithmetic calculation that uses 2 different pay balances.Example: You have a deduction that doesn'tRecalculate during Retro. TheCalculationon that deduction is a percentage of an earning that does recalculate in retro (excluding retro amounts).
- Set upPay Balance 1, based on the earning, and select these values:
- TheInclude All Retro Values in Current Gross to Netoption.
- ABalance PeriodofCurrent Period.
- Set upPay Balance 2, based on the earning, and select these values:
- TheExclude Values from Current Gross to Net During Calculationcheck box.
- TheInclude All Retro Values in Current Gross to Netoption.
- ABalance PeriodofCurrent Period.
- Access theCreate Arithmetic Calculationtask and complete these fields:1st OperandOperator2nd OperandPay Balance 1SubtractPay Balance 2