Articles about: Reports, Importers and Exporters

R05 - How to generate the monthly timesheet (Payroll Summary)

The R05 - Employee Time Sheet for the Month is an essential tool for the final payroll verification.


Unlike the Time and Attendance Report (R01), which shows the day-to-day data, the R05 provides consolidated totals for the period. It sums up all overtime, lateness, absences, and other events for each employee, delivering a summarized view ready for management analysis or submission to accounting.


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 R05 - Employee timesheet for the month .


  1. Define the filters for your query:
  • Main filter: You can filter by workplaces , employers , or groups .
  • Period: Select the month and year you wish to view.


  1. Configure the optional fields in the "What information to show?" section:
  • PIS number, job title, and employer of employees : Include this information in the report to facilitate employee identification.
  • Workplace Supervisor : Displays the name of the supervisor responsible for the employee or workplace.
  • States and cities of work locations : Shows the geographic location of each work location.
  • Ignore terminations this month : Excludes terminated employees from the report.


  1. Configure the "extra options":
  • Send report results by email : Check this option if you wish to receive the report by email as well. The file will be automatically sent to the email address registered to the user who made the request.
  • Hour/minute format (hh:mm) : By default, the report displays values ​​in decimal format. Select this option to display the time entry values ​​in hour and minute format.



  1. Click on Generate Excel (the green button in the bottom right corner).


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 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. R05 is downloaded as a compressed (ZIP) file. When you extract the file, you will see three spreadsheets:
  • r05-success: The main report with all the data.
  • r05-status: A technical file about the generation status.
  • r05-error: Lists any possible errors in the generation process.


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


How to read the report


Spreadsheet R05 consolidates the monthly totals


Information Group

Main Columns

Audit Tips (Your Management)

Identification

Name, Code, CPF (Brazilian Individual Taxpayer Registry), RG (Brazilian Identity Card), Date of admission, Workplace, Payroll start date, Termination date, Company name and CNPJ (Brazilian Corporate Taxpayer Registry).

Use the Code or CPF to securely cross-reference the data when comparing it with your payroll system.

Work Schedule and Attendance

Hours Worked , Hours Expected , Working Days , Expected Working Days .

Compare "Hours Worked" with "Hours Planned" to get a macro view of who completed the required hours or who had significant variations.

Overtime

Extra Hours , Night Shift Extra Hours Extended (Extra hours on days off/holidays), Special Extra Hours .

The report separates overtime hours by type (daytime, nighttime, holidays). Check the totals to ensure they are within the department's budget.

Absences and Discounts

Lateness , Early Departure , Absences , Absences (in days), Days Off, Days Suspended, Days Without Rest Day (Rest Discount).

Pay attention to the DSR (Weekly Rest Day): The column "Days without DSR" indicates how many days of paid weekly rest the employee lost due to absences or lateness during the week.

Night Shift and Additional Hours

Night Shift Allowance (Additional Pay), Night Shift Reduction (Reduced Hours), Inter-Shift Hours .

Compliance: Check if the "H. de Inter-Jornada" column has values, as this indicates that the employee did not rest the mandatory 11 hours between shifts.

Page Status

Locked page.

Indicates "Yes" or "No". Ensures that you are using data from a payroll sheet that has already been audited and closed by the manager.



R05 is your monthly "summary." It transforms all daily records into consolidated numbers, speeding up payroll closing and ensuring that payments and deductions are made accurately.


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: January 27, 2026

Was this article helpful?

Share your feedback.

Cancel

Thanks!