Template RH

.

In this situation, to achieve these goals, it is vital that the human resources departments provide reliable and up-to-date information on the staff to other managers.

.

Learn through the available dashboards:

• the distribution of labor force by cost center,

• the HR costs by cost center,

• overtime rates by cost center,

• which employees with the most absences,

• if the employee's level of education and age group are within the company's standards.

Download the HR worksheet and replace it with your data to start reviewing immediately and improving the management of your employees.

If you do not have all the data available, leave the corresponding columns blank.

Share your information with other company managers by displaying only the information relevant to them while you still have full access to all information.

.

• Data Competência: Date of data collection on the HR system

.

• Filial: Name of the branch where the employee works

.

• Colaborador: Employee's name and code

• Sexo: Employee's gender

.

.

.

• Cargo: Description of the position that the employee occupies within the company

.

• Situação: Indicates whether the employee is on active staff

• Tipo Situação: Indicates the employee's dismissal reason

• Periculosidade: Indicates if the employee performs a function considered dangerous

• Insalubridade: Indicates if the employee performs a function considered unhealthy

• Data Admissão: The date when the employee started working at the company

.

• Salário Mês: The value of the salary paid to the employee in the month of competence

.

• Passivo Décimo Terceiro: valor provisionado para o décimo terceiro salário

.

• Passivo FGTS: valor que foi recolhido para o FGTS do colaborador

• Bnf. Transporte: Amount paid as a voucher benefit

• Bnf. Alimentação: Amount paid for the food voucher

• Bnf. Saúde: Amount paid as health plan benefit

• Bnf. Outros: Amount paid under other benefits

• Qtd.Horas Extras: The amount of overtime worked

• Valor Horas Extras: The value of overtime worked

• Qtd. Horas Pagas: The number of hours paid

• Qtd. Horas Faltas: The number of hours the employee missed work

• Percentual de Horas Faltas: Percentage of absences over hours paid

Analysis:

• Collaboration analysis by cost center

• Monthly Cost analysis by Cost Center

• Management of employees by branch

• Overtime information

• Ranking of employees with more absence

• Summary of employees by Sex, Marital Status, level of education and Age Group