p B54 B A C D E F 1 The June bank statement and the cash T-account for Superior Printing, Inc., is shown below 2 BANK STATEMENT Deposits 3 Checks Other Date Balance June 1 18,500 3 440 6 18,060 4 1,200 7 16,860 8 500 8 16,360 10 1,200 15,160 13 250 10 10,000 24,910 20 11 80 NSF 840 23,990 22 12 9,800 35,000 49,190 26 13 350 48,840 27 14 4,600 44,240 29 15 700 17000 60,540 30 16 920 Serv. Charge 50 59,570 Interest 30 17 600 30 59,000 Earned tr. A C D F Cash June 1 Bal June 13 deposit June 22 deposit June 29 deposit June 30 deposit 18,500 10,000 440 Check #100 35,000 1,200 Check#101 17,000 500 Check #102 28,000 1,200 Check #103 250 Check #104 80 Check # 105 9,800 Check #106 350 Check # 107 4,600 Check # 108 770 Check # 109 Check # 110 Check # 111 4,900 700 920 Check #112 600 Check #113 June 30 Bal 82,190 tr) X B54 C A 37 Required: 38 Prepare a bank reconciliation for June using the bank statement and T-account above and the information below 39 Additional information: 40 There were no deposits in transit or outstanding checks at May 31 41 Note: Columns C and F must be entered as positive values. In columns B& E, use cell references 42 to the appropriate items from the list below. List "Deductions" in chronological order (earliest item first) 43 Bank Error NSF Check 44 Deposits in Transit Outstanding Checks Recording Error Service Charge 45 EFT from Customer 46 Interest Earned 47 SUPERIOR PRINTING, INC. Bank Reconciliation At June 30 48 49 50 Updates to Company's Books 51 Updates to Bank Statement $59,000 Ending cash balance per books Additions: 52 Ending balance per bank statement 53 Additions: $82,190 54 55 Deductions: Deductions: 56 57 58 Up-to-date ending cash balance Up-to-date ending cash balance 59 60 Sheet1 DEADH