A B C D E F G H J 123 2 Nolan Company's cash account shows a $22,352 debit balance and its bank statement shows $21,332 on deposit at the close of business on June 30. 4 567 a. Outstanding checks as of June 30 total $3,713. b. The June 30 bank statement lists $41 in bank service charges; the company has not yet recorded the cost of these services. $22,352 $21,332 3,713 41 8 c. In reviewing the bank statement, a $90 check written by the company was mistakenly recorded in the company's books as $99. 9 10 d. June 30 cash receipts of $4,724 were placed in the bank's night depository after banking hours 11 and were not recorded on the June 30 bank statement. 12 e. The bank statement included a $23 credit for interest earned on the company's cash in the 13 bank. The company has not yet recorded interest earned. 14 15 Required: 16 Prepare a bank reconciliation using the above information. 17 18 (Use cells A2 to H13 from the given information to complete this question.) 19 90 99 99 4,724 23 + 18 (Use cells A2 to H13 from the given information to complete this question.) 19 20 NOLAN COMPANY 21 Bank Reconciliation 22 23 Bank statement balance June 30 Book balance 24 Add: Add: 25 26 27 28 29 Deduct: 30 31 Adjusted bank balance Deduct: Adjusted book balance 32