R10 - How to generate the report with the summary of the time bank.

The R10 report offers a consolidated view of employees' time bank balances, allowing for quick and easy tracking of key transactions, compensations, and the accumulated balance for each employee. It is ideal for management analysis, payroll processing, and periodic time bank audits.

Step-by-step guide to generating the R10 report.

1. Access the reports menu.

• In the top menu, go to management reports and records option .

• Select the option " R10 - Spreadsheet with the summary of the time bank ".

2. Configure the filters.

• Choose the filter criteria according to your needs. You can select by workplaces, employers, employees, or groups.
• Next, specify the period to be considered in the report, choosing the start date and end date.
• Select the "Show information in hours/minutes (hh:mm)" option so that all balances and transactions are displayed in hours and minutes format.
• With the "Show total balance up to the selected end date" option enabled, the report will consider the total accumulated balance of the time bank up to the chosen end date, allowing a consolidated view of the employee's time bank.
• "Consider terminated employees" shows the employees who have already been dismissed during the analyzed period, with data up to the date of termination.
• If you wish, check the "send report results by email" option to receive the file directly at the email address registered to your user account.

3. Generate the report

• Click on "generate excel" to start processing the report.
• Follow the progress in the notification center (bell icon) located in the top menu.

• When the progress reaches 100%, the report will be automatically downloaded to your computer's downloads folder. If the download does not start automatically, locate the report in the notification queue and click on the corresponding line to start a new download.

Understand the report

Once downloaded, you will receive a compressed file (.zip) containing three files:

• Success (main report) : Presents the information organized into different tabs, allowing for a detailed analysis of employee time tracking. See how each part works:
• Summary of time bank: This tab provides a consolidated overview of each employee's time bank for the selected period. The following are displayed:
• Code, Password, and Name: employee identification.
• Number of approved events: total number of bank transaction records approved during the period.
• Total for the period: balance of banked hours generated (positive or negative) only within the filtered period.
• Total positive/negative for the period: separates credit hours from debit hours within the selected period.
• Total balance in the time bank: total balance considering the entire time bank cycle up to the filtered end date. The cycle begins with the start date of the time bank or the last total time bank settlement (whichever is more recent).
• Total positive/negative balance in the bank: details how much of this total balance is credit or debit in the bank's cycle.
• Detailed breakdown of the period: presents a detailed breakdown of time bank transactions, separating the converted values ​​by time entries, only within the selected period. Ideal for meticulous month-by-month analysis or for specific intervals.
• Bank details: presents a breakdown of banked hours transactions, separating the converted values ​​by time entries, within the current cycle.
• Employees without a time bank rule: Lists employees who do not have a time bank rule linked to them, helping to identify possible configuration issues.

• Status : Spreadsheet summarizing the processing status by employee, indicating whether the employee was included in the report generation.
• Errors : This spreadsheet lists inconsistencies or problems identified during processing that prevented certain collaborators from being included in the report. This allows for analysis and correction of the necessary records before a new attempt.

Observation

The "period" always corresponds to the report's issuance interval, while the "bank balance" shows the accumulated result since the bank's inception or the last withdrawal (considering the most recent date).

The R10 report is essential for monitoring employee time banks, providing a clear view of balances, compensations, and historical data. Use this report for quick checks, audits, and more informed decision-making in time management.

If you need support interpreting the data or setting up the report, contact us via WhatsApp . Our team is available to help!

Updated on: September 17, 2025