The instructions cover the construction of working time bank tracking in Netvisor using record types and salary types. The balance of the working time bank is displayed on the payslip, and necessary calculation formulas are defined for reporting purposes.

Table of contents

In Netvisor, you can track hours recorded in the working time bank and paid hours using record types on the working hours report. This example is constructed so that the balance of the working time bank is visible on the employee's payslip, allowing the employee to also monitor the balance of the working time bank. Tracking can also be set up solely for the payroll accountant, where the payroll accountant monitors the hours in the working time bank from the working hours report. In such a situation, there is no need to create salary types, and you can manage with just the record types mentioned in the help.

New salary types to be created for payroll

Five new salary types must be created in company-specific salary types to ensure that the formulas for record types work on the payslip. The salary types can be named as desired:

  • Multiplier 1
  • Hours RECORDED in the working time bank
  • Leaves to be PAID from the working time bank
  • Balance of the working time bank
  • Opening balance of the working time bank

New salary types are created from company-specific salary types:

Salaries > Payroll > Salary model management > Company-specific salary types > Add new salary type

  1. For all salary types, select the group "Salaries and allowances".
  2. Select the payroll list group "Not considered".
  3. Select the source "User's formula".
  4. Except for the salary type "Opening balance of the working time bank", select the source "Employee's salary basis" so that the initial situation of the working time bank can be entered in salary basis management.

Ensure that all salary types have at least "Included in calculation by default". Select "Shown on report" only for the salary type "Leaves to be paid from the working time bank".

Creating record types

Create two record types for recording and paying working time bank hours:

Salaries > Settings > Payroll settings > Record types > Add new record type

  1. Give the record type to be recorded in the working time bank a suitable name.
  2. Select the formula for the salary model: Hours x 1 x Multiplier 1 = Hours recorded in the working time bank. (Example: 20h x 1 x 1 = 20).

  1. Add another record type for paying hours from the working time bank.
  2. Construct the formula for the salary model according to the agreed method in the company (e.g., regular salary according to the time of taking the leave).

"When the employee takes leave from the working time bank, they are paid regular salary for the hours taken according to the time of taking the leave."

Defining calculation formulas

Define the calculation formula for the salary type "Multiplier 1":

Salaries > Payroll > Salary model management > Select "Formulas" from the salary model > Salary type formulas tab > Salaries and allowances > Multiplier 1 > Green plus > Fixed number > 1 > Save

Before you can add the calculation formula to the salary type "Balance of the working time bank", ensure that the salary type is linked to a salary model:

Salaries > Payroll > Salary model management > Select the desired salary model > Link salary type to salary model > Search for salary type from the list > Link

Define the "Balance of the working time bank" formula from the same place as Multiplier 1:

  1. Initially select the salary type "Opening balance of the working time bank" and the calculation +.
  2. Select "Value of salary type in time period" element.
  3. Select the salary type "Hours recorded in the working time bank" and the value "Amount".
  4. Select the period "Whole year".
  5. Select minus (-) as the calculation.
  6. Subtract the paid hours by selecting the salary type "Leaves to be paid from the working time bank".

Add "Leaves to be paid from the working time bank" to the Salary in money formula:

Salaries > Payroll > Salary model management > Select "Formulas" from the salary model > Salary type formulas tab > Calculatory > Salary in money > Edit (pen/notepad) > Green plus > Calculation: plus sign > Green plus > Salary type: Leaves to be paid from the working time bank > Save

Opening balance of the working time bank

If necessary, add the initial situation of the working time bank to the salary basis:

Salaries > Personnel > Salary basis management

Formatting the salary model

Edit the necessary salary types to be hidden from the payslip or change their order:

Salaries > Payroll > Salary model management > Select salary model > Format tab

Example of use

  1. The employee records 50 h "Hours recorded in the working time bank" and 150 h of normal work. The supervisor approves the records. Additional or overtime hours, flexible working hours, and time equivalent to monetary benefits based on law or agreement can be transferred to the working time bank.
  2. The payroll accountant creates the payslip. Normal work is paid as earnings, and hours recorded in the working time bank accumulate the balance of the working time bank.
  3. In the following month, 150 h of work is recorded and 20 h of leaves to be paid from the working time bank. The balance of the working time bank decreases (50 h - 20 h = 30 h).

  4. In the third month, 150 h of work is recorded, 5 h added to the working time bank, and 10 h paid from the working time bank. The final balance of the working time bank is 25 h (30 + 5 - 10 = 25).

Monitoring the working time bank on working hours and payroll reports

Monitor hours and balances from reports:

Working hours > Working hours reports > Report format: Working hours report

  1. Select the period (e.g., Whole year).
  2. Make restrictions to the employee and salary model.
  3. Select record types from the record type menu by holding the ctrl key: "Hours recorded in the working time bank" and "Leaves to be paid from the working time bank".
  4. Press "Show report".

The report shows the difference between recorded and paid hours, which is the remaining balance.

Retrieve the number of paid hours and euros from payroll reports:

Salaries > Payroll > Reports > Payroll reports

Frequently asked questions

Question: Can the working time bank be monitored without salary types?
Answer: Yes, tracking is possible solely for the payroll accountant from the working hours report, using only record types.

Question: How is the opening balance of the working time bank entered?
Answer: Select "Opening balance of the working time bank" as the source for the salary type "Employee's salary basis" and enter the balance in Salary basis management.

Question: What hours can be transferred to the working time bank?
Answer: Additional or overtime hours, flexible working hours, and time equivalent to monetary benefits based on law or agreement can be transferred there.

Keywords: working time bank, payroll, record types, salary types, calculation formula, balance, working hours report, opening balance

This article has been translated using an AI-based translation tool. The contents or wording of these instructions may differ from those in other instructions or in the software.


Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.