Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The accounting department prepares a bank reconciliation at the end of each month. The following Tableau Dashboard is provided assist in our reconciliation for the

image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
The accounting department prepares a bank reconciliation at the end of each month. The following Tableau Dashboard is provided assist in our reconciliation for the month of November Bank Statement Balance $20,000 $15,000 $10,000 $5,000 $0 October 31 November 15 November 30 Book Balance $20,000 $15,000 $10,000 $5,000 $0 October 31 November 15 November 30 Sard nework Cash Interest Received on Bank Balance Total Deposits in Transit November 30 $250 November Bank Fees 540 330 $20 Check Printing Fees Service Fees $10 50 August September October November Outstanding Checks at Nov. 30 Check #1203 $100 Wire Transfer Fees Check #1278 $78 tableau 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 (utled 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 2 Record the interest revenue. Note Enter debits before credits General Journal Date Nov 30 Debit Credit Reset Journal entry worksheet

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Hotel And Restaurant Accounting

Authors: Cole Raymond

8th Edition

0866125531, 9780866125536

More Books

Students also viewed these Accounting questions