This problem requires the use of ACL software. For this problem, open an existing ACL Project, then choose the Sample Project data files. In the “Tables” folder, open the “Payroll Analysis” subfolder, then the “Payroll” file. The suggested command or other source of information needed to solve the problem requirement is included at the end of each question.
a. Determine the number of payroll transactions in the file (read the bottom of the Payroll file screen).
b. Determine the largest and smallest payroll transaction (gross pay) for the month of September (Quick Sort). How would the auditor use this information?
c. Determine gross pay for September (Total). Which general ledger account(s) would this total be reconciled to?
d. Determine and print gross pay by department (Summarize).
e. Recalculate net pay for each payroll transaction for September and compare it with the amount included in the file (Computed Fields or Filter). What would be your concern if there were any differences? What transaction- related and balance-related audit assertions are associated with this test?
f. Determine if there are any gaps or duplicates in the cheque numbers (Gaps and Duplicates). What would be your concern if there were gaps or duplicates?