Bank Statement Balance

october 31 15000

november 5 12600

november 10 8400

november 15 9700

november 20 10300

november 25 14100

november 30 16028

book balance

october 31 15000

november 5 11400

november 10 12100

november 15 9100

november 20 10700

november 25 15300

november 30 16127

cash interest received on bank balance

august 31

september 24

october 22

november 37

november bank fees

check printing fees 35

service fees 15

wire transfer fees 14

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 $0 October 31 November 15 November 30 Book Balance $20,000 $15,000 $10,000 $5,000 50 Cash Interest Received on Bank Balance Total Deposits in Transit November 30 $250 $40 November Bank Fees $30 $20 Service Check Printing Fees Fees $10 $0 August September October November Outstanding Checks at Nov. 30 Check #1203 $100 Wire Transfer Fees Check #1278 $78 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 Check No 1203 and Check No. 1278 are outstanding checks as of November 30, the November 30 bank statement. Bank Reconciliation November 30 Bank statement balance Add Book balance Add: 01 0 0 0 Deduct Deduct 0 0 Adjusted bank balance $ Adjusted book balance $ 0