Two excels upload/download are available
- ‘Loss of Pay Days’ Template
- Using this excel, the user can upload the loss of paydays for the selected salary cycle against each staff member.
- When this excel is downloaded for the very first time, Loss of Paydays column against each employee is pre-filled with ‘0’ and the number of salary components in ‘Salary Register’ excel are pre-filled considering ‘0’ LOP Days.
- As soon as the user uploads this excel, the ‘Salary Register’ template is updated after LOP Calculation is done according to the LOP Days uploaded in this excel.
- Each time this excel is re-uploaded, the values in salary register will be revised and re-calculated discarding any previous manual override on salary register values.
- The change according to the uploaded LOP Days will only be seen in the components for which LOP is made applicable in salary component screen.
- ‘Salary Register’ Template
- The amounts in this excel are according to the LOP Days entered in ‘Loss of Pay’ template and salary structure uploaded.
- When ‘Loss Of Pay’ template is not uploaded by the user, the amounts in this template would be displayed considering ‘0’ LOP Days.
- User can make manual edits in any of the salary components in this sheet which will have no impact on any other dependent column.
- Each time user uploads the ‘Loss Of Pay’ template the values in this excel is revised discarding any manual edits done. However, any Adhoc added for a staff still remains mapped and is not dependent on upload of LOP excel.
- This final values of each component uploaded in this excel will also be displayed in the information present in salary register screen.
- Adhoc Deduction or Payment components created in salary components screen can be added by the user while downloading this template on need basis.
- Adhoc components will be mapped to the staff member against who a value was uploaded for the same.
- While downloading this template, the user has to mandatorily download those Adhoc components which have been already mapped to one/more staff for which the register is being downloaded.
Was this article helpful to you?
Yes1
No2