Paste Clipboard A1 3 4 5 6 1.000 7 8 9 10 11 FILE 2 12 13 14 15 5 6 16 1. Prepare a bank reconciliation using a company's bank statement and cash account. HOME Date June 1 3 8545NOWO A 10 13 A B D E 1 The June bank statement and the cash T-account for Superior Printing Company is shown below. 2 20 22 26 27 29 Calibri 30 INSERT B I U Y Font X 11 T PAGE LAYOUT Checks A A Preparing a bank reconciliation. - Excel FORMULAS DATA REVIEW 5 440 1,200 500 1,200 250 80 9,800 350 4,600 700 920 % Alignment Number Conditional Format as Cell Formatting Table Styles Styles fix The June bank statement and the cash T-account for Superior Printing Company BANK STATEMENT Deposits 10,000 35,000 17,000 Other VIEW NSF Serv. Charge Cells Editing No 840 50 F Balance Sign In n 18,500 18,060 16,860 16,360 15,160 24,910 23,990 49,190 48,840 44,240 60,540 59,570 X V 4 Paste A1 16 Clipboard G FILE 17 18 19 20 21 22 23 24 25 26 27 7898 28 29 30 1. Prepare a bank reconciliation using a company's bank statement and cash account. HOME A 30 30 Calibri INSERT BIU Font B PAGE LAYOUT 11 A A June 1 Bal. June 13 deposit June 22 deposit June 29 deposit June 30 deposit 920 600 Preparing a bank reconciliation. - Excel FORMULAS DATA REVIEW G Cash % Alignment Number Conditional Format as Cell Cells Editing Formatting Table Styles Styles The June bank statement and the cash T-account for Superior Printing Company 18,500 10,000 35,000 17,000 28,000 D Serv. Charge Interest Earned ^^^ 440 Check # 100 1,200 Check #101 500 1,200 250 80 9,800 350 4,600 770 E Check #102 Check #103 VIEW Check # 104 Check #105 Check #106 Check #107 Check # 108 Check #109 AL HAAA 50 30 GJ F Sign In 59,570 59,000 X Y 28 29 30 800 OWNHO 31 32 33 34 35 42 43 4 45 45 47 48 45 50 51 44 A 46 49 June 30 Bal. B READY Attempt(s) C 36 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). Bank Error NSF Check Outstanding Checks Recording Error Service Charge Deposits in Transit EFT from Customer Interest Earned 82,190 D Updates to Bank Statement Sheet 1 350 4,600 770 4,900 700 920 600 E Check #107 Check # 108 SUPERIOR PRINTING COMPANY Bank Reconciliation At June 30 Check #109 Check #110 Check #111 Check #112 Check #113 F Updates to Company's Books Hint 1 + Show Me 4 100% i A 49 50 51 52 Bank statement balance 53 Additions: 54 55 Deductions: 56 57 58 Adjusted bank balance 59 60 61 62 READY Attempt(s) Updates to Bank Statement B Sheet 1 +) C Bank Reconciliation At June 30 D Book balance Additions: Deductions: Updates to Company's Books Adjusted book balance E 4 F Hint 100% Show Me