How to Use the Bank of Hours

How to use the time bank
Excel Spreadsheets

What is hour bank?

The hour bank is a system that serves to make the working day of employees more flexible, making it possible to compensate for hours due and overtime in an organized way. We all know that in the day to day work can happen to arise unforeseen and demands to carry out activities that can generate a longer working time than agreed in contract.

To prevent the "exploitation" of the worker and a possible loss of the company, the hour bank was established as a way of controlling those extra hours.

Banner Overtime Calculation Worksheet

Although relatively simple, this does not mean that it has no current law or legal agreement on the subject. In addition to what is stated in the CLT, the 9.601 / 1998 law was created to regulate this type of activity and the control of the time bank must be authorized by agreement or collective agreement.

How does the time bank work?

In view of the economic uncertainty and the need to implement strategies to deal with times of crisis, the adoption of the hour bank represents an interesting alternative for companies. Under the system, the employee and employer create a kind of "account", in which the hours worked are recorded more.

The credit in favor of the employee can be used as a vacation, extension of vacations or anticipation of the end of the file. See a chart of our spreadsheet for overtime calculation which exemplifies overtime worked month to month.

The first step in making the hour bank work in your company is to understand how the overtime calculation correctly.

How to use time bank - graphs

The adoption of the hour bank obeys strict rules. The first requirement is that the system be ratified by agreement or collective agreement. Your deployment can not exceed the limit set for the workday - 10 hours per day and 44 per week. Another concern is the usual overtime. They should not be counted in the system.

The agreement for the adoption of the hour bank is valid for one year and may be renewed. At the end of the term, the credit in favor of the employee must be paid as overtime. In case of dismissal of the employee, the balance in the system becomes overtime worked (which must also be paid according to the termination criteria).

Spreadsheet of hours bank

Managing the time bank is a challenge for any manager. A company with 300 employees working on three shifts presents a myriad of parameters for assembling the system. The variable remuneration (additional of dangerousness and of night work), weekly rest paid (DSR), holidays, delays, layoffs, absences, medical leave and shift changes are just some of the elements that require rigid control.

In most cases, the simplest way is to use an hour bank worksheet. Let's see the example of our Extra Time Calculation Worksheet. Here's one of the results she reports after filling in:

How to use time bank - hour bank analysis

Bank of Hours Model

The first step is to understand what the overtime pay model is for your company. You may choose not to hold the time bank and pay overtime every month for hours worked by your employees.

Normally, if it is possible to make a bank of hours, I believe it to be advisable, since in this way you pay less for your company and also give greater flexibility to those who work in your company to take one or other slack according to their availability and overtime carried out.

Here's the choice and establishment of overtime:

How to use time bank - hours bank system

The organization of the time bank should facilitate decision making by the company. Thus, the information presented helps define the best option for the company: payment of overtime or maintenance of the bank of hours.

How to use hours bank - hours worked

Another functionality of the worksheet is the issuance of personalized reports from employees, in addition to the point sheet itself.

How to Use the Bank of Hours

The assembly of the spreadsheet should include the following elements:

  • record of each employee's workload;
  • employee input and output control;
  • record hours of worked hours;
  • inclusion of hazard premium;
  • calendar of the current year;
  • option of payment of overtime or inclusion in the bank of hours;
  • record of due hours, overtime and hours bank;
  • monthly report of hours worked by employees;
  • analysis of total hours added / discounted;
  • preparation of composition charts of the time bank.

How to use time bank - hour bank

It should be noted that the adoption of the spreadsheet gives the company a chance to reduce the time spent controlling the time bank. This represents productivity gain, cost reduction, and the possibility of allocating personnel in other areas. The automation also allows the organization to have a more consistent planning, since it consolidates the history of the use of labor in the organization.

Banner Overtime Calculation Worksheet

The has a spreadsheet ready to calculate overtime with time bank in Excel. Check out all the features or see all our features spreadsheets for human resources!

Excel Spreadsheets


Please, write your comment
Please enter your name