UK
Start trial
Free template· UK, Excel, opens in Google Sheets

Free shift swap template (Excel)

A shift swap template records every swap between staff: who gives the shift up, who takes it, the date and times, who approved it and when. This one keeps a running log in date order, works out the hours of each swapped shift, overnight shifts included, and has a column to confirm the 11-hour rest still holds.

rosterelf-uk-shift-swap.xlsx
The shift swap log filled in for five swaps: who gave up and who took each shift, start and finish times, hours, status, approver and a rest check

File checked No signup

How to

Three checks before you approve a swap

A like-for-like swap on paper is not always one in practice. The declined swap in the example failed the first check.

Rest either side

Eleven hours between the end of one working day and the start of the next, for both people. Callum was closing at 23:00 the night before, so a 07:00 start would have left him 8 hours.

Skills for the role

Whether the person taking the shift has the training or certification it needs: a personal licence holder on a bar, food hygiene in a kitchen.

Hours for both people

What the swap does to each person’s week. It can create overtime, push someone towards the 48-hour average, or take an under-18 past 8 hours a day.

What’s in the file

  • A Swap Log: who gives up the shift, who takes it, and when
  • Hours per swap worked out from start and finish by formula
  • Drop-downs for status and the rest check, plus who approved it
  • 30 rows to log swaps, and an Instructions tab
Download Excel (.xlsx)
In RosterElf

Next week’s rota from this week’s, in one click

For when copying the sheet every week becomes the job.

A café worker beside RosterElf’s Select a roster to copy panel, with last week’s roster ready to copy

Save a week as a template and copy it forward

Any weekCopy last weekStaff app
  • Save any rota as a reusable template
  • Copy last week’s rota instantly
  • Clone individual shifts across days
  • Staff see their shifts on the iPhone and Android app
FAQ

Shift swap FAQ

  • Unless the contract says otherwise, a swap needs the employer’s agreement: the shift is rostered to a person, and two staff cannot reassign it between themselves. In practice most employers approve routinely, but the approval is what makes the swap the employer’s record rather than a private arrangement.

  • A swap the worker requested is not the employer changing their shift, so the coming right to reasonable notice and short-notice cancellation payments is aimed at employer-initiated changes rather than worker-requested swaps. The detail is subject to consultation. See our Employment Rights Act shift rights guide.

  • Because payroll works from the original rota unless somebody tells it otherwise. One swap is easy to remember; fourteen across a month is not. The log shows what changed, who agreed it and when, and it shows a pattern of one person routinely giving shifts away.

  • Yes. Upload the .xlsx to Google Drive and open it with Google Sheets: the layout and the formulas carry over. It works in LibreOffice Calc too.

  • No. A rota records what was planned. Minimum wage compliance turns on what was actually worked, and the burden of proof sits with the employer, so you need a record of hours as well. Our free timesheet templates cover that side.