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.
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
The result? Weeks of rework for HR, medical education and rota teams, while doctors wait for clarity as start dates loom.
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.
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.
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.
Start with one live list that maps people > posts > dates.
Publish early so services and doctors have time to plan.
Make induction portable so returning doctors only do what is new or expiring.
Treat payroll as change‑controlled with clear ownership and sign‑off.
Track a few signals monthly to drive improvement.
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.
Map what you do today and where spreadsheets appear.
Pilot the next cohort using one live register and a simple change‑control.
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.
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