Weekly and Fortnightly Payroll / Salary Slips

@tonyta …ok …i’m not much expert on this field …i’ve double checked HR module:

  • per hour rate: i’ve just double checked and it’s possible to set if Salary Slip Based on Timesheet is set.

  • hours worked per day (start time, end time): can be set in time sheet as well.

at the end:

  • daily/weekly working hours: the number of hours employee has to work per contract.

  • rate for extra hours: if employee will work extra hours that should be paid more than “normal” hours, as well as if working during holidays.

  • leave application: should allow to set number of hours of leave not only days/half days

Well …as told you i’m not an expert but wrote down stuff on how people get paid here …

We really need an expert on this :joy:

@JoEz the Civil Contracting App by @revant_one touchs on this idea. It is well documented and is available via frappe App Installer.

Like @JoEz HR and Payroll are an areaI know nothing about.
Would a lot of weekly and fortnightly payroll features be covered by simply adding a Week number field directly after the month field in the Process PayRoll Doctype?
So we would have Fiscal Year, Month and Week Number. We are currently in Week 43.
@tonyta It does get a bit tricky when you start to factor in holidays

@System19 thx for the info, i’ll have a look at that …

The day/half day unit is another problem in the Leave application as well as the Entitlements’ accrual.

For the time being, we have been using Time Sheet and Excel to work them out.

However, I think they should both be addressed in a separate topic.

I am new to ERPNext and really like what I see so far. This is a feature I am quite interested in as well. Some thoughts to @tonyta post on 10/19.

Someone posted about week numbers, I think this is a key component to determining pay periods. You can pay weekly for each single week number, fortnightly for every 2 consecutive week numbers and monthly based on standard calendar (standard calendar would also “see” the week numbers). The start date can certainly need logic, but that is generally a one time thing when you hire someone and then again when you terminate someone.

You should be able to mention what day you pay your people by pay cycle. e.g. Every Friday (for weekly), ever other Wed for fortnightly, and day of month for monthly. I would think a Salary Slip Pay Cycle doctype would help to facilitate this if I understand the architecture well enough.

Do you assign the “Salary Slip Pay Cycle” to an employee document directly or via his/her department so everyone in a department is automatically getting paid the same way?

Unless this is in 7.1 or 7.2 future releases, I think it would be good to add a field in Salary Component for Component type. Drop down for Earning or Deduction selection. Then update the Salary Component to only show Earning types in earning table and the same for Deductions.

The rest looks fabulous.

This feature will come out in v 7.1.

Rest of your suggestions will also be taken into consideration.

1 Like

@tonyta do you want to add the design at Add Weekly Payroll Processing · Issue #4422 · frappe/erpnext · GitHub

What is your github id?

design uploaded into github - my id is tta-cloude8

Would it not be nice if this small addiction be made in time sheet based salary structure:
Making the rate variable because a staff may work in 2 or 3 different projects in a month and the rate paid to him differ per project.
This can be solved by the erpnext team by making more than one provision for salary components rate in Salary structure

Pls consider because this will help in some organisation

is there a feature that can process multiple salary structures in one click?because in our case employees can have diferrent structure, some employees may have overtime, some may have deduction, and different allowances so how can we manage this?

No, that is not possible. In one payroll, only 1 Salary Structure is taken into consideration.

Would you be open to an enhancement request to make this an option to run all structures at once?

One Employee can have only one active Salary Structure for given dates right now. Multiple salary structures will be confusing I think, you can add conditions to the existing Salary Structure instead of creating new one.

I am not sure that is what @Sachine_P1 is asking about. I took the question as more about running payroll across all structures for all employees in one run instead of allowing different structures for the same employee by payroll run.

Sachine_P1 - mind elaborating?

you are right thats what i was asking,actually it will work i found the solution.thanks

thanks for the great work on payroll you have done so far, but i have one comment regarding the salary structure,
the system will be better and minimize redundancy work if we can give the condition and formula on the creation of salary components it will minimize redundant work for companies which have large number of employees, but if we give the condition and formula on salary components , it will be thick or unthick for employees which they are concerned…but now we have to write the same formula for all employees.thanks

What was that?

@James_Robertson, @KanchanChauhan the system by default works it.
but what we need now is to give the formula on the salary components, it will make the payroll system very simple, in our case we have almost 800 employee, and we have created 800 salary structure for each but writing formula for each salary structure on each salary components again and again is time taking.it will be better if we write the formula on the components and when we call the salary component the system will bring the formula automatically.thanks.

I want to jump in the fray and request one addition to the fantastic work done on the Process Payroll system. Currently, we process two divisions with a small number of employees, and their salary structures individually assigned, with correct formulas. All works well, including the rounding as per:

Bank Entry Rounding Error when processing Payroll

The Journal Entry ERPNext makes includes one bank entry per all the pay slips processes in that particular payroll. One of my banks handles it this way and in the statement it reports one transaction for the entire set paid. I can access the integration online when having processed the payroll electronically. It works great out of the box.

However, the other bank we use, shows each employee’s net cash deposit individually, and I would like to have the option in ERPNext to generate multiple bank entries in the same JournaI Entry where the payroll is processed.

Of course, I can add this manually and the entire Journal Entry would balance, but currently it involves cancelling the ERPNext generated Journal Entry and then Amending it so that we split the bank transaction into its individual components. This is a time consuming effort, and would like this feature implemented in the Process Payroll tool.

Github #8037

1 Like