Articles about: Reports, Importers and Exporters

R17 - How to generate the Employee Absence and Vacation Spreadsheet

The R17 report - Absence and Vacation Spreadsheet is an management . It generates a detailed spreadsheet with information on all scheduled employee absences, including leaves of absence, sick leave, and vacation periods.


This report is essential for your planning and for verifying payroll data.


How to generate the report


  1. In the main menu, go to Management and click on Reports and Records .


  1. In the Reports list (on the right), select option R17 - Absence and Vacation Spreadsheet .


  1. Define the filters for your query.:
  • Main filter: You can filter by workplaces , employers , employees , or groups .
  • Period: Select the date range (start and end) you wish to view. It is crucial that this period covers the start and end dates of the absences/vacations you want to see.


💡 Tip: If you want to receive the report by email as soon as it is generated, check the "Send report results by email" option.


  1. Click on Generate Excel .



How to download the generated report


After clicking "Generate Excel," the platform will process the report in the background.


  1. Click the bell icon (Notifications) in the bottom left corner of your screen to follow the file being generated.



  1. When the status changes to "100%", your report will appear in the completed reports .



  1. If the download did not start automatically, click the cloud (download) icon next to the report name to download the file to your computer.


  1. The file will be downloaded as a compressed (ZIP) archive containing three internal spreadsheets:
  • r17-success: The main report with all absence and vacation data.
  • r17-status: import status spreadsheet
  • 17-error: A spreadsheet listing any errors that occurred during data generation.


  1. Open the compressed file and locate the r17-success for your review.


How to read the report


View of the "Vacation Spreadsheet" tab


The R17 spreadsheet is divided into two main tabs, making absence management

Tab (Spreadsheet)

Key Column(s)

What does the information represent?

Audit Tips (Your Management)

Vacation Spreadsheet

TYPE (Vacation), START and END , DAYS .

Scheduled vacation periods (enjoyment) for employees.

Planning: DAYS column to confirm that the vacation duration is correct.

Absences Spreadsheet

TYPE (Default motif chosen), START and END .

Periods of legal absences, such as leaves of absence due to disability benefits from the INSS (Brazilian National Social Security Institute), maternity leave, or unpaid leave.

Indefinite Absences: Pay attention to the END , which may indicate an "indefinite" status.

Both tabs

Employee , Registration Number , Workplace .

Employee identification data and their affiliation with the company.

Conference: Verify that the information provided has been assigned to the correct employee.


R17 is a tool for creating and evolving your planning. With it, you have a complete and organized view of all absences, ensuring that vacation and leave management


If you still have questions or need assistance, contact our Support team via the chat integrated into the Pontotel Gestão website or via WhatsApp !

Updated on: November 11, 2025

Was this article helpful?

Share your feedback.

Cancel

Thanks!