Reports

The Reports section allows you to view and export sign in activity, spaces bookings, and evacuation reports. There are four reports available, History, Timesheet, Bookings, and Evacuations.

The Reports view on the Sign In App portal

History

The History report allows you to view and export visitor history reports based on defined dates. The exported data can be used to analyse visitor and staff sign ins for a determined period of time.

The History report view on the Sign In App portal

The first list you will see on the History report is a summary of today's visitors.

Filter options

Use the filters at the top to select the site, group, and timeframe. When selecting the timeframe you can click Today, Yesterday, This week, and This month to select a pre-configured timeframe or use the date picker to select a custom one.

New style date picker

Export

Click the Export button to export the data using the selected filters.

Important

To include custom or personal fields with your exported data you need to select a specific group for the export.

To select custom fields, tick the box next to each field you'd like to include before clicking the export button. For repeat visitor groups you can also include personal fields in the export.

Tip

Your data will be downloaded in CSV format. These will open in Microsoft Excel or Numbers on Mac as a spreadsheet. The export includes the date and time of the sign in, but this can sometimes be formatted incorrectly in Excel. Make sure the cell formatting is set to a format which supports date and time.

View sign in details

To view a summary of a visitor's details click the record.

Detail modal of a visitor's history

Protect records

You may have sign in records that shouldn’t be deleted in line with the group’s data retention settings. You can protect these records so they’re kept permanently unless they’re changed to unprotected. Select the record you need and then click the padlock button to protect this sign in record.

Safety check status

When viewing sign in history, a green icon will appear next to records that have passed your site safety check. Clicking into a record will show you the time/date the certificate was issued and which portal user created the certificate. You can read about setting up safety check here here.

Tip

On the Today screen you can also view visitor safety check status and protect records.


Timesheet

The Timesheet report provides a summary of one day's activity in a visual format. Unlike the History report which shows each sign in/out as a separate record, Timesheet groups these together for each person giving a daily total.

Detail modal of a timesheet report

This view shows a list of group members with their time on site appearing next to them as green bars on a grid.

Filter options

Run your own reports using the filter options located at the top of the Timesheet.

Filter name Description
Site Select which site to display
Group Select which group to display
Date Click the left and right arrows next to the date to toggle through the days, or click on the date to show a date picker
Search Search for an individual by name
Activity toggle

Clicking the button below allows you to toggle between showing all members on the timesheet and only those with activity. The setting here will persist when exporting the data.

Detail modal of a timesheet report
Editing / adding a sign in

To make sure your Timesheet report is accurate, you have the option to edit individual records (for example if a group member forgot to sign out). To view more details about a sign in record, hover over the green bar and the exact sign in and out times, duration of sign in, and details of any edit will be displayed. To edit a record, click on the green bar and a window will pop up allowing you to enter a sign in time, a sign out time and a reason.

Audit log

When you change a sign in record, your name, the current date and reason you provide is permanently saved against the sign in. An icon will appear on the green bar to show the record has been changed.

To manually add a missing sign in, click the plus button which appears when you hover your mouse over a row. You will be asked to provide the same information as when you edit a record.

Export

Export your timesheet data by clicking the Export button in the top right corner. The Timesheet will contain a row for each group member and a column for each day selected. This column will show the number of hours signed in. You will be asked to select a group, all sites or a single one, and if the export should include all members or only those with activity. Next, select if sign ins across more than one day should be grouped by day of sign in, or separate days. The report needs to have a start and end date no more than 31 days apart. Finally, select any personal fields you’d like to include in the report.

Tip

The number of hours worked is calculated as a decimal, so 5.5 hours = 5 hours 30 minutes, not 5 hours 5 minutes.


Bookings

The bookings report allows you to view and export Spaces bookings helping to give you an insight into the utilisation of office space. You will only see this option if you have Spaces enabled for at least one site. If you don’t currently use Spaces you can read the full setup guide here.

Overview of the Spaces booking report

Opening the spaces booking report you’ll see an overview of all bookings for the month. You can use the Site dropdown to select the site you’d like to view the spaces bookings for. If you want to view a specific time period, click the date picker and select the timeframe. You can view bookings in the past, present, and future.

View of the timepicker modal for filtering spaces bookings

Use the Zone dropdown to filter the results by one of your zones. This can help you understand the utilisation of a floor or area of your site.

Filtering the Spaces results by Zone

Use the Category dropdown to view all bookings for a specific category. This could be desks, meeting rooms, parking spaces, or any of the other spaces categories you have set up for your site.

Filtering the Spaces results by Category

Export

Once you’ve selected any site, zone, space, category, and timeframe filters you need, click the Export button to export the data. All data exported will be in CSV format.

Tip

Bookings exports will also include any of the notes recorded as part of the booking process.


Evacuations

The evacuations report section of the portal allows you to view all of your past evacuation reports in one place. You can see an overview of each report, when it was created, the duration, the result, and who started and completed the report. Click a report to view a more detailed report for that evacuation.

Filtering the Spaces results by Category

Important

Evacuations will only show in the Reports section of the portal if you have Shared Evacuation Reports enabled. To enable this go to Manage and scroll down to Sign In App+ and click Shared Evacuation Reports. Click here to read the full guide.

Once you’ve clicked into the evacuation report, you’ll see a visual representation of how many of the evacuees were accounted for. Below this there is a list of all evacuees and their status from the evacuation. A green tick shows they were accounted for, a red cross indicates they were not present, and grey question mark shows there was no action. You can filter the list by groups and evacuation points. Clicking the printer icon will give you the option to print or download the report.

Filtering the Spaces results by Category

© 2024 Sign In App Ltd