NHS resident doctor rotations: run changeovers without spreadsheets

LAURA CHAMBERS • 06 Oct 2025

Every six months, TIS data lands late or changes mid-cycle, spreadsheets take over and teams scramble to reconcile posts. This playbook summarises the approach in our guide - showing how to allocate, reassign and onboard doctors in one auditable flow, then handoff cleanly into ESR.

Why rotations feel harder than they should

Two weeks before changeover, a large cohort list lands with late updates. A "master" spreadsheet is copied for education, rota and payroll. By the end of the week, there are four versions and no one is sure which is most current. Doctors receive conflicting information, managers plan cover twice and payroll fields are retyped under pressure. None of this is just inevitable. A streamlined approach and a single, up-to-date allocation record keep everyone on the same page and make for a smooth handover every time.

Root causes

  1. When cohort data arrives late or isn’t complete, teams are left piecing things together by hand.
  2. When vacancies are grouped at the cohort level, it’s hard to see the individual posts underneath - so spreadsheets quickly start to go off-track.
  3. Mid‑year changes multiply updates across teams and systems.
  4. When multiple organisations and shared services are involved, it’s easy for ownership to get lost in the shuffle during handovers.

The result? Weeks of rework for HR, medical education and rota teams, while doctors wait for clarity as start dates loom.

What good looks like (and why it works)

  • One place to coordinate rotations so allocations don’t live in email threads or parallel spreadsheets.

  • Fast, controlled changes when plans shift, with a single record everyone trusts.

  • Clean handoff into HR/payroll systems without retyping details at pace.

  • Clear visibility for leaders so risks surface early and audits are painless.

Two proven paths

Path A - streamline the model you use today
Keep the current placements approach but standardise how information flows. Work from one confirmed allocation list, align key milestones and make updates through a simple, controlled handover so downstream systems stay in step. The guide walks through the steps and templates.

Path B - move to an open placement model
Run placements through a transparent, campaign‑style process with digital onboarding to remove ad‑hoc spreadsheets. This model is already proven at scale in other parts of the NHS; the guide explains when it’s right and how to phase it in.

What this means for your teams

For medical staffing
Earlier certainty on who is going where and when, fewer duplicate requests, clearer handover points.

For rota teams
A single, confirmed allocation register reduces reversals and enables earlier publication.

For payroll
Fewer last‑minute changes and clearer approvals reduce errors and queries at rotation.

For leaders
Consistent language, consistent ownership and a simple audit pack improve assurance without extra meetings.

Doctor and a patient (1)

A simple operating framework you can lift

  1. Start with one live list that maps people > posts > dates.

  2. Publish early so services and doctors have time to plan.

  3. Make induction portable so returning doctors only do what is new or expiring.

  4. Treat payroll as change‑controlled with clear ownership and sign‑off.

  5. Track a few signals monthly to drive improvement.

Myths vs realities

Myth: Rotations are chaotic by nature
Reality: Most pain comes from coordination gaps, not training requirements.

Myth: Detailed rotas must be finalised months in advance
Reality: You need early certainty on who goes where and when; shift‑level detail can follow locally.

Implementation in weeks (not months)

  1. Map what you do today and where spreadsheets appear.

  2. Pilot the next cohort using one live register and a simple change‑control.

  3. Scale up once confidence is high and formalise your audit pack.

Our resource on managing resident doctor rotation guide walks you through each step in a friendly, straightforward way - clearly outlining who’s responsible and what tools to use along the way.

FAQs

Not to get started. The approach works with your current setup; the guide explains options if you later want deeper integrations.

Agree a simple ownership pattern and one live register. The guide includes a governance model to adapt.

Use a light change‑control with clear owners and notifications. The guide includes an example you can adapt.

Decide what you’ll recognise from previous placements and trigger only new or expiring tasks. The guide provides a checklist.

 

Want the step‑by‑step detail?

Our guide expands on each step with templates and examples for NHS teams to use in practice.

Download the guide: Manage resident doctor rotations without spreadsheets