R22 - How to generate the spreadsheet to verify payroll (closing checklist)
The R22 - Payroll Checklist Spreadsheet is your main checklist report before closing the month. It was designed to facilitate your management simple payroll closing .
This report helps to quickly identify which employees and which days need adjustment.
How to generate the report
- In the main menu, go to Management and click on Reports and Records .
- In the Reports list (on the right), select the option R22 - Spreadsheet to check sheets .
- 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.
- 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.
- Click on "Generate Excel" .
How to download the report
After clicking "generate excel," the platform will process the report in the background.
- Click the bell icon (Notifications) in the bottom left corner of your screen to follow the file being generated.
- When the status changes to "100%", your report will appear in the completed reports .
- 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 during generation.
- Open the r22-success to begin your analysis.
How to read the report
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 | This is your payroll closing priority . The tab lists all errors that prevent the correct calculation of the payroll. | Immediate Action: Check the Observation . Errors such as "Order of points has errors" or "Incomplete pairs of markings" need to be corrected on the employee's sheet. |
Notable Events | This tab lists events that are not errors , but require your attention and validation before closing. | Review of Absences: Use this tab to check all Absences , Tardiness , and Leaves for the period, ensuring that all absences are correct. |
Notes | This tab lists all the notes/comments that were entered on the timesheet during the period. | Communication Audit: Check the notes left by managers or HR to ensure that all justifications have been addressed. |
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: November 27, 2025
Thanks!