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

.

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.

Information on the HR spreadsheet:

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

.

.

• 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

.

• 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

.

.

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

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

.

• Data Demissão: The date when the employee was dismissed from the company

.

• 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 Extras: The amount of overtime worked

.

.

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

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

.

• Collaboration analysis by cost center

• 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