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.
If your company's accrual policy is full entitlement - Calendar Year, Financial Year, or Employee Anniversary, then it is recommended to generate this report.
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 Daily or Monthly, 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.
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.