The purpose of this part of the audit process for Apollo Shoes is to design tests of controls, substantive tests of transactions, and analytical procedures for the sales, collection, payroll, personnel, acquisition, and payment cycles. These test and procedures are with intent to attest operating effectiveness of internal controls of Apollo Shoes on the basis of documentation provided. It is with the understanding that with the performing of test and procedures an opinion can be formed but management of Apollo shoes is responsible for the maintenance and assessment internal controls of over financial reporting. The design of test of controls of the sales and collection cycle follows. Sales and Collection Cycle
Tests of Controls
Sales Cycle: The review of the revenue and collection cycle manual of Apollo Shoes provides the improper record keeping of sales orders and that sales orders are not numbered which may affect the accuracy of pricing on invoices so steps. The test of controls for sale cycle to determine accuracy will be: 1. Examine sample 1004345 for Anglonesia Rehabilitation and Reprogramming Institute invoice to review unit prices of merchandise listed. 2. Compare unit prices on invoice for merchandise to these shoe types from inventory status report of 2007. 3. Verify unit prices on invoices are correct.
Collection Cycle: A review of balance confirmation from customers provides a customer of Apollo Shoes Neutralizer’s account balance was understated by $ 1,388.75, which prompts testing of existence of collections. With that information, the test of controls of existence of collections will be: 1. Determine if bank reconciliation has been performed.
2. Request bank deposit slips and for end of year for 2007 and bank statement with information for deposit for end of year 2007. 3. Review accounts receivable aged trial balance.
4. Compare deposit amount listed on bank statement to deposit slips. 5. Review balance on reconciliation.
6. Compare payments customers indicate on balance confirmations to those listed on deposit slips for end of year 2007 and payments indicated on accounts receivable aged trial balance. 7. Verify the amounts of reconciliation, bank statement, deposit slips, and accounts receivable aged trial balance align. Substantive Tests of Transactions
Sales Cycle: With the same rationale of attesting to accuracy of recorded sales with the test of controls notation of a customer indicating receipt of merchandise not requested, the steps of substantive test of transactions are: 1. Examine sample 1004345 for Anglonesia Rehabilitation Trace invoice back to shipping documents, sales and customer order. 2. Verify shipping amount is correct.
3. Verify if what is listed is sales order was shipped.
4. Verify if what listed on sales or is what Anglonesia Rehabilitation requested Collection Cycle: In regards to collections, the same rationale for test of controls proving existence with the basis of Neutralizer having an understated balance, the substantive test for collections would be: 1. Review cash receipts journal for the amount of the cash receipt indicated by customers. 2. Review bank statement for deposits indicated.
3. Review deposit slips for list of deposits.
4. Verify amount customers indicate they payment is listed on deposit slips and are included on deposits listed on bank statement. Analytical Procedures
Sales Cycle: From the basis of negative press that Larry Lancaster addresses in the letter to shareholders the assumption is that sales will decrease. The analytical procedures to confirm expectations for the sales cycle will be: 1. Review the sales trial balances from end of year 2006 and 2007. 2. Divide the sales trial balances for 2007 by the 2006 trial balance. 3. Determine the percentage change and if it is positive to confirm expectation. Collection Cycle: From the same basis for the analytical...