Setting Up Automatic Reporting - Attendance Tracking

In this article, we will go over how to set up automatic reporting for attendance tracking.

Attendance data is only available if your operatives use the start and end shift features in GuardTek.

NOTE: When an operative select starts and ends their shift in GuardTek, if no schedule was previously assigned to that user, GuardTek logs a shift equaling the times worked. This means your Scheduled Hours Worked VS Actual Hours Worked will show the same information.

How to Set up Automatic Reporting for Attendance Tracking

To set up automatic reporting for logbook Activities:

1. Log onto the Guardtek web portal as an Admin or Supervisor.

2. Hover over the Reporting Tool module and click Automatic Reporting

Image 0 .png

3. On this page, you will find any existing automatic reports you have created.

2023- (4).png

NOTE: these reports are user-specific, and you can only see the reports templates you have created.

The automatic reporting setup is a 3-stage process: first, you create your report template, then your email recipients, and last, you create your schedule.

They are independent, however. Once you create your template, you could click the run icon to run the report on screen, or once you created your email recipients, you could just click send.

2023- (3).png

Create a Report Template

1. Click Add New

Image 1.png

2. Choose Shift on the drop-down menu


3. Name your report (be specific, especially if you set up multiple reports)


4. Check the boxes for reporting format PDF and Excel

2023- (5).png

5. Click Enter

Image 2.png

6. Select the Time Period to be Covered from the drop-down menu

2023- (11).png

The following options are available:

  • Yesterday
  • Last Hours (a new field opens to add the number of hours)
  • Last 12 Hours
  • Last 7 Days
  • Last 30 Days
  • Last 90 Days
  • Last Days (a new field opens to add the number of hours)

7. Select your sites. You can select multiple posts as required

2023- (13).png

8. Select the type of analysis. You can make multiple selections as required

2023- (6).png

"Site Coverage Bar Chart" should be combined with "Sorted By." Only one sort option can be selected at a time.

2023- (7).png

"Site Coverage XY Chart" needs to be used in combination with "Show Trend Curve By"

2023- (8).png

Shift Coverage Report: provides an Excel summary and an Excel detailed report on Scheduled hours worked vs. Actual hours worked, used, for instance, to send to the HR department for payroll purposes.

Example of an Excel Summary (after converting from the original CSV file format)

2023- (9).png

Sample of an Excel Detailed Report (after converting from the original CSV file format)

2023- (10).png

NOTE: All GuardTek Excel files are in a CSV format. To convert to an Excel Workbook format, check this article, "How to Convert CVS Excel Files (.csv) to Excel Workbook format (.xlsm)." 

Site Coverage Bar Chart: this option gives a bar chart summary of Scheduled total hours VS Actual total hours.

2023- (12).png

Site Coverage Bar Chart – Sorted by Post: this option gives a bar chart summary per post. This option is only helpful if you select multiple posts on your site.

2023- (14).png

Site Coverage Bar Chart – Sorted by Officer: this option gives a bar chart summary per officer.

2023- (15).png

Site Coverage XY Chart: this option gives a trend curve analysis sorted by month, week, or day for upward/downward fluctuations analysis. Your choice should align with the time you are reporting on.

2023- (16).png

9. Click Enter at the bottom of the page to save your template

Image 3.png

Your template will now show on the main page.

Create an Email Recipient(s) 

1. Locate the desired template, and under the Email field, click on the Email icon

2023- (17).png

2. Select Add New

2023- (18).png

3. Under Recipient, select GuardTek User, Employee, or Other Contact.

2023- (19).png

4. Click the drop-down arrow and search for the name on the recipient address list. The system will save all previously added contact details, but if you don't see it on the list, choose "Other Contact," complete contact details, and click Add.

2023- (20).png

5. Type of notification is set automatically to email. Please make sure that the email address is correct and click Add.

2023- (21).png

6. Repeat steps 3 to 5 to add multiple recipients. Once done, you can click Close and double-check on the notifications screen that all is correct before selecting Close again.

2023- (22).png

Create a Report Schedule

1. Locate the desired template, and under Schedule field, click on Not Defined.

2023- (23).png

2. Set your start and end dates by clicking on the calendar icon and selecting a date from there

2023- (24).png

3. Select the frequency. Depending on your selection, different menus open for further selection

2023- (25).png

4. Input time of day report will be generated, and click Add. You can select multiple times

2023- (26).png

5. Save your schedule by selecting Enter at the bottom of the page

To make changes to your schedule, just click on it and repeat the steps above.

2023- (27).png

Was this article helpful?
0 out of 0 found this helpful

Articles in this section