Create grid templates

This article is intended for: 

Admin

Related module:

Admin Area Payroll Preparation

 

The variable payroll elements grid template allows you to define the data that will be exported for payroll processing. You can create several templates depending on your needs.

The template will then be used each month to transmit information to the payroll department.

 

ExcitedDancingGIF.gif

 

Create and customize your grid templates

Access: Admin area > Leave & Absences > Variable payroll elements > EVP grid templates

Nothing could be simpler!

  • Click the “Add button” button to create a new grid template, or duplicate an existing one
  • In the “Général” tab, enter a description
General tab of the EVP grid template

 

  • Once in the “Éléments variables” tab, click “Add button Ajouter un élément variable”
  • You can then select the element group: this will create a header in the EVP grid as well as during the Excel export. If you do not wish to create a grouping, select “aucun”.
  • Then select the group order (numerical): this defines the order in which the groups will be displayed in the EVP grid and the Excel export

Note: it is not possible to exceed the limit of the number 99. If you try to enter a higher number, the following message will appear: “Votre opération n'a pas pu être effectuée. Merci de bien vouloir essayer à nouveau (modification).”

 

Selection of payroll field and display order within the group

 

  • You can now select the payroll field: the drop-down list is populated by the previously defined fields
  • Also enter the field order (numerical): this defines the order in which the fields will be displayed within the group, in the EVP grid and the Excel export
Editable and Exported options for an EVP grid field

 

  • Check “Éditable” to allow values to be modified in each new EVP grid. If applicable, the retrieved values will be grayed out and cannot be modified in the grid. This feature is incompatible with “Ne montrer que les modifications de la période” for EVP grid fields.

Important! Variable elements retrieved from entries made on the platform (overtime, expense reports, leave and absences) cannot be set as editable.

 

  • Check “Exporté”: so that the field appears in the Excel export of the EVP grid
  • Save the row
Saving the field row in the EVP grid

 

  • And repeat the operation for each necessary field
  • Finally, save the grid

 

And there you have it! You have created your custom grid template! You can now use it when creating your EVP grids 😉

Customized EVP grid template ready to use

 

Related articles:


Keywords: Variable payroll elements · EVP · grid · Leave and absences · Excel export · variable · grid templates · field definition · employee record · payroll · fields · bonus · overtime · salary

Was this article helpful?

37 out of 60 found this helpful

Comments

Article is closed for comments.