ABCDEFGHIJKLMNOPQRSZ
1
2
Academic Year Budget
3
NameEmployee 1Employee 2Employee 3
4
PositionPosition 1Events CoordinatorProgram Coordinator
5
Hours per week14#REF!#REF!
6
Total weeks33#REF!#REF!
7
Hours budgeted462.00#REF!#REF!
8
Hours worked to date0.00#REF!#REF!
9
Hours remaining462.00#REF!#REF!
10
Percentage used0.00%#REF!#REF!
11
Difference0.00%#REF!#REF!
12
13
Weeks complete0
14
Total weeks33
15
% weeks complete0%
16
17
GSSF Accountability Sheet
18
The Accountability Sheet is meant to help serve Authorized Signers and Payroll Approvers who manage employees.
19
The sheet allows you to see when your employees are working and properly budget the remaining hours available to your employees.
20
To properly use this sheet, please ensure you are using the most up to date copy with the current fiscal year indicated and ensure
21
that you are entering the current weeks completed in cell C13
22
As a reminder, GSSF organizations are expected to follow and be in compliance wih the Accountability Sheet Policy and have this sheet
23
or a similar version available upon request to the SSFC Chair. Failure to do so will result in a violation.
24
For assistance with this sheet, please email the ASM Funding Advisor: ksteigleder@wisc.edu
25
26
INSTRUCTIONS FOR ADDING EMPLOYEES
27
1) Select an employee tab below and right click. Choose "Move or Copy"
28
2) Select (move to end) and check the box for "Create Copy." A new tab should appear similarly titled and copied at the end.
29
30
FORMULAS FOR TOTALS TAB
31
Hours per Week
32
The formula for the Hours per Week row will be ='TitleOfTab'!Cell
33
For example, Employee 3 would be ='Employee 3'!C3
34
This is because that information lives on the Employee 3 tab and that information is in Cell C3.
35
Employee 1 is ='Employee 1'!C3 and Employee 2 is ='Employee 2'!C3
230
If you've renamed the tabs to something else, say Events Coordinator, it would be ='Events Coordinator'!C3
231
Total Weeks
232
The formula for Total Weeks row will be ='TitleOfTab'!Cell
233
Very similar to Hours per Week instructions, however instead of C3, the information is in C4.
234
For example, Employee 3 would be ='Employee 3'!C4
235
Hours Budgeted
236
The formula for Hours Budgeted will be the Hours Per Week Cell * the Total Weeks cell
237
For example, Employee 3 would be =E5*E6
238
When you type the formula directly into the cell and hit enter, it will populate the answer 396.00 which is the total budgeted hours.
239
Hours Worked To Date
240
The formula for this cell will be ='TitleofTab'!Cell + ='TitleofTab'!Cell
241
The information for this forumla is found within each total of each payperiod's hours on the employee's hourly log.
242
For example, Employee 3 would be ='Employee 3'!F26+'Employee 3'!F46 etc.
243
What this does is it is adding each TOTAL underneath each pay period section on that employee's tab to give a total hours worked to date.
244
Hours Remaining
245
The formula for Hours Reamining will be =Hours Budgeted - Hours Worked to Date.
246
For example, Employee 3 would be =E7-E8.
247
When you type the formula directly into the cell and hit enter, it will populate the answer which is the hours remaining for that employee.
248
Percentage Used
249
The formula for Percentage Used will be =Hours Worked to Date / Hours Budgeted
250
For example, Employee 3 would be =E8/E7.
251
When you type the formula directly into the cell and hit enter, it will populate the answer which is the percent of hours used for that employee.
252
Difference
253
The formula for Difference will be =Percentage Used per Employee - Percentage of Weeks Complete.
254
For example, Employee 3 would be =E10-C15.
255
When you type the formula directly into the cell and hit enter, it will populate the answer which is the percentage difference of hours used of that employee.
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294