Articles about: Reports, Importers and Exporters

R22 - How to generate the spreadsheet to verify payroll (closing checklist)

O R22 - Planilha para verificar folhas é o seu principal relatório de checklist antes de fechar o mês. Ele foi desenhado para facilitar sua gestão, listando todas as correções necessárias (como pontos em branco, marcações duplicadas ou fora de ordem) para garantir um fechamento de folha correto e simples.
Este relatório ajuda a identificar rapidamente quais colaboradores e quais dias precisam de ajuste.


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 the option R22 - Spreadsheet to check sheets.


  1. Define the filters for your query:
  • Main filter: You can filter by workplaces, employers, or groups.
  • Period: Select the date range (start and end) you wish to view.


  1. Configure the extra options:
  • Generate only a complete list of pending items: By selecting this option, the report will consolidate "Notable Events" (such as absences and lateness) and "Notes" added to the sheet into a single tab.
  • Send report results by email: Check if you would like to receive a copy by email.


  1. Click on "Generate Excel".




How to download the report


After clicking "generate excel," the platform will process the report in the background.


  1. Click the bell icon (Notifications) in the navigation menu to track the file being generated.


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


  1. R22 is downloaded as a compressed (ZIP) file. When you extract the file, you will see three spreadsheets:
  • r22-success: The main report with all the data.
  • r22-status: A technical file about the generation status.
  • r22-error: Lists any potential errors in the generation process.


  1. Open the r22-success to begin your analysis.


How to read the report


View of the "Points to correct" tab


The r22-success file is your closing checklist. It is divided into tabs that separate the types of pending items, facilitating their management and progress in the payroll closing process.

Tab (Spreadsheet)

What does the information represent?

Audit Tips (Your Management)

Points to correct

Esta é a sua prioridade de fechamento. A aba lista todos os erros que impedem o cálculo correto da folha.

Ação Imediata: Verifique a coluna Observação. Erros como "Ordem dos pontos possui erros" ou "Pares de marcações incompletos" precisam ser ajustados na folha do colaborador.

Notable Events

Esta aba lista eventos que não são erros, mas que exigem sua atenção e validação antes do fechamento.

Revisão de Ausências: Use esta aba para conferir todas as Faltas, Atrasos e Dispensas do período, garantindo que todas as ausências estão corretas.

Notes

This tab lists all the notes/comments that were entered on the timesheet during the period.

Auditoria de Comunicação: Verifique as notas deixadas por gestores ou pelo RH para garantir que todas as justificativas foram tratadas.


R22 makes payroll closing easier and safer. By using it as a checklist before closing the month, you ensure the transparency and accuracy of all employee data.


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: May 22, 2026

Was this article helpful?

Share your feedback.

Cancel

Thanks!