Please prepare bank reconcilation and show the unexplained difference as an adjustment to the book balance. include analysis is the amount if the theft and how the bookeeper attempted to conceal the theft.

The president of The Pembrook Company suspects the bookkeeper is embezzling cash from the company. She asks you, confidentially, to look over the bank reconciliation that the bookkeeper has prepared to see if you discover any discrepancies between the books and the bank statement. She provides you with the Cash account from the general ledger, the bank statement, and the bank reconciliation as of December 31 (Click the icon to view the December bank slatement.) (Click the icon to view the December cash activity.) (Clickhe icon to view the December bank reconciliation.) (Click the icon to view additional information.) Read the First prepare the corrected bank reconciliation. (Include the balances at December 31 in each of the addition subtotal calculations If an input field is not used in the table, leave the field empty, do not select a label or enter a zero. Abbreviations used EFT= electronic funds transfer, NSF = non-sufficient funds) Data table vadditional info each of the addi iselect a label o Data table Vadditional sach of the a select a labe Data table Vadditional in each of the ad iselect a label Bank Books Balance: 12/31 53,289 Balance, 12/31 5 11, 111 Add. Add Deposits in transit Subtotal 7,449. Interest revenue Loss: Subtotal 11. 16.8 Outstanding checks L059. No. 1560 5185 Book error 5:4,000 No. 1901 825 NSF check 166 (1,176) EFT payment of utilities Adjusted bank balance 8. 6.273 Adjusted book balance Data table w the December c w additional inforn w the December Data table More info You learn from the November bank reconciliation that the following checks were outstanding on November 30: No. 1560 for $185, No. 1880 for $553, No. 1882 for $126, and No. 1883 for $461. There was one deposit in transit on November 30 for \$1,282. An examination of the actual deposit slips revealed no bank errors. Assume the cash deposit of \$2,325 on December 24 is the correct amount. The January bank statement showed that a $660 deposit cleared the bank on January 2. The president of The Pembrook Company suspects the bookkeeper is embezzling cash from the company. She The unexplained difference is made up of the following. (Select all statements that apply. If an input field is not used in the table, leave the field empty; do not select a label.) Unexplained difference The theft of was concealed by at December 31 on the company's reconciliation