Upcoming Expiration Dates Report
How to read and use your Upcoming Expiration Date Report
- Sample Public: Our Values
- Getting Started
- Day To Day Management
- Managing Users
- Managing Multiple Schools
- The Dashboard
- The Template Editor
- Managing Staff Profiles
- Advanced Editor
- Insights and Reporting
- User Settings
- MIS Integration
- Troubleshooting and Support
- Safeguarding Guide
- What's New
- External Checks
- Sign In App Integration
- Incident Tracking
Table of Contents
The Upcoming Expiration Dates Report will show you live, up-to-date, colour-coded lists of your Expiration Dates.
The Report will show the Staff Member's name, Profile Type and which check is expired/expiring.
![](https://static.helpjuice.com/helpjuice_production/uploads/upload/image/17902/3821312/downloads20240209-84-wwrw4x.png)
You can filter this Report by Profile Type and Tag by using the filter bar along the top of the Report:
![](https://static.helpjuice.com/helpjuice_production/uploads/upload/image/17902/3821313/downloads20240209-96-zrvs1r.png)
On the left-hand side of the Report, you can choose from:
- Expired: A list of Profiles that have expired checks.
![](https://static.helpjuice.com/helpjuice_production/uploads/upload/image/17902/3821316/downloads20240209-83-liuwdr.png)
- Expiring this month: A list of Profiles that have checks expiring in the current month.
![](https://static.helpjuice.com/helpjuice_production/uploads/upload/image/17902/3821317/downloads20240209-59-h27qgp.png)
- Expiring next month: A list of Profiles that have checks expiring next month.
![](https://static.helpjuice.com/helpjuice_production/uploads/upload/image/17902/3821318/downloads20240209-84-oj4poi.png)
You can open a Profile Page directly from this Report by clicking on the Profile from the list.
When you export this Report to Excel, the expired and expiring checks will be displayed on separate tabs.
Further Customisation
We have recently updated this report so that you can also add your own customised date ranges. For example, if you would like a report that shows any training due, 6 months in advance.
Firstly, make a duplicate copy of the default report as below:
![](https://static.helpjuice.com/helpjuice_production/uploads/upload/image/17902/3821320/image-png-Aug-29-2023-11-53-25-8265-AM20240209-96-ujjved.png)
Scroll down and click 'View' to open your copy:
![](https://static.helpjuice.com/helpjuice_production/uploads/upload/image/17902/3821321/image-png-Aug-29-2023-11-54-29-8182-AM20240209-89-o2dsba.png)
You will be presented with a blank report:
![](https://static.helpjuice.com/helpjuice_production/uploads/upload/image/17902/3821322/image-png-Oct-27-2023-09-21-03-9545-AM20240209-85-j1788a.png)
Click the drop-down options to create a group of your choice. In the below example, I have selected to view any expiry dates expiring exactly or earlier than in 6 months' time:
Then select 'Add Group' to be presented with a list of profiles that match this criteria:
![](https://static.helpjuice.com/helpjuice_production/uploads/upload/image/17902/3821324/image-png-Oct-27-2023-09-13-25-6918-AM20240209-101-htojw0.png)
You can filter the report further by using the 'Select Fields' option at the top of the report. In this example, I have used my 'DSL Training Completed Date' field to filter what I'd like to see on the report:
![](https://static.helpjuice.com/helpjuice_production/uploads/upload/image/17902/3821325/image-png-Oct-27-2023-09-14-26-9694-AM20240209-59-nnqews.png)
You can add as many groups as needed, by clicking the 'Edit' button on the left-hand side of the report to add further groups. Once you have added your additional groups, click 'Finish Editing':
You can filter this report further if needed by using the filter bar at the top, where you can filter by profile type, tag, and rating:
You can also use the 'Edit' button in the top right-hand corner of the report to change the Name, Description, who the report is shared with, and whether you would like to include central team profiles if you are part of a federation/trust: