Tableau DA 6-3: Mini-Case, Entries from a bank reconciliation LO P3 (similar to EX 6-1, 6-13] The accounting department prepares a bank reconciliation at the end of each month. The following Tableau Daster provi assist in our reconciliation for the month of November Bank Statement Balance $20.000 $35,000 $10,000 $5.000 $0 October 31 November 15 November 30 Book Balance 520.000 $15,000 $30.000 S5.000 10 October 31 November 15 November 30 Cash Interest Received on Bank Total Deposits in Transit $5,000 $0 October 31 November 15 November 30 Cash Interest Received on Bank Total Deposits in Transit Balance November 30 $250 $40 November Bank Fees $30 $20 Check Printing Fees Service Eles $10 $0 August September October November Wire Transfer Fees Outstanding Checks at Nov. 30 Check #1203 $100 Check #1278 tableau $78 1. After preparing the bank reconciliation, record the journal entries necessary to make the company's book balance of cash equ the reconciled cash balance as of November 30. Specifically record the: (1) cash interest received on the bank balance and (2) m $78 Check #1278 + ableau EO 1. 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). 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 reconcillation? Complete this question by entering your answers in the tabs below. 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 recondled 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 Montes de bord Date General Journal Debit Credit After preparing the bank reconciliation, record the journal entries necessary to make the company's book balance of cash equ reconciled cash balance as of November 30. Specifically record the: (1) cash interest received on the bank balance and (2) fees (titled Miscellaneous Expense). View transaction list Journal entry worksheet Check my 1. 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) 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? Complete this question by entering your answers in the tabs below. 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? b. The bank statement showed a check received from a customer was deposited for 5412 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 $136 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.
