How to export data from Pontotel
Pontotel offers various export files that allow you to extract employee time and attendance information and integrate it into your payroll system.
These files ensure that data on work hours, overtime, absences, and other time records are transmitted accurately and in a standardized manner, facilitating HR routines and reducing rework.
See below how to perform the export and which file type is best suited to your needs.
Step-by-step guide to accessing exporters
- Access the side menu and click on Management > Reports and records .
- At the top of the screen, go to the Exports .
- Choose the export template you want to generate.
- Configure the exporter filters according to your needs. Once configured, click the corresponding button to generate it.
Types of exporters available
Pontotel offers several export models, each designed for a specific purpose.
Next, understand what each of them represents and when to use them:
E01 – Time and attendance record for all employees
Generates a complete report with all time clock entries made by employees during the selected period. It is ideal for general audits or integration with payroll systems that require a detailed time clock report.
E02 – File for importing notes
It gathers detailed information about time entries made by employees, such as overtime, absences, lateness, night shift differentials, and other events that directly affect payroll calculation.
This file can be generated in TXT or CSV , depending on the needs of the target system. However, it needs to be configured beforehand by the Pontotel support team , as each payroll system has a specific layout and reading rules.
E03 – File for importing time bank data
Exports employee time bank information, including credits, debits, and final balance. This file can be used in payroll systems for automatic calculation of compensations.
E04 – Audio and video of employee timesheets
It generates a package containing the media (audio and images) recorded by employees during clocking in and out. This is useful for internal audits and compliance verification.
E05 – AFD file with employee points
It generates the file in AFD (Data Source File) , a standard defined by Ordinance 671 or Ordinance 1510, which contains all the time entries recorded by REP-P.
If you want to generate the AFD in the standard established by Ordinance 1510, choose the option "export AFD (1510)". If you want the file in the layout defined by Ordinance 671, choose the option "extract AFD (671)".
E06 – AFDT file with employee points
AFDT (Processed Data Source File) format , which includes the markings after the information has been processed, such as justifications, exemptions, and corrections applied.
E07 – ACJEF file with employee points
It generates the ACJEF file (Work Schedule Control File for Tax Purposes) , used in labor inspections and audits, containing the consolidated history of time entries.
E08 – File for importing history
Exporting data is designed to integrate employee time and attendance history with the company's payroll system or other corporate systems. It allows the transfer of past data, such as work schedules, incidents, adjustments, and time records in .TXT or .CSV , facilitating the consolidation of historical information in the new environment.
This file is especially useful in system migration or when it is necessary to maintain a complete history of payroll calculations and entries within the payroll system, ensuring continuity in calculations and reports.
Like other export files, the E08 file needs to be pre-configured by the Pontotel team , as each payroll system may require a specific layout and data structure.
E09 – File with detailed notes
It generates a detailed report with all the time entries, events, and justifications for each employee, making it ideal for in-depth analysis or verifying calculations before payroll closing.
E10 – Electronic Journal Record (AEJ)
Standardized file containing essential work schedule information, meeting the legal requirements of Ordinance/MTP No. 671 and ensuring complete traceability of time entries.
E11 – File for importing benefit records
Exports data related to time entries that impact benefits, such as meal vouchers or transportation vouchers. This must also be pre-configured according to the payroll system layout.
E12 – File for importing VR and VL benefit records (analytical and consolidated)
Generates XLS files specifically for the control and integration of Meal Vouchers (VR) and Food Vouchers (VL) analytical (per employee) and consolidated formats . It must also be pre-configured by the Pontotel team to meet the payroll system standard.
Exporting data from Pontotel is an essential step in maintaining alignment between time and attendance control and payroll processing, ensuring accuracy, security, and practicality in HR routines.
For further guidance, please consult the articles on our support website, or contact us via the chat integrated into the Pontotel Gestão website, or through our WhatsApp .
Updated on: November 3, 2025
Thanks!