Audit Objective pr-1

Summarize and stratify salaries by department/grade etc

Step 1

Summarization

Using the main form, select the summarize function for the column or variable of interest. (Typically the column would be named something like 'Payroll Amount'). This column name can be selected from a drop down list (it must be numeric).

If the selected column is not numeric, then an error message will be displayed in the status bar and another column must then be selected.

The next step in the process is to select the columns to be sorted for sub-totals. One or more column names must be entered and separated by commas. If the column name contains embedded spaces, e.g. "Payroll Amount" then it must be enclosed in brackets - [Payroll Amount]. Column names are not case sensitive, but must be properly spelled, otherwise an error message will be displayed on the status bar.

The summarization report will include both counts, totals, minima, maxima, average and standard deviation for each break point, i.e. change in sort key.

There is a complete description of the procedure available for viewing.

Output from the process will be available in two formats:

1. As a report in a file
2. As a report (in the 'report tab')

The report file may be loaded into Excel for for further analysis or sorting.

An example of summarization column name for this test is [transaction amount]. An example of sort keys for summarization is [vendor number], [location].





Home



Application Area