Generating a report under Leave >> Reports >> Leave Balance Report may be a headache to some admins as it creates confusion.
This article will differentiate how the system computes when the basis is either Approved or Consumed.
Approved leave
If your company’s policy is “Entitlement”, then it is advisable to generate this report as it is very straightforward.
Balance As At the day you generated the report = Opening balance (C) + Adjustment (D) - leave taken of the year (E)
However, if your company’s policy is on “Earned”, the formula on the Leave Balance changes to align with your company’s policy.
Balance As At the day you generated the report = Opening balance + Earned leave as of today date + Adjustment - leave taken of the year
NOTE: The Leave Approved field only considers the leave approved as of the day you are generating the report (today’s date). You may have future leave applications that are still pending, then this report will not include in the counting.
Consumed Leave
Entitlement policy - Balance as at 31/12/2020 = LBF from previous year + Earned Leave as of the chosen date + Adjustment - leave taken as of the chosen date
Earned leave policy - Balance as at 31/12/2020 = Earned leave as of the chosen date + Adjustment - leave taken as of the chosen date
NOTE: This report will generate values based on the consumed leave as of 31st of December.