Anylasis componenet should be included

• it should be on excel sheet
  

Assignment 1 X + X C A classroom.google.com/u/0/c/MTYxNzcxNTMOMTE1/a/MTg3MjQ1NTQ4NjQ5/details F Assignment 1.JPG Open with . . Problem 7-11A Preparing a bank reconciliation and recording adjustments _ LOG Assignmer CHECK FIGURE: 1. Adjusted book balance = $28,250 Vinay Yarlagadda . 12 The following is information for Dundee Realty: rk Assigned a. Balance per the bank statement dated October 31, 2020, is $26,830. 5 points b. Balance of the Cash account on the company books as of October 31, 2020, is $5,575. dited - Assignme... X c. $14,680 of customer deposits were outstanding as of September 30; this amount had been deposited to Dundee's account age Individual Assignments in October. Include a cover page ( d. Cheques written in October that had not cleared the bank as of October 31 were: Add or create You can do the assign #8700, $985 are legible. #8709, $12,600 #8801, $620 #8815, $145. Turn in Ass e. The bank charged Dundee's account for a $2,350 cheque of the E-Zone Networks; the cheque was found among the Ima cancelled cheques returned with the bank statement. f. Bank service charges for October amount to $65. g. A customer's cheque (Teresa Krant) for $7,050 had been deposited in the bank correctly but was recorded in the ments accounting records as $7,500. Class comments h. Among the cancelled cheques is one for $260 given in payment of an account payable to Decker Company; the bookkeeper had recorded the cheque incorrectly at $620 in the company records. private comment. i. The bank statement showed an electronic fund transfer of $22,880 for a customer payment. A bank service fee Page 524 of $50 was charged. j. A bank deposit of October 31 for $13,420 does not appear on the bank statement. Required 1. Prepare a bank reconciliation statement as of October 31, 2020. 2. Prepare the necessary entries to make the Cash account agree with the bank reconciliation adjusted Cash balance as of October 31. Analysis Component: Identify the effects on the income statement and balance sheet if the entries in Part 2 were not recorded. (? + Type here to search O Assignment 1 - GOO. 10:49 PM " 10/13/2020