Template RH

In competitive environments and with the lack of qualified human resources, a proper management of those resources has a major role in retaining talents and in maintaining productivity.

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.

Through the HR template, the HR managers can automate, with a low cost, a generation and a distribution, with security and confidentiality, like information on the staff.

.

.

• 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.

.

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

.

Information on the HR spreadsheet:

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

.

• Filial: Name of the branch where the employee works

• Centro de Custo: Name of the cost center where the employee is designated

• Colaborador: Employee's name and code

.

• Estado Civil: Employee's marital status

• Grau de Instrução: Employee's level of education

• Faixa Etária: Employee's age group

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

• Tipo Contrato: Type of employment association with the employee

.

.

.

.

.

.

.

• Remuneração Mês: The value of the employee's net remuneration in the month of competence

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

• Passivo Férias: Amount provisioned for vacations

• 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 Faltas: The number of hours the employee missed work

.

Analysis:

.

• Monthly Cost analysis by Cost Center

.

.

• Ranking of employees with more absence

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