Articles about: Reports, Importers and Exporters

R27 - How to generate the absenteeism report

The R27 report, available on the Pontotel platform, presents indicators of voluntary, involuntary, and total employee absenteeism , providing a consolidated view of absences within the company. This report is essential for HR to monitor absence patterns, analyze impacts on productivity, and support people management strategies.


Step-by-step guide to generating the R27 report.


  1. In the navigation menu of the Management website, select the Reports and Records.


  1. Select the option "R27 - Absenteeism Report".


  1. Configure the filters.



Escolha quem analisar: Use as abas no topo para definir a base do relatório: locais de trabalho, empregados ou grupos. Selecione os itens desejados.
Defina o período: Informe início período e fim período. Esse intervalo determina de quando até quando o absenteísmo será calculado no arquivo.
Opções extras (marque apenas o que precisar):

  • Omit employee with zero values: removes from the spreadsheet those who had no absences/occurrences during the period.
  • Display terminated employees: includes those who left within the analyzed period.
  • Disregard hours that have been added to the time bank: ignores entries already sent to the time bank, so as not to count them as absences.
  • Omit absences, lateness, and early departures if the employee has a positive balance in the period: if the employee ends the period with a positive balance, these negative occurrences are not included in the report.
  • Include "total by employer" tab: adds a tab to the file with average absenteeism rates by employer.
  • Include "Total by Workplace" tab: adds a tab to the file with average absenteeism rates by workplace.
  • Consider suspension in the report: includes suspensions in the calculation (it goes into the involuntary absences block).


  1. Click on "Generate Excel" to start processing the report.


  1. In the navigation menu, click the bell icon (Notifications) to track the file being generated.


  1. When it reaches "100%", the report will be downloaded automatically.


Understand the report


The report is exported in Excel format and features several columns with detailed information about each employee. See below for an explanation of each field, as well as the formulas used to arrive at the values ​​for specific fields:

  • Columns |** Password, Code, Name, CPF (Brazilian Taxpayer ID), Job Title, Department, Work Location, Date of Hire**: employee registration data.
  • Column I |** Length of service:** Employee's length of service up to a reference date in the report, expressed in decimal years (two decimal places).
  • Column J |** Total hours planned for the period: **number of hours of work expected in the period.
  • Column K | **Total hours of absence:** Number of hours of absence within the period.
  • Column L |** Total hours of lateness: number of hours of lateness (in relation to the expected workday) incurred by the employee within the period.  **
  • Column M | Total early departures: number of hours of early departure (in relation to the expected workday) taken by the employee within the period.
  • Column N |** Total hours of unjustified absence:** sum of absence time, lateness, and early departure. Formula: K + L + M
  • Column O |** Total hours of leave:** number of absences justified by means of leave (partial or full day), such as medical leave.
  • Column P | Total: sum of justified and unjustified absences. Formula: N + O
  • Column Q |** % Voluntary Absenteeism**: percentage of voluntary absences in relation to the total hours scheduled for the period. Formula: (N ÷ J) × 100.
  • Column R |** % Involuntary Absenteeism**: percentage of justified absences in relation to the total hours scheduled for the period. Formula: (O ÷ J) × 100.
  • Column S** | % Total Absenteeism**: total percentage of absences (voluntary + involuntary) in relation to scheduled work hours. Formula: (P ÷ J) × 100.


In addition to individual employee information, the report also allows you to calculate average absenteeism rates:

  • By workplace: add up the absenteeism percentages of employees at the same location and divide by the number of employees.
  • By employer: follow the same logic, considering all employees linked to the employer.


Conclusion


The R27 Absenteeism Report is an essential tool for monitoring absences, differentiating between voluntary and involuntary reasons, and identifying impacts on team performance. With it, HR can make more strategic decisions, implement engagement initiatives, and reduce absenteeism rates.


If you still have questions or need assistance, please contact our Support team via the chat integrated into the Management website or via WhatsApp. 

Updated on: May 22, 2026

Was this article helpful?

Share your feedback.

Cancel

Thanks!