QS 6-11 (Algo) Bank reconciliation LO P3 Nolan Company's cash account shows a $20,621 debit balance and its bank statement shows $19,791 on deposit at the close of business on June 30 o. Outstanding checks as of June 30 total $2482 b. The June 30 bank statement lists $22. in bank service charges, the company has not yet recorded the cost of these services c. In reviewing the bank statement, a $40 check written by the company was mistakenly recorded in the company's books as $49. d. June 30 cash receipts of $3,333 were placed in the bank's night depository after banking hours and were not recorded on the June 30 bank statement e. The bank statement included a $34 credit for interest earned on the company's cash in the bank. The company has not yet recorded interest earned Prepare a bank reconciliation using the above information NOLAN COMPANY Bank Reconciliation June 30 Book balance Bank statement balance Add Add 0 0 Deduct Deduct Adjusted bank balance 0 O Adjusted book balance 3 $ Tableau DA 6-2: Exercise, Preparing a bonk reconciliation LO P3 (similar to EX 6-12) The accounting department prepares a bank reconciliation of the end of each month. The following Tableau Dashboard is provided to assist in our reconciliation for the month of November Bank Statement Balance $20,000 $15,000 $10,000 $5,000 50 October 31 November 15 November 30 Book Balance $20,000 $15,000 $10,000 $5,000 SO October 31 November 15 November 30 Cash Interest Received on Bank Balance Total Deposits in Transit November 30 $250 November Bank Fees 540 530 320 Check Printing Fees Service Fees 510 530 $20 Check Printing Fees Service Fees $10 $0 August September October November Outstanding Checks at Nov. 30 Check #1203 $100 Wire Transfer Fees Check #1278 $78 tableau GP Prepare the company's bank reconciliation using information from the Tableau Dashboard Assume the following The company has not yet recorded the bank fees. The company has not yet recorded cash interest received for November Deposits in transit on November 30 were placed in the bank's night depository after banking hours and were not recorded on the November 30 bank statement. Check Number 1203 and Check Number 1278 are outstanding checks as of November 30 Bank Reconciliation November 30 Book balance Add Bank statement balance |Add 0 0 0 Deduct: 0 Deduct D 0 Adjusted bank balance Adjusted book balance 5 0