Salary Slip year to date column calculation on print out

[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?