ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
2
MACS Timesheet upload file
3
4
DO NOT INSERT OR DELETE ANY ROWS.
5
6
Welcome to the Excel worksheet that records additional hours for your staff
7
(excluding Long Service Leave and Parental Leave). Refer to the examples tab for more explanations
8
9
STEP 1
10
Download this file from the email and save it to a reliable location on your network. When saving it, please save using the "xlsx" format to ensure the automated features continue to work correctly.
11
While it does not contain sensitive information (eg salary amounts, date of birth etc), we recommend you store it where other staff cannot accidentally delete or incorrectly modify it.
12
13
STEP 2
14
Run the "MAS - Employee Masterfile" report from the eHR system and copy the relevant data from that report into the respective columns in the tab "Staff List" in this file. This will then provide automation of your INPUT tab.
15
The "EmployeeId" refers to the individual staff members' employee number and the "PositionCode" refers to the position the staff member has been assigned to. These details are all available in eHR.
16
17
STEP 3
18
On the INPUT tab, enter:
- your school E Number (Capital E)
- current pay period end date from the dropdown list
Additional hours must be from the previous pay period or earlier
19
STEP 4
20
On the INPUT tab:
- Select staff member from the drop down list
- Enter date of additional hours
- Select pay component description from the drop down list
- Depending on the pay component, enter additional information in that row.
Repeat for all staff members who had additional hours
21
STEP 5
22
Complete the remainder of the row, noting that the payroll costs for each line will be charged to the P&L based on the default GL account nominated for each Pay Component Code.
23
24
STEP 6
25
Send completed and reviewed workbook to shared services payroll team via HEAT.
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100