ERPNext Conference 2019* ERPNext.com Blog

How to export whole salary slips with all salary components and their values?

erpnext

#1

Hello,
Is there any option to export all salary slips into one single excel sheet with all salary components and it’s value ?

Please help me to achieve this.
Thanks and regards.


#2

Hello, you cannot export salary slips. However, you can export salary structures and salary structure assignments.


#3

@Michelle_Alva
But HR need such a report/consolidated excel sheet for keep/sent to higher order employees. As you suggested, exporting Salary Structure and Salary Structure Assignments will be able to resolve this requirement ?


#4

@Michelle_Alva Instead of this can i use query reports for it ? If it is possible which table has all the saved components and it is value against an employee ??


#5

you can simply use salary register to export salary processing for a single month. It basically gives you every salary information as analysed on each payslip.


#6

Hi Rajeeb,

You can check the salary register for a consolidated report of the payroll generated. It will give you each and every detail.

Regards,
Reema