Articles about: Reports, Importers and Exporters

I06 - How to use the Time Bank Importer

The Time Bank Importer (I06) allows managers to quickly and easily update employee time bank balances using a spreadsheet in .xlsx .

This feature is ideal for companies that need to centrally record or adjust large volumes of data, without having to manually enter each employee's information.


In this article, you will learn how to download, correctly fill out, and import the template spreadsheet into the Gestão website .


Step-by-step guide to using the Time Bank Importer


  1. Access the I06 Importer


  • In the system menu, click on Management , then select Reports and Records.
  • Go to the Imports and select I06 - Time Bank Importer.



  1. Download the template spreadsheet.


  • In "import type", select the "Time Bank" .
  • Click on " download as xlsx" to download the standard spreadsheet that needs to be filled out.
  • This spreadsheet contains the necessary fields to correctly import the information.



  1. Fill out the template spreadsheet.


3.1. Enter the PASSWORD, NAME, CPF or PIS in plain text format (Columns A to D ), exactly as they appear in the employee's record.


⚠️ Warning: If you fill in the CPF (Brazilian Individual Taxpayer Registry), do not fill in the PIS (Brazilian Social Integration Program). If you fill in the PIS, leave the CPF field blank. Only one of the fields should be filled in.


3.2. Use the decimal format with a period (.) for the Positive Total and Negative (Columns E and F ).

  • Example: 0.5 represents 00:30
  • Example: 1.0 represents 01:00
  • Example: 1.5 represents 01:30


3.3 . Fill in the date the balance will be posted in the format DD/MM/YYYY (Columns G to I )


3.4. If there are overtime hours, extraordinary hours and/or special hours, add the values ​​together to achieve a Positive Total .

  • Example:
    • Overtime: 1.0
    • Extraordinary overtime: 1.0
    • Special overtime: 1.0
    • Total Positive: 3.0


💡 Tip: Use this website to convert hours and minutes to decimal format.


  1. Import the spreadsheet into the system.

  • After saving the changes to the spreadsheet, return to the importer screen and click the icon below to select the spreadsheet from your computer's folder.



  • Next, click "import" to upload the file.


  1. Check the imported information.


  • Please wait for the spreadsheet import process to finish.





  • Once the process is complete, a report will be generated with feedback on the import.
  • Make sure the banked hours balance has been entered on the employee's timesheet and is being included in the accumulated banked hours.


Notes:


  • The data entered in the spreadsheet must be exactly the same as the data registered in the system (such as CPF and name), otherwise the import may fail.
  • Always review the values ​​before importing, ensuring that the sum of the overtime fields matches the Positive Total .
  • The decimal format with a period (.) is required. Commas (,) will not be accepted.
  • Keep a copy of the imported spreadsheet for internal control or auditing purposes.


The Time Bank Importer (I06) offers greater speed and efficiency in time management, allowing adjustments to be made in batches simply and securely. By correctly filling out the template spreadsheet and following the steps above, you ensure that the information is imported without errors.


If you need help filling out the form or have questions during the import process, please contact our support team via WhatsApp .


Updated on: September 24, 2025

Was this article helpful?

Share your feedback.

Cancel

Thanks!