This problem requires the use of ACL software, which can

This problem requires the use of ACL software, which can be accessed by following the instructions available on the textbook website. Information about downloading and using ACL and the commands used in this problem can also be found on the textbook website. You should read all of the reference material preceding the instructions about “Quick Sort” before locating the appropriate command to answer parts a. through f. For this problem, use the file labeled “Payroll_details” in the “Payroll” subfolder in the ACL_Rockwood project. 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_detail file screen.) 

b. Determine the largest and smallest payroll transaction (gross pay) for all pay periods combined. (Quick Sort) 

c. Determine total gross pay for all pay periods. (Total) 

d. Determine and print gross pay by pay period. (Summarize) 

e. Recalculate net pay for each payroll transaction for all pay periods and compare it to the amount included in the file. (Filter) 

f. Determine whether there are any gaps in the pay period sequence. If you were to identify gaps in the sequence, what would be your concern? (Gaps) 

g. For parts a. through 

f. above, identify the type of audit evidence used for each procedure. How might the auditor use this evidence in testing of payroll expense?

How Our Website Works


It has never been easier to place your order. Fill in the initial requirements in the small order form located on the home page and press “continue” button to proceed to the main order form or press “order” button in the header menu. Starting from there let our system intuitively guide you through all steps of ordering process.


All your payments are processed securely through PayPal. This enables us to guarantee a 100% security of your funds and process payments swiftly.


Next, we match up your order details with the most qualified freelance writer in your field.


Once we have found the most suitable writer for your assignment, they start working on a masterpiece just for you!


Once finished, your final paper will be available for download through your personal dashboard. You will also receive an email notification with a copy of your paper attached to it. Sometimes, the writer may leave a note for you about the order in case there is any additional information that they need to give you.

Leave a Reply

Your email address will not be published.