The cash data of Diane Automotive for December 2017 follow: (Click the icon to view the chequebook.) Diane received the following bank statement on December 31, 2017: (Click the icon to view the bank statement.) (Click the icon to view the additional data for the bank reconciliation.) Requirement Prepare the Diane Automotive bank reconciliation at December 31, 2017. Prepare the Diane Automotive bank reconciliation at December 31, 2017. (Leave unused cells blank.) Diane Automotive Bank Reconciliation December 31, 2017 BANK: Add: Less: Cheque No. BOOKS: Add: Less: Chequebook Cash Date Item Jrnl. Ref Debit Credit Balance December 1 Balance 7,550 31 CR 6 8,463 16,013 31 CP 11 10,284 5,729 Cash Receipts (CR) Cash Payments (CP) Date Cash Debit Cheque No. Cash Credit December 2 $ 2,722 3113 $ 1,077 8 435 3114 1,173 10 678 3115 1,300 16 1,483 3116 209 22 510 3117 919 29 1,384 3118 1,081 30 1,251 3119 446 $ 8,463 Total 3120 1,476 3121 119 3122 2,484 $ 10,284 Total Bank statement Bank Statement for December 2017 $ 7,550 Beginning balance Deposits and other additions: December 1 $ 775 EFT 4 2,722 9 435 12 678 17 1,483 22 1,325 BC 510 23 7,928 Cheques and other deductions: December 7 $ 1,077 13 1,030 14 527 US 15 1,173 18 209 21 284 EFT 26 919 30 1,081 30 20 SC (6,320) i Additional data Additional data for the bank reconciliation include the following: a. The EFT deposit was a receipt of a monthly car lease. The EFT debit was a monthly insurance payment. b. The bank collection was of a note receivable. c. The unauthorized signature cheque was received from a customer. d. The correct amount of cheque number 3115, a payment on account, is $1,030. (Diane's accountant mistakenly recorded the cheque for $1,300.)