(a) Pace, CPA, is performing audit procedures for the December 31, Year 3 audit of Adeline Aircraft Financing Co. (AAF), an issuer in the business of financing private aircraft. You, a senior auditor from Pace, attended the Cash Receipts walkthrough, gathered walkthrough support (reference exhibits), and have been asked by your manager to perform certain procedures related to the assessment of the design and operating effectiveness of the internal controls in the walkthrough.

As part of the assessment of design effectiveness, you have been asked to identify any segregation of duties issues. Review the support found in the exhibits (found in additional information at the end of the question) and document your assessment by clicking in the associated cell and selecting from the list provided.

(b) To assess the operating effectiveness of the internal controls, you observed and gathered support for one instance of each control in the walkthrough. This support serves as a test of one for each control in the test of control matrix. Review the gathered support found in the exhibits and complete your assessment by completing the testing matrix below.

• For each control, write either 'Yes' or 'No' for Control Occurrence to indicate whether or not the control occurrence observed was operating effectively

  • In the Control Occurrence Details column, select from the option below the explanation for whether or not the control was operating effectively by clicking in the associated cells and selecting from the list provided. An explanation may be used once, more than once, or not at all.

    

• Assume that there is only one explanation for each control occurrence.

Control #1 (APPLICATION)

Transaction Description: Update access for posting cash to the receivable system is controlled by system security

Selection Source: Receivable User Access Report

Procedures Performed: Obtained receivable user access report in walk-through and reviewed users' access to record cash receipts. We selected one employee who should be granted access and one employee who should not be granted access to apply cash receipts. We obtained a screen print from the receivable system showing the access level of each of our selections.

Control Occurrence:

Control Occurrence Detail:

Control #2 (DAILY)

Transaction Description Resolution of variation between remittance and payment due

Selection Source: July Receivable system report

Procedures Performed: We observed the query and pull from the receivable system for customer payments due and the associated cash receipts for the month of July. Data was exported to an excel file. We compared remittance (cash application) and payment due for variances and noted any unexplained or stale (> 30 days) variances over $500.

Control Occurrence:

Control Occurrence Detail:

Control #4 (MONTHLY)

Transaction Description: Monthly Cash Reconciliation

Selection Source: General Ledger Account # 0011-11222-012012-1010, July

Procedures Performed: We obtained monthly reconciliation for the related general ledger account balance and performed the following: (i) inspected reconciliation for evidence of timely preparation and review based on sign-offs; (ii) agreed balance per ledger to the General Ledger; (iii) agreed external source balance to bank statement (for cash) or receivable subledger (for receivables); and (iv) noted any unusual reconciling items (i.e. aged over 30 days, or items without explanation and/or support).

Control Occurrence:

Control Occurrence Detail:

Additional information for the question:

Cash Receipts Walkthrough

Walkthrough Template
Company: Financial statement date: Walkthrough process:	Adeline Aircraft Financing Co. December 31, Year 3 Cash Receipts
Documentation of Walkthrough Procedures Performed:
Transaction selected for walkthrough:	Finance receivable: Falcon 900B Wire amount: $10,654 Wire date: 7/8/Year 3
Individuals we talked with to confirm our understanding:	J. Jackson, division accountant
Documentation of Our Understanding of Cash Receipt Process:
Overview Cash receipts involves the process flow related to the receipt of customer cash receipts, the application of such receipts to the related finance receivables in the receivable subledger, and the posting of cash receipts applied in the subledger to the general ledger. Initiation Cash is usually received by wire; however, cash may also be received via lockbox, ACH or check. Paying customers prefer to pay online, which would be received by Adeline Aircraft Financing Co. (AAF) in the form of a wire. As wire receipt represents the only material amount of cash receipt, we elected to walkthrough the cash receipt of Falcon 900B for the amount of $10,654 on 7/8/Year 3. AAF has a specific bank account designed for the receipt of customer payments. This allows the division accountant to easily review cash receipts related to finance receivables. The division accountant manages this bank account and transfers total weekly receipts to the company's main bank account. Authorization Update access for posting cash in the receivable system is controlled by system security and is limited to select personnel, evidencing Control No. 1. Processed / Posted to the GL Once the cash is received, the division accountant then matches the individual remittances to the corresponding payment due in the system. When the division accountant matches the individual remittance to the payment, many times there will be special instructions for how to apply the payment to a customer's account. If there is significant variation (>$500) between the remittance and corresponding payment due, the matter is immediately investigated and resolved by the division accountant, evidencing Control No. 2. Per discussion with the division accountant the authorization and adjustment to payments due is performed by the Account Management Group. Once the customer's payment is matched to remittance, the division accountant posts the transaction to the proper customer's account. Daily, the receivable system automatically interfaces with the general ledger system, evidencing Control No. 3. Monthly Reconciliations The bank accounts for the related cash accounts are reconciled and reviewed monthly by the Cash Accounting Group, evidencing Control No. 4.

E-Mail Correspondence With Division Accountant

From: J.Jackson@AAF.com To: auditsenior@pace.com Date: October 11, Year 3 Accounting Senior, See below for my responses (R) to your questions. Q: Has the Cash Receipts walkthrough changed from the previous year? R: No changes to the process. As I mentioned during the walkthrough, Adam Clark was the division accountant and process owner of the Cash Application walkthrough last year. I took over as of January 1, Year 3. Q: Do you know of any manager override functions within this process? R: No, I am not aware of any manager override functions. Q: For Control No. 1, our audit team selected one user who should have access and one user who should not have access, and we obtained screen shots of the User Access Report. Gina's access seemed appropriate. We selected Adam Clark as a user who should not have access to the receivable system; however, he had similar access to you and Gina. Could you explain? R: See response to question 1. Adam Clark recently switched roles and his access must not have been changed yet. Sincerely, J. Jackson

Select an option below We noted no issues related to segregation of duties. Custody of assets and recording of assets are not appropriately segregated. Authorization of assets and recording of assets are not appropriately segregated. Custody of assets and authorization of assets are not approprately segregated. Recording of assets and reconciliation are not appropriately segregated. RESET CANCEL ACCEPT