BANK RECONCILIATION PROBLEM

Please answer in excel format as posted for best answer.

Explanations : BC-bank collection; EFT-electronic funds transfer; NSF-nonsuffcient funds checks; SC-service charge Additional data for the bank reconciliation follows: a. The EFT credit was a receipt of rent. The EFT debit was an insurance payment. 13 b. The NSF check was received from a customer. 14 c. The $1,400 bank collection was for a note receivable. The correct amount of check 1419, for rent expense, is $1,910. Dunlap's d. controller mistakenly recorded the check for $1,190. Requirement (Check your spelling carefully and do not abbreviate.) 1. Prepare the bank reconciliation of Durkin Insurance at December 31, 2015. (Start in cell Al. Enter all values as positive value. The check answer button will be active after you place information in cell F15.)The December cash records of Durkin Insurance Is provided. Durkin's Cash account shows a balance of $17,340 at December 31. On December 31, Durkin Insurance received the bank statement. Additional data for the bank reconciliation is provided. (Click the icon to the left to view the checkbook, bank statement, and additional information.)