People Apps

Edward Dixon

Sarah Mills

Sheldon Walker

Find out how to extract your data from People in various forma

Reports/Queries/Data

(Admin Only) An in-depth view of filters and options for creating queries

Queries - Filters and Options

Queries - How to Create a Query

(Admin Only) Video and description detailing how to create charts within the query builder

Queries - Creating Charts

(Admin Only) Build a query that tells you when each employee has logged in to the system

Queries - Login Audit Report

(Admin Only) Build a report on how many days/hours entitlement pro rata.

Queries - Holiday Entitlement Accrued To Date

(Admin Only) Build a report on employee holidays

Queries - Holidays

Queries - TOIL

(Admin Only) Build a report on your employee's clock in and out information

Queries - Timesheets

Build a report on employee's yearly, remaining entitlement and carryover

Queries - Annual Leave Entitlement

(Admin Only) Build a report on Project Assignments

Queries - Assignments

(Admin Only) Build a report on Maternity/Paternity leave

Queries - Maternity/Paternity

Creating an expense report, exporting and printing.

Queries - Build an Expense Report

(Admin Only) Report on logbook information and/or logbook approval data.

Queries - Logbook

Report on employee's length of service and LOS rules

Queries - Length of Service

(Admin Only) Build a report on thanks badges

Queries - Thanks

Queries - Deleted Holiday

(Admin Only) Load Query Data Into Excel via Power Bi

People® Queries and Excel Power Bi

Queries - Goals

(Admin Only) Build a report on who has been late over a specific time period

Queries - Late Report

Queries - Deleted documents

(Admin Only) Build a report on other events

Queries - Other Events

Discover the true level (and cost) of your company's staff turnover rate.

Reports - Staff Turnover

(Admin Only) Build a report on documents added, signed etc.

Queries - Documents

Build a report on who had edit access rights

Queries - Edit Access Rights

(Admin Only) Build a report on training records

Queries - Training

(Admin Only) Build a report on performance reviews

Queries - Performance

Queries - Sickness

Queries - Leavers

(Admin Only) Build a query on Applicant/Vacancy information

Queries - ATS Reports

(Admin Only) Build a query on all salary changes

Queries - Historical Salary Report

(Admin Only) Build a query on changes made to an employee's record

Queries - Historical Changes Report

Using the 'Greater than' and 'Less than' options to report on information within a chosen point in time.

Queries - Filter by a Specific Time Frame

Report on the employees in the company at a specific time

Queries - Point in Time Head Count Report

(Admin Only)  Guidance on query building files imported to Microsoft Excel

Opening Query Builder Files in Excel

The Query Builder

(Admin Only) Create your own bright report with images and data chosen specifically by you.

Report Designer - How to Create a Custom Report

Details how to print a report opened in your safari or chrome browser

Printing Reports from Safari or Google Chrome

Reports

Check out what the overall picture of your company looks like right now

Reports - Top Facts About Our Company

(Admin Only) Adding charts and graphs to your customised report.

Report Designer -  Charts/Graphs

Reports and Designer

Here’s how to sync up to 7 queries with Microsoft Excel (Windows only)

Excel Hotsheets

Sync up to 10 queries on GoogleSheets and share externally

Google Hotsheets

Create a Consolidated Timesheet Report in Excel

Use V Lookup in Excel to see who has not yet started their Performance Review

Report on who hasn't opened their Performance Review.

How to print reports based on an employees holiday or absence

Printing Individual Holiday and Absence Reports

Hotsheets and other

Login

4 Min Demo

Free Trial

News

Find answers and get help from Intercom Support and Community Experts