Part of your duties as the company's Chief Internal Control Officer (CICO) is to prepare a bank reconcillation each month to ensure proper accounting and safeguarding of cash. The bank reconciliation involves you comparing information in the bank statement to information in the company's cash records. - At the beginning of the month, both the bank and the company had a beginning cash balance of $23,470. - By the end of the month, the bank statement shows a monthend cash balance of $20,680, while the company's records indicate a month-end cash balance of $24,820. - The left circle encompasses all cash transactions for the month reflected in the bank's balance of cash. - The right circle encompasses all cash transactions for the month reflected in the company's current balance of cash. Click here to open graph in separate window. Answer the following questions (Use the following codes: DEP = deposits; EFT = electronic funds transfec; INT = interest earned, NOTE = note collected; NSF = non sufficient funds; 5F= service fees): Required: 1. Which transactions are shown in the intersection of the two circies? Click here to open graph in separate window. Answer the following questions (Use the following codes: DEP = deposits; EFT = electronic funds transfer; INT = interest earned; NOTE = note collected; NSF = non sufficient funds; SF = service fees): Required: 1. Which transactions are shown in the intersection of the two circles? 2. Which transactions are not yet reflected in the company's cash records? 3. Which transactions are not yet reflected in the bank's cash records for July? 4. Calculate the bank's adjusted balance of cash and the company's adjusted balance of cash (Hint: Begin with the month-end balances of cash in the bank statement and company records in the given information above). 5. Record the entries to adjust the company's cash balance. The EFT for $900 includes the cost of utilities in the current month. Complete this question by entering your answers in the tabs below. Calculate the bank's adjusted balance of cash and the company's adjusted baiance of cash (Hint: Begin with the month-end balances of cash in the bank statement and company records in the given information above). 2. Which transactions are not yet reflected in the company's cash records? 3. Which transactions are not yet reflected in the bank's cash records for July? 4. Calculate the bank's adjusted balance of cash and the company's adjusted balance of cash (Hint Begin with the month-end. balances of cash in the bank statement and company records in the given information above). 5. Record the entries to adjust the company's cash balance. The EFT for $900 includes the cost of utilities in the current month. Complete this question by entering your answers in the tabs below. Record the entries to adjust the company's cash balance. The EFT for $900 includes the cost of utlities in the current month. (If no entry is required for a transaction/event, select "No Journal Entry Required" in the first account ficid.) Journal entry worksheet Record the entry for cash recelved against notes recelvable along with interest. Note1 Enter debits beforn credits. 2. Which transactions are not yet reflected in the company's cash records? 3. Which transactions are not yet reflected in the bank's cash records for July? 4. Calculate the bank's adjusted balance of cash and the company's adjusted balance of cash (Hint: Begin with the month-end balances of cash in the bank statement and company records in the given information above). 5. Record the entries to adjust the company's cash balance. The EFT for $900 includes the cost of utilities in the current month Complete this question by entering your answers in the tabs below. Record the entries to adfust the company's cash balance. The EFT for $900 includes the cost of utilities in the current month. (If no is required for a transaction/event, select "No Journal Entry Required" in the first account field.) Journal entry worksheet Record the entry for cash paid against accounts receivable, utilities and service fees. Note: Enter debits before credits
