Using AI for HR: Probation, Renewal and Right-to-Work Deadline Checklist

An HR consultant can track probation reviews, contract renewals and right-to-work expiry dates for several client firms in one sheet, with one row per person, formulas that calculate the due dates and a reminder ladder. AI drafts the reminder messages and blank review forms; a named person makes every decision about confirming, extending or ending.

Missing a date is the expensive failure here. Under many contracts an unreviewed probation simply rolls into confirmed employment, a fixed-term contract can lapse into awkward territory, and a missed right-to-work follow-up check can cost the employer its defence against a civil penalty. Those are practical reasons for a tracker, and none of them needs AI to decide anything. The AI job is dull and useful: turning dates into clear reminders, in the right voice, to the right person, on time.

Follow me on Instagram@sagnikteaches

A note on regimes. Which rules apply depends on where each client's staff work, so the tracker carries a column for the check regime. I describe the two that come up most: the UK Home Office scheme, with its online share-code checks, and US Form I-9 reverification. Neither replaces advice from a qualified adviser for your clients' situations.

Connect on LinkedInSagnik Bhattacharya

What the tracker holds, and what it must not

The tracker is a working list of dates and statuses, not a personnel file. Keep it small.

Subscribe on YouTube@sagnikteaches

What it must not hold: passport or permit numbers, copies of identity documents, immigration status details beyond the date and check type, performance assessments, or reasons for any decision. Those belong in the client's own secure personnel files. The less your tracker contains, the less it matters if it goes astray, and the safer it is to let a tool see a row.

The formulas that do the work

These work in Excel or Google Sheets. Assume start date in column D, probation months in E, contract end in H and right-to-work expiry in K.

Probation end (F):        =IF(ISNUMBER(E2),EDATE(D2,E2)-1,"")
Review due (G):           =IF(F2="","",F2-14)
Days to review (I):       =IF(G2="","",G2-TODAY())
Days to contract end (J): =IF(ISNUMBER(H2),H2-TODAY(),"")
Days to RTW expiry (L):   =IF(ISNUMBER(K2),K2-TODAY(),"")
Status flag (M):          =IF(AND(I2<>"",I2<0),"Escalate",IF(AND(L2<>"",L2<=30),"RTW 30",IF(AND(L2<>"",L2<=60),"RTW 60",IF(AND(L2<>"",L2<=90),"RTW 90",IF(AND(I2<>"",I2<=7),"Review 7",IF(AND(I2<>"",I2<=21),"Review 21",IF(AND(J2<>"",J2<=120),"Renewal 120","OK")))))))

Two cautions. First, EDATE adds calendar months, and whether "three months" ends the day before or on the same day depends on the contract wording, so I subtract one day by default and you change it to match the client's contract. Second, a formula is only as good as the start date; add a data-validation rule so only real dates can be entered. Third, when a probation is signed off, replace the months in column E with "Done": the ISNUMBER test then blanks the review columns and the row stops flagging. Typing "Permanent" in H or "None" in K works the same way. For help turning plain-English requests into formulas safely, see the ChatGPT and Excel guide, which shows how to ask for a formula and test it on sample rows.

The checklist, by deadline type

Probation reviews

1. Read the contract for the probation length, any extension clause and notice during probation. Record the length in the sheet.
2. Calculate the end date and a review date 14 days earlier.
3. Remind the manager at 21 days and 7 days before the review date, with the blank review form attached.
4. The manager holds the meeting and records the outcome: confirm, extend (if the contract allows) or take further advice.
5. An HR adviser or the client's decision-maker signs off. Update the sheet and file the confirmation letter.
6. If no outcome is recorded by the end date, escalate the same day.

Contract renewals

1. Flag fixed-term contracts at 120 days before the end date, giving time for a decision on renewal, conversion or end.
2. Ask the manager for their intention in writing at 90 days.
3. Check any rule on repeated fixed-term contracts or notice with the adviser; these rules vary and I do not state them here.
4. Prepare the letter or amendment for sign-off at 45 days; record the new end date or the decision to end.

Right-to-work follow-up

The mechanics differ by regime, but the tracker job is the same: record when permission expires, remind early, and record that the follow-up happened.

• Share-code system. The Home Office employer's guide (1 October 2026 edition) says that for staff with time-limited permission the employer re-checks on or before the date the permission ends, and the follow-up need not be the same type of check as the first. Checks can be online with a share code (the only route for eVisa holders), a manual check of original documents, or a digital check through a registered provider. Copies of documents are kept securely for the length of employment plus two years, and staff whose first check showed settled status need no follow-up. The same edition extends the scheme to some workers' contracts, individual sub-contractors and online matching arrangements that started on or after 1 October 2026, so ask clients who use contractors whether those people belong in the tracker too.
• Form I-9. USCIS says an employer must reverify by the earlier of two dates: the employment authorisation expiry the employee gave in Section 1, or the expiry of the List A or List C document recorded in Section 2. Reverification is recorded on Supplement B, and USCIS suggests giving employees at least 90 days' warning. Citizens, noncitizen nationals and permanent residents who showed a Permanent Resident Card are not reverified, and List B documents never are. Forms are kept for three years after hire or one year after employment ends, whichever is later.

