You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Quarterly accrual based on employee hire date

Accepted answer
edited Oct 22, 2019 10:08AM in Workforce Management 3 comments


Quarterly accrual based on employee hire date


Hi Team,

We are trying to achieve one of our client's requirement where in client wants leave accrual to be done quarterly based on employee hire date.

Ex: If any employee hired on 10-Jan-2018, his/ her accrual should run and add 50 hrs to their balance as on 09-Apr-2018 and on the 4th quarter end 150 hours must be added to employee balance. i.e.,

Employee Hire Date Accrual period Start Accrual Period end Accrual Rate
10-Jan-2018 10-Jan-2018 09-Apr-2018 50
  10-Apr-2018 09-Jul-2018 50
  10-Jul-2018 09-Oct-2018 50
  10-Oct-2018 09-Jan-2018 150

 We have written fast formula which is fetching and calculating the accruals correctly, for the employee who have been hired on '01-Jan' . 

Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!