Warning: preg_replace(): Empty regular expression in [path]/showthread.php on line 2381

Warning: preg_replace(): Empty regular expression in [path]/showthread.php on line 2381

Warning: preg_replace(): Empty regular expression in [path]/showthread.php on line 2381
Leave Balance Calculation in Excel - Calculate the balance for each leave type as on the following dates if the DOJ is 31-03-2016 - CiteHR

No Tags Found!

SH

Shai89308

Executive Hr

AS

Ammu Shanvi

Human Resource

GS

G SHASHI KRISHNA

Senior Manager - Hr

AH

Aizant HR

Human Resources

MA

MARSHAL

Safety Officer

AK

Anish Katoch

Hr Executive

PR

PranjalR

Hr Recruiter

AP

Alka Pal

Hr Executive

Karthikeyan8195

Management Consultant

MK

Mohit Kumar Puri

Head Marketing

AU

Austex

Accounts Manager


Anonymous
Calculate the balance for each leave type as on the following dates if the DOJ is 31-03-2016, considering he has not taken any leave and all leaves are carried forward. Please share the calculations in an excel sheet along with the final balances.
Leave type Casual leave Sick Leave Earned Leave
Annual Allotment 24 18 24
Pro-rata Yes Yes Yes
From DOJ DOJ DOJ
Accrual Quarterly Monthly Bi-annually
From Beginning of quarter End of month Beginning of half-year
Leave cycle Financial year Financial year Calendar year
Date Balance- C/L Balance- S/L Balance- E/L
7/8/2017
25-12-2017
16-01-2018
5/5/2018
12/6/2018
19-07-2018
15-03-2019

From India, Bangalore
Anonymous
Can someone help me with the calculations mentioned in the above thread.
From India, Bangalore
rashmitha-pinky
I need answer for this problem
Calculate the balance for each leave type as on the following dates if the DOJ is 31-03-2016, considering he has not taken any leave and all leaves are carried forward. Please share the calculations in an excel sheet along with the final balances.
Leave type
Annual Allotment Pro-rata From Accrual
From Leave cycle Date 07-08-2017 25-12-2017 16-01-2018 05-05-2018 12-06-2018 19-07-2018 15-03-2019
Casual leave
24
Yes
DOJ
Quarterly
Beginning of quarter
Financial year
Balance- C/L
Sick Leave
18 Yes DOJ Monthly
End of month Financial year Balance- S/L
Earned Leave

From India
hitesh-don
I don’t know whether my sheet is correct or not But I tried my best It might be helpful for you if my answer is correct
From India, Hyderabad
Attached Files (Download Requires Membership)
File Type: xlsx Leave balance sheet.xlsx (11.1 KB, 779 views)

shivi.mittal
Hi, Please refer the solved sheet.
From India, Delhi
Attached Files (Download Requires Membership)
File Type: xlsx Leave Excercise.xlsx (10.1 KB, 730 views)

Find answers from people who have previously dealt with business and work issues similar to yours - Please Register and Log In to CiteHR and post your query.




About Us Advertise Contact Us Testimonials
Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2024 CiteHR ®

All Copyright And Trademarks in Posts Held By Respective Owners.