Try ERPNext Buy Support Partners Foundation

[Discussion] Working Days in Salary Slip

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.



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-forum+un...@googlegroups.com.

For more options, visit https://groups.google.com/groups/opt_out.

 

 

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).
  • 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) 
  • 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)
  • Five Days Leave:
    • All cases consider as 6 days leave.
  • 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.



    On Friday, July 26, 2013 4:41:50 PM UTC+5:30, Anand Doshi wrote:
    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.



    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-forum+un…@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.

    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


    On Thu, Aug 21, 2014 at 11:20 PM, Addy <ad...@gmail.com> wrote:
    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).
  • 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)
  • 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)
  • Five Days Leave:
    • All cases consider as 6 days leave.
  • 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.



    On Friday, July 26, 2013 4:41:50 PM UTC+5:30, Anand Doshi wrote:
    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.



    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-forum+un…@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.




    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-forum+un…@googlegroups.com.

    To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-user-forum/CAPjtCMnwX_udKPLcmjJ7nOmQVQYY2hNfhLVVHcGs4Xn-aWrQxg%40mail.gmail.com.

    For more options, visit https://groups.google.com/d/optout.

    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.

    On Thursday, August 21, 2014, Addy <ad...@gmail.com> wrote:
    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).
  • 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)
  • 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)
  • Five Days Leave:
    • All cases consider as 6 days leave.
  • 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.



    On Friday, July 26, 2013 4:41:50 PM UTC+5:30, Anand Doshi wrote:
    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 typeLeave Without Pay.

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

    Thanks,
    Anand.
    --
    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-forum+un...@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.



    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-forum+un…@googlegroups.com.

    To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-user-forum/CAAQzbF1zOQCd4JEkBCxmHn6AcMvmSegKcHm79DfFULKeWHFB%3DA%40mail.gmail.com.

    For more options, visit https://groups.google.com/d/optout.

    ‎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
    To: er...@googlegroups.com
    Reply To: er...@googlegroups.com
    Subject: [erpnext-user-forum] [Discussion] Working Days in Salary Slip

    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. 

    On Thursday, August 21, 2014, Addy <ad...@gmail.com> wrote:
    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).
  • 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) 
  • 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)
  • Five Days Leave:
    • All cases consider as 6 days leave.
  • 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.



    On Friday, July 26, 2013 4:41:50 PM UTC+5:30, Anand Doshi wrote:
    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 typeLeave Without Pay.

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

    Thanks,
    Anand.
    -- 
    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-forum+un...@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.



    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-forum+un…@googlegroups.com.

    To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-user-forum/CAAQzbF1zOQCd4JEkBCxmHn6AcMvmSegKcHm79DfFULKeWHFB%3DA%40mail.gmail.com.

    For more options, visit https://groups.google.com/d/optout.




    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-forum+un…@googlegroups.com.

    To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-user-forum/20140822121123.5378180.90860.9679%40xavierltd.com.

    For more options, visit https://groups.google.com/d/optout.

    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!

    El viernes, 26 de julio de 2013 06:11:50 UTC-5, Anand Doshi escribió:
    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.



    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-forum+un…@googlegroups.com.

    To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-user-forum/090e8703-9e7a-4492-806a-04366fbc2015%40googlegroups.com.

    For more options, visit https://groups.google.com/d/optout.

    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.



    On 22-Aug-2014, at 6:49 pm, Abdel Gadiel Martínez Lassonde <ab...@gmail.com> wrote:

    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!

    El viernes, 26 de julio de 2013 06:11:50 UTC-5, Anand Doshi escribió:
    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.



    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-forum+un…@googlegroups.com.

    To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-user-forum/090e8703-9e7a-4492-806a-04366fbc2015%40googlegroups.com.

    For more options, visit https://groups.google.com/d/optout.




    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-forum+un…@googlegroups.com.

    To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-user-forum/53921610-EB9D-4461-8960-6715CA339A9B%40gmail.com.

    For more options, visit https://groups.google.com/d/optout.

    I am not getting your exact point, my pay slip pifra is here can you check it out?
    How many days I have to include as a working days in salary slip?