[Discussion] Working Days in Salary Slip

system · July 26, 2013, 11:11am

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.

adityaduggal · August 21, 2014, 5:50pm

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:

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.
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.

system · August 22, 2014, 5:40am

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:

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.

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.

anand · August 22, 2014, 6:54am

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:

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.

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.

wale · August 22, 2014, 12:11pm

‎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:

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.

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.

abdel_g_martinez_l · August 22, 2014, 1:19pm

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.

rmehta · August 23, 2014, 8:41am

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.

pifra · September 28, 2020, 11:53am

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?

pifraslip · January 2, 2022, 1:00am

As of, we manually enter LWP and move on with salary fulfillment

Salary per day = Total Salary/Total days in Month

It is a very old post but still useful. I get my salary slip from pifra but didn’t understand how they calculated working days.

How many days are included in the salary slip, Like they include the working days only?