Bank Reconciliation and Related Journal Entries The book balance in the checking account of Lyle's Salon as of November 30 is $3,282.95. The bank statement shows an ending balance of $2,127. By examining last month's bank reconciliation, comparing the deposits and checks written per books and per bank in November, and noting the service charges and other debit and credit memos shown on the bank statement, the following were found: a. An ATM withdrawal of $150 on November 18 by Lyle for personal use was not recorded on the books. b. A bank debit memo issued for an NSF check from a customer of $19.50. c. A bank credit memo issued for interest of $19 earned during the month. d. On November 30, a deposit of $1,177 was made, which is not shown on the bank statement. e. A bank debit memo issued for $17.50 for bank service charges. f. Checks No. 549, 561, and 562 for the amounts of $185, $21, and $9.40, respectively, were written during November but have not yet been received by the bank. g. The reconciliation from the previous month showed outstanding checks totaling $271.95. One of those checks, No. 471 for $18.65, has not yet been received by the bank. h. Check No. 523 written to a creditor in the amount of $372.90 was recorded in the books as $327.90. Required: 1. Prepare a bank reconciliation as of November 30. Lyle's Salon Bank Reconciliation November 30, 20-- Bank statement balance, November 30 Add deposit in transit $ 2,127.00 1,177.00 Deduct outstanding checks: No. 471 No. 549 No. 561 No. 562 Adjusted bank balance Book balance, November 30 Add interest earned 3,304.00 18.65 185 21 9.40 234.05 3,069.95 3,282.95 19.00 3,301.95 Deduct: Unrecorded ATM withdrawal 150.00 Deduct: NSF check 19.50 Deduct: Bank service charge 17.50 Deduct: Error in recording Check No. 523 45.00 3,301.95 X Adjusted book balance 3,069.95