Salary Slip year to date column calculation on print out

[Jermaine_Gray]

Any one know how to put the YTD column on salary slip.

[saurabh6790]

what is the use case?

[James_Robertson]

The use case is that in many jurisdictions, knowing the YTD value for various salary components is useful to an employee from an awareness perspective (on printed salary slip) and is also very useful in varying tax calculations that need to know this value due to ways that tax are applied based on the value. This is a big need that is not in the platform today. I have mentioned the same in other threads.

Glossary of Field Names and Operators Available in Salary Structures

I have done some research/testing/experimenting in my dev instance to see about figuring out some things. So I have not been able to figure out all the varying operators/operations you can do in a salary structure component formula, I did figure out that you can use any field name from the document type itself. If you need more fields from the employee, you can add read-only versions of those into the salary slip form via link records and then use those field names in your formulas. So for exa…

[adam26d]

This has popped up several GitHub issues and forum topics but hasnt yet got the attention:

Updates to the Payroll

Salary component YTD and Pay Slip updates

How can I Find Cumulative Salary in HR?

Sorry, feature does not exist.

ERPNext in Australia

Hello @OneiricIT We have been using the payroll section in HR module since last July. It was last step before dropping MYOB completely. At the moment we are running version 6.27. I’ll let you know about the new formula feature once we migrate to 7.1. We use Salary Structure same as yourself to keep history. For the time being, we manually calculate the PAYG using ATO website. There is still a bit of extra work that needs to be done (e.g. PAYG calculation, YTD amounts, an Entitlements ledger, e…

I’m planning on a customisation template. Not much experience customising ERPNext under the hood. But we can do some new fields/doctypes and add a few scripts to achieve this. Doable with some help from the Pros.

In reply to @James_Robertson’s Github post. Heres my full idea:

---

I’m considering customising the HR module to achieve this. I plan to pull the values from past payslips and sum them up in the current payslip.

It’d also be useful to save the current value in the Employee Profile, or better a linked document.

This will need an opening value in case of an implementation with already existing YTD values (mid-year for example).

So the formula for YTD Tax would be:
Employee_YTD_Tax = Employee_Opening_Tax_Value + [Employee_Past_Payslip_Tax]

Does anyone know how to query this given item from all past payslips on a given Employee ID?

[seanfalloy]

I need this functionality to (In Canada) I will be willing to put some effort into adding this but I don’t have the time currently. I will check back in on the progress and help out if you haven’t figured out a good way.

[James_Robertson]

I am no developer, but my guess would be that there is going to need to be some kind of back end python code that goes in and queries past payslips based on the employee id or some kind of key field. You will have to look up fiscal year information first to know when the “start” month is and then from there go back X months from current month and grab the data. If there is a way to store the data in a table, that would be good so that once the calculation is done once it is good for a full month before having to be queried again. I would think an update to the salary slip doctype would be a good place to capture this. This would save precious resources at server side.