[Discussion] Working Days in Salary Slip

258 views
Skip to first unread message

Anand Doshi

unread,
Jul 26, 2013, 7:11:50 AM7/26/13
to erpnext-u...@googlegroups.com
Hi everyone,

We have an issue on github (https://github.com/webnotes/erpnext/issues/285) that needs your attention.

It begs the question, do companies consider holidays as paid days?

Currently, in Salary Slip, Total days in month are total no. of days in the month (e.g. 31), and not total no. of working days in a month. (e.g. 24 i.e total no of days - holidays)

In this case, the per day salary is calculated as: 

Salary per day = Total Salary / Total days in month

Hence, if one considers holidays as paid days, then salary per day will be less than that if they are not. This has an impact on how much salary is reduced if someone takes a leave of type Leave Without Pay.

So, what is common in most cases? Holidays are paid days or are they not?

Thanks,
Anand.

Addy

unread,
Aug 21, 2014, 1:50:27 PM8/21/14
to erpnext-u...@googlegroups.com
Hi Anand,

Just stumbled upon this post and I know its a very old post but still wanted to post my thoughts into it.

The calculation of the salary per day is only as per the above rule of Total Salary/ Total Days in the month but the tricky issue especially here in India, is to define how many leaves should be considered, as per the labor laws in India (AFAIK) every person is entitled for 1 day leave on 6 working days. Assuming 6 working days with weekly off on Sunday, we could consider the following cases:

  1. One Day leave: This should always be considered as 1 days, irrespective of the clubbing of the weekly off. This means that a leave on Mo or Sa should be considered as 1 only.
  2. Two Days leave:
    • Mo, Tu: Should be considered as 2 days leave
    • Sa, Mo: Again would be considered as 2 days leave (Su would be given as weekly off).
  3. Three Days leave:
    • Sa, Mo, Tu: Consider as 4 days leave (Su should be taken as leave)
    • Mo, Tu, We: Consider as 4 days leave (Su should be taken as leave)
    • Tu, We, Th: Consider as 3 days leave (Su would be given as weekly OFF)
    • We, Th, Fr: Consider as 3 days leave (Su would be given as weekly OFF)
    • Th, Fr, Sa: Consider as 4 days leave (Su should be taken as leave)
    • Fr, Sa, Mo: Consider as 4 days leave (Su should be taken as leave) 
  4. Four Days Leave
    • Mo, Tu, We, Th: Consider as 5 days leave (Su should be taken as leave)
    • Tu, We, Th, Fr: I am confused since this person does not deserve the weekly OFF but still it would be considered as 4 days leave only.
    • We, Th, Fr, Sa: Consider as 5 days leave (Su should be taken as leave)
  5. Five Days Leave:
    • All cases consider as 6 days leave.
  6. Six Days leave:
    • All cases consider as 7 days leave.
Now the problem gets trickier if the leaves span across months since the weeks would be overlapping and this is where I guess that HR people always give salary after a week so your code must be considering the days before the month from earlier month in that week to analyse the days prior to the month and decide accordingly about the number of leave days.

Mahesh

unread,
Aug 22, 2014, 1:40:10 AM8/22/14
to ERPNext User's Forum
Dear Aditya.
Nicely put.

Dear Team.
Would be looking forward for this functionality.
As of, we manually enter LWP and move on with salary fulfillment.

Regards,
Mahesh


--
You received this message because you are subscribed to the Google Groups "ERPNext User's Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-user-fo...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-user-forum/26ed5073-2608-4cfb-af21-a2f2987acc80%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Anand Doshi

unread,
Aug 22, 2014, 2:54:04 AM8/22/14
to erpnext-u...@googlegroups.com
Hi Aditya

Wow! So many complications for a leave! 

Thanks for the detailed post. 

@community: Do such rules apply anywhere else in the world?

-Anand. 
Hence, if one considers holidays as paid days, then salary per day will be less than that if they are not. This has an impact on how much salary is reduced if someone takes a leave of typeLeave Without Pay.

So, what is common in most cases? Holidays are paid days or are they not?

Thanks,
Anand.

-- 

wa...@xavierltd.com

unread,
Aug 22, 2014, 8:11:30 AM8/22/14
to erpnext-u...@googlegroups.com
‎Hi Anand,

Well, they sure don't apply in my part of town : )

If I'm correct though, it appears the logic in the system Aditya outlined below is:

1. Any leave not exceeding 2 days is independent of weekly off day (in this case, Sunday)

2. Any leave of 3 days ‎and above causes the weekly off day (Sunday) to be counted as leave unless there is at least one working day in-between them (by them, I mean leave days and weekly off)

Cheers! 


Kind regards,
Olawale ‎
From: Anand Doshi
Sent: Friday, August 22, 2014 7:54 AM
Subject: [erpnext-user-forum] [Discussion] Working Days in Salary Slip

Abdel Gadiel Martínez Lassonde

unread,
Aug 22, 2014, 9:19:20 AM8/22/14
to erpnext-u...@googlegroups.com
Hi @community!

I'll respond you according to the laws on Panama:
Article 54. The duration and payment of vacations shall be governed by the following rules:
1. Thirty days for every eleven months of continuous work, a rate of one day for every eleven days of the service of his employer.
2. Payment of one month's salary when compensation has been agreed for a month, and four weeks and a third, where it has been agreed by week. In these cases, if the salary includes bonuses, commissions or other variables sums, or the employee has received salary increase, the average ordinary wages and extraordinary accrued during the past eleven months, or the last base salary will be paid, whichever is more favorable to the worker.
3. In the case of workers paid by the hour or day total of ordinary and extraordinary remuneration the employee would have received in the last eleven months of service by the total number of ordinary days, or less time served will be divided if is proportional holidays, and this ratio is multiplied by the number of days of annual leave due to him. If the base salary earned during the last month is more than average, the holiday will be paid as one.
4. For purposes of computing the time served entitling vacation, the duration of the weekly rest, holidays or national mourning, sick leave within the limits indicated in Article 200 will be counted, the cases described in the Article 208 or other interruptions specifically authorized by the employer.
5.
Amounts to be received by the worker will be settled and paid three days in advance of the date you begin enjoying the annual break.
6. A worker whose entitlement ends before the full rest period referred to in this article shall be paid in cash on proportional entitled to a rate of one day for every eleven working days vacation.
7. Fulfilled the holiday period the employee is entitled to be reinstated in his post.

Hope this information works.

Regards!

Rushabh Mehta

unread,
Aug 23, 2014, 4:41:24 AM8/23/14
to erpnext-u...@googlegroups.com
Thanks Abdel,

Thanks for sharing. I am not sure how fast we can implement these :) You can add this as a comment to the original GitHub Issue.



--
You received this message because you are subscribed to the Google Groups "ERPNext User's Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-user-fo...@googlegroups.com.
Reply all
Reply to author
Forward
0 new messages