Parent Contact Log & Communication Tracker

A comprehensive automated Excel system designed to help teachers, tutors, pastoral staff and school leaders record parent/carer communication, manage follow-ups and maintain a clear communication history for every pupil.

The tracker is designed for everyday use. Staff can record a contact quickly using simple dropdown menus, while the workbook automatically updates dashboards, pupil profiles, follow-up alerts and communication analysis.

Key features include:

Quick Contact Log for fast day-to-day recording
Capacity for up to 200 pupils
Up to 500 communication records
Automatic follow-up status and overdue alerts
Today Dashboard showing actions requiring attention
Whole-school Communication Dashboard
Positive parent/carer contact monitoring
Contact success-rate analysis
Repeated unsuccessful-contact alerts
Repeated concern identification
Individual pupil communication profiles
Complete chronological communication history
Printable parent/carer communication summaries
Follow-Up Queue
Contact reason, method and outcome analysis
SEND, Pupil Premium and EAL cohort analysis
Year-group analysis
Weekly communication review dashboard
Editable contact reasons, methods, outcomes and staff roles
Editable alert thresholds
Fictional sample data included to demonstrate how the system works
No macros or external add-ins required

Suitable for classroom teachers, form tutors, Heads of Year, pastoral teams, SENDCos, attendance teams, Heads of Department and school leaders.

The resource can be adapted for use across different subjects, year groups and school settings.

Safeguarding and data protection

This tracker is designed for routine parent/carer communication and is not a safeguarding recording system. Safeguarding concerns and disclosures should always be recorded using your organisation’s approved safeguarding procedures.

Users are responsible for storing identifiable pupil and parent/carer information in accordance with their organisation’s data-protection policies.

© SharpeEducation 2026. All rights reserved.

For purchaser use only. Redistribution, resale, public sharing or uploading the editable resource to other platforms is not permitted.