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 navigation menu of the Management website, select the 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.
  • Formato hora/minuto (hh:mm): Por padrão, o relatório apresenta os valores em formato decimal. Marque essa opção para que os valores dos apontamentos venham em formato de hora e minuto.



  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 the navigation menu to track the file being generated.


  1. Once completed, the report will be downloaded to your computer automatically.


  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 . Each row represents an employee, and the columns show the sum of each type of event


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).

Utilize o Código ou CPF para cruzar os dados com segurança na comparação com o seu sistema de folha de pagamento.

Work Schedule and Attendance

H. Trabalhadas, H. Previstas, Dias Trab, Dias Trab. previstos.

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

Overtime

H. Extra, H. Extra Not (Noturna), H. Extra Ext. (Extras em folga/feriado), H. Extra Especial.

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

H. de Atraso, H. Saída Antecipada, H. em Faltas, Faltas (em dias), Dias dispensa, Dias susp., Dias s/ DSR (Desconto de Repouso).

Atenção ao DSR: A coluna "Dias s/ DSR" indica quantos dias de descanso semanal remunerado o colaborador perdeu devido a faltas ou atrasos na semana.

Night Shift and Additional Hours

Adic. Noturno (Adicional), Red. noturna (Hora reduzida), H. de Inter-Jornada.

Conformidade: Verifique se a coluna "H. de Inter-Jornada" possui valores, pois isso indica que o colaborador não descansou as 11h obrigatórias entre turnos.

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

Was this article helpful?

Share your feedback.

Cancel

Thanks!