Whichever regime applies, the tracker triggers the check; the check itself is done by the person the client has trained, following the client's process. Do not let an AI tool inspect identity documents or decide whether a document is valid.

The reminder ladder

These lead times are my defaults, not legal requirements. Adjust for each client's pace; a firm with a monthly board needs longer lead times than one where the manager sits beside the owner.

Where AI fits: drafting the nudge, never the decision

The note on this row is firm: no automated decisions. AI drafts text. It never confirms a probation, never ends a contract and never judges an immigration document.

A prompt that sets reminder wording for a client in one tone and keeps data minimal:

Draft a short email from [HR consultant firm] to a manager at an IT support firm. Facts: person ID ITS-02; probation review due on 22 November; the manager should hold the review meeting before then and return the attached review form. Tone: friendly, plain, no legal language, under 120 words. Do not state any outcome and do not suggest what the decision should be. End with one sentence offering a call if they want to talk through the review.

A realistic output reads well but may add a line such as "you will probably want to confirm the role". That nudges the decision, so delete it. Check also that the date appears exactly as supplied and that the email does not include the employee's name if you used an ID.

Mail-merge, not a free-for-all

Once a template works, stop prompting each time. Save the approved wording as a template with placeholders and merge it from the sheet. The advantage is consistency and fewer chances for a tool to introduce an error. Use AI to maintain the wording, not to rewrite every reminder.

Review forms

Ask the tool for a blank probation review form: objectives, evidence, support given, outcome options (confirm, extend, take advice) and a signature block. Compare it with the client's own policy and have the client's adviser approve it once. Then it is a reusable asset.

Main worked example: four clients, twelve people

Say your HR practice looks after four small firms: an IT support firm, a bookkeeping practice, a physiotherapy clinic and a dental practice. Today is 4 November 2026. The tracker holds three people per firm. Here are four illustrative rows after the formulas run.

The sort-by-flag view gives your morning list. ITS-02 gets the 21-day reminder to the IT firm's manager. BKP-05's fixed-term contract ends in 116 days, inside the 120-day mark, so the renewal question goes out now. PHY-03's permission expires on 2 February 2027, exactly 90 days away, so the first right-to-work reminder goes today. DEN-01's review was due on 31 August, 14 days before a probation end (14 September) that has already passed, so it escalates to the dental practice owner today. The previous quarter, that last row would have been invisible until someone noticed.

Total effort to run this weekly with twelve rows: about 20 minutes to sort, check and send, versus an unknown risk of missing a row. Those minutes are illustrative; with 60 people across ten clients, the sheet and merge still take under an hour, which is why the tracker scales better than memory. For wider uses of AI in an HR practice, see how HR consultants use AI for policies, letters and cases.

More examples of the workflow

A before and after of a reminder

Before, typed in a hurry: "Reminder re probation, please do the review." After, from the template: "Hi [first name], the probation review for ITS-02 is due by 22 November. Please book 30 minutes with them before then, fill in the attached form and send it back by 20 November. If you would like to talk it through first, reply and we will find a time. [your name]". The second gives a date, an action, a return date and an offer of help.

A realistic mistake

A consultant filled start dates from an old spreadsheet where dates were typed as text, so the formulas returned blanks for four rows and nobody noticed. The status column said "OK" for them. Prevent it: add a check cell counting rows where the start date is not numeric, and make "OK" appear only when dates exist.

A quick sum for client reporting

Each month send each client a one-line summary: 12 people tracked, 2 reviews due in 30 days, 1 renewal decision open, 1 right-to-work follow-up at 90 days. AI can draft that from the counts; you supply the counts from the sheet, using COUNTIFS formulas, not by asking a chatbot to count rows.

A handover when staff leave the client

When a person leaves, mark the row closed, record the leaving date and set a retention-review date for any right-to-work records: copies from share-code or document checks are kept for two years after employment ends, and a Form I-9 for one year after leaving or three years after hire, whichever is later. Confirm with the client's adviser before anything is destroyed. The sheet then shows who is still active, and the old rows stop triggering reminders.

A right-to-work follow-up, traced from reminder to record

Take the illustrative row PHY-03 above: permission expires on 2 February 2027. Here is the timeline the tracker should produce, with who does what.

Notice the target date for completing the check is two weeks before expiry, not on it. A buffer absorbs sickness, holidays and a share code that does not work the first time. The last row is the important one: the plan for non-completion is agreed in advance, with the adviser, so nobody improvises the day before.

A probation that needs extending: the paper trail

Say the review of ITS-02 shows concerns and the manager wants more time. Whether the contract allows an extension, and how it must be notified, is for the adviser to confirm. Your tracker job is the paper trail:

1. Record the manager's recommendation and the date it arrived.
2. Hold the extension letter until the adviser has approved the wording and the contract basis.
3. Update the probation end date in the sheet only once the letter is sent, and record the new review date.
4. Set a fresh ladder for the new review.

If you ask an AI tool to draft the extension letter, give it only the approved facts: the new end date, the contract clause reference supplied by the adviser and the support offered. Do not ask it to say whether an extension is lawful or fair. You then check the letter against the adviser's wording.

