Make employee-wise Journal Entry for payroll entry

[amadhaji]

We plan to make an app to customize payroll to record each employee Liability and pay them in cash instead of paying them through bank.
supposed features:

• option in Payroll Entry to detect if it’s employee-wise.
• if payroll entry is employee-wise then
  1. filter Payroll Payable Account to payable account type.
  2. on submitting salary slips form Payroll Entry create one Journal Entry that sum the debit (Earning) and credit (Deduction) for each Salary Component (Default Behavior) and distinguish employees’ Liability for each Salary Slip and set employee as party.
  3. after submitting salary slips add button in Payroll Entry to create Payment Entry For each salary slip and add salary slip in Payment References table.

Any Suggestions for better Scenario?

[amadhaji]

@imorghim @Mohammed_Alnozily

[amadhaji]

Other related posts

---

Salary in Journal Entry

Dear Community, Accounting Entry from Process Payroll is marking as Single Journal Entry,is there any provision to Mark Employee as Party to distinguish each Salary Slip in Journal Entry so that we can track Paid and Pending (in case salary is released as Part).

@hereabdulla
@ahmadRagheb

---

Salary Slip Payment

It seems to me that the salary payment system isn’t fully actualized yet, with respect to paying employees. It looks like the only way to do a payment is through the Payroll Processing system, and that creates a single JV for all the salaries going out. This is OK if you’re sending the money to a bank for processing, but if you’re doing it yourself it and need to print cheques or do e-transfers into all your employee accounts, it doesn’t work so well. It seems to me that you should be able to …

@Ben_Cornwell_Mott

[amadhaji]

Repository for the app where changes will made
It still under development for anyone who want to track the progress

GitHub - open-alt/employeewise_payroll: Make employee-wise Journal Entry for...

[abdufaiz]

+1
A similar approach has already been addressed in Advanced payment, where the account Employee Advances (Asset) will be used for all advances. Upon creating a Payment Entry, the Party type is selected as employee, and the employee details are fetched.
https://docs.erpnext.com/docs/v13/user/manual/en/human-resources/employee-advance
If the same can be applied here for Payroll Entry for each employee

[amadhaji]

@abdufaiz

If the same can be applied here for Payroll Entry for each employee

Yes, That’s possible.

@amadhaji

• option in Payroll Entry to detect if it’s employee-wise.
• if payroll entry is employee-wise then

1. filter Payroll Payable Account to payable account type .
2. on submitting salary slips form Payroll Entry create one Journal Entry that sum the debit (Earning) and credit (Deduction) for each Salary Component (Default Behavior) and distinguish employees’ Liability for each Salary Slip and set employee as party.
3. after submitting salary slips add button in Payroll Entry to create Payment Entry For each salary slip and add salary slip in Payment References table .

the development of these features is complete.
I hope, I can upload docs for how to use it, today or tomorrow.
extensive tests are needed

[amadhaji]

@amadhaji

I hope, I can upload docs for how to use it, today or tomorrow.

Sorry, to be late,
Documentation As README.md is uploaded and could be found in the repository.
I hope, It’s useful app.

[fnrfarid]

@amadhaji

can the same be done for Deductions?

Usecase: for Provident Fund deductions, as only one single Journal gets created for each payroll, it is difficult to understand how much is deducted for each employee!

We could use salary register for this, but what if we are migrating from another system, then we will have to look for two reports in order to figure out the total amount when someone is leaving and we need to settle their PF amounts.

It would have been nice if we could implement the same like employee-wise liabilities in journal posting