Batch Add Attendance Records

Batch Add Attendance Records

Batch Add Attendance

Manual Batch Adding of Attendance is recommended to be done for entering multiple attendance records in one go. This also overrides existing attendance records when an entry is unlocked. Batch adding attendance does not affect entries that are locked during uploading.

To add Attendance by batch:
1. From the Top Navigation go to Time and Attendance > click Attendance Computation tab.


2. Click on Batch Add Attendance button.


3. Under Step 1, click on Download Template.
    • The .csv file will be downloaded to your computer.
      
                  
4. Accomplish the template accordingly. Time should be in Military Time for Time Records batch upload.
    • Batch Upload for Time Records (Clock In/Out) Sample:


    • Batch Upload for Computed Attendance (Total Hours Worked) Sample:
        • Clock In and Clock Out and Hours worked should not be uploaded together in a single row if they are on the same date.
        • Add headers depending on the need. Refer to individual editing in the View button.
        • Do not delete Clock in/out columns when uploading the csv file.
        • Use UT for Undertime record and Tardiness for Tardy.

5. Once done, upload the file under the Step 2 section > click Choose File > Upload.


    • The system validates the uploaded file.
    • Uploaded batch of attendance appears on the Time Attendance > Attendance Computation >  Employee List once validated.

    • Related Articles

    • Edit Attendance Records

      Edit/Add Employee's Clock In and Clock Out Time records are the recorded clock in and clock out times of an employee. Multiple clock ins and clock outs are displayed on this section. Considering multiple records, the first clock and last clock out ...

    • Lock and Unlock Attendance Records

      Locking attendance is useful if you are in the phase of processing or finalizing attendance for payroll computation. Locked attendance does not allow any attendance alteration coming from the employees’ side. Taking this extra step prevents last ...

    • View Attendance

      To view attendance: 1. From the Top Navigation go to Time and Attendance > Attendance Computation. In the Employee List the following attendance details are displayed: Employee ID Employee Name Date Expected Shift First Clock In Last Clock Out Hours ...

    • Regenerate Attendance

      Attendance Computation The Attendance Computation page provides all the details needed for payroll computation. It can also be used as a stand alone report since it is an exportable csv file. In this page, administrators can view details on how an ...

    • Create/Add a Fixed Schedule

      Creating/Adding Fixed Schedule To create/add a fixed schedule:                       1.      From the Top Navigation go to Time and Attendance and you will land on the Shifts tab. 2.      Switch to the Schedules tab. 3.      Click on Add Schedule. ...