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 import banked hours data using a spreadsheet.


How to use the Time Bank Importer


  1. In the main menu, click on Management, then select Reports and Records.



  1. Go to the Imports and select I06 - Time Bank Importer.


  1. In "import type", select the "Time Bank".


  1. Click on "download as xlsx" to download the standard spreadsheet that needs to be filled out.



  1. Fill out the template spreadsheet.



5.1. **Enter the fields **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.


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

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


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


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


5.5. If the balance to be added should be considered for calculating bank limits (Column M), fill in with "S" or leave blank. If it should not be considered, fill in with "N".


5.6. If this is a partial reduction of the employee's time bank balance (Column N), fill in with "S".


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


  1. After filling it out, save the spreadsheet. Go back to the importer screen and click the icon below to select the file on your computer.



  1. Click "import" to upload the file.



  1. Please wait for the spreadsheet import process to finish.



  1. Once the process is complete, a report will be generated with feedback on the import.


  1. 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 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: March 19, 2026

Was this article helpful?

Share your feedback.

Cancel

Thanks!