Salary Register Bulk Upload Overview

Two excels upload/download are available

  • ‘Loss of Pay Days’ Template
    1. Using this excel, the user can upload the loss of paydays for the selected salary cycle against each staff member.
    2. 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.
    3. 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.
    4. 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.
    5. 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
    1. The amounts in this excel are according to the LOP Days entered in ‘Loss of Pay’ template and salary structure uploaded.
    2. When ‘Loss Of Pay’ template is not uploaded by the user, the amounts in this template would be displayed considering ‘0’ LOP Days.
    3. User can make manual edits in any of the salary components in this sheet which will have no impact on any other dependent column.
    4. 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.
    5. This final values of each component uploaded in this excel will also be displayed in the information present in salary register screen.
    6. Adhoc Deduction or Payment components created in salary components screen can be added by the user while downloading this template on need basis.
    7. Adhoc components will be mapped to the staff member against who a value was uploaded for the same.
    8. 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
Was this article helpful to you?
Yes1
No2