When a client ignores the reminders

It happens. A busy owner does not answer three emails. Agree an escalation path in your engagement letter, so chasing is part of the service rather than a nuisance. An illustrative final-notice template:

Subject: Action needed today - [client name], ID [code], [deadline type]

Hi [first name], we have sent three reminders about the [deadline type] for ID [code], due on [date]. We have not had a reply. Please confirm by [time, date] that the step has been done or tell us what is blocking it. If we do not hear from you, we will call [number on file]. [your name]

The key is the specific next action and the fixed time. AI can draft variants for different tones; send the same wording to each client so you can show that you treated them consistently.

Data protection for the tracker

You hold personal data for each client. Agree in writing what you hold, where, for how long and who can see it. Use IDs rather than names in anything that reaches a tool. Check the tool's data terms and training settings; what to check in an AI tool's privacy policy lists the questions. Share the sheet by access-controlled link, not email attachment, and review access each quarter.

Immigration status is a sensitive subject, and checks must apply consistently to avoid discrimination, so the process must be the same for every new hire whatever their background. A tracker that only lists some staff for checks can itself create risk; follow each client's adviser on how checks are applied.

Setting this up for a new client in a morning

Onboarding a client onto the tracker is itself a checklist, and a short one keeps the first month clean.

1. Ask for a staff list with start dates, contract types and probation lengths, using IDs in place of names where the client is comfortable with that.
2. Ask which people have time-limited permission to work and the expiry dates, and which regime applies to each.
3. Check three contracts yourself against the list, to catch a probation length that differs from what the manager remembers.
4. Agree the manager contact for each team and the escalation owner.
5. Send a test reminder to each manager so you know the email arrives and the form attachment opens.

The third item is the one people skip, and it is where most surprises appear: a probation of six months in the contract but three in the manager's head. Ten minutes spent there saves a difficult conversation later.

Testing that the tracker works

1. Add a dummy row with dates set to trigger each flag and confirm each reminder fires.
2. Run the sheet against the client's own records once a month and note differences.
3. Have the client's manager confirm the dates in the sheet match their calendar.
4. After a quarter, count missed or late items. The target is none; each miss reveals a gap in the process.

If you want help building the tracker around your own client mix, my AI implementation consultation covers mapping the dates and choosing the drafting steps; the sheet and ladder above are enough to start without it.

Questions HR consultants ask about deadline tracking

Should the tracker hold document numbers?

No. Record the check type, the date checked, who checked and the expiry or follow-up date. Keep copies of documents in the client's own secure file store, as that regime requires, and keep the tracker light so a leaked sheet reveals little.

Can AI decide whether a probation is passed?

No. It can draft a reminder or a blank review form, but confirming, extending or ending a probation is a decision for the manager and the HR adviser, based on evidence and the contract. Keep a human sign-off on every outcome.

How far ahead should reminders go?

Use a ladder. For right-to-work expiry, 90, 60 and 30 days before is a sensible default, and USCIS suggests reminding employees at least 90 days before reverification is due. For probation, remind the manager 21 days and 7 days before the review meeting.

What if a client keeps its own records?

Then the tracker mirrors them and the client's records stay the source of truth. Agree who updates what, and add a monthly check that your sheet matches theirs, because a tracker that drifts from the real dates is worse than none.

Further reads

• Does a Five-Person Business Really Need an AI Policy? — Whether a small client needs an AI policy of its own.
• AI for HR in Small Businesses: 12 Tasks You Can Hand Over Safely — Twelve HR jobs a small business can hand over safely.
• How to Answer Staff HR Questions With an AI Helpdesk — Answering routine staff questions without a queue.
• How to Chase Missing Client Records With AI Before Deadlines — Chasing clients for documents before a deadline.
• How to Onboard New Hires Onto Your AI Tools and Rules — Onboarding new hires onto your tools and rules.
• How to Write an AI Usage Policy for Your Small Business — A policy for how your team uses AI with people data.
• Apprentice Off-the-Job Training Log: What to Record and How AI Helps — An employer-side training log: the fields, a filled-in week, sign-offs, a month-end check against the provider's records, and where AI helps.
• ChatGPT and Copilot for HR: Which Suits a Small People Team? — A four-question rule, seat costs for a three-person people team, and the employee-data handling that matters more than which assistant you choose.
• AI Tools for HR Professionals: Policies, Onboarding and Staff Questions — How a small-business HR lead can use AI for policy drafts, onboarding checklists and a staff question assistant, with data-protection and legal review built in.
• Automated Onboarding for Doctors: A Practice Manager's AI Checklist — A practice manager's gate-by-gate onboarding checklist for a new doctor, with AI-built trackers, chasers and a 90-day review.
• AI Tools and AI Development: The Complete 2026 Guide — the AI hub, including every tutorial in the AI-for-business series.

Sources: the Home Office employer's guide to right to work checks (1 October 2026 edition) for follow-up checks, retention of copies and the scheme's extended scope; the USCIS pages on completing Supplement B and the Form I-9 questions and answers on retention; all checked 4 November 2026. Verify current rules with each client's adviser.