1. Prepare a bank reconciliation using a company's bank statement and cash account. Preparing a bank reconciliation. - Excel FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW gn in H 1 u. ER-2 . AAlignment Number Conditional Format as Cell Cells Editing Paste N Formatting. Table" Styles Styles Clipboard A1 The June bank statement and the cash T-account for Superior Printing Company v 1 The June bank statement and the cash T-account for Superior Printing Company is shown below BANK STATEMENT Deposits Date Checks Other Balance 4 5 June 1 6 18,500 18,060 16,860 16,360 15,160 24,910 23,990 49,190 48,840 44,240 60,540 59,570 1,200 10 13 20 1,200 250 9 10 10,000 NSF 9,800 350 4,600 700 920 35,000 12 13 14 15 16 26 27 29 30 17,000 Serv. Charge 50