Salary Slip working days/payment days calculation in ERPNext HRMS

Hi

I am facing an issue with Salary Slip working days/payment days calculation in ERPNext HRMS.

Our company’s salary calculation policy is:

  • Monthly salary is calculated based on 26 days.

  • Sunday / Weekly Holiday should be treated as an unpaid weekly holiday and should reduce the payable/working days.

  • National Holidays and Local Holidays are paid holidays and should not reduce the employee’s salary/payable days.

  • If a National/Local Holiday falls on a Sunday, it should be counted only once as the weekly holiday and should not result in an additional deduction.

  • However, when we add both Sundays and National/Local Holidays to the same Holiday List, ERPNext treats them as holidays during the working-day calculation. As a result, the National/Local Holidays are also reducing the working/payment days.

    What we need

    We want the system to distinguish between:

    Weekly Holiday (Sunday) → Unpaid / Deduct from payable days

    National/Local Holiday → Paid / Do not deduct from payable days

    Sunday + National/Local Holiday on the same date → Count only once as Sunday