ABCDEFGHIJKLMNOPQRSTUVWXYZAA
1
2
* Please make a copy of this document to edit.
3
Instructions: Select 'File' > then 'Make a copy'
4
>Insert Organisation Name<Date: 12/12/2022
5
6
Instructions to use this spreadsheet
7
- This spreadsheet has been created with formulas baked in.
8
- To make changes to the employee name and roles, click on the boxes that say <Employee Name> or <Role> and enter details required.
9
- To amend the scheduled hours, click the drop-down to the right of the Start and End cells.
10
- Add pay information and contracted hours to work out overtime.
11
- Column U calculates the total number of hours worked in the given week while Column V highlights outstanding contractual hours i.e James is missing 18 hours of work.
12
- Total contractual pay is calculated in Column X to work out the base rate per employee for the week, while Column W identifies the base rate for the week including overtime pay.
13
- Negative balances in column X highlights missing contracted hours (see James as an example below). When the value is positive it identifies the total overtime pay, for that week.
14
Discover a much faster way to manage your workforce rotas with Sona's Smart Scheduling, click here:https://www.getsona.com/features/scheduling
15
16
Name RolePrimary LocationContracted Hours Hourly Rate Overtime Hourly Rate Mon 19 Dec 2022Tue 20 Dec 2022Wed 21 Dec 2022Thu 22 Dec 2022Fri 23 Dec 2022Sat 24 Dec 2022Sun 25 Dec 2022Total HoursOustanding Contractual HoursTotal Pay (inc. any overtime) Pay (Actual - Contracted)Overtime pay
17
Start End Start End Start End Start End Start End Start End Start End
18
Sarah Manager Glade Street40£20.00£25.008:00 AM4:00 PM8:00 AM4:00 PM8:00 AM4:00 PM8:00 AM4:00 PM8:00 AM3:00 PM39:001:00£780.00£800.00£0.00
19
Manager Manager Manager Manager Manager
20
Mark Nurse Glade Street36£16.74£19.376:00 AM4:00 PM7:00 PM7:00 AM7:00 PM7:00 AM7:00 PM7:00 AM46:000:00£770.04£602.64£193.70
21
Nurse Nurse Nurse Nurse
22
Lisa Senior CarerGlade Street35£12.63£14.257:00 AM7:00 PM7:00 AM7:00 PM7:00 AM7:00 PM7:00 AM7:00 PM48:000:00£606.24£442.05£185.25
23
Senior CarerSenior CarerSenior CarerSenior Carer
24
James Care AssistantGlade Street38£11.52£12.602:00 PM12:00 AM2:00 PM12:00 AM20:0018:00£230.40£437.76£0.00
25
Care AssistantCare Assistant
26
StephenHousekeeperGlade Street37£10.42£11.7310:00 PM5:00 AM1:00 PM9:00 PM10:00 PM5:00 AM10:00 PM3:00 AM8:00 PM3:00 AM34:003:00£354.28£385.54£0.00
27
HousekeeperHousekeeper HousekeeperHousekeeperHousekeeper
28
<Employee Name><Role>0:000:00£0.00£0.00£0.00
29
30
<Employee Name><Role>0:000:00£0.00£0.00£0.00
31
32
<Employee Name><Role>0:000:00£0.00£0.00£0.00
33
34
<Employee Name><Role>0:000:00£0.00£0.00£0.00
35
36
<Employee Name><Role>0:000:00£0.00£0.00£0.00
37
38
<Employee Name><Role>0:000:00£0.00£0.00£0.00
39
40
<Employee Name><Role>0:000:00£0.00£0.00£0.00
41
42
<Employee Name><Role>0:000:00£0.00£0.00£0.00
43
44
<Employee Name><Role>0:000:00£0.00£0.00£0.00
45
46
Required vs Actual Staff for each day:RequiredActualRequiredActualRequiredActualRequiredActualRequiredActualRequiredActualRequiredActual187:000:00£2,740.96£2,667.99£378.95
47
<Input>4<Input>3<Input>3<Input>2<Input>3<Input>2<Input>3
48
Totals Hours:186.00
49
Total hoursOustanding Contractual HoursTotal pay (inc. overtime)Pay (Actual - Contracted)Overtime pay
50