Icon

How to Pull the Payroll Audit Report

This is a step-by-step guide for Google Chrome and Microsoft Excel

By Jacob Higgison
1
Click on "="
Step #1: Click on "="
2
Click on "Dataviews & Reports"
Step #2: Click on "Dataviews & Reports"
3
Click on "Report Library"
Step #3: Click on "Report Library"
4
Click on "Reporting Jobs"
Step #4: Click on "Reporting Jobs"
5
Click on the Audit Report - Config Changes
Step #5: Click on the Audit Report - Config Changes
6
Change the Start Date to the Date you need - (this should be the day after the end date of the previous report)
Step #6: Change the Start Date to the Date you need - (this should be the day after the end date of the previous report)
7
Set the End Date as 30 days after the start date (the report will break with more than 30 days)
Step #7: Set the End Date as 30 days after the start date (the report will break with more than 30 days)
8
Click on "Recurs by month starting"
Step #8: Click on "Recurs by month starting"
9
Change this to the CURRENT day of the month and the start time to a few minutes after the CURRENT time (this is so the report will run)
Step #9: Change this to the CURRENT day of the month and the start time to a few minutes after the CURRENT time (this is so the report will run)
10
Click on "Apply"
Step #10: Click on "Apply"
11
Click on "Apply"
Step #11: Click on "Apply"
12
Click here
Step #12: Click here
13
Click here
Step #13: Click here
14
Now it's time to start the recording
Step #14: Now it's time to start the recording
15
Click on "Recording"
Step #15: Click on "Recording"
16
Click on "Entire Screen"
Step #16: Click on "Entire Screen"
17
Click on the screen your Dimensions is on.
Step #17: Click on the screen your Dimensions is on.
18
Click on "Share"
Step #18: Click on "Share"
19
Click on "Ok"
Step #19: Click on "Ok"
20
Click here
Step #20: Click here
21
Double-click on "@ g8education.edu.au_2025-01-15T14"
Step #21: Double-click on "@ g8education.edu.au_2025-01-15T14"
22
Drag it to the screen you're recording on
Step #22: Drag it to the screen you're recording on
23
Click on "A"
Step #23: Click on "A"
24
Navigate to the LAST row, this is important to show the auditors the complete report.
Step #24: Navigate to the LAST row, this is important to show the auditors the complete report.
25
Click on "Stop sharing" (turns off the recording)
Step #25: Click on "Stop sharing" (turns off the recording)
26
Click on "Download"
Step #26: Click on "Download"
27
Save this in Sharepoint
Step #27: Save this in Sharepoint
28
Save the report AND recording here
Step #28: Save the report AND recording here
29
Copy the report to a NEW sheet
Step #29: Copy the report to a NEW sheet
30
Use Remove Duplicates on the first three columns
Step #30: Use Remove Duplicates on the first three columns
31
Delete out columns after C and add in a "comments" column, with commentary for the change

Then highlight the cells and add a border for the email.
Step #31: Delete out columns after C and add in a "comments" column, with commentary for the changeThen highlight the cells and add a border for the email.

32
Email out the report (do not email the recording)
Step #32: Email out the report (do not email the recording)