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 No. 1203 and Check No. 1278 are outstanding checks as of November 30. Bank Reconciliation November 30 Book balance Bank statement balance Add: Add: Deduct: Deduct 0 $ 0 Adjusted book balance Adjusted bank balance Tableau DA 8-2: Exercise, Preparing a bank reconciliation LO P3 The accounting department prepares a bank reconciliation at 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 Bank Balance November 25: S14,100 $0 November 30 November 15 October 31 Book Balance $20,000 $15,000 $10,000 $5,000 Book Balance November 25: S15,300 $0 October 1 November 15 November SC Cash Interest Received on Bank Balance Total Deposits in Transit November 30 $250 November Bank Fees $30 $20 Check Printing Fees Service Fees $10 September October August November Outstanding Checks at Nov. 30 Wire Transfer Fees $100 Check #1203 $78 Check #1278 November 15 November K Total Deposits in Transit November 30 $250 November Bank Fees Service Check Printing Fees Fees Check Printing Fees: $35 vember 0 Wire Transfer Fees $100 Total Deposits in Transit November 30 $250 November Bank Fees Check Printing Fees Service Fees Service Fees: $15 Wire Transfer Fees r Wire Transfer Fees Wire Transfer Fees S14 nation from the Tableau Dashboard. Assume the following: Balance $40 $30 $20 $10 August: $31 September August October November betonding Checks at Nov. 30 Balance $40 $30 $20 $10 September: $24 October November September August Balance Nc $40 $30 $20 $10 October: $22 $0 October November August September Balance Novemt $40 No $30 $20 November: $37 ok $10 $0 September October November August August September October November Outstanding Checks at Nov. 30 Check #1203 $100 Check #1278 $78 tableau Tableau DA 8-2: Exercise, Preparing a bank reconciliation LO P3 The accounting department prepares a bank reconciliation at the end of each month. The following Tableau Das assist in our reconciliation for the month of November. Bank Statement Balance $20,000 $15,000 -- $10,000 --- 55.000 --- Bank Balance October 31: $15,000 $0 October 31 November 15 November 30 Book Balance The accounting department prepares a bank reconciliation at the end of each month. The following Tableau Dashboa assist in our reconciliation for the month of November. Bank Statement Balance $20,000 $15,000- $10 000 $5,000---- Bank Balance November 15: 59,700 November 30 November 15 October 31 1. Dalam Tableau DA 8-2: Exercise, Preparing a bank reconciliation LO P3 The accounting department prepares a bank reconciliation at the end of each month. The following Tableau Dashboard assist in our reconciliation for the month of November. Bank Statement Balance $20,000 $15,000 $10.000- Bank Balance November 30: $16.028 $5,000 50 November 30 November 15 October 31 Book Balance Book Balance $20,000 $15,000 $10,000 Book Balance October 31: $15,000 $5,000 $0 October 31 November 15 November 30 Book Balance $20,000 $15,000 $10,000 $5,000 Book Balance November 15: $9,100 $0 October 31 November 15 November 30 Novem Book Balance 20.000 15.000 10,000 $5.000 $0 Book Balance November 30: $16.127 October 31 November 15 Required 1 Required 2 After preparing the bank reconciliation, record the journal entries necessary to make the company's book balance of cash equal to the reconciled cash balance as of November 30. Specifically record the: (1) cash interest received on the bank balance and (2) monthly bank fees (titled Miscellaneous Expense). View transaction list Journal entry worksheet 1 2 Record the interest revenue. Note Ender de bits before credits Debit Credit Date General Journal Nov 30 Prev 7 of 7 Journal entry worksheet 1 Record the interest revenue. Note: Enter debits before credits. General Journal Debit Credit NOV 20 1 Record the monthly bank fees (titled Miscellaneous Expense). Note: Enter debits before credits. Debit credit Date General Journal Nov 30 Required 1 Required 2 Assume that information from the Tableau Dashboard is insufficient to reconcile the two balances. How would we report each of the following on the bank reconciliation? . a b. The bank statement showed a check received from a customer was deposited for $412 instead of the correct amount of $142 on November 2. This is a bank error. The bank received an electronic funds transfer (EFT) on November 30 for $350 and the company has not yet recorded this transaction. The bank statement shows a $135 NSF check from a customer, the company has not yet recorded this NSF check Check No. 1289 for November rent expense was correctly written and drawn for $830 but was erroneously entered in the accounting records as $380. C d