Bank Reconciliation and Related Journal Entries The book balance in the checking account of Lyle's Salon as of November 30 is $3,266.72. The bank statement shows an ending balance of $2,105.00. 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: An ATM withdrawal of $147.00 on November 18 by Lyle for personal use was not recorded on the books. A bank debit memo issued for an NSF check from a customer of $19.60. A bank credit memo issued for interest of $18.00 earned during the month. On November 30, a deposit of $1,176.00 was made, which is not shown on the bank statement. A bank debit memo issued for $18.20 for bank service charges. Checks No. 549, 561, and 562 for the amounts of $172.00, $24.00, and $9.30, respectively, were written during November but have not yet been received by the bank. The reconciliation from the previous month showed outstanding checks totaling $271.95. One of those checks, No. 471 for $18.78, has not yet been received by the bank. Check No. 523 written to a creditor in the amount of $375.00 was recorded in the books as $332.00. Required: 1. Prepare a bank reconciliation as of November 30. Lyle's Salon Bank Reconciliation November 30, 20- Bank statement balance, November 30 Bank statement balance, November 30 11 $ Adjusted bank balance Book balance, November 30 S $ Adjusted book balance 2. Prepare the required journal entries. Page: DATE ACCOUNT TITLE DOC. POST NO. REF. DEBIT CREDIT 1 20-Nov. 30 1 2 2 3 Interest earned for November 4 3 4 S 30 5 6 6 7 8 Unrecorded ATM withdrawal 7 8 30 9 10 10 11 NSF check 11 12 12 1330 13 14 © ED < 5 6 7 00 9 O 12 12 13 30 13 14 14 15 Bank service change 15 16 16 17 30 17 18 18 19 Error in recording Check No. 523 19 O & oljo