Free right to work tracker spreadsheet
An Excel and Google Sheets template that flags every right to work date at 60, 30 and 14 days. Free, no sign-up.
What is in the template
- Room for 200 workers, with check type drop-downs.
- Automatic follow-up due date and days left.
- Status that turns amber at 60, 30 and 14 days and red once a date has passed.
- Settings sheet to change the warning windows.
- Two example rows to show how it works. Delete them first.
The template records checks. It does not carry out the check. Keep a copy of each check result with the worker’s file.
How to use it
1. Download and open the file.
2. Delete the two example rows.
3. Fill in the yellow columns.
4. Open it regularly. It does not send reminders.
Where spreadsheets fall short
A spreadsheet is a fair place to start. Here is what it cannot do.
No reminders
It only helps if someone opens it. Nothing is sent to you.
No change history
An accidental edit or deleted row leaves no trace. You cannot see who changed what.
Wide access
Anyone with the file can see every worker’s details.
If you have more than a handful of workers, BeComply keeps the same record with a change log and flags for follow-up checks. It is free for up to 5 workers. See the full comparison.
Questions
Does the template work in Google Sheets?
Yes. Upload the .xlsx file to Google Drive and open it with Google Sheets. The formulas and status colours carry across. Check the drop-downs after you import.
Does the spreadsheet send reminders?
No. A spreadsheet cannot email you. It shows a status when you open it. If you want reminders and a change log, that is what BeComply is for.
Is it safe to keep passport details in a spreadsheet?
The template does not ask for passport numbers. Keep any file with personal data in a protected location, limit who can open it and do not share it by email.
Keep every right to work check on record.
Free forever for up to 5 workers. No credit card required.