Concept: Fiscal Year Proration with HCM Event
Workday prorates commitments and obligations when a pay period spans 2 fiscal years. You can
enable either the
Earnings Proration
or Forward
Accrual Proration
options on the Edit Company Payroll
Commitment Options
task. Workday will calculate existing earnings
proration before applying fiscal year proration.When an HCM event such as
New Hire
or Compensation Change
occurs within a
prorated subperiod, Workday uses these Calculation Proration
options from the Edit Earning
task to calculate proration within
that subperiod:- Prorate Using Days Worked
- Prorate Using Calendar Days
- Prorate Using Annual Working Days
Example: Forward Accrual Proration Using Calendar Days
A budget manager needs to prorate a worker's earnings for a pay period that spans 2
fiscal years. The budget manager:
- Sets up forward accruals using theEdit Period Scheduletask.
- Enables theForward Accrual Prorationoption on theEdit Company Payroll Commitmenttask.
- SelectsProrate Using Calendar Daysoption on theEdit Earningtask.
An HR administrator makes a compensation change to the worker's earnings for the same pay
period.
Field | Result |
|---|---|
Fiscal Year | 7/1/19 - 6/30/20 |
Final pay period for 2019 | 6/26/19 - 7/9/19 |
Forward accrual - Days to accrue | 3 |
Forward accrual - Days in basis | 14 |
Calendar days for full pay period | 10 |
Worker's earning for pay period | 4000 |
Compensation change on 7/4/19 | 5000 |
Workday calculates earnings for the prorated subperiods based on forward accrual
as:
Subperiods | Result |
|---|---|
Subperiods pay (6/26/19 - 6/30/19) | (Days to accrue/ Days in basis) x Earnings: (3/10) x 4000 = 1200 |
Subperiods pay (7/1/19 - 7/9/19) | ((Days in Basis - Days to accrue)/ Days in basis) x Earnings: (7/10) x 4000 =
2800 |
Workday then calculates prorated obligation as:
Description | Result |
|---|---|
Calendar days in subperiod (7/1/19 - 7/3/19) before compensation
change | 3 |
Calendar days in subperiod (7/4/19 - 7/9/19) after compensation
change | 6 |
Total calendar days in subperiod | 9 |
Prorated obligation before compensation change (7/1/19 - 7/3/19) | [(Days in subperiod before compensation change)/Calendar days in full subperiod)] x
[Subperiod pay amount]: (3/9) x 2800 = 933.33 |
Prorated obligation after compensation change (7/1/19 - 7/3/19) | [(Days in subperiod after compensation change)/Calendar days in full subperiod)] x
[Subperiod pay amount after compensation change]: (6/9) x [(7/10) x
5000] = 2,333.33 |