Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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 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 -- S5,000 SO October 31 November 15 November 30 Book Balance $20,000 $15,000 $10,000 S5,000 SO October 31 November 15 November 30 Cash Interest Received on Bank Total Deposits in Transit Balance November 30 $250 S40 November Bank Fees 530 S20 Check Printing Fees Service Fees S10 $0 August September October November Outstanding Checks at Nov. 30 Check #1203 $100 Wire Transfer Fees Check #1278 $78 *+ableau K & PO 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? 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 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 Record the interest revenue. Note: Enter debits before credits. Date General Journal Debit Credit Nov 30 Record entry Clear entry View general journal Required 1 Required 2 >
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started