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 "="
2
Click on "Dataviews & Reports"
3
Click on "Report Library"
4
Click on "Reporting Jobs"
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)
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"
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"
11
Click on "Apply"
12
Click here
13
Click here
14
Now it's time to start the recording
15
Click on "Recording"
16
Click on "Entire Screen"
17
Click on the screen your Dimensions is on.
18
Click on "Share"
19
Click on "Ok"
20
Click here
21
Double-click on "@ g8education.edu.au_2025-01-15T14"
22
Drag it to the screen you're recording on
23
Click on "A"
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)
26
Click on "Download"
27
Save this in Sharepoint
28
Save the report AND recording here
29
Copy the report to a NEW sheet
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.
Then highlight the cells and add a border for the email.
32
Email out the report (do not email the recording